Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 10978 invoked from network); 3 Mar 2008 09:28:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Mar 2008 09:28:04 -0000 Received: (qmail 948 invoked by uid 500); 3 Mar 2008 09:27:58 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 919 invoked by uid 500); 3 Mar 2008 09:27:58 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 316 invoked by uid 99); 3 Mar 2008 09:27:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Mar 2008 01:27:56 -0800 X-ASF-Spam-Status: No, hits=-1998.8 required=10.0 tests=ALL_TRUSTED,FS_REPLICA X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Mar 2008 09:27:17 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 00AC3234C083 for ; Mon, 3 Mar 2008 01:26:51 -0800 (PST) Message-ID: <1868507703.1204536411001.JavaMail.jira@brutus> Date: Mon, 3 Mar 2008 01:26:51 -0800 (PST) From: =?utf-8?Q?=C3=98ystein_Gr=C3=B8vlen_=28JIRA=29?= To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-3475) Replication: Slave reports ERROR XSLA7: Cannot redo operation null in the log. In-Reply-To: <55412923.1204116351030.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-3475?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1257= 4393#action_12574393 ]=20 =C3=98ystein Gr=C3=B8vlen commented on DERBY-3475: ---------------------------------------- If I understand the patch correctly, when in replication slave pre mode, it both prevents checkpoints from being initiated and makes sure a checkpoint is a null op. Would not just making checkpoint be a null op be sufficient? > Replication: Slave reports ERROR XSLA7: Cannot redo operation null in th= e log. > -------------------------------------------------------------------------= ------ > > Key: DERBY-3475 > URL: https://issues.apache.org/jira/browse/DERBY-3475 > Project: Derby > Issue Type: Bug > Components: Replication > Affects Versions: 10.4.0.0 > Environment: Derby trunk revision 631534 + DERBY 3205 patch failo= ver-slave-2a. > Reporter: =C3=98ystein Gr=C3=B8vlen > Assignee: J=C3=B8rgen L=C3=B8land > Attachments: derby-3475-1a.diff, derby-3475-1a.stat, slaveDB.zip > > > Master: > ij> connect 'jdbc:derby:masterDB;user=3Doystein;password=3Dpass;startMast= er=3Dtrue;slaveHost=3Dlocalhost'; > ij(CONNECTION1)> delete from t where i > 8192; > 253952 rows inserted/updated/deleted > ij(CONNECTION1)> connect 'jdbc:derby:masterDB;user=3Doystein;password=3Dp= ass;failover=3Dtrue'; > ERROR XJ001: Java exception: ': java.lang.NullPointerException'. > Slave reports in the log: > ------------ BEGIN SHUTDOWN ERROR STACK ------------- > ERROR XSLA7: Cannot redo operation null in the log. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:296) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1525) > =09at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.jav= a:920) > =09at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:334) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessM= anager.java:1019) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java= :793) > =09at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:205) > =09at org.apache.derby.impl.db.SlaveDatabase.bootBasicDatabase(SlaveDatab= ase.java:425) > =09at org.apache.derby.impl.db.SlaveDatabase.access$000(SlaveDatabase.jav= a:70) > =09at org.apache.derby.impl.db.SlaveDatabase$SlaveDatabaseBootThread.run(= SlaveDatabase.java:312) > =09at java.lang.Thread.run(Thread.java:619) > Caused by: ERROR XSLAO: Recovery failed unexpected problem log record is = Not first but transaction is not in transaction table : 58625. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:286) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1289) > =09... 17 more > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nested exception, level (1)= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > ERROR XSLAO: Recovery failed unexpected problem log record is Not first b= ut transaction is not in transaction table : 58625. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:286) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1289) > =09at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.jav= a:920) > =09at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:334) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessM= anager.java:1019) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java= :793) > =09at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:205) > =09at org.apache.derby.impl.db.SlaveDatabase.bootBasicDatabase(SlaveDatab= ase.java:425) > =09at org.apache.derby.impl.db.SlaveDatabase.access$000(SlaveDatabase.jav= a:70) > =09at org.apache.derby.impl.db.SlaveDatabase$SlaveDatabaseBootThread.run(= SlaveDatabase.java:312) > =09at java.lang.Thread.run(Thread.java:619) > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D end nested exception, level (1) = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > ------------ END SHUTDOWN ERROR STACK ------------- > -------- BEGIN REPLICATION ERROR MESSAGE --------- > Replication slave got a fatal error for database 'slaveDB'. Replication w= ill be stopped. > Replication slave role was stopped for database 'slaveDB'. > 2008-02-27 12:03:00.830 GMT: > Shutting down instance a816c00e-0118-5ac5-f06b-000003e6d478 > ---------------------------------------------------------------- > ERROR XSLAA: The store has been marked for shutdown by an earlier excepti= on. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:279) > =09at org.apache.derby.impl.store.raw.log.LogToFile.appendLogRecord(LogTo= File.java:3696) > =09at org.apache.derby.impl.services.replication.slave.SlaveController$Sl= aveLogReceiverThread.handleLogChunk(SlaveController.java:540) > =09at org.apache.derby.impl.services.replication.slave.SlaveController$Sl= aveLogReceiverThread.run(SlaveController.java:486) > Caused by: ERROR XSLA7: Cannot redo operation null in the log. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:296) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1525) > =09at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.jav= a:920) > =09at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:334) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessM= anager.java:1019) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java= :793) > =09at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:205) > =09at org.apache.derby.impl.db.SlaveDatabase.bootBasicDatabase(SlaveDatab= ase.java:425) > =09at org.apache.derby.impl.db.SlaveDatabase.access$000(SlaveDatabase.jav= a:70) > =09at org.apache.derby.impl.db.SlaveDatabase$SlaveDatabaseBootThread.run(= SlaveDatabase.java:312) > =09at java.lang.Thread.run(Thread.java:619) > Caused by: ERROR XSLAO: Recovery failed unexpected problem log record is = Not first but transaction is not in transaction table : 58625. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:286) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1289) > =09... 17 more > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nested exception, level (1)= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > ERROR XSLA7: Cannot redo operation null in the log. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:296) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1525) > =09at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.jav= a:920) > =09at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:334) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessM= anager.java:1019) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java= :793) > =09at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:205) > =09at org.apache.derby.impl.db.SlaveDatabase.bootBasicDatabase(SlaveDatab= ase.java:425) > =09at org.apache.derby.impl.db.SlaveDatabase.access$000(SlaveDatabase.jav= a:70) > =09at org.apache.derby.impl.db.SlaveDatabase$SlaveDatabaseBootThread.run(= SlaveDatabase.java:312) > =09at java.lang.Thread.run(Thread.java:619) > Caused by: ERROR XSLAO: Recovery failed unexpected problem log record is = Not first but transaction is not in transaction table : 58625. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:286) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1289) > =09... 17 more > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D end nested exception, level (1) = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nested exception, level (2)= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > ERROR XSLAO: Recovery failed unexpected problem log record is Not first b= ut transaction is not in transaction table : 58625. > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:286) > =09at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java= :1289) > =09at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.jav= a:920) > =09at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:334) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessM= anager.java:1019) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor= .java:1999) > =09at org.apache.derby.impl.services.monitor.TopService.bootModule(TopSer= vice.java:291) > =09at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Base= Monitor.java:553) > =09at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Mo= nitor.java:419) > =09at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java= :793) > =09at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:205) > =09at org.apache.derby.impl.db.SlaveDatabase.bootBasicDatabase(SlaveDatab= ase.java:425) > =09at org.apache.derby.impl.db.SlaveDatabase.access$000(SlaveDatabase.jav= a:70) > =09at org.apache.derby.impl.db.SlaveDatabase$SlaveDatabaseBootThread.run(= SlaveDatabase.java:312) > =09at java.lang.Thread.run(Thread.java:619) > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D end nested exception, level (2) = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > --------- END REPLICATION ERROR MESSAGE ---------- > Replication slave role was stopped for database 'slaveDB'. --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.