gist segmentation fault
Hello,
We're preparing to upgrade postgresql from 12.8 to 14.2 but still we have some bugs and issues. Most of them are our fault, but now we have problem wedon't know how to play with it.
-- dmesg message
[Sat Apr 2 08:26:24 2022] postmaster[1939250]: segfault at 7f2998f2c000 ip 00007f4a56cfeaaa sp 00007fff5a3e36a8 error 6 in libc-2.28.so[7f4a56b9e000+1bc000][Sat Apr 2 08:26:24 2022] Code: 8e c0 01 00 00 c5 fe 6f 06 c5 fe 6f 4e 20 c5 fe 6f 56 40 c5 fe 6f 5e 60 48 81 c6 80 00 00 00 48 81 ea 80 00 00 00 c5 fd e7 07 fd e7 4f 20 c5 fd e7 57 40 c5 fd e75f 60 48 81 c7 80 00 00 00
-- PostgreSQL Log message
2022-04-02 08:26:24 MSK 00000LOG: server process (PID 1939250) was terminated by signal 11: Segmentation fault2022-04-02 08:26:24 MSK 00000DETAIL: Failed process was running: SELECT "SubdivisionId", "UserId", "UserLogin"FROM powerbi."GetReportRights1002_VIEW" ;2022-04-02 08:26:24 MSK 00000LOG: terminating any other active server processes
-- User error message
54000: index row requires 554440232 bytes, maximum size is 8191
-- We have compiled from the source code with modified macros
sed -i.gres "s/#define NAMEDATALEN 64/#define NAMEDATALEN 320/g" ./src/include/pg_config_manual.h
sed -i.gres "s/#define NAMEDATALEN 64/#define NAMEDATALEN 320/g" ./src/interfaces/ecpg/include/sqlda-native.h
-- In the attachment files
-- DDL
-- The result of the command execution: gdb /usr/pgsql-14/bin/postgres <core dump file> --ex 'bt full' --batch
Arup Nanda <Arup.Nanda@protonmail.com> writes:
We're preparing to upgrade postgresql from 12.8 to 14.2 but still we have some bugs and issues. Most of them are our fault, but now we have problem wedon't know how to play with it.
[ crash in copy_ltree for an upgraded GIST index ]
I think this is the same problem already reported at [1]/messages/by-id/17406-71e02820ae79bb40@postgresql.org.
It's an unfortunate error in the GIST ltree opclass.
You could apply the patch [2]https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=7d30f59da locally perhaps, if you
don't want to wait around for 14.3.
regards, tom lane
[1]: /messages/by-id/17406-71e02820ae79bb40@postgresql.org
[2]: https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=7d30f59da
Thanks, Том Lane.
We will wait for the release.
Sent with ProtonMail secure email.
------- Original Message -------
On Monday, April 4th, 2022 at 17:12, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Show quoted text
Arup Nanda Arup.Nanda@protonmail.com writes:
We're preparing to upgrade postgresql from 12.8 to 14.2 but still we have some bugs and issues. Most of them are our fault, but now we have problem wedon't know how to play with it.
[ crash in copy_ltree for an upgraded GIST index ]I think this is the same problem already reported at [1].
It's an unfortunate error in the GIST ltree opclass.
You could apply the patch [2] locally perhaps, if you
don't want to wait around for 14.3.regards, tom lane
[1] /messages/by-id/17406-71e02820ae79bb40@postgresql.org
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=7d30f59da