PostgreSQL Discussion - could not send data to server: Operation not supported

Author

could not send data to server: Operation not supported

ruben

2005-09-26, 1:24 pm

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

Qingqing Zhou

2005-09-26, 8:24 pm

"ruben" <ruben20@superguai.com> wrote

>
> 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
>

It is a segment fault in Postgres process. You can compile another PG using
exactly the same envrionment with --enable-debug support (if this version is
not) and trace the core dump (if you got it). Theoretically you can bt the
core dump frames and post here.

Regards,
Qingqing

Sponsored Links