pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_clog after crash
4+ messages / 2 participants
[nested] [flat]
* pg_clog after crash
@ 2004-06-11 11:46 Andreas Schmitz <a.schmitz@cityweb.de>
0 siblings, 1 reply; 4+ messages in thread
From: Andreas Schmitz @ 2004-06-11 11:46 UTC (permalink / raw)
To: pgsql-admin
Hello *,
after a harddisk filling up to a 100% the database crashed. This is the output
I get when I try to start the DB again. Is there any chance to get it back
running without using a dump ?
regards,
-Andreas
2004-06-11 13:38:23 [22379] LOG: database system was interrupted while in
recovery at 2004-06-11 13:32:44 CEST
HINT: This probably means that some data is corrupted and you will have to
use the last backup for recovery.
2004-06-11 13:38:23 [22379] LOG: checkpoint record is at 25/FB90EFA4
2004-06-11 13:38:23 [22379] LOG: redo record is at 25/FB90ED88; undo record
is at 0/0; shutdown FALSE
2004-06-11 13:38:23 [22379] LOG: next transaction ID: 10185227; next OID:
17088234
2004-06-11 13:38:23 [22379] LOG: database system was not properly shut down;
automatic recovery in progress
2004-06-11 13:38:23 [22379] LOG: redo starts at 25/FB90ED88
2004-06-11 13:38:24 [22379] PANIC: could not access status of transaction
10256385
DETAIL: could not read from file "/var/data/pgsql/data/dbs_1/pg_clog/0009" at
offset 204800: Success
2004-06-11 13:38:24 [22373] LOG: startup process (PID 22379) was terminated
by signal 6
2004-06-11 13:38:24 [22373] LOG: aborting startup due to startup process
failure
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_clog after crash
@ 2004-06-11 18:01 Tom Lane <tgl@sss.pgh.pa.us>
parent: Andreas Schmitz <a.schmitz@cityweb.de>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2004-06-11 18:01 UTC (permalink / raw)
To: a.schmitz@cityweb.de; +Cc: pgsql-admin
Andreas Schmitz <a.schmitz@cityweb.de> writes:
> after a harddisk filling up to a 100% the database crashed. This is
> the output I get when I try to start the DB again. Is there any chance
> to get it back running without using a dump ?
What PG version is this?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_clog after crash
@ 2004-06-14 08:10 Andreas Schmitz <a.schmitz@cityweb.de>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Andreas Schmitz @ 2004-06-14 08:10 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Hi Tom,
PostgreSQL 7.4.1 is used in this case. I was able to fix the clog by
dd if=/dev/zero bs=8k count=1 >><CLOG_FILE
regards,
-andreas
On Friday 11 June 2004 20:01, Tom Lane wrote:
> Andreas Schmitz <a.schmitz@cityweb.de> writes:
> > after a harddisk filling up to a 100% the database crashed. This is
> > the output I get when I try to start the DB again. Is there any chance
> > to get it back running without using a dump ?
>
> What PG version is this?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a.schmitz@cityweb.de
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_clog after crash
@ 2004-06-14 12:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: Andreas Schmitz <a.schmitz@cityweb.de>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-06-14 12:25 UTC (permalink / raw)
To: a.schmitz@cityweb.de; +Cc: pgsql-admin
Andreas Schmitz <a.schmitz@cityweb.de> writes:
>> What PG version is this?
> PostgreSQL 7.4.1 is used in this case.
Now that I look at it, your report matches Chris K-L's trouble
http://archives.postgresql.org/pgsql-hackers/2004-01/msg00530.php
which is fixed in 7.4.2.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-06-14 12:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-11 11:46 pg_clog after crash Andreas Schmitz <a.schmitz@cityweb.de>
2004-06-11 18:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-14 08:10 ` Andreas Schmitz <a.schmitz@cityweb.de>
2004-06-14 12:25 ` Tom Lane <tgl@sss.pgh.pa.us>
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