[ https://forge.continuent.org/jira/browse/SEQUOIA-874?page=all ]
Emmanuel Cecchet resolved SEQUOIA-874:
--------------------------------------
Resolution: Not an issue
The column name can be tuned in the recovery log configuration as defined in
the DTD:
<!ELEMENT RecoveryLogTable EMPTY>
<!ATTLIST RecoveryLogTable
createTable CDATA "CREATE TABLE"
tableName CDATA "logtable"
logIdColumnType CDATA "BIGINT NOT NULL"
vloginColumnType CDATA "VARCHAR NOT NULL"
sqlColumnName CDATA "sql"
sqlColumnType CDATA "VARCHAR NOT NULL"
sqlParamColumnType CDATA "VARCHAR"
autoConnTranColumnType CDATA "CHAR(1) NOT NULL"
transactionIdColumnType CDATA "BIGINT NOT NULL"
requestIdColumnType CDATA "BIGINT"
execTimeColumnType CDATA "BIGINT"
updateCountColumnType CDATA "INT"
extraStatementDefinition CDATA ",PRIMARY KEY (log_id)"
>
Just define the sqlColumnName attribute with another non-reserved keyword.
Example: <RecoveryLogTable sqlColumnName ="sql_data" .../>
> 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
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
