[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

postgresql-12 - crash. Any hints.



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.


Reply to: