View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003473SymmetricDSBugpublic2018-03-05 07:412018-03-07 17:33
Reporterniem.buithi Assigned Toelong  
Priorityurgent 
Status closedResolutionduplicate 
Product Version3.9.4 
Summary0003473: SymmetricDS issue after upgraded from 3.8.32 to 3.9.4
DescriptionHi all,

I got the issue after upgraded the symmetricDS from 3.8.32 to 3.9.4.
The issue happned for both the source node and the target node.
NOTE: I added 3 keys into my properties file as the changes on https://www.symmetricds.org/issues/view.php?id=3392
Steps To Reproduce1. I have 1 source node and 2 target nodes that are running symmetricDS version 3.8.32.
3. Download the binaries of symmetricDS 3.9.4 from https://www.symmetricds.org/download
4. Stop symmetricDS in the source node and Target nodes.
5. Upgrade symmetricDS to 3.9.4 for the source node and 2 target node (I updated my engine files to add new key as the fix on case https://www.symmetricds.org/issues/view.php?id=2859).
6. Start symmetricDS in the source node and targets node.
7. SymmetricDS can start successfully (all trigger were created) but It cannot sync.

Could you please help me check this case?

Additional InformationThe error in my log file as below:

2018-03-05 13:27:10,880 INFO [admin-AUNSW000002MS] [TriggerRouterService] [symmetric-engine-startup-1] Done synchronizing triggers
2018-03-05 13:27:11,021 INFO [admin-AUNSW000002MS] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 5000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,021 INFO [admin-AUNSW000002MS] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 10000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,021 INFO [admin-AUNSW000002MS] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 10000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,021 INFO [admin-AUNSW000002MS] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start
2018-03-05 13:27:11,021 INFO [admin-AUNSW000002MS] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start
2018-03-05 13:27:11,021 INFO [admin-AUNSW000002MS] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *'
2018-03-05 13:27:11,021 INFO [admin-AUNSW000002MS] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *'
2018-03-05 13:27:11,043 INFO [admin-AUNSW000002MS] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2018-03-05 13:27:11,043 INFO [admin-AUNSW000002MS] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2018-03-05 13:27:11,043 INFO [admin-AUNSW000002MS] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,043 INFO [admin-AUNSW000002MS] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,043 INFO [admin-AUNSW000002MS] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2018-03-05 13:27:11,043 INFO [admin-AUNSW000002MS] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start
2018-03-05 13:27:11,116 INFO [admin-AUNSW000002MS] [FileSyncTrackerJob] [symmetric-engine-startup-1] Starting job 'File Sync Tracker' with cron expression: '0 0/5 * * * *'
2018-03-05 13:27:11,116 INFO [admin-AUNSW000002MS] [FileSyncPullJob] [symmetric-engine-startup-1] Starting File Sync Pull on periodic schedule: every 60000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,116 INFO [admin-AUNSW000002MS] [FileSyncPushJob] [symmetric-engine-startup-1] Starting File Sync Push on periodic schedule: every 60000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,116 INFO [admin-AUNSW000002MS] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,116 INFO [admin-AUNSW000002MS] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Mon Mar 05 13:27:15 AEDT 2018
2018-03-05 13:27:11,116 INFO [admin-AUNSW000002MS] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start
2018-03-05 13:27:11,116 INFO [admin-AUNSW000002MS] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED:
     nodeId=AUNSW000002MS
     groupId=admin
     type=server
     subType=null
     name=admin-AUNSW000002MS
     softwareVersion=3.9.4
     databaseName=Microsoft SQL Server
     databaseVersion=12.0
     driverName=Microsoft JDBC Driver 4.0 for SQL Server
     driverVersion=4.0.2206.100
     uptime=0 sec.
2018-03-05 13:27:15,521 INFO [admin-AUNSW000002MS] [PushHeartbeatListener] [admin-AUNSW000002MS-job-4] Some attribute(s) of node changed. Recording changes
2018-03-05 13:27:15,521 INFO [admin-AUNSW000002MS] [PushHeartbeatListener] [admin-AUNSW000002MS-job-4] Updating my node configuration info according to the symmetric properties
2018-03-05 13:27:16,071 INFO [admin-AUNSW000002MS] [DataGapFastDetector] [admin-AUNSW000002MS-job-1] Full gap analysis is running
2018-03-05 13:27:16,335 INFO [admin-AUNSW000002MS] [DataGapFastDetector] [admin-AUNSW000002MS-job-1] Querying data in gaps from database took 264 ms
2018-03-05 13:27:16,335 INFO [admin-AUNSW000002MS] [DataGapFastDetector] [admin-AUNSW000002MS-job-1] Full gap analysis is done after 264 ms
2018-03-05 13:27:16,695 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-1] The 'config' channel is NOT in common batch mode
2018-03-05 13:27:18,683 INFO [admin-AUNSW000002MS] [ConfigurationChangedDataRouter] [admin-AUNSW000002MS-job-1] Channels flushed because new channels came through the data router
2018-03-05 13:27:18,683 INFO [admin-AUNSW000002MS] [ConfigurationChangedDataRouter] [admin-AUNSW000002MS-job-1] About to refresh the cache of nodes because new configuration came through the data router
2018-03-05 13:27:18,683 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-1] Routed 4 data events in 2612 ms
2018-03-05 13:27:23,714 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-1] The 'heartbeat' channel is NOT in common batch mode
2018-03-05 13:27:24,182 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-1] Routed 2 data events in 483 ms
2018-03-05 13:30:03,958 INFO [admin-AUNSW000002MS] [FileTriggerTracker] [admin-AUNSW000002MS-job-9] Tracked 126 files in 3 seconds. Found 126 files changed.
2018-03-05 13:30:05,432 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-11] The 'filesync' channel is NOT in common batch mode
2018-03-05 13:30:07,630 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-11] Routed 252 data events in 2198 ms
2018-03-05 13:39:53,694 INFO [admin-AUNSW000002MS] [PullUriHandler] [qtp699780352-13] 3 data and 2 batches sent during pull request from tablet:AUNSW000002MS/ADMIN-PC:AUNSW000002MS/ADMIN-PC
2018-03-05 13:40:02,354 INFO [admin-AUNSW000002MS] [MsSqlSymmetricDialect] [admin-aunsw000002ms-dataloader-1] This database DOES support disabling triggers during a symmetricds data load
2018-03-05 13:40:02,803 INFO [admin-AUNSW000002MS] [ConfigurationChangedDatabaseWriterFilter] [admin-aunsw000002ms-dataloader-1] Channels flushed because new channels came through the data loader
2018-03-05 13:40:02,932 INFO [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-15] 3 data and 2 batches loaded during push request from tablet:AUNSW000002MS/ADMIN-PC:AUNSW000002MS/ADMIN-PC.
2018-03-05 13:40:06,428 INFO [admin-AUNSW000002MS] [ConfigurationChangedDataRouter] [admin-AUNSW000002MS-job-6] Channels flushed because new channels came through the data router
2018-03-05 13:40:06,428 INFO [admin-AUNSW000002MS] [ConfigurationChangedDataRouter] [admin-AUNSW000002MS-job-6] About to refresh the cache of nodes because new configuration came through the data router
2018-03-05 13:40:06,693 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-6] Routed 3 data events in 372 ms
2018-03-05 13:42:17,335 INFO [admin-AUNSW000002MS] [RouterService] [admin-AUNSW000002MS-job-20] Routed 2 data events in 27 ms
2018-03-05 13:42:22,215 INFO [admin-AUNSW000002MS] [PullUriHandler] [qtp699780352-14] 1 data and 1 batches sent during pull request from tablet:AUNSW000002MS/ADMIN-PC:AUNSW000002MS/ADMIN-PC
2018-03-05 13:43:34,350 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-2] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey.init [AbstractMethodError:1590958151]
java.lang.AbstractMethodError: Method org/apache/commons/dbcp/DelegatingPreparedStatement.setNString(ILjava/lang/String;)V is abstract
    at org.apache.commons.dbcp.DelegatingPreparedStatement.setNString(DelegatingPreparedStatement.java)
    at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:349)
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:241)
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:172)
    at org.jumpmind.db.sql.JdbcSqlTemplate.setValues(JdbcSqlTemplate.java:1013)
    at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(JdbcSqlTransaction.java:455)
    at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.execute(DefaultDatabaseWriter.java:865)
    at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.insert(DefaultDatabaseWriter.java:202)
    at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:191)
    at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
    at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84)
    at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
    at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:206)
    at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:210)
    at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:177)
    at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:123)
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$1.call(DataLoaderService.java:1029)
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$1.call(DataLoaderService.java:991)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
2018-03-05 13:43:34,445 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-15] Failed to process batch StackTraceKey.init [RuntimeException:2427343595]
java.lang.RuntimeException: java.lang.AbstractMethodError: Method org/apache/commons/dbcp/DelegatingPreparedStatement.setNString(ILjava/lang/String;)V is abstract
    at org.jumpmind.symmetric.io.data.DataProcessor.rethrow(DataProcessor.java:249)
    at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:154)
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$1.call(DataLoaderService.java:1029)
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$1.call(DataLoaderService.java:991)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.AbstractMethodError: Method org/apache/commons/dbcp/DelegatingPreparedStatement.setNString(ILjava/lang/String;)V is abstract
    at org.apache.commons.dbcp.DelegatingPreparedStatement.setNString(DelegatingPreparedStatement.java)
    at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:349)
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:241)
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:172)
    at org.jumpmind.db.sql.JdbcSqlTemplate.setValues(JdbcSqlTemplate.java:1013)
    at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(JdbcSqlTransaction.java:455)
    at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.execute(DefaultDatabaseWriter.java:865)
    at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.insert(DefaultDatabaseWriter.java:202)
    at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:191)
    at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
    at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84)
    at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
    at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:206)
    at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:210)
    at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:177)
    at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:123)
    ... 6 more
2018-03-05 13:43:42,979 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-3] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:43:43,117 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-3] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:43:43,182 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-13] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:43:52,916 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-4] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:43:52,929 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-4] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:43:52,947 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-15] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:44:03,069 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-5] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:44:03,086 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-5] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:44:03,102 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-19] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:44:12,961 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-6] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:44:12,976 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-6] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:44:13,022 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-13] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:44:22,960 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-7] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:44:22,991 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-7] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:44:23,007 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-12] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:44:33,008 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-8] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:44:33,026 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-8] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:44:33,040 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-16] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:44:43,022 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-9] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:44:43,038 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-9] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:44:43,070 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-14] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:44:53,040 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-10] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:44:53,055 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-10] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:44:53,072 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-17] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:45:03,056 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-11] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:45:03,069 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-11] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:45:03,087 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-13] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:45:13,101 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-12] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:45:13,131 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-12] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:45:13,147 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-13] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:45:23,100 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-13] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:45:23,123 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-13] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:45:23,132 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-19] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:45:33,085 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-14] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:45:33,101 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-14] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:45:33,117 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-13] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:45:43,403 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-15] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:45:43,435 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-15] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:45:43,479 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-19] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:45:53,132 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-16] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:45:53,132 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-16] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:45:53,148 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-13] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:46:03,116 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-17] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:46:03,133 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-17] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:46:03,148 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-12] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:46:13,133 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-18] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:46:13,147 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-18] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:46:13,147 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-12] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:46:23,135 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-19] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:46:23,148 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-19] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:46:23,179 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-19] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:46:33,132 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-20] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:46:33,147 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-20] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:46:33,163 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-15] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:46:43,132 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-21] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:46:43,150 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-21] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:46:43,150 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-12] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:46:53,165 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-22] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:46:53,179 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-22] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:46:53,241 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-17] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:47:03,195 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-23] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:47:03,226 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-23] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:47:03,242 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-15] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:47:13,194 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-24] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:47:13,570 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-24] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:47:13,616 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-17] Failed to process batch StackTraceKey [RuntimeException:2427343595]
2018-03-05 13:47:23,273 INFO [admin-AUNSW000002MS] [IncomingBatchService] [admin-aunsw000002ms-dataloader-25] Retrying batch AUNSW000002MS/ADMIN-PC-27
2018-03-05 13:47:23,288 ERROR [admin-AUNSW000002MS] [ManageIncomingBatchListener] [admin-aunsw000002ms-dataloader-25] Failed to load batch AUNSW000002MS/ADMIN-PC-27 StackTraceKey [AbstractMethodError:1590958151]
2018-03-05 13:47:23,305 ERROR [admin-AUNSW000002MS] [DataLoaderService] [qtp699780352-12] Failed to process batch StackTraceKey [RuntimeException:2427343595]
TagsNo tags attached.

Relationships

duplicate of 0003474 closedelong java.lang.AbstractMethodError: java/sql/PreparedStatement.setNString 

Activities

elong

2018-03-05 13:15

developer   ~0001140

Check in the "lib" and "web/WEB-INF/lib" directories to see if you have duplicate JAR files from both 3.8 and 3.9. For example, you might see commons-dbcp-1.3.jar and commons-dbcp-1.4.jar, but you should only have one of those.

elong

2018-03-05 13:22

developer   ~0001141

This was also reported on issue 0003474 along with pull request to fix it:

https://www.symmetricds.org/issues/view.php?id=3474

Sounds like we should be using commons-dbcp-1.4.jar with MS-SQL JDBC.

niem.buithi

2018-03-06 02:15

reporter   ~0001142

Hi Elong,

I deleted all old JAR files in the "lib" and "web/WEB-INF/lib" in 3.8.32 before copy the new binaries of 3.9.4 into those folders.
I will wait for the fix of this case on the next release.

Thanks and Best Regards,
Niem bui

elong

2018-03-07 17:33

developer   ~0001143

I think you could workaround it in 3.9 by deleting the web/WEB-INF/lib/commons-dbcp-1.3.jar and copying in web/WEB-INF/lib/commons-dbcp-1.4.jar (from SymmetricDS 3.8). I'll close this as a duplicate, since it's fixed 0003474.

Issue History

Date Modified Username Field Change
2018-03-05 07:41 niem.buithi New Issue
2018-03-05 13:15 elong Note Added: 0001140
2018-03-05 13:22 elong Note Added: 0001141
2018-03-05 13:23 elong Relationship added duplicate of 0003474
2018-03-06 02:15 niem.buithi Note Added: 0001142
2018-03-07 17:33 elong Note Added: 0001143
2018-03-07 17:33 elong Assigned To => elong
2018-03-07 17:33 elong Status new => closed
2018-03-07 17:33 elong Resolution open => duplicate