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

From Noah Silverman
Subject WEIRD CRASH?!?!
Date
Msg-id F16B1E66-2FF7-11D7-A3A3-000393AA8F3C@allresearch.com
Whole thread Raw
In response to Re: Multiple databases one directory  (Josh Berkus <josh@agliodbs.com>)
Responses Re: WEIRD CRASH?!?!
List pgsql-performance
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.
2003-01-24 18:28:06 LOG:  all server processes terminated;
reinitializing shared memory and semaphores
2003-01-24 18:28:06 LOG:  database system was interrupted at 2003-01-24
18:28:06 EST
2003-01-24 18:28:06 LOG:  checkpoint record is at 9/C4574974
2003-01-24 18:28:06 LOG:  redo record is at 9/C200D144; undo record is
at 0/0; shutdown FALSE
2003-01-24 18:28:06 LOG:  next transaction id: 5159292; next oid:
50856954
2003-01-24 18:28:06 LOG:  database system was not properly shut down;
automatic recovery in progress
2003-01-24 18:28:06 LOG:  redo starts at 9/C200D144
2003-01-24 18:28:13 LOG:  ReadRecord: record with zero length at
9/C4578CC0
2003-01-24 18:28:13 LOG:  redo done at 9/C4578C9C
2003-01-24 18:29:02 LOG:  recycled transaction log file 00000009000000C0
2003-01-24 18:29:02 LOG:  recycled transaction log file 00000009000000C1
2003-01-24 18:29:02 LOG:  recycled transaction log file 00000009000000BC
2003-01-24 18:29:02 LOG:  recycled transaction log file 00000009000000BD
2003-01-24 18:29:02 LOG:  recycled transaction log file 00000009000000BE
2003-01-24 18:29:02 LOG:  recycled transaction log file 00000009000000BF
2003-01-24 18:29:02 LOG:  database system is ready





pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Multiple databases one directory
Next
From: Josh Berkus
Date:
Subject: Re: WEIRD CRASH?!?!