Re: WAL does not recover gracefully from out-of-disk-space

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Vadim Mikheev <vadim4o(at)email(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: WAL does not recover gracefully from out-of-disk-space
Date: 2001-03-08 04:16:01
Message-ID: 3AA70781.2E3A4533@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Was the following bug already fixed ?

Regards,
Hiroshi Inoue

Tom Lane wrote:
>
> With current sources:
>
> DEBUG: copy: line 629980, XLogWrite: new log file created - try to increase WAL_FILES
> DEBUG: copy: line 694890, XLogWrite: new log file created - try to increase WAL_FILES
> FATAL 2: copy: line 759383, ZeroFill(logfile 0 seg 13) failed: No space left on device
> Server process (pid 3178) exited with status 512 at Fri Feb 23 21:53:19 2001
> Terminating any active server processes...
> Server processes were terminated at Fri Feb 23 21:53:19 2001
> Reinitializing shared memory and semaphores
> DEBUG: starting up
> DEBUG: database system was interrupted at 2001-02-23 21:53:11
> DEBUG: CheckPoint record at (0, 21075456)
> DEBUG: Redo record at (0, 21075456); Undo record at (0, 0); Shutdown TRUE
> DEBUG: NextTransactionId: 4296; NextOid: 145211
> DEBUG: database system was not properly shut down; automatic recovery in progress...
> DEBUG: redo starts at (0, 21075520)
> The Data Base System is starting up
> DEBUG: open(logfile 0 seg 0) failed: No such file or directory
> TRAP: Failed Assertion("!(readOff > 0):", File: "xlog.c", Line: 1441)
> !(readOff > 0) (0) [Bad file descriptor]
> postmaster: Startup proc 3179 exited with status 134 - abort

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ian Lance Taylor 2001-03-08 05:52:00 Re: Proposed WAL changes
Previous Message Bruce Momjian 2001-03-08 03:34:39 Re: Performance monitor