pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Fw: postgres database crash
2+ messages / 2 participants
[nested] [flat]

* Fw: postgres database crash
@ 2006-11-22 00:29 anil maran <anilmrn@yahoo.com>
  2006-11-22 02:01 ` Re: Fw: postgres database crash Richard Broersma Jr <rabroersma@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: anil maran @ 2006-11-22 00:29 UTC (permalink / raw)
  To: pgsql-admin

Hi
CRON job running vacuum on a database and pg_ctl stop -m fast got called

Now I m unable to run the database, the following is the error when I run pg_ctl -D /work/database start
LOG:  logger shutting down

on running 
tail -n 30 postgresql-Mon.log 
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LOG:  startup process (PID 31612) was terminated by signal 6 
LOG:  aborting startup due to startup process failure
LOG:  logger shutting down
LOG:  database system was interrupted while in recovery at 2006-11-20 16:56:18 PST
HINT:  This probably means that some data is corrupted and you will have to use the last backup for recovery. 
LOG:  checkpoint record is at 8A/8F01D6D4
LOG:  redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE
LOG:  next transaction ID: 32782967; next OID: 2499839
LOG:  next MultiXactId: 972; next MultiXactOffset: 2099 
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LOG:  startup process (PID 31846) was terminated by signal 6
LOG:  aborting startup due to startup process failure 
LOG:  logger shutting down
LOG:  database system was interrupted while in recovery at 2006-11-20 17:12:21 PST
HINT:  This probably means that some data is corrupted and you will have to use the last backup for recovery. 
LOG:  checkpoint record is at 8A/8F01D6D4
LOG:  redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE
LOG:  next transaction ID: 32782967; next OID: 2499839
LOG:  next MultiXactId: 972; next MultiXactOffset: 2099 
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 8A/8F00833C
PANIC:  block 1100 unfound
LOG:  startup process (PID 32000) was terminated by signal 6
LOG:  aborting startup due to startup process failure 
LOG:  logger shutting down

pg_controldata 
pg_control version number:            812
Catalog version number:               200510211
Database system identifier:           4952196794948500735 
Database cluster state:               in recovery
pg_control last modified:             Mon 20 Nov 2006 05:14:36 PM PST
Current log file ID:                  138
Next log file segment:                170
Latest checkpoint location:           8A/8F01D6D4 
Prior checkpoint location:            8A/8C01924C
Latest checkpoint's REDO location:    8A/8F00833C
Latest checkpoint's UNDO location:    0/0
Latest checkpoint's TimeLineID:       1
Latest checkpoint's NextXID:          32782967 
Latest checkpoint's NextOID:          2499839
Latest checkpoint's NextMultiXactId:  972
Latest checkpoint's NextMultiOffset:  2099
Time of latest checkpoint:            Mon 20 Nov 2006 12:53:56 PM PST
Maximum data alignment:               4 
Database block size:                  8192
Blocks per segment of large relation: 131072
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32 
Date/time type storage:               floating-point numbers
Maximum length of locale name:        128
LC_COLLATE:                            en_US.UTF-8
LC_CTYPE:                              en_US.UTF-8


I tried running pg_resetxlog everything got lost, so restoring the copied database folder

I got pointers to looking at pg_filedump and I could not find out how to specify options to filedump
Please help me out
my data bases is like 1gigabyte, panicking
thanks

 
Anil


 
____________________________________________________________________________________
Sponsored Link

Mortgage rates near 39yr lows. $510k for $1,698/mo. 
Calculate new payment! www.LowerMyBills.com/lre

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Fw: postgres database crash
  2006-11-22 00:29 Fw: postgres database crash anil maran <anilmrn@yahoo.com>
@ 2006-11-22 02:01 ` Richard Broersma Jr <rabroersma@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Broersma Jr @ 2006-11-22 02:01 UTC (permalink / raw)
  To: anil maran <anilmrn@yahoo.com>; pgsql-admin

> Please help me out
> my data bases is like 1gigabyte, panicking
> thanks

May be try the general mailing list.  There are more users there with the experience needed to
advise you.

Regards,

Richard Broersma Jr.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-11-22 02:01 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-22 00:29 Fw: postgres database crash anil maran <anilmrn@yahoo.com>
2006-11-22 02:01 ` Richard Broersma Jr <rabroersma@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox