From: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Database corupption on pg 7.3.3 |
Date: | 2003-08-30 08:44:07 |
Message-ID: | 3F5063D7.FC2B1389@t1.unisoftbg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have had two times problem with pg database corruption.
My system:
Dual athlon 2.4
1 GB RAM,
linux red hat 7.3
reiserFS
Also on the system I have cron that every 3 h. make dump and every 24 h.
make vacuum full analyze.
After working some days pg crashes and I was not able to restore it.
I found tis messages into the log:
Lock file "/mnt/diske/skladdb/postmaster.pid" already exists.
Is another postmaster (pid 1208) running in "/mnt/diske/skladdb"?
LOG: database system was interrupted at 2003-08-22 20:10:51 EEST
LOG: checkpoint record is at 0/1829A1E4
LOG: redo record is at 0/1829A1E4; undo record is at 0/0; shutdown
FALSE
LOG: next transaction id: 45726; next oid: 13875914
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/1829A224
PANIC: Invalid page header in block 4 of 16645
LOG: startup process (pid 1212) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-08-25
09:03:14 EEST
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at 0/1829A1E4
LOG: redo record is at 0/1829A1E4; undo record is at 0/0; shutdown
FALSE
LOG: next transaction id: 45726; next oid: 13875914
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/1829A224
PANIC: Invalid page header in block 4 of 16645
LOG: startup process (pid 1211) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-08-25
09:10:29 EEST
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at 0/1829A1E4
LOG: redo record is at 0/1829A1E4; undo record is at 0/0; shutdown
FALSE
LOG: next transaction id: 45726; next oid: 13875914
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/1829A224
PANIC: Invalid page header in block 4 of 16645
LOG: startup process (pid 1211) was terminated by signal 6
LOG: aborting startup due to startup process failure
Pls, help me to solve this problem.
regards,
ivan.
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2003-08-30 09:46:08 | Re: Multiple Connections |
Previous Message | Bruce Momjian | 2003-08-30 05:02:35 | Re: [Fwd: Postgresql-7.4beta1 compilation error] |