gist segmentation fault

From: Arup Nanda <Arup(dot)Nanda(at)protonmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: gist segmentation fault
Date: 2022-04-04 08:35:44
Message-ID: 994tHPj4OUk0AygGbSjyII6ekE4SXMS67yNG4dMYFwNBSmrKQCREefkCZJ1ir8Tvmw1NvWZM5PVLz2d1ye54OoT0TAlpIExFKnFk3KZP3Dk=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Attachment Content-Type Size
ddl.sql text/plain 3.9 KB
coredump.txt text/plain 23.5 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastien Flaesch 2022-04-04 11:33:14 Transaction and SQL errors
Previous Message David G. Johnston 2022-04-04 01:57:25 Re: PostgreSQL JSON