pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_basebackup WAL -- invalid pages
2+ messages / 2 participants
[nested] [flat]
* pg_basebackup WAL -- invalid pages
@ 2012-12-03 20:44 Darron <darron@realtyserver.com>
2012-12-03 21:16 ` Re: pg_basebackup WAL -- invalid pages Lonni J Friedman <netllama@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Darron @ 2012-12-03 20:44 UTC (permalink / raw)
To: pgsql-admin
Running PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu, compiled by gcc
(Debian 4.4.5-8) 4.4.5, 64-bit
Having some issues with streaming replication. After creating a basebackup
with pg_basebackup, I get the following in the logs when starting the backup
as a steaming hot standby.
2012-12-03 20:27:08 GMT 21494 dLOG: database system was interrupted while
in recovery at log time 2012-11-29 21:32:38 GMT
2012-12-03 20:27:08 GMT 21494 dHINT: If this has occurred more than once
some data might be corrupted and you might need to choose an earlier
recovery target.
2012-12-03 20:27:08 GMT 21494 dLOG: entering standby mode
2012-12-03 20:27:08 GMT 21494 dDEBUG: checkpoint record is at 1C/E28B7978
2012-12-03 20:27:08 GMT 21494 dDEBUG: redo record is at 1C/E2000020;
shutdown FALSE
2012-12-03 20:27:08 GMT 21494 dDEBUG: next transaction ID: 0/1903870;
next OID: 249837974
2012-12-03 20:27:08 GMT 21494 dDEBUG: next MultiXactId: 1; next
MultiXactOffset: 0
2012-12-03 20:27:08 GMT 21494 dDEBUG: oldest unfrozen transaction ID:
673, in database 1
2012-12-03 20:27:08 GMT 21494 dDEBUG: transaction ID wrap limit is
2147484320, limited by database with OID 1
2012-12-03 20:27:08 GMT 21494 dDEBUG: resetting unlogged relations:
cleanup 1 init 0
2012-12-03 20:27:08 GMT 21494 dDEBUG: initializing for hot standby
2012-12-03 20:27:08 GMT 21494 dLOG: consistent recovery state reached at
1C/E28B79D8
2012-12-03 20:27:08 GMT 21494 dLOG: redo starts at 1C/E2000020
2012-12-03 20:27:08 GMT 21494 dDEBUG: recovery snapshots are now enabled
2012-12-03 20:27:08 GMT 21494 dCONTEXT: xlog redo running xacts: nextXid
1903870 latestCompletedXid 1903869 oldestRunningXid 1903870
2012-12-03 20:27:08 GMT 21492 dLOG: database system is ready to accept
read only connections
2012-12-03 20:27:09 GMT 21494 dWARNING: page 27 of relation
base/103111746/231701662 does not exist
2012-12-03 20:27:09 GMT 21494 dCONTEXT: xlog redo visible: rel
1663/103111746/231701662; blk 27
2012-12-03 20:27:09 GMT 21494 dPANIC: WAL contains references to invalid
pages
2012-12-03 20:27:09 GMT 21494 dCONTEXT: xlog redo visible: rel
1663/103111746/231701662; blk 27
2012-12-03 20:27:09 GMT 21492 dLOG: startup process (PID 21494) was
terminated by signal 6: Aborted
2012-12-03 20:27:09 GMT 21492 dLOG: terminating any other active server
processes
2012-12-03 20:27:09 GMT 21493 dDEBUG: logger shutting down
The Autovacumm launcher is running on the master postgres server, would that
cause issues with pg_basebackup. Any ideas what the problem could be?
Thanks,
Darron
_____
I am using the Free version of SPAMfighter <http://www.spamfighter.com/len;
.
SPAMfighter has removed 2 of my spam emails to date.
Do you have a slow PC? <http://www.spamfighter.com/SLOW-PCfighter?cid=sigen;
Try free scan!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_basebackup WAL -- invalid pages
2012-12-03 20:44 pg_basebackup WAL -- invalid pages Darron <darron@realtyserver.com>
@ 2012-12-03 21:16 ` Lonni J Friedman <netllama@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Lonni J Friedman @ 2012-12-03 21:16 UTC (permalink / raw)
To: Darron <darron@realtyserver.com>; +Cc: pgsql-admin
On Mon, Dec 3, 2012 at 12:44 PM, Darron <darron@realtyserver.com> wrote:
> Running PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu, compiled by gcc
> (Debian 4.4.5-8) 4.4.5, 64-bit
>
>
>
> Having some issues with streaming replication. After creating a basebackup
> with pg_basebackup, I get the following in the logs when starting the backup
> as a steaming hot standby.
>
>
>
> 2012-12-03 20:27:08 GMT 21494 dLOG: database system was interrupted while
> in recovery at log time 2012-11-29 21:32:38 GMT
>
> 2012-12-03 20:27:08 GMT 21494 dHINT: If this has occurred more than once
> some data might be corrupted and you might need to choose an earlier
> recovery target.
>
> 2012-12-03 20:27:08 GMT 21494 dLOG: entering standby mode
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: checkpoint record is at 1C/E28B7978
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: redo record is at 1C/E2000020;
> shutdown FALSE
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: next transaction ID: 0/1903870;
> next OID: 249837974
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: next MultiXactId: 1; next
> MultiXactOffset: 0
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: oldest unfrozen transaction ID:
> 673, in database 1
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: transaction ID wrap limit is
> 2147484320, limited by database with OID 1
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: resetting unlogged relations:
> cleanup 1 init 0
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: initializing for hot standby
>
> 2012-12-03 20:27:08 GMT 21494 dLOG: consistent recovery state reached at
> 1C/E28B79D8
>
> 2012-12-03 20:27:08 GMT 21494 dLOG: redo starts at 1C/E2000020
>
> 2012-12-03 20:27:08 GMT 21494 dDEBUG: recovery snapshots are now enabled
>
> 2012-12-03 20:27:08 GMT 21494 dCONTEXT: xlog redo running xacts: nextXid
> 1903870 latestCompletedXid 1903869 oldestRunningXid 1903870
>
> 2012-12-03 20:27:08 GMT 21492 dLOG: database system is ready to accept
> read only connections
>
> 2012-12-03 20:27:09 GMT 21494 dWARNING: page 27 of relation
> base/103111746/231701662 does not exist
>
> 2012-12-03 20:27:09 GMT 21494 dCONTEXT: xlog redo visible: rel
> 1663/103111746/231701662; blk 27
>
> 2012-12-03 20:27:09 GMT 21494 dPANIC: WAL contains references to invalid
> pages
>
> 2012-12-03 20:27:09 GMT 21494 dCONTEXT: xlog redo visible: rel
> 1663/103111746/231701662; blk 27
>
> 2012-12-03 20:27:09 GMT 21492 dLOG: startup process (PID 21494) was
> terminated by signal 6: Aborted
>
> 2012-12-03 20:27:09 GMT 21492 dLOG: terminating any other active server
> processes
>
> 2012-12-03 20:27:09 GMT 21493 dDEBUG: logger shutting down
>
>
>
> The Autovacumm launcher is running on the master postgres server, would that
> cause issues with pg_basebackup. Any ideas what the problem could be?
autovacuum is definitely not the cause of this. That's a default
setting, and if it was problematic with pg_basebackup it would be well
documented.
Are you certain that the pg_basebackup ran successfully to completion?
Can you provide the exact command options you used when running it?
Are all the postgres servers running the same version of postgresql
with the same OS version?
Can you document the exact steps you took when extracting the
basebackup on the server?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-12-03 21:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-12-03 20:44 pg_basebackup WAL -- invalid pages Darron <darron@realtyserver.com>
2012-12-03 21:16 ` Lonni J Friedman <netllama@gmail.com>
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