View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004806 | SymmetricDS Pro | Bug | public | 2021-02-02 18:15 | 2021-02-25 21:35 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.6 | ||||
| Target Version | 3.12.7 | Fixed in Version | 3.12.7 | ||
| Summary | 0004806: Fix transaction file generation for MySQL 5.5 and earlier | ||||
| Description | When generating a snapshot using MySQL 5.5 or earlier, the following error occurs when the transaction file is generated: 2021-02-02 10:41:27,054 WARN [] [SnapshotUtil] [qtp19999714-4419] Failed to create transactions file StackTraceKey.init [SqlException:1749033020] org.jumpmind.db.sql.SqlException: Failed to execute sql: SELECT b.trx_id, t.processlist_user, t.processlist_host, b.trx_started, b.trx_state, b.trx_rows_modified, w.blocking_trx_id 'blockingId', b.trx_query FROM information_schema.innodb_lock_waits w RIGHT JOIN information_schema.innodb_trx b ON b.trx_id = w.requesting_trx_id INNER JOIN performance_schema.threads t ON b.trx_mysql_thread_id = t.thread_id;^M at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:306)^M at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:123)^M at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:160)^M at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:148)^M at org.jumpmind.db.sql.AbstractSqlTemplate.queryForCursor(AbstractSqlTemplate.java:113)^M at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:203)^M at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199)^M at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:189)^M at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:173)^M Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.processlist_user' in 'field list'^M | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.12 de909948 2021-02-02 19:10:11 evan-miller-jumpmind Committer: GitHub Details Diff |
0004806: Fixed transaction file generation for MySQL 5.5 and earlier (0000139) |
Affected Issues 0004806 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/MySqlDatabasePlatform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-02-02 18:15 | emiller | New Issue | |
| 2021-02-02 18:15 | emiller | Status | new => assigned |
| 2021-02-02 18:15 | emiller | Assigned To | => emiller |
| 2021-02-02 19:10 | emiller | Status | assigned => resolved |
| 2021-02-02 19:10 | emiller | Resolution | open => fixed |
| 2021-02-02 19:10 | emiller | Fixed in Version | => 3.12.7 |
| 2021-02-02 20:00 | Changeset attached | => SymmetricDS 3.12 de909948 | |
| 2021-02-25 21:35 | admin | Status | resolved => closed |