It is home PC box with debian sid. Recently my postgres was upgraded from version 11 to 12. I migrate databases, and during last few days I have had 2 server crashes. Crashes were during different statements. And after crash these statements executed successfully. In log I have: =============================================================== 2019-11-04 00:07:38 CET LOG: server process (PID 19244) was terminated by signal 11: Segmentation fault 2019-11-04 00:07:38 CET DETAIL: Failed process was running: update queue set priority = -3 ; 2019-11-04 00:07:38 CET LOG: terminating any other active server processes [...] 2019-11-04 00:07:39 CET LOG: all server processes terminated; reinitializing 2019-11-04 00:07:39 CET DEBUG: mmap(150994944) with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory 2019-11-04 00:07:39 CET LOG: database system was interrupted; last known up at 2019-11-04 00:02:24 CET =============================================================== 2019-11-05 21:43:56 CET LOG: server process (PID 23233) was terminated by signal 11: Segmentation fault 2019-11-05 21:43:56 CET DETAIL: Failed process was running: SELECT po_nr FROM get_free_numbers(999); 2019-11-05 21:43:56 CET LOG: terminating any other active server processes [...] 2019-11-05 21:43:57 CET LOG: all server processes terminated; reinitializing 2019-11-05 21:43:57 CET DEBUG: mmap(150994944) with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory 2019-11-05 21:43:58 CET LOG: database system was interrupted; last known up at 2019-11-05 21:43:49 CET ===============================================================
any hints? KJ -- http://wolnelektury.pl/wesprzyj/teraz/ we: The single most important word in the world.