Hi:
A PHP script that is running every 30 minutes for three years has
crashed when updating a Postgres database table with this error message:
"pg_exec() query failed: could not send data to server: Operation not
supported"
I just ran it again and it worked fine. I could not find a single page
about this error in Google. This is the output of the logfile:
LOG: server process (PID 7069) was terminated by signal 11
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: 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.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2005-09-26 16:49:43 CEST
LOG: checkpoint record is at 125/858E0144
LOG: redo record is at 125/858E0144; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 2270061; next OID: 30820346
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 125/858E0184
LOG: redo is not required
LOG: database system is ready
LOG: unexpected EOF on client connection
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
