View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004974 | SymmetricDS | Bug | public | 2021-05-04 14:23 | 2021-05-28 20:40 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.10 | Fixed in Version | 3.12.10 | ||
| Summary | 0004974: Routing and extracting had X columns but expected Y | ||||
| Description | When user removes sym_trigger_hist entries, the router service will generate a new entry based on the current table definition. If the column names don't match the row values that were already captured, then an error can occur in either routing or during extraction that complains that the data "Had X columns but expected Y". [server] - DataExtractorService - The batch 1-25 appears corrupt in staging, so removing it. (The extracted row for table sym_console_user had 16 columns but expected 23. Corrupted row for data ID 32: [server] - RouterService - Failed to route and batch data on 'config' channel org.jumpmind.symmetric.SymmetricException: Failed to route data: 33 for table: sym_node_security. at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:912) at org.jumpmind.symmetric.service.impl.RouterService.selectDataAndRoute(RouterService.java:773) at org.jumpmind.symmetric.service.impl.RouterService.routeDataForChannel(RouterService.java:519) at org.jumpmind.symmetric.service.impl.RouterService.routeDataForEachChannel(RouterService.java:291) at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:220) at org.jumpmind.symmetric.job.RouterJob.doJob(RouterJob.java:49) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) 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:748) Caused by: org.jumpmind.symmetric.io.data.ProtocolException: The router row for table sym_node_security had 13 columns but expected 15. at org.jumpmind.symmetric.route.AbstractDataRouter.testColumnNamesMatchValues(AbstractDataRouter.java:215) at org.jumpmind.symmetric.route.AbstractDataRouter.getDataAsString(AbstractDataRouter.java:100) at org.jumpmind.symmetric.route.AbstractDataRouter.getNewDataAsString(AbstractDataRouter.java:87) at org.jumpmind.symmetric.route.AbstractDataRouter.getDataMap(AbstractDataRouter.java:57) at org.jumpmind.symmetric.route.ConfigurationChangedDataRouter.routeToNodes(ConfigurationChangedDataRouter.java:129) at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:885) ... 15 more | ||||
| Steps To Reproduce | This test was run on Oracle. 1. Install SymmetricDS 3.11 and get it running with server and client 2. Stop it and delete from sym_trigger_hist 3. Upgrade to SymmetricDS 3.12 and get it running 4. Observe changes for sym_node_security and sym_console_user will get errors | ||||
| Tags | routing | ||||
|
SymmetricDS: 3.12 c6c57581 2021-05-04 14:31:23 Details Diff |
0004974: Routing and extracting had X columns but expected Y |
Affected Issues 0004974 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/TriggerReBuildReason.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-05-04 14:23 | elong | New Issue | |
| 2021-05-04 14:23 | elong | Status | new => assigned |
| 2021-05-04 14:23 | elong | Assigned To | => elong |
| 2021-05-04 14:23 | elong | Tag Attached: routing | |
| 2021-05-04 14:31 | elong | Status | assigned => resolved |
| 2021-05-04 14:31 | elong | Resolution | open => fixed |
| 2021-05-04 14:31 | elong | Fixed in Version | => 3.12.10 |
| 2021-05-04 15:00 | admin | Changeset attached | => SymmetricDS 3.12 c6c57581 |
| 2021-05-28 20:40 | admin | Status | resolved => closed |