View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005316 | SymmetricDS Pro | Bug | public | 2022-05-31 19:29 | 2022-06-06 12:37 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.13.0 | ||||
| Target Version | 3.13.5 | Fixed in Version | 3.13.5 | ||
| Summary | 0005316: Snapshot error on sym_outgoing_batch_summary for load-only node | ||||
| Description | Snapshot utility is using wrong database to collect the sym_outgoing_batch_summary.csv file. 2022-05-30 18:11:18,615 WARN [target-mariadb] [SnapshotUtil] [background-refresher-1] Failed to run extract query select node_id, channel_id ,status, count(*), sum(data_row_count), sum(byte_count), sum(error_flag), min(create_time), sum(router_millis), sum(extract_millis), sum(network_millis), sum(filter_millis), sum(load_millis), sum(fallback_insert_count), sum(fallback_update_count), sum(missing_delete_count), sum(skip_count), sum(ignore_count) from sym_outgoing_batch group by node_id, channel_id ,status StackTraceKey.init [SqlException:744093721] org.jumpmind.db.sql.SqlException: Failed to execute sql: select node_id, channel_id ,status, count(*), sum(data_row_count), sum(byte_count), sum(error_flag), min(create_time), sum(router_millis), sum(extract_millis), sum(network_millis), sum(filter_millis), sum(load_millis), sum(fallback_insert_count), sum(fallback_update_count), sum(missing_delete_count), sum(skip_count), sum(ignore_count) from sym_outgoing_batch group by node_id, channel_id ,status at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:101) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:146) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:134) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:207) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:202) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:192) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:176) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:124) at org.jumpmind.symmetric.util.SnapshotUtil.extractQuery(SnapshotUtil.java:480) at org.jumpmind.symmetric.util.SnapshotUtil.createSnapshot(SnapshotUtil.java:255) at org.jumpmind.symmetric.ClientSymmetricEngine.snapshot(ClientSymmetricEngine.java:513) at com.jumpmind.symmetric.console.impl.bp$1.doWork(SupportPanel.java:75) at com.jumpmind.symmetric.console.ui.common.I$1.onBackgroundDataRefresh(InProgressDialog.java:117) at com.jumpmind.symmetric.console.ui.b.a(BackgroundRefresherService.java:99) at com.jumpmind.symmetric.console.ui.b$2.run(BackgroundRefresherService.java:139) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: java.sql.SQLSyntaxErrorException: (conn=223922) Table 'test.sym_outgoing_batch' doesn't exist at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:266) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:366) at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:615) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:87) ... 21 more | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.13 b861837b 2022-05-31 19:31:17 Details Diff |
0005316: Snapshot error on sym_outgoing_batch_summary for load-only node |
Affected Issues 0005316 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/util/SnapshotUtil.java | Diff File | ||
|
SymmetricDS: 3.14 27afcefe 2022-05-31 19:31:17 Details Diff |
0005316: Snapshot error on sym_outgoing_batch_summary for load-only node |
Affected Issues 0005316 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/util/SnapshotUtil.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-05-31 19:29 | elong | New Issue | |
| 2022-05-31 19:29 | elong | Status | new => assigned |
| 2022-05-31 19:29 | elong | Assigned To | => elong |
| 2022-05-31 19:34 | elong | Status | assigned => resolved |
| 2022-05-31 19:34 | elong | Resolution | open => fixed |
| 2022-05-31 19:34 | elong | Fixed in Version | => 3.13.5 |
| 2022-05-31 20:00 | admin | Changeset attached | => SymmetricDS 3.13 b861837b |
| 2022-05-31 20:00 | admin | Changeset attached | => SymmetricDS 3.14 27afcefe |
| 2022-06-06 12:37 | admin | Status | resolved => closed |