[ https://forge.continuent.org/jira/browse/SEQUOIA-874?page=all ] Emmanuel Cecchet closed SEQUOIA-874: ------------------------------------
Was not an issue. > Recovery Log cannot be created on a MySQL 5 Server. Column name sql is a > reserved word. > --------------------------------------------------------------------------------------- > > Key: SEQUOIA-874 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-874 > Project: Sequoia > Type: Bug > Components: Recovery Log > Versions: Sequoia 2.10.3 > Environment: Sequoia 2.10.3, MySQL 5.0.24 > Reporter: Jan-Peter Rusch > Assignee: Emmanuel Cecchet > > > When trying to create (manually/automatically) recovery log tables on MySQL 5 > this fails with the following error: > ERROR controller.xml.DatabasesParser Failed to check JDBC Recovery log tables. > java.lang.RuntimeException: Unable to initialize the database: > java.sql.SQLException: Unable to create table logtable (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 'NOT NULL,sql VARCHAR NOT > NULL,sql_param VARCHAR,auto_conn_tran CHAR(1) NOT NULL,' at line 1) > MySQL Reference Manual states that sql is a reserved word. Quoting ('sql', > "sql") does not work as pointed out in the manual (See manual remarks at > bottom of page) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://forge.continuent.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Sequoia mailing list Sequoia@lists.forge.continuent.org https://forge.continuent.org/mailman/listinfo/sequoia
