psql crash with custom build on RedHat 7

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема psql crash with custom build on RedHat 7
Дата
Msg-id CAFCRh-_MigeAmKWPD1QxdmC70m0Lzx1-y3NsU=cfiHK4pYc9Hw@mail.gmail.com
обсуждение исходный текст
Ответы Re: psql crash with custom build on RedHat 7
Список pgsql-general
Дерево обсуждения
Hi. We've recently upgraded from libpq 15.2 to 16.1.
We custom build postgresql using the instructions and GCC 9.1 (from RH7's dts9).
We used the same process for building 15.2 and 16.1.
But somehow psql crashes on any backslash command, while 15.2 works fine.
I've included the small backtrace below.
I've used \conninfo, but \dn crashes just the same.
Regular SQL OTOH is fine (I tried that, before sending this email), so this is specific to backslash commands too.
At this point, we're not sure what's going on.
I've tried against a 14.8 server (as shown below), but also a 12.5 one, same results.
So it seems related to the client side and how it was compiled, not the server side.

16.1 (custom) built on Windows, or on RH8 with GCC 12 work fine OTOH.

Would anyone have a clue why 16.1 on RH7 would fail as shown below?
Were there any specific changes between 15.2 and 16.1 that could explain this behavior?

Another data-point, our own apps built using our custom-built libpq on RH7 (the same one used by psql, see ldd below) pass all their unit tests, and obviously no crashes.

Thanks for any help, clues, anything that might help. Thanks, --DD

[ddevienne@marsu SharedComponents]$ ldd .../postgresql/16.1/Linux_x64_2.17_gcc91/bin/psql
        linux-vdso.so.1 =>  (0x00007ffcf9cb1000)
        libpq.so.5 => .../postgresql/16.1/Linux_x64_2.17_gcc91//lib/libpq.so.5 (0x00007f278e8e6000)
        libreadline.so.6 => /lib64/libreadline.so.6 (0x00007f278e4d4000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f278e2b8000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f278e0b0000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f278ddae000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f278d9e1000)
        libssl.so.10 => /lib64/libssl.so.10 (0x00007f278d770000)
        libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f278d30f000)
        libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f278d0e5000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f278e71a000)
        libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f278ce98000)
        libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f278cbb0000)
        libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f278c9ac000)
        libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f278c779000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f278c575000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f278c35f000)
        libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f278c151000)
        libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f278bf4d000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f278bd34000)
        libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f278bb0d000)
        libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f278b8ab000)
[ddevienne@marsu SharedComponents]$ cat /etc/redhat-release
Red Hat Enterprise Linux Workstation release 7.5 (Maipo)

[ddevienne@marsu SharedComponents]$ gdb .../postgresql/16.1/Linux_x64_2.17_gcc91/bin/psql
GNU gdb (GDB) Red Hat Enterprise Linux 8.3-3.el7
Copyright (C) 2019 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
    <http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from .../postgresql/16.1/Linux_x64_2.17_gcc91/bin/psql...
(No debugging symbols found in .../postgresql/16.1/Linux_x64_2.17_gcc91/bin/psql)
(gdb) run postgresql://ddevienne@db/migrated
Starting program: .../postgresql/16.1/Linux_x64_2.17_gcc91/bin/psql postgresql://ddevienne@db/migrated
Missing separate debuginfos, use: debuginfo-install glibc-2.17-222.el7.x86_64
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Password for user ddevienne:
psql (16.1, server 14.8)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, compression: off)
Type "help" for help.

migrated=> \conninfo

Program received signal SIGSEGV, Segmentation fault.
0x00000000004232b8 in slash_yylex ()
Missing separate debuginfos, use: debuginfo-install keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-18.el7.x86_64 libcom_err-1.42.9-11.el7.x86_64 libselinux-2.5-12.el7.x86_64 ncurses-libs-5.9-14.20130511.el7_4.x86_64 openssl-libs-1.0.2k-12.el7.x86_64 pcre-8.32-17.el7.x86_64 readline-6.2-10.el7.x86_64 zlib-1.2.7-17.el7.x86_64
(gdb) bt
#0  0x00000000004232b8 in slash_yylex ()
#1  0x000000000042456b in psql_scan_slash_command ()
#2  0x000000000040d56f in HandleSlashCmds ()
#3  0x0000000000421d63 in MainLoop ()
#4  0x0000000000405c5c in main ()
(gdb)

В списке pgsql-general по дате отправления:

Предыдущее
От: Ilya Kosmodemiansky
Дата:
Сообщение: Re: Read write performance check
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: psql crash with custom build on RedHat 7