View Issue Details

IDProjectCategoryView StatusLast Update
0003530SymmetricDSBugpublic2018-09-13 14:46
Reporterddlg_2Assigned To 
Priorityhigh 
Status feedbackResolutionopen 
Product Version3.9.1 
Target VersionFixed in Version 
Summary0003530: Symmetric push data failed,caused by a error while processing GET request
DescriptionHi,

Symmetric push data failed,caused by a error while processing GET request.

Exception log as following:

2018-04-25 06:56:10,037 INFO [server-010] [SymmetricServlet] [qtp1226622409-14] Error while processing GET request for node: 001 at 127.0.0.1 with path: /server-010/pull The message is: Failed to execute sql: select b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary from sym_outgoing_batch b join sym_channel c on c.channel_id = b.channel_id where (c.data_event_action is null or c.data_event_action = ?) and b.node_id = ? and c.queue = ? and b.status in (?, ?, ?, ?, ?, ?, ?, ?) order by b.batch_id asc
2018-04-25 06:56:10,058 ERROR [server-010] [InitialLoadExtractorJob] [server-010-job-13] Exception while executing job 'Initial Load Extract' StackTraceKey.init [SqlException:3085670781]
org.jumpmind.db.sql.SqlException: Failed to execute sql: select node_id, queue from sym_extract_request where status=? group by node_id, queue
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:120)
    at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:140)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:195)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:185)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:121)
    at org.jumpmind.symmetric.service.impl.DataExtractorService.getExtractRequestNodes(DataExtractorService.java:1663)
    at org.jumpmind.symmetric.service.impl.DataExtractorService.queueWork(DataExtractorService.java:1637)
    at org.jumpmind.symmetric.job.InitialLoadExtractorJob.doJob(InitialLoadExtractorJob.java:44)
    at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:225)
    at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:287)
    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: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

2018-04-25 06:56:20,128 INFO [client1-001] [PushService] [client1-001-push-default-8] Could not communicate with node 'server:010:010' at http://localhost:31415/sync/server-010 because it returned HTTP code 500

Activities

hanes

2018-09-13 14:46

developer   ~0001239

Some questions:
1. Are you still having this issue in more recent versions of 3.9?
2. Are your server and client on separate machines or are you running multi-homed?
3. Is your database the server is connecting to on a separate machine?
The error message in your log would seem to indicate an environment issue where the server is unable to maintain a reliable database connection to the database, not necessarily a software bug.

Issue History

Date Modified Username Field Change
2018-04-24 23:20 ddlg_2 New Issue
2018-09-13 14:46 hanes Status new => feedback
2018-09-13 14:46 hanes Note Added: 0001239