[ https://forge.continuent.org/jira/browse/SEQUOIA-892?page=all ]
Stephane Giron closed SEQUOIA-892:
----------------------------------
Resolution: Not an issue
Problem solved by user. Recovery log table definitions were wrong.
> Unable to store checkpoint Member Name [ Duplicated key ]
> ---------------------------------------------------------
>
> Key: SEQUOIA-892
> URL: https://forge.continuent.org/jira/browse/SEQUOIA-892
> Project: Sequoia
> Type: New Feature
> Components: Recovery Log
> Versions: Sequoia 2.10.3
> Environment: 2 Servers running Centos 4.4 / Sequoia 2.10.3 with RAIDb1
> configuration and running 1 virtual DB (1 controller/bacjend per host,
> syncronized)
> Reporter: Rami Shakhsa
> Assignee: Stephane Giron
> Priority: Blocker
>
>
> When i run the first controller everthing working well, but at the momento
> that i run the 2nd Controller I have the next error. This error is continuous
> each time that seqouia try to insert some now checkpoint.
> 17:56:06,878 INFO controller.core.Controller Sequoia controller (2.10.3)
> 17:56:06,953 INFO controller.core.Controller Loading configuration file:
> /sequoia/sequoia-2.10.3-bin/config/controller/controller.xml
> 17:56:07,020 INFO controller.core.Controller JMX is enabled
> 17:56:07,043 INFO controller.core.Controller Starting JMX server on host:
> sipsql1.goldslam.com
> 17:56:07,317 INFO controller.backup.BackupManager Registering backuper mysql
> to handle format MySQL raw dump
> 17:56:07,339 INFO backend.DatabaseBackend.DB1 Adding connection manager for
> virtual user "openser"
> 17:56:07,339 INFO backend.DatabaseBackend.DB1 Adding connection manager for
> virtual user "openserro"
> 17:56:07,683 INFO controller.RequestManager.opensequoia Request manager will
> parse requests with the following granularity: TABLE
> 17:56:07,713 INFO controller.virtualdatabase.opensequoia Using Hedera
> properties file: /hedera_jgroups.properties
> -------------------------------------------------------
> GMS: address is 192.168.0.6:32792
> -------------------------------------------------------
> 17:56:12,270 INFO controller.virtualdatabase.opensequoia Group opensequoia
> connected to Member(address=/192.168.0.6:32792, uid=opensequoia)
> 17:56:12,271 INFO controller.virtualdatabase.opensequoia First controller in
> group opensequoia
> 17:56:12,276 ERROR controller.backend.BackendStateListener Could not store
> information for backend: DB1
> java.sql.SQLException: Unable to get checkpoint from the recovery log
> (Checkpoint does not exist in recovery log)
> at
> org.continuent.sequoia.controller.recoverylog.events.GetCheckpointLogIdEvent.execute(GetCheckpointLogIdEvent.java:96)
> at
> org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:732)
> 17:56:12,277 INFO sequoia.controller.recoverylog Checking recovery log
> consistency
> 17:56:12,282 INFO controller.virtualdatabase.opensequoia Unknown last state
> for backend DB1. Leaving node in disabled state.17:56:12,282 INFO
> controller.core.Controller Adding VirtualDatabase opensequoia
> 17:56:12,286 INFO controller.core.Controller Waiting for connections on
> 192.168.0.6:25322
> 17:56:12,293 INFO controller.core.Controller Controller started on
> 2007.01.08 02 at 05:56:12 PM CET
> 17:56:12,293 INFO controller.core.Controller Controller
> sipsql1.goldslam.com:25322 ready, listening to requests ...
> ----------------------------- ERROR -----------------------------------
> 17:56:29,076 ERROR sequoia.controller.recoverylog Logger thread was unable to
> log Storing checkpoint Member(address=/192.168.0.7:32771, uid=opensequoia)
> joined group opensequoia-sipsql1.goldslam.com:25322-20070108175628662+0100
> with id 0 because of java.sql.SQLException: Unable to store checkpoint
> Member(address=/192.168.0.7:32771, uid=opensequoia) joined group
> opensequoia-sipsql1.goldslam.com:25322-20070108175628662+0100 in recovery log
> database (Duplicate entry 'Member(address=/192.168.0.7:32771,
> uid=opensequoia' for key 1)
> ---------------------------------------------------------------------------
> java.sql.SQLException: Unable to store checkpoint
> Member(address=/192.168.0.7:32771, uid=opensequoia) joined group
> opensequoia-sipsql1.goldslam.com:25322-20070108175628662+0100 in recovery log
> database (Duplicate entry 'Member(address=/192.168.0.7:32771,
> uid=opensequoia' for key 1)
> at
> org.continuent.sequoia.controller.recoverylog.LoggerThread.storeCheckpointWithLogId(LoggerThread.java:398)
> at
> org.continuent.sequoia.controller.recoverylog.events.StoreCheckpointWithLogIdEvent.execute(StoreCheckpointWithLogIdEvent.java:69)
> at
> org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:732)
> 17:56:31,028 INFO controller.virtualdatabase.opensequoia Checking virtual
> database configuration from sipsql2.goldslam.com:25323
> 17:56:31,271 INFO controller.virtualdatabase.opensequoia Controller
> sipsql2.goldslam.com:25323 is compatible with the local configuration
> 17:56:31,393 INFO controller.virtualdatabase.opensequoia Updating backend
> list for controller Member(address=/192.168.0.7:32771, uid=opensequoia)
> ************************
> CONTROLLER CONFIGS
> ************************
> -------- Controller config 1 ----------
> <?xml version="1.0" encoding="UTF-8" ?>
> <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER
> 2.10.3//EN"
> "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.3.dtd";>
> <SEQUOIA-CONTROLLER>
> <Controller ipAddress="192.168.0.6" port="25322">
> <Report/>
> <JmxSettings>
> <RmiJmxAdaptor/>
> </JmxSettings>
> <VirtualDatabase configFile="mysql-single.xml"
> virtualDatabaseName="opensequoia" autoEnableBackends="true"
> checkpointName="Initial_empty_recovery_log"/>
> </Controller>
> </SEQUOIA-CONTROLLER>
> -------- Controller config 2 ----------
> <?xml version="1.0" encoding="UTF-8" ?>
> <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER
> 2.10.3//EN"
> "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.3.dtd";>
> <SEQUOIA-CONTROLLER>
> <Controller ipAddress="192.168.0.7" port="25322">
> <Report/>
> <JmxSettings>
> <RmiJmxAdaptor/>
> </JmxSettings>
> <VirtualDatabase configFile="mysql-single.xml"
> virtualDatabaseName="opensequoia" autoEnableBackends="true"
> checkpointName="Initial_empty_recovery_log"/>
> </Controller>
> </SEQUOIA-CONTROLLER>
> **********************************
> VIRTUAL DATABASES CONFIGS
> **********************************
> -------- on the 1st controller -------
> <RecoveryLog driver="com.mysql.jdbc.Driver"
> driverPath="/usr/share/java/mysql-3.1.14.jar"
> url="jdbc:mysql://192.168.0.6/RECOVERY_DB"
> login="user" password="xxx">
> <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL"
> vloginColumnType="TEXT NOT NULL"
> sqlColumnName="sql2"
> sqlColumnType="TEXT NOTNULL"
> sqlParamColumnType="TEXT NOT NULL"
> transactionIdColumnType="BIGINT NOT NULL"
> extraStatementDefinition=",PRIMARY KEY(log_id)"/>
> <CheckpointTable tableName="CHECKPOINT"
> heckpointNameColumnType="VARCHAR(32) NOT NULL"/>
> <BackendTable tableName="BACKEND"
> databaseNameColumnType="TEXT NOT NULL"
> backendNameColumnType="TEXT NOT NULL"
> checkpointNameColumnType="TEXT NOT NULL"/>
> <DumpTable tableName="DUMP"
> dumpNameColumnType="TEXT NOT NULL"
> dumpDateColumnType="TIMESTAMP"
> dumpPathColumnType="TEXT NOT NULL"
> dumpFormatColumnType="TEXT NOT NULL"
> checkpointNameColumnType="TEXT NOT NULL"
> backendNameColumnType="TEXT NOT NULL"
> tablesColumnType="TEXT NOT NULL"/>
> </RecoveryLog>
> ---- on the 2nd CONTROLLER ------
> <RecoveryLog driver="
> com.mysql.jdbc.Driver" driverPath="/usr/share/java/mysql-3.1.14.jar"
> url="jdbc:mysql://192.168.0.7/RECOVERY_DB"
> login="user" password="xxx">
> <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL"
> vloginColumnType="TEXT NOT NULL"
> sqlColumnName="sql2"
> sqlColumnType="TEXT NOTNULL"
> sqlParamColumnType="TEXT NOT NULL"
> transactionIdColumnType="BIGINT NOT NULL"
> extraStatementDefinition=",PRIMARY KEY(log_id)"/>
> <CheckpointTable tableName="CHECKPOINT"
> heckpointNameColumnType="VARCHAR(32) NOT NULL"/>
> <BackendTable tableName="BACKEND"
> databaseNameColumnType="TEXT NOT NULL"
> backendNameColumnType="TEXT NOT NULL"
> checkpointNameColumnType="TEXT NOT NULL"/>
> <DumpTable tableName="DUMP"
> dumpNameColumnType="TEXT NOT NULL"
> dumpDateColumnType="TIMESTAMP"
> dumpPathColumnType="TEXT NOT NULL"
> dumpFormatColumnType="TEXT NOT NULL"
> checkpointNameColumnType="TEXT NOT NULL"
> backendNameColumnType="TEXT NOT NULL"
> tablesColumnType="TEXT NOT NULL"/>
> </RecoveryLog>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
