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