Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tfd81-0003jW-M3 for pgsql-admin@arkaria.postgresql.org; Mon, 03 Dec 2012 21:00:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tfd80-0008K0-UH for pgsql-admin@arkaria.postgresql.org; Mon, 03 Dec 2012 21:00:36 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TfcsL-0007he-Dh for pgsql-admin@postgresql.org; Mon, 03 Dec 2012 20:44:25 +0000 Received: from mx.realtyserver.com ([184.107.80.8]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TfcsI-0008Qx-Tf for pgsql-admin@postgresql.org; Mon, 03 Dec 2012 20:44:24 +0000 X-Footer: cmVhbHR5c2VydmVyLmNvbQ== Received: from localhost ([127.0.0.1]) by mx.realtyserver.com for pgsql-admin@postgresql.org; Mon, 3 Dec 2012 12:45:12 -0800 From: "Darron" To: Subject: pg_basebackup WAL -- invalid pages Date: Mon, 3 Dec 2012 12:44:22 -0800 Message-ID: <01cd01cdd196$f9fbf0f0$edf3d2d0$@realtyserver.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01CE_01CDD153.EBDAFAE0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac3RlvdEeAvbKYVRS++Fgzz5CO+xMg== Content-Language: en-us X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_01CE_01CDD153.EBDAFAE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 . SPAMfighter has removed 2 of my spam emails to date. Do you have a slow PC? Try free scan! ------=_NextPart_000_01CE_01CDD153.EBDAFAE0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.
SPAMfighter has removed 2 of my spam emails to date.

Do you = have a slow = PC? Try free scan! ------=_NextPart_000_01CE_01CDD153.EBDAFAE0--