Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group