Re: PITR COPY Failure (was Point in Time Recovery)

From: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
To: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PITR COPY Failure (was Point in Time Recovery)
Date: 2004-07-20 00:48:50
Message-ID: 40FC6BF2.5050701@coretech.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-patches

I have been doing some re-testing with CVS HEAD from about 1 hour ago
using the simplified example posted previously.

It is quite interesting:

i) create the table as:

CREATE TABLE test0 (filler TEXT);

and COPY 100 000 rows on length 109, then recovery succeeds.

ii) create the table as:

CREATE TABLE test0 (filler VARCHAR(120));

and COPY as above, then recovery *fails* with the the signal 6 error below.

LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/A4807C
LOG: record with zero length at 0/FFFFE0
LOG: redo done at 0/FFFF30
LOG: restored log file "0000000000000000" from archive
LOG: archive recovery complete
PANIC: concurrent transaction log activity while database system is
shutting down
LOG: startup process (PID 17546) was terminated by signal 6
LOG: aborting startup due to startup process failure

(I am pretty sure both TEXT and VARCHAR(120) failed using the original
patch)

Any suggestions for the best way to dig a bit deeper?

regards

Mark

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-07-20 01:22:42 Re: [HACKERS] Point in Time Recovery
Previous Message Simon Riggs 2004-07-19 22:14:24 Re: [HACKERS] Point in Time Recovery

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-07-20 01:20:35 Re: pg_dump bug fixing
Previous Message Gavin M. Roy 2004-07-20 00:36:44 Re: localhost redux

Browse pgsql-patches by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-07-20 01:22:42 Re: [HACKERS] Point in Time Recovery
Previous Message Simon Riggs 2004-07-19 22:14:24 Re: [HACKERS] Point in Time Recovery