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

* pg_clog after crash
@ 2004-06-11 11:46 Andreas Schmitz <a.schmitz@cityweb.de>
  2004-06-11 18:01 ` Re: pg_clog after crash Tom Lane <tgl@sss.pgh.pa.us>
  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 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   ` Re: pg_clog after crash 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-11 11:46 pg_clog after crash Andreas Schmitz <a.schmitz@cityweb.de>
  2004-06-11 18:01 ` Re: pg_clog after crash Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-06-14 08:10   ` Andreas Schmitz <a.schmitz@cityweb.de>
  2004-06-14 12:25     ` Re: pg_clog after crash 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-11 11:46 pg_clog after crash Andreas Schmitz <a.schmitz@cityweb.de>
  2004-06-11 18:01 ` Re: pg_clog after crash Tom Lane <tgl@sss.pgh.pa.us>
  2004-06-14 08:10   ` Re: pg_clog after crash Andreas Schmitz <a.schmitz@cityweb.de>
@ 2004-06-14 12:25     ` Tom Lane <tgl@sss.pgh.pa.us>
  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