Miles,
By default, Sequoia uses 'sql' as the column name to store SQL in the
recovery table. As this is a reserved word in MySQL this is likely to fail.
You can read
https://forge.continuent.org/pipermail/sequoia/2006-December/004222.html
to see how to handle this.
Also varchar(255) is likely to be too small for some SQL, you should use
an unlimited string length by using the MySQL TEXT data type.
Hope this helps,
Emmanuel
I'm still having trouble getting sequoia to be happy with the recovery
log and I'm not sure what I'm doing wrong. If I'm understanding the
documentation correctly, all I have to do is create the database where
the logs will be stored, and set up the XML config for sequoia to
connect to the database and create all the tables. I've tried manually
creating the tables myself and starting from an empty database with no
tables and I still can't get it working. Anyone mind looking at my config?
I'm using mysql as the backend database. I modified the sample config
to specify sizes for the VARCHAR columns since mysql requires that.
But I've also tried it without specifying the size and it still isn't
working:
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://10.1.2.1:3306/ctl1log
<http://10.1.2.1:3306/ctl1log>" login="test" password="xxxxxxx">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT
NOT NULL"
vloginColumnType="VARCHAR(255) NOT NULL"
sqlColumnType="VARCHAR(255) NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR(255)
NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR(255) NOT NULL"
dumpFormatColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
tablesColumnType="VARCHAR(255) NOT NULL"/>
</RecoveryLog>
When I use the CLI to try and load my virtual DB config:
load virtualdatabase configuration
/usr/local/sequoia/config/virtualdatabase/test.xml
I get:
Loading of virtual databases configuration file failed (because of
Failed to check JDBC Recovery log tables.).
tcpdump shows that it is at least connecting to the database server
and carrying on a conversation. Unfortunately, I'm having trouble
getting mysql to keep a query log so I can see exactly what query
sequoia is building and trying to run on the server.
-Miles
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
