View Issue Details

IDProjectCategoryView StatusLast Update
0003530SymmetricDSBugpublic2019-04-24 13:49
Reporterddlg_2Assigned Toelong 
Status closedResolutionnot fixable 
Product Version3.9.1 
Target VersionFixed in Version 
Summary0003530: Symmetric push data failed,caused by a error while processing GET request

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 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(
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(
    at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(
    at org.jumpmind.symmetric.service.impl.DataExtractorService.getExtractRequestNodes(
    at org.jumpmind.symmetric.service.impl.DataExtractorService.queueWork(
    at org.jumpmind.symmetric.job.InitialLoadExtractorJob.doJob(
    at org.jumpmind.symmetric.job.AbstractJob.invoke(
    at java.util.concurrent.Executors$
    at java.util.concurrent.FutureTask.runAndReset(
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(
    at java.util.concurrent.ScheduledThreadPoolExecutor$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
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
TagsNo tags attached.



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
2019-04-24 13:49 elong Assigned To => elong
2019-04-24 13:49 elong Status feedback => closed
2019-04-24 13:49 elong Resolution open => not fixable