Hi,
I am getting an error message very similar to that reported in
<http://www.mail-archive.com/[email protected]/msg00300.html>
when trying to use Sequoia 3.0-beta1 . In my case, I tried to resolve
the problem by changing the sequoia.dtd file and my virtual database
XML file, but this didn't work.
When the controller loads my virtual database, it isn't able to
create the dump table of recovery logs. The error messages, my virtual
database config file and the corresponding dtd file are pasted below.
Anyone have an idea of how to solve this problem?
'table' is a reserved MySQL keyword but 'tables' should not.
Which version of MySQL are you using?
- --------------------------- error message
- -------------------------------------------
java.lang.RuntimeException: Unable to initialize the database:
java.sql.SQLException: Unable to create dump table dumptable (You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'tables
TEXT NOT NULL' at line 1)
at
org.continuent.sequoia.controller.recoverylog.RecoveryLog.checkRecoveryLogTables(RecoveryLog.java:2780)
(...)
To get the full statement that is used to create the table, edit your
log4j.properties file and set the recovery log logger to DEBUG instead
of INFO:
log4j.logger.org.continuent.sequoia.controller.recoverylog=DEBUG,
Console,Filetrace
You should be able to see what statement is used to create the table and
what is wrong with it.
Keep us posted with your progress,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
