FATAL: bogus freespace amount

Started by Carlos Henrique Reimerabout 18 years ago2 messagesgeneral
Jump to latest
#1Carlos Henrique Reimer
carlos.reimer@opendb.com.br

Hi,

We are facing the following problem during the PostgreSQL 8.2.4 startup in a
Windows XP/SP2 box:

2008-03-31 13:35:12 1: LOG: database system was interrupted at 2008-03-31
09:45:44
2008-03-31 13:35:12 2: LOG: checkpoint record is at 0/7588FFD8
2008-03-31 13:35:12 3: LOG: redo record is at 0/7588FFD8; undo record is
at 0/0; shutdown TRUE
2008-03-31 13:35:12 4: LOG: next transaction ID: 0/100487; next OID:
909454
2008-03-31 13:35:12 5: LOG: next MultiXactId: 1; next MultiXactOffset: 0
2008-03-31 13:35:12 6: LOG: database system was not properly shut down;
automatic recovery in progress
2008-03-31 13:35:12 7: LOG: record with zero length at 0/75890038
2008-03-31 13:35:12 8: LOG: redo is not required
2008-03-31 13:35:12 9: LOG: database system is ready
2008-03-31 13:35:12 10: FATAL: bogus freespace amount
2008-03-31 13:35:12 1: LOG: startup process (PID 856) exited with exit
code 1
2008-03-31 13:35:12 2: LOG: aborting startup due to startup process
failure
2008-03-31 13:35:13 1: LOG: logger shutting down

What can be done to bring the system up again?

Thank you in advance!

Reimer

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Carlos Henrique Reimer (#1)
Re: FATAL: bogus freespace amount

"Carlos H. Reimer" <carlos.reimer@opendb.com.br> writes:

2008-03-31 13:35:12 10: FATAL: bogus freespace amount

This probably means $PGDATA/global/pg_fsm.cache has gotten trashed.
Fortunately that's just a cache --- you should be able to delete the
file and start up.

regards, tom lane