covergogl.blogg.se

build/./src/backend/access/transam/xact.c:3085 build/./src/backend/access/transam/xact.c:2087 build/./src/backend/utils/mmgr/portalmem.c:738 build/./src/backend/utils/mmgr/portalmem.c:642 build/./src/backend/commands/portalcmds.c:407 #13 0x0000557cc1cdbcd4 in PersistHoldablePortal at. build/./contrib/pg_stat_statements/pg_stat_statements.c:1045 #12 0x00007f0ec05ae09d in pgss_ExecutorRun (queryDesc=0x557cc2e1a5a0, direction=ForwardScanDirection, count=0, execute_once=) at. build/./src/backend/executor/execMain.c:350

#11 standard_ExecutorRun (queryDesc=0x557cc2e1a5a0, direction=, count=0, execute_once=) at. build/./src/backend/executor/execMain.c:1632 #10 ExecutePlan (execute_once=, dest=0x557cc2e1a630, direction=, numberTuples=0, sendTuples=, operation=CMD_SELECT, use_parallel_mode=, planstate=0x557cc2ea1558,Įstate=0x557cc2ea12f8) at. build/./src/include/executor/executor.h:248 build/./src/backend/executor/nodeMergejoin.c:1353 build/./src/backend/executor/nodeMergejoin.c:494 build/./src/include/executor/executor.h:391 build/./src/include/executor/executor.h:322 build/./src/backend/executor/execExprInterp.c:482 build/./src/include/executor/tuptable.h:344 build/./src/backend/executor/execTuples.c:1912 build/./src/backend/executor/execTuples.c:695

build/./src/backend/executor/execTuples.c: No such file or directory. build/./src/backend/executor/execTuples.c:930ĩ30. Program terminated with signal SIGSEGV, Segmentation fault. Gdb backtrace gives following output $ gdb /usr/lib/postgresql/13/bin/postgres 13/main/core.postgres.12264 Max core file size unlimited unlimited bytes Now it seems to allow core dumps: $ for f in `pgrep postgres` do cat /proc/$f/limits | grep core done I've updated /etc/postgresql/13/main/pg_ctl.conf to include core dumps pg_ctl_options = '-core-files'Īnd restarted postgresql service. WARNING: terminating connection because of crash of another server processĭETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. LOG: terminating any other active server processes I have a PostgreSQL 13 instance that keeps crashing: LOG: server process (PID 10722) was terminated by signal 11: Segmentation faultĭETAIL: Failed process was running: COMMIT