Hi Davide,
I'm really new to sequoia (and continuent.org) and I'm trying to install
Sequoia 3.0b1 to see if it could fit our needs.
You should use the latest version either 2.10.6 or 3.0b2.
I've noticed, while creating the recovering log and while trying to activate a
backend, that sequoia does not put single reverse quote ` character
to "protect" names of tables and/or columns, and there are problematic column
names like "sql" that do not work.
You must avoid reserved keywords like 'sql' for column names. You can
use the EmbeddedRecoverylog in 3.0 if you want to avoid this problem.
17:41:58,165 ERROR sequoia.controller.recoverylog Error while cleaning the
recovery log
java.sql.SQLException: Unable get cleanup recovery log
(com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'sql FROM RECOVERY WHERE exec_status
LIKE 'F'' at line 1)
If you want to use MySQL to store your recovery log, then you will have
to overwrite your sql column name in the recovery log definition of your
configuration file.
Hope this helps,
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
