Psql is bug？this issue was also encountered in postgresql 16.3

PostgreSQL Percona Distribution for PostgreSQL
1

[postgres@ora23ai ~]$ psql
psql (15.7)

Type “help” for help.
malloc(): corrupted top size
Aborted (core dumped)

  • saw the same core dump file from the /var/log/messages

[root@ora23ai ~]# coredumpctl list

TIME PID UID GID SIG COREFILE EXE
Sun 2024-07-14 14:36:44 UTC 5267 1001 1001 6 none /usr/local/postgresql/percona-postgresql15/bin/psql
Sun 2024-07-14 14:40:06 UTC 5338 1001 1001 6 present /usr/local/postgresql/percona-postgresql15/bin/psql

[root@ora23ai ~]# coredumpctl info
   Timestamp: Sun 2024-07-14 14:40:06 UTC (11min ago)
  Command Line: psql
    Executable: /usr/local/postgresql/percona-postgresql15/bin/psql
 Control Group: /user.slice/user-0.slice/session-3.scope
          Unit:
         Slice: user-0.slice
       Session: 3
     Owner UID: 0 (root)
       Boot ID: 348f8a837b8441cb92b0b671399640c9
    Machine ID: be412bd3b0e64ca9a93910d1db40d078
      Hostname: ora23ai
       Storage: /var/lib/systemd/coredump/core.psql.1001.348f8a837b8441cb92b0b671399640c9.5338.1720968006000000.lz4
       Message: Process 5338 (psql) of user 1001 dumped core.
                Stack trace of thread 5338:
                #0  0x00007fb50b66452f raise (libc.so.6)
                #1  0x00007fb50b637e65 abort (libc.so.6)
                #2  0x00007fb50b6a5727 __libc_message (libc.so.6)
                #3  0x00007fb50b6aca2c malloc_printerr (libc.so.6)
                #4  0x00007fb50b6b0208 _int_malloc (libc.so.6)
                #5  0x00007fb50b6b126e malloc (libc.so.6)
                #6  0x00007fb50c1c758d history_def_insert (libedit.so)
                #7  0x00007fb50c1c7a85 history_load (libedit.so)
                #8  0x00007fb50c1d22a0 read_history (libedit.so)
                #9  0x000000000041ff8b initializeInput (psql)
                #10 0x0000000000405346 main (psql)
                #11 0x00007fb50b6507e5 __libc_start_main (libc.so.6)
                #12 0x000000000040544e _start (psql)
  • after i deleted .psql_history ,then psql works fine, it is shown below.

[postgres@ora23ai ~]$ rm -rf .psql_history
[root@ora23ai ~]# su - postgres
Last login: Sun Jul 14 14:47:28 UTC 2024 on pts/0
[postgres@ora23ai ~]$ psql
psql (15.7)
Type “help” for help.
postgres=#
postgres=# \q

but i found that another problem arose.

could not save history to file "/home/postgres/.psql_history": Success

ll /home/postgres/.psql_history
-rw-------  1 postgres postgres    20 Jul 14 14:49 .psql_history

more additional information.

[postgres@ora23ai ~]$ ps -efa|grep postgres
ps: /opt/pgdistro/percona-postgresql16/lib/libuuid.so.1: no version information available (required by /lib64/libblkid.so.1)
postgres    3404       1  0 15:28 ?        00:00:00 /opt/pgdistro/percona-postgresql16/bin/postgres -D /pgdata
postgres    3405    3404  0 15:28 ?        00:00:00 postgres: checkpointer
postgres    3406    3404  0 15:28 ?        00:00:00 postgres: background writer
postgres    3408    3404  0 15:28 ?        00:00:00 postgres: walwriter
postgres    3409    3404  0 15:28 ?        00:00:00 postgres: autovacuum launcher
postgres    3410    3404  0 15:28 ?        00:00:00 postgres: logical replication launcher
root        6462    2986  0 16:56 pts/0    00:00:00 su - postgres
postgres    6463    6462  0 16:56 pts/0    00:00:00 -bash
postgres    6552    6463  0 17:04 pts/0    00:00:00 ps -efa
postgres    6553    6463  0 17:04 pts/0    00:00:00 grep --color=auto postgres

[postgres@ora23ai ~]$ cat /etc/redhat-release
AlmaLinux release 8.9 (Midnight Oncilla)
2
  • A little additional information.
[postgres@ora23ai ~]$ ps -efa|pgrep postgres
ps: /opt/pgdistro/percona-postgresql16/lib/libuuid.so.1: no version information available (required by /lib64/libblkid.so.1)
pgrep: /opt/pgdistro/percona-postgresql16/lib/libuuid.so.1: no version information available (required by /lib64/libblkid.so.1)
3404
3405
3406
3408
3409
3410
6617
[postgres@ora23ai ~]$ ll /lib64/libblkid.so.1
lrwxrwxrwx 1 root root 17 Apr  6 21:02 /lib64/libblkid.so.1 -> libblk

windows 1

postgres=# select pg_backend_pid();
pg_backend_pid

       6617

(1 row)

postgres=# select version();
version

PostgreSQL 16.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22.0.1), 64-bit
(1 row)

postgres=# \q
could not save history to file “/home/postgres/.psql_history”: Success

windows 2

[postgres@ora23ai ~]$ strace -p 6617
strace: Process 6617 attached
epoll_wait(5, [{events=EPOLLIN, data={u32=28714904, u64=28714904}}], 1, -1) = 1
recvfrom(9, “Q\0\0\0\26select version();\0”, 8192, 0, NULL, NULL) = 23
sendto(9, “T\0\0\0 \0\1version\0\0\0\0\0\0\0\0\0\0\31\377\377\377\377\377\377\0”…, 171, 0, NULL, 0) = 171
recvfrom(9, 0xe492e0, 8192, 0, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable)
epoll_wait(5, [{events=EPOLLIN|EPOLLHUP, data={u32=28714904, u64=28714904}}], 1, -1) = 1
recvfrom(9, “X\0\0\0\4”, 8192, 0, NULL, NULL) = 5
getpid() = 6617
munmap(0x7fa6f4dc5000, 1048576) = 0
getpid() = 6617
futex(0x7fa6f4522344, FUTEX_WAKE_PRIVATE, 2147483647) = 0
exit_group(0) = ?
+++ exited with 0 +++

3

Hi,

I tried without success to reproduce the error, see below.

I noticed you were using AlmaLinux version 8. I ran my test in an incus container. At a guess, and it’s only a guess, I’d first confirm that you’ve installed postgres on a viable OS.

Hope this helps.

incus launch images:almalinux/8 tmp-alma1
incus exec tmp-alma1 -- su -

#
# INSTALL pg16, x86_64
#   https://www.postgresql.org/download/linux/redhat/
#
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql16-server
sudo /usr/pgsql-16/bin/postgresql-16-setup initdb
sudo systemctl enable postgresql-16
sudo systemctl start postgresql-16

#
# VALIDATION
#
dnf install -y net-tools
netstat -tlnp

Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      3172/postgres
tcp6       0      0 ::1:5432                :::*                    LISTEN      3172/postgres

su - postgres
psql (PostgreSQL) 16.3
[postgres@tmp-alma1 ~]$ psql
psql (16.3)
Type "help" for help.

postgres=# select version();
                                                 version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 16.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22), 64-bit
(1 row)

postgres=# \q
[postgres@tmp-alma1 ~]$ logout
[root@tmp-alma1 ~]# coredumpctl list
No coredumps found.
4

Apologies, I didn’t ask but I assumed you were using vanilla postgres. I’ll repeat the test with our Percona distro of postgres.

5

Thinks, i’m having this issue in both Percona Distribution for PostgreSQL 15.7 and Percona Distribution for PostgreSQL 16.3 and it’s easy to reproduce.

6

As per my last post, I reran the installation. No issues were found. Please note as there was no Alma Linux 8 available Rocky LInux 8 was used instead.

Hope this helps :slight_smile:

AS ROOT

# -------------------
# PART 1
dnf module disable postgresql llvm-toolset
dnf install dnf-plugins-core
dnf module enable llvm-toolset
dnf config-manager --set-enabled powertools

# -------------------
# PART 2
yum -y install curl
yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
percona-release setup ppg16
yum install percona-ppg-server16



# -------------------
# PART 3
/usr/pgsql-16/bin/postgresql-16-setup initdb
systemctl start postgresql-16

# -------------------
# PART 4
dnf install -y mlocate net-tools man
mandb && updatedb
netstat -tlnp
7

Just to be clear.

  • test 1: vanilla pg installed on alma linux 8
  • test 2: percona pg installed on alma linux 8 using the Percona Rocky Linux 8 distro
8

I’m install Percona Distribiution for PostgreSQL from binary tarballs .the link is below
https://docs.percona.com/postgresql/16/tarball.html

9

Right then, 3X’s the charm!

What I’m documenting below should work for you. The tarball you used is not the correct one as it assumes you have SSL ver 3 which doesn’t appear to be on a base install of Alma Linux 8.

Goto this URL for the correct tarball and after choosing pg 16 download this one
percona-postgresql-16.3-ssl1.1-linux-x86_64.tar.gz

Now here’s the instructions I used. It’s slightly different then the documentation originally references but its far simpler IMHO.

#
# ALMALINUX 8
#   Some of these aren't needed but I find them useful
#   
dnf install -y mlocate man net-tools wget curl mc tar vim

adduser percona -p percona
su - percona
mkdir postgres data
cd postgres

# download and extract
tar -xzpvf percona-postgresql-16.3-ssl1.1-linux-x86_64.tar.gz

#
# update resource files, elminate the long path invocations
#    next time you login
#
echo "
if [ -f ~/.bash_aliases ]; then
    . ~/.bash_aliases
fi
" >> $HOME/.bashrc

echo "
export PATH=:$HOME/postgres/percona-haproxy/sbin/:$HOME/postgres/percona-patroni/bin/:$HOME/postgres/percona-pgbackrest/bin/:$HOME/postgres/percona-pgbadger/:$HOME/postgres/percona-pgbouncer/bin/:$HOME/postgres/percona-pgpool-II/bin/:$HOME/postgres/percona-postgresql16/bin/:$HOME/postgres/percona-etcd/bin/:/opt/percona-perl/bin/:/opt/percona-tcl/bin/:/opt/percona-python3/bin/:$PATH
" > $HOME/.bash_aliases

# initialize cluster, remember to logout 
# and back in in order to update the PATH environment variable
#
initdb -D $HOME/data

# start cluster
pg_ctl start -D $HOME/data -l logfile

# login
psql
10

I’m so sorry i should have said more about the environment.

[postgres@ora23ai ~]$ ll percona-postgresql-1*
-rw-r--r-- 1 postgres postgres 270884083 Jun  5 18:21 percona-postgresql-15.7-ssl1.1-linux-x86_64.tar.gz
-rw-r--r-- 1 postgres postgres 273228701 Jun  5 18:23 percona-postgresql-16.3-ssl1.1-linux-x86_64.tar.gz

[postgres@ora23ai ~]$ openssl version
OpenSSL 1.1.1k  FIPS 25 Mar 2021
[postgres@ora23ai ~]$ ll /opt/pgdistro/
total 0
drwxr-xr-x 3 postgres postgres 17 Jun  5 18:39 percona-etcd
drwxr-xr-x 7 postgres postgres 64 Jun  5 18:39 percona-haproxy
drwxr-xr-x 4 postgres postgres 53 Jun  5 18:38 percona-patroni
drwxr-xr-x 5 postgres postgres 39 Jun  5 18:25 percona-perl
drwxr-xr-x 5 postgres postgres 65 Jun  5 18:38 percona-pgbackrest
drwxr-xr-x 3 postgres postgres 85 Jun  5 18:38 percona-pgbadger
drwxr-xr-x 6 postgres postgres 52 Jun  5 18:37 percona-pgbouncer
drwxr-xr-x 7 postgres postgres 67 Jun  5 18:37 percona-pgpool-II
drwxr-xr-x 7 postgres postgres 67 Jun  5 18:37 percona-postgresql16
drwxr-xr-x 6 postgres postgres 56 Jun  5 18:29 percona-python3
drwxr-xr-x 7 postgres postgres 67 Jun  5 18:31 percona-tcl
11

if you’re still having problems then I suggest you reinstall everything on another completely different OS/machine in order to eliminate that the issues is related to the operating system.

12

I have performed the installation of the recommended OS for ppg16.

[root@rocky8 ~]# cat /etc/redhat-release
Rocky Linux release 8.9 (Green Obsidian)
[root@rocky8 ~]# openssl version
OpenSSL 1.1.1k  FIPS 25 Mar 2021
[root@rocky8 ~]# useradd postgres -m
[root@rocky8 ~]# passwd postgres
Changing password for user postgres.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@rocky8 ~]# su - postgres
[root@rocky8 ~]# chown -R postgres:postgres /home/postgres/percona-postgresql-16.3-ssl1.1-linux-x86_64.tar.gz
[root@rocky8 ~]# su - postgres
[root@rocky8 ~]# mkdir -p /usr/local/pgsql16.3
[root@rocky8 local]# ln -s /usr/local/pgsql16.3 /usr/local/pgsql
[root@rocky8 local]# ll
total 0
drwxr-xr-x. 2 root root  6 Oct 11  2021 bin
drwxr-xr-x. 2 root root  6 Oct 11  2021 etc
drwxr-xr-x. 2 root root  6 Oct 11  2021 games
drwxr-xr-x. 2 root root  6 Oct 11  2021 include
drwxr-xr-x. 2 root root  6 Oct 11  2021 lib
drwxr-xr-x. 3 root root 17 Jan 10  2024 lib64
drwxr-xr-x. 2 root root  6 Oct 11  2021 libexec
lrwxrwxrwx. 1 root root 20 Jul 17 13:33 pgsql -> /usr/local/pgsql16.3
drwxr-xr-x. 2 root root  6 Jul 17 13:32 pgsql16.3
drwxr-xr-x. 2 root root  6 Oct 11  2021 sbin
drwxr-xr-x. 5 root root 49 Jan 10  2024 share
drwxr-xr-x. 2 root root  6 Oct 11  2021 src
[root@rocky8 pgsql]# tar xf /home/postgres/percona-postgresql-16.3-ssl1.1-linux-x86_64.tar.gz -C ./
[root@rocky8 local]# chown -R postgres:postgres pgsql
[root@rocky8 local]# chown -R postgres:postgres pgsql16.3

[root@rocky8 pgsql]# cp -r percona-perl percona-python3 percona-tcl /opt/
[root@rocky8 pgsql]# ll /opt
total 0
drwxr-xr-x. 5 root root  39 Jul 17 13:36 percona-perl
drwxr-xr-x. 6 root root  56 Jul 17 13:36 percona-python3
drwxr-xr-x. 7 root root  67 Jul 17 13:36 percona-tcl
drwxr-xr-x. 8 root root 136 Jan 10  2024 VBoxGuestAdditions-6.1.30
[root@rocky8 pgsql]# chown -R postgres:postgres /opt/percona-*
[root@rocky8 pgsql]# ll
total 0
drwxr-xr-x. 3 postgres postgres 17 Jun  5 10:39 percona-etcd
drwxr-xr-x. 7 postgres postgres 64 Jun  5 10:39 percona-haproxy
drwxr-xr-x. 4 postgres postgres 53 Jun  5 10:38 percona-patroni
drwxr-xr-x. 5 postgres postgres 39 Jun  5 10:25 percona-perl
drwxr-xr-x. 5 postgres postgres 65 Jun  5 10:38 percona-pgbackrest
drwxr-xr-x. 3 postgres postgres 85 Jun  5 10:38 percona-pgbadger
drwxr-xr-x. 6 postgres postgres 52 Jun  5 10:37 percona-pgbouncer
drwxr-xr-x. 7 postgres postgres 67 Jun  5 10:37 percona-pgpool-II
drwxr-xr-x. 7 postgres postgres 67 Jun  5 10:37 percona-postgresql16
drwxr-xr-x. 6 postgres postgres 56 Jun  5 10:29 percona-python3
drwxr-xr-x. 7 postgres postgres 67 Jun  5 10:31 percona-tcl
[root@rocky8 pgsql]# ll /opt
total 0
drwxr-xr-x. 5 postgres postgres  39 Jul 17 13:36 percona-perl
drwxr-xr-x. 6 postgres postgres  56 Jul 17 13:36 percona-python3
drwxr-xr-x. 7 postgres postgres  67 Jul 17 13:36 percona-tcl
drwxr-xr-x. 8 root     root     136 Jan 10  2024 VBoxGuestAdditions-6.1.30
[root@rocky8 pgsql]# cd
[root@rocky8 ~]# su - postgres
Last login: Wed Jul 17 13:35:24 UTC 2024 on pts/0
[postgres@rocky8 ~]$ vim .bash_profile
[postgres@rocky8 ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

export PATH=:/usr/local/pgsql/percona-haproxy/sbin/:/usr/local/pgsql/percona-patroni/bin/:/usr/local/pgsql/percona-pgbackrest/bin/:/usr/local/pgsql/percona-pgbadger/:/usr/local/pgsql/percona-pgbouncer/bin/:/usr/local/pgsql/percona-pgpool-II/bin/:/usr/local/pgsql/percona-postgresql16/bin/:/usr/local/pgsql/percona-etcd/bin/:/opt/percona-perl/bin/:/opt/percona-tcl/bin/:/opt/percona-python3/bin/:$PATH
[postgres@rocky8 ~]$ source .bash_profile
[postgres@rocky8 ~]$ exit
logout
[root@rocky8 ~]# mkdir /pgdata
[root@rocky8 ~]# chown postgres:postgres /pgdata/
[root@rocky8 ~]# su - postgres
Last login: Wed Jul 17 13:36:53 UTC 2024 on pts/0
[postgres@rocky8 ~]$ initdb -D /pgdata/
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg_ctl -D /pgdata/ -l logfile start

[postgres@rocky8 ~]$
[postgres@rocky8 ~]$
[postgres@rocky8 ~]$
[postgres@rocky8 ~]$ pg_ctl -D /pgdata/ -l logfile start
waiting for server to start.... done
server started
[postgres@rocky8 ~]$ psql
psql (16.3)
Type "help" for help.

postgres=#
postgres=#
postgres=#
postgres=# \q
could not save history to file "/home/postgres/.psql_history": Success
[postgres@rocky8 ~]$
[postgres@rocky8 ~]$ cat /etc/redhat-release
Rocky Linux release 8.9 (Green Obsidian)
[postgres@rocky8 ~]$ psql
psql (16.3)
Type "help" for help.

postgres=# WITH cur_vaccs AS (
postgres(#   SELECT split_part(split_part(substring(query from '.*..*'), '.', 2), ' ', 1) AS tab
postgres(#   FROM pg_stat_activity
postgres(#   WHERE query LIKE 'autovacuum%'
postgres(# )
postgres-# SELECT 'VACUUM (FREEZE, ANALYZE) "'|| n.nspname ||'"."' || c.relname ||'";'
postgres-# FROM pg_class c
postgres-# JOIN pg_namespace n ON c.relnamespace = n.oid
postgres-# LEFT JOIN pg_class t ON c.reltoastrelid = t.oid AND t.relkind = 't'
postgres-# WHERE c.relkind IN ('r', 'm') AND NOT EXISTS (
postgres(#   SELECT * FROM cur_vaccs WHERE tab = c.relname
postgres(# )
postgres-# ORDER BY GREATEST(age(c.relfrozenxid), age(t.relfrozenxid)) DESC
postgres-# LIMIT 100;
                                 ?column?
--------------------------------------------------------------------------
 VACUUM (FREEZE, ANALYZE) "information_schema"."sql_sizing";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_type";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_foreign_table";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_authid";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_statistic_ext_data";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_user_mapping";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_subscription";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_attribute";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_proc";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_class";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_attrdef";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_constraint";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_inherits";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_index";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_operator";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_opfamily";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_opclass";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_am";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_amop";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_amproc";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_language";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_largeobject_metadata";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_aggregate";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_statistic_ext";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_rewrite";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_trigger";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_event_trigger";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_description";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_cast";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_enum";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_namespace";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_conversion";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_depend";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_statistic";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_db_role_setting";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_tablespace";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_auth_members";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_shdepend";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_shdescription";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_ts_config";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_ts_config_map";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_ts_dict";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_ts_parser";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_ts_template";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_extension";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_foreign_data_wrapper";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_foreign_server";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_policy";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_replication_origin";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_default_acl";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_init_privs";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_seclabel";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_shseclabel";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_collation";
 VACUUM (FREEZE, ANALYZE) "pg_catalog"."pg_parameter_acl";
postgres=# \q
could not save history to file "/home/postgres/.psql_history": Success
[postgres@rocky8 ~]$ psql
psql (16.3)
Type "help" for help.

malloc(): invalid size (unsorted)
Aborted (core dumped)
[postgres@rocky8 ~]$
[postgres@rocky8 ~]$ ll /pgdata/
total 64
drwx------. 5 postgres postgres    33 Jul 17 13:39 base
drwx------. 2 postgres postgres  4096 Jul 17 13:42 global
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_commit_ts
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_dynshmem
-rw-------. 1 postgres postgres  5711 Jul 17 13:39 pg_hba.conf
-rw-------. 1 postgres postgres  2640 Jul 17 13:39 pg_ident.conf
drwx------. 4 postgres postgres    68 Jul 17 13:39 pg_logical
drwx------. 4 postgres postgres    36 Jul 17 13:39 pg_multixact
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_notify
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_replslot
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_serial
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_snapshots
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_stat
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_stat_tmp
drwx------. 2 postgres postgres    18 Jul 17 13:39 pg_subtrans
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_tblspc
drwx------. 2 postgres postgres     6 Jul 17 13:39 pg_twophase
-rw-------. 1 postgres postgres     3 Jul 17 13:39 PG_VERSION
drwx------. 3 postgres postgres    60 Jul 17 13:39 pg_wal
drwx------. 2 postgres postgres    18 Jul 17 13:39 pg_xact
-rw-------. 1 postgres postgres    88 Jul 17 13:39 postgresql.auto.conf
-rw-------. 1 postgres postgres 29676 Jul 17 13:39 postgresql.conf
-rw-------. 1 postgres postgres    70 Jul 17 13:39 postmaster.opts
-rw-------. 1 postgres postgres    73 Jul 17 13:39 postmaster.pid

Hope to get help from the community.

13

Did you notice this error message, this looks like a permissions issue? Maybe, or not, it has something to do with your issue.

postgres=# \q
**could not save history to file "/home/postgres/.psql_history"**: Success
[postgres@rocky8 ~]$
[postgres@rocky8 ~]$ cat /etc/redhat-release
Rocky Linux release 8.9 (Green Obsidian)
[postgres@rocky8 ~]$ psql
psql (16.3)
Type "help" for help.
14

One other thought. It would be helpful to reiterate the URL for the documentation you are following.

15

I wonder what the hell went wrong,didn’t anyone else come across it?it’s also a good reproduce.

[postgres@rocky8 ~]$ ll -a
total 266860
drwx------. 2 postgres postgres      4096 Jul 17 13:39 .
drwxr-xr-x. 4 root     root            37 Jul 17 13:29 ..
-rw-------. 1 postgres postgres       401 Jul 17 14:50 .bash_history
-rw-r--r--. 1 postgres postgres        18 Aug  2  2022 .bash_logout
-rw-r--r--. 1 postgres postgres       543 Jul 17 13:38 .bash_profile
-rw-r--r--. 1 postgres postgres       376 Aug  2  2022 .bashrc
-rw-------. 1 postgres postgres      2397 Jul 17 14:50 logfile
-rw-r--r--. 1 postgres postgres 273228701 Jul 17 13:29 percona-postgresql-16.3-ssl1.1-linux-x86_64.tar.gz
-rw-------. 1 postgres postgres       565 Jul 17 13:41 .psql_history
-rw-------. 1 postgres postgres      1113 Jul 17 13:38 .viminfo
[postgres@rocky8 ~]$ getenforce
Disabled
[postgres@rocky8 ~]$ systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)
[postgres@rocky8 ~]$ psql
psql (16.3)
Type "help" for help.

malloc(): invalid size (unsorted)
Aborted (core dumped)
16

I’m surprised that we haven’t had this issue internally?

17

It has been tested and installed using the Yum method without problems.So I think there’s something wrong with the binary package that this.