View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003530 | SymmetricDS | Bug | public | 2018-04-25 03:20 | 2019-04-24 17:49 |
Reporter | ddlg_2 | Assigned To | elong | ||
Priority | high | ||||
Status | closed | Resolution | not fixable | ||
Product Version | 3.9.1 | ||||
Summary | 0003530: Symmetric push data failed,caused by a error while processing GET request | ||||
Description | Hi, 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 | ||||
Tags | No tags attached. | ||||
|
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. |
Date Modified | Username | Field | Change |
---|---|---|---|
2018-04-25 03:20 | ddlg_2 | New Issue | |
2018-09-13 18:46 | hanes | Status | new => feedback |
2018-09-13 18:46 | hanes | Note Added: 0001239 | |
2019-04-24 17:49 | elong | Assigned To | => elong |
2019-04-24 17:49 | elong | Status | feedback => closed |
2019-04-24 17:49 | elong | Resolution | open => not fixable |