View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005621 | SymmetricDS Pro | Bug | public | 2022-12-09 17:29 | 2023-01-23 17:30 |
| Reporter | cquamme | Assigned To | cquamme | ||
| Priority | normal | ||||
| Status | resolved | Resolution | open | ||
| Summary | 0005621: MongoDB Throws Error During Change Capture | ||||
| Description | When you set up Symmetric to have changes captured from MongoDB, currently there is an error that presents that makes it so the sym_data table is unable to be locked. This error message will show up in the log: Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYM_DATA"; SQL statement: select d.data_id, d.table_name, d.event_type, '' as row_data, '' as pk_data, '' as old_data, d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, d.is_prerouted from sym_data d where d.channel_id=? and ((d.data_id between ? and ?) or (d.data_id between ? and ?) or (d.data_id between ? and ?) or (d.data_id between ? and ?)) order by d.data_id asc [50200-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) at org.h2.message.DbException.get(DbException.java:178) at org.h2.message.DbException.get(DbException.java:154) at org.h2.table.RegularTable.doLock(RegularTable.java:530) at org.h2.table.RegularTable.lock(RegularTable.java:464) at org.h2.table.TableFilter.lock(TableFilter.java:147) at org.h2.command.dml.Select.queryWithoutCache(Select.java:632) at org.h2.command.dml.Query.query(Query.java:323) at org.h2.command.dml.Query.query(Query.java:291) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:91) at org.h2.command.Command.executeQuery(Command.java:197) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:109) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:81) ... 10 more | ||||
| Tags | No tags attached. | ||||