Hi again..
There are no kernel messages and I do not seem to find anything related
to this error code. The version installed is the last version available
in Debian testing branch:
postgresql-8.1 8.1.4-6
I have searched and there are not any known bugs about XID or processes
exiting unexpectedly
Any more ideas, please?.
Thanks for your time Alvaro :).
---
Mario.
Alvaro Herrera escribió:
Hola,
Mario Lopez wrote:
Hola Alvaro,
The process that are being reaped are postgresql child processes, more
precisely the process that is attending my queryes...
Here I have another log that has the %p %i and %x in that order but I
see no clear difference.
I see the same as you: the process that dies is the one that was doing
the INSERT. There's no stated reason for the failure however ... the
process just exits with code 255. I don't remember seeing this before.
Is there anything on the kernel messages? I doubt it's the kernel,
because we'd be seeing something about getting a signal, and I don't
think it would be this reproducible.
Maybe someone else has an idea? The previous-to-last message below is
"server process exited with exit code 255".
What PostgreSQL version is this exactly?
Maybe this is the case where proc_exit() is called when it was already
running? i.e. proc_exit(proc_exit_inprogress)? Alas, no, I see that
that would return with exit code 1, not 255.
PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: StartTransaction
PID:3559 CMD_TAG:idle XID:273990713 UBICACI?N: ShowTransactionState, xact.c:3930
PID:3559 CMD_TAG:idle XID:273990713 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 273990713/1/0, nestlvl: 1, children: <>
PID:3559 CMD_TAG:idle XID:273990713 UBICACI?N: ShowTransactionStateRec, xact.c:3955
PID:3559 CMD_TAG:INSERT XID:273990713 DEBUG: 00000: ProcessQuery
PID:3559 CMD_TAG:INSERT XID:273990713 UBICACI?N: ProcessQuery, pquery.c:128
PID:3524 CMD_TAG: XID: DEBUG: 00000: reaping dead processes
PID:3524 CMD_TAG: XID: UBICACI?N: reaper, postmaster.c:2021
PID:3524 CMD_TAG: XID: DEBUG: 00000: proceso de servidor (PID 3559) termin? con c?digo de salida 255
PID:3524 CMD_TAG: XID: UBICACI?N: LogChildExit, postmaster.c:2419
