Hi list,
I'm running postgresql 8.0.1 on FreeBSD 4.11-STABLE, the machine is
and AMD Sempron 2.2, 1GB Ram..
I use postgresql as database for dspam, an spam classification
program. This database have and moderated use, on averange 20
simultaneous conections executing relative big queries using "in"
clausule.
Watching postgresql logs I see the following messages ocurs a lot of
times in a day:
May 3 06:58:44 e-filter postgres[250]: [21-1] LOG: server process
(PID 59608) was terminated by signal 10
May 3 06:58:44 e-filter postgres[250]: [22-1] LOG: terminating any
other active server processes
May 3 06:58:44 e-filter postgres[59605]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59605]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59605]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59605]: [21-4] HINT: In a moment
you should be able to reconnect to the database and repeat your
command.
May 3 06:58:44 e-filter postgres[59607]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59607]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59607]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59607]: [21-4] HINT: In a moment
you should be able to reconnect to the database and repeat your
command.
May 3 06:58:44 e-filter postgres[59606]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59606]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59606]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59606]: [21-4] HINT: In a moment
you should be able to reconnect to the database and repeat your
command.
May 3 06:58:44 e-filter postgres[59626]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59626]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59626]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59626]: [21-4] HINT: In a moment
you should be able to reconnect to the database and repeat your
command.
May 3 06:58:44 e-filter postgres[59628]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59629]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59629]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59629]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59629]: [21-4] HINT: In a moment
you should be able to reconnect to the database and repeat your
command.
May 3 06:58:44 e-filter postgres[59628]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59628]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59628]: [21-4] HINT: In a moment
you should be able to reconnect to the database and repeat your
command.
May 3 06:58:44 e-filter postgres[59609]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59609]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59609]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59609]: [21-4] HINT: In a moment
you should be able to reconnect to the database and repeat your
command.
May 3 06:58:44 e-filter postgres[59627]: [21-1] WARNING: terminating
connection because of crash of another server process
May 3 06:58:44 e-filter postgres[59627]: [21-2] DETAIL: The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
May 3 06:58:44 e-filter postgres[59627]: [21-3] process exited
abnormally and possibly corrupted shared memory.
May 3 06:58:44 e-filter postgres[59627]: [21-4] HINT: In a moment
you should