Postgres Pro
Downloads
Home   >   mailing lists

Thread: gist segmentation fault

gist segmentation fault

From
Arup Nanda
Date:
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
6in 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
6f56 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
4881 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-0208: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
Attachment

Re: gist segmentation fault

From
Tom Lane
Date:
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] https://www.postgresql.org/message-id/flat/17406-71e02820ae79bb40%40postgresql.org
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=7d30f59da

Re: gist segmentation fault

From
Arup Nanda
Date:
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:


> 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
ourfault, 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] https://www.postgresql.org/message-id/flat/17406-71e02820ae79bb40%40postgresql.org
> [2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=7d30f59da