WEIRD CRASH?!?!

From: Noah Silverman <noah(at)allresearch(dot)com>
To: josh(at)agliodbs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: WEIRD CRASH?!?!
Date: 2003-01-24 23:59:58
Message-ID: F16B1E66-2FF7-11D7-A3A3-000393AA8F3C@allresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-01-25 00:03:42 Re: WEIRD CRASH?!?!
Previous Message Josh Berkus 2003-01-24 23:22:28 Re: Multiple databases one directory