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
