Re: postgresql-12 - crash. Any hints.
kjonca@poczta.onet.pl (Kamil Jońca) writes:
> 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
Today was another crash.
Another piece of a puzzle: There is (unlogged) table with 70M+
rows. After crash this table is empty (but table itself exists.)
KJ
--
http://wolnelektury.pl/wesprzyj/teraz/
If A equals success, then the formula is _A = _X + _Y + _Z. _X is work. _Y
is play. _Z is keep your mouth shut.
-- Albert Einstein
Reply to: