From: | Mike Richards <mrmikerich(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | A couple serious errors |
Date: | 2004-11-18 10:39:12 |
Message-ID: | 516d7fa804111802392b47b7a2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Over the past couple days I started seeing errors like this in my server logs:
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.
Then tonight I started getting one like this:
FATAL: semctl(0, 0, SETVAL, 0) failed: Identifier removed
Postgresql is primarily being used for a web application here, and the
first of these errors starts popping up after things have been running
for 3-4 hours (I don't have any idea about the second because tonight
is the first I've seen it). Once it starts, about 1 in every 3-4 web
requests that hit the database fail.
It may just be coincidence, but this all seemed to start a few nights
ago right after I ran a full vacuum. Since then I've dumped and
reloaded the database and have upgraded from 7.3 -> 7.4.6, but the
problem persists.
I've found that most of the time restarting Apache will cure the
problem, but obviously this is less-than-ideal as a long-term
solution.
Searching google reveals that several other people have also seen
error messages like the first, and that it is not the root of the
problem but a symptom. I'm not sure which logging options to use to
get the necessary details for solving this, but if this isn't enough
to go on, just tell me what to uncomment and/or change I'll get you
more info.
Thanks,
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Dawid Kuroczko | 2004-11-18 11:17:01 | Re: Tsearch2 and Unicode? |
Previous Message | Markus Wollny | 2004-11-18 10:08:38 | Re: Tsearch2 and Unicode? |