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
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 |
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 |
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 |