Dear Emmanuel,
please find answers below.
------------------
Hi Rami,
Which version of Sequoia are you using?
-------- we use sequoia 2.10.3 ---------------
Are the 2 controllers running on different machines?
-------- yes our 2 controllers running on different servers -----------
What group communication implementation are you using?
----------- Hedera_jgroup ------------
What is your recovery log configuration?
------- below ------
-------- 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>
Hope that this can help you and us.
kindest regards,
Rami
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
