Re: WEIRD CRASH?!?!

Noah,

> I think my server crashed and then restarted itself. Does anybody know
> what all this means:
>
> 2003-01-24 18:28:06 PANIC: link from
> /RAID/pgsql/pg_xlog/00000009000000BC to
> /RAID/pgsql/pg_xlog/00000009000000C4 (initialization of log file 9,
> segment 196) failed: File exists
> 2003-01-24 18:28:06 LOG: server process (pid 1574) was terminated by
> signal 6
> 2003-01-24 18:28:06 LOG: terminating any other active server processes
> 2003-01-24 18:28:06 WARNING: Message from PostgreSQL backend:
> The Postmaster has informed me that some other backend
> died abnormally and possibly corrupted shared memory.
> I have rolled back the current transaction and am
> going to terminate your database system connection and exit.
> Please reconnect to the database system and repeat your query.

This means that somebody KILL -9'd a postgres process or the postmaster, and
Postgres restarted in order to clear the shared buffers. If the database
started up again, you are fine.

--
-Josh Berkus
Aglio Database Solutions
San Francisco