From: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PostgreSQL crash with PANIC message |
Date: | 2016-03-23 18:43:31 |
Message-ID: | 56F2E3D3.4060709@evolu-s.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
a customer of ours has an old PC (CoreDuo, 4 GB RAM, Windows XP)
that's running PostgreSQL. Yesterday PostgreSQL started crashing
suddenly with the following log
2016-03-23 10:40:42 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:40:42 CET LOG: could not fork new process for connection:
unrecognized winsock error 10004
2016-03-23 10:40:43 CET LOG: could not receive data from client:
unrecognized winsock error 10055
2016-03-23 10:40:43 CET LOG: unexpected EOF on client connection
2016-03-23 10:42:48 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:48 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:49 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:49 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:50 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:50 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:51 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:51 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:52 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:52 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:53 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:53 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:54 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:54 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:55 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:55 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:42:56 CET LOG: CreateProcess call failed: unrecognized
winsock error 10004 (error code 1450)
2016-03-23 10:42:56 CET LOG: could not fork autovacuum worker process:
unrecognized winsock error 10004
2016-03-23 10:43:24 CET LOG: could not receive data from client:
unrecognized winsock error 10055
2016-03-23 10:43:24 CET LOG: unexpected EOF on client connection
2016-03-23 10:43:24 CET LOG: could not receive data from client:
unrecognized winsock error 10061
2016-03-23 10:43:24 CET LOG: unexpected EOF on client connection
2016-03-23 10:43:27 CET LOG: could not receive data from client:
unrecognized winsock error 10055
2016-03-23 10:43:27 CET LOG: unexpected EOF on client connection
2016-03-23 10:43:30 CET PANIC: could not write to log file 6, segment
217 at offset 3366912, length 8192: Invalid argument
The machine has 4,5 GB of allocated memory (thus swapping).
I googled to get some references to what's above and that's results:
Winsock 10004 means Interrupted function call;
Error code 1450 should mean "Insufficient system resources exist to
complete the requested service"
Winsock 10055 means "No buffer space available"
Winsock 10061 means "Connection refused"
The only thing I couldn't get some serious reference was the PANIC
message that's in the last row.
But putting the other things together, I figured out the machine is too
obsolete and ran out of system resources, causing error 1450, which
Winsock 10055 is solely a consequence, and probably the PANIC is
generated by this mess.
Am I right?
Thanks in advance,
Moreno.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-03-23 18:57:25 | Re: PostgreSQL crash with PANIC message |
Previous Message | mariusz | 2016-03-23 11:30:47 | Re: Including SQL files |