From: | andy rost <Andy(dot)Rost(at)noaa(dot)gov> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | URGENT - startup process (PID 29541) was terminated by signal 6 |
Date: | 2006-10-06 17:50:22 |
Message-ID: | 4526975E.7030003@noaa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Our Opteron DB server had a problem with its RAID controller requiring
an immediate shutdown of our Postgres server (8.1.3 on FreeBSD 6.0
release number 10). We used kill -QUIT on the postmaster PID.
After repairing and rebooting the server we tried to start Postgres and
get the following:
2006-10-06 12:32:40 CDT FATAL: the database system is starting up
2006-10-06 12:32:40 CDT FATAL: the database system is starting up
2006-10-06 12:32:40 CDT PANIC: heap_clean_redo: no block
2006-10-06 12:32:40 CDT LOG: startup process (PID 29541) was terminated
by signal 6
2006-10-06 12:32:40 CDT LOG: aborting startup due to startup process
failure
At shutdown we had the following:
2006-10-06 12:08:48 CDT PANIC: right sibling is not next child in
"winddir_idxu"
2006-10-06 12:08:48 CDT STATEMENT: VACUUM ANALYZE VERBOSE
2006-10-06 12:08:49 CDT LOG: server process (PID 91933) was terminated
by signal 6
2006-10-06 12:08:49 CDT LOG: terminating any other active server processes
Anything I can do?
--------------------------------------------------------------------------------
Andrew Rost
National Operational Hydrologic Remote Sensing Center (NOHRSC)
National Weather Service, NOAA
1735 Lake Dr. West, Chanhassen, MN 55317-8582
Voice: (952)361-6610 x 234
Fax: (952)361-6634
andy(dot)rost(at)noaa(dot)gov
http://www.nohrsc.noaa.gov
--------------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | John D. Burger | 2006-10-06 18:12:23 | Re: Two efficiency questions - clustering and ints |
Previous Message | Joshua D. Drake | 2006-10-06 16:17:26 | Re: PostgreSQL Database Transfer between machines(again) |