View Issue Details

IDProjectCategoryView StatusLast Update
0005621SymmetricDS ProBugpublic2023-01-23 17:30
Reportercquamme Assigned Tocquamme  
Status resolvedResolutionopen 
Summary0005621: MongoDB Throws Error During Change Capture
DescriptionWhen 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(
    at org.h2.message.DbException.get(
    at org.h2.message.DbException.get(
    at org.h2.table.RegularTable.doLock(
    at org.h2.table.RegularTable.lock(
    at org.h2.table.TableFilter.lock(
    at org.h2.command.dml.Select.queryWithoutCache(
    at org.h2.command.dml.Query.query(
    at org.h2.command.dml.Query.query(
    at org.h2.command.dml.Query.query(
    at org.h2.command.CommandContainer.query(
    at org.h2.command.Command.executeQuery(
    at org.h2.jdbc.JdbcPreparedStatement.executeQuery(
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(
    ... 10 more
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2022-12-09 17:29 cquamme New Issue
2022-12-09 17:29 cquamme Status new => assigned
2022-12-09 17:29 cquamme Assigned To => cquamme
2023-01-23 17:30 cquamme Status assigned => resolved