-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Emmanuel,
The problem is resolved. I'm using MySQL 4.1.14 and I guess 'tables'
is a reserved keyword. I changed my virtual database configuration file
setting the tablesColumnName attribute to 'tabless' in the tag DumpTable
and the controller started normally.
Thanks for your help.
André Cardoso de Souza
Emmanuel Cecchet escreveu:
> 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
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
iD8DBQFFXe7r7OGbca89nlkRAt4qAJ0d4SpkNLs1KFmR3fZJ/IrRquEBJACgktU6
BVSmfVOE/Q0JyMcM2Xpo6WE=
=W/47
-----END PGP SIGNATURE-----
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
