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