Hi All,
I am new in sequoia....
I am trying to setup Sequoia to Mirror two MySQL Servers(v5.1.30).
My Controller fails to create the RecoveryLog Tables because "VARCHAR(size)
NOT NULL" not supported...
*RecoveryLog elements*:
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(50) NOT NULL"
sqlColumnType="VARCHAR(20) NOT NULL"
sqlParamColumnType="VARCHAR(20) NOT NULL"
autoConnTranColumnType="CHAR(1) NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECK_POINT"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(50) NOT NULL"
backendNameColumnType="VARCHAR(50) NOT NULL"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<DumpTable tableName="SEQUOIA_DUMP"
dumpNameColumnType="TEXT NOT NULL"
dumpDateColumnType="DATETIME"
dumpPathColumnType="TEXT NOT NULL"
dumpFormatColumnType="TEXT NOT NULL"
checkpointNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
tablesColumnType="TEXT NOT NULL"/>
*BUG*:
java.lang.RuntimeException: Unable to initialize the database:
java.sql.SQLExcep
tion: Unable to create table RECOVERY (You have an error in your SQL syntax;
che
ck the manual that corresponds to your MySQL server version for the right
syntax
to use near 'sql VARCHAR(20) NOT NULL,sql_param VARCHAR(20) NOT
NULL,auto_conn_tran CHAR(1) NOT NULL,trans
action_id BIGI' at line 1)
What should I set the type of the fields in the RecoveryLog Tables
to?
Help please.
Regards
--
Bakary,
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
