Re: WEIRD CRASH?!?! - Mailing list pgsql-performance

From Noah Silverman
Subject Re: WEIRD CRASH?!?!
Date
Msg-id 22021C37-2FF9-11D7-A3A3-000393AA8F3C@allresearch.com
Whole thread Raw
In response to Re: WEIRD CRASH?!?!  (Josh Berkus <josh@agliodbs.com>)
Responses Re: WEIRD CRASH?!?!
Re: WEIRD CRASH?!?!
Re: WEIRD CRASH?!?!
List pgsql-performance
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
>
>


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: WEIRD CRASH?!?!
Next
From: Josh Berkus
Date:
Subject: Re: WEIRD CRASH?!?!