Re: WEIRD CRASH?!?!

Yes,
but I'm the only one logged into this box, and I didn't kill anything.
It appears to have died all by itself.

Thanks,

-N


On Friday, January 24, 2003, at 07:03 PM, Josh Berkus wrote:

> 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
>
>