PGSQL service dieing...
My pgsql service keeps dieing and has a bunch of errors like this in the
server log, eventually it stops giving these
Warning: terminatin 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 nother server process exited
abnormally and possible corrupted shared memory
Hint: ina moment you should be able to reconnect to the database and repeat
your command
And starts giving these:
FATAL: the database system is in recovery mode
Could a series of commands, say perhaps a few hundred of the course of an
hour, that had incorrect syntax cause a problem like this? Is there
anywhere I can go for more info?
Dan
Daniel Baughman wrote:
Warning: terminatin 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 nother server process exited
abnormally and possible corrupted shared memory
Hint: ina moment you should be able to reconnect to the database and repeat
your command
There should be something to say what killed "another server process".
Could a series of commands, say perhaps a few hundred of the course of an
hour, that had incorrect syntax cause a problem like this? Is there
anywhere I can go for more info?
No - backends should only die in the event of hardware problems/out of
memory/disk or they've been killed by an administrator.
The first thing you'll need to do is find out why the initial problem
occurs. There should be something in the logs to say what is happening.
--
Richard Huxton
Archonet Ltd
"Daniel Baughman" <danrb@codenet.net> writes:
My pgsql service keeps dieing and has a bunch of errors like this in the
server log, eventually it stops giving these
Warning: terminatin connection because of crash of another server process
Those are just fallout. Show us the original problem.
regards, tom lane
What version and what platform is this on?
Show quoted text
On Fri, Jun 18, 2004 at 01:33:43PM -0600, Daniel Baughman wrote:
My pgsql service keeps dieing and has a bunch of errors like this in the
server log, eventually it stops giving theseWarning: terminatin 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 nother server process exited
abnormally and possible corrupted shared memory
Hint: ina moment you should be able to reconnect to the database and repeat
your commandAnd starts giving these:
FATAL: the database system is in recovery mode
Could a series of commands, say perhaps a few hundred of the course of an
hour, that had incorrect syntax cause a problem like this? Is there
anywhere I can go for more info?Dan
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match