Got timeout writing communication packets
Posted by: M.Manigandan Mangundu
Date: August 05, 2021 09:16PM

Hi ,

We have specific query which is running as job and it's using jdbc connector 5.1 version. we running mysql 5.7.32 mysql version and while we run the job first time the we are able to see the query in mysql db and while the query in "sending to client" state the query got aborted and logged the error in error log file as "Got timeout writing communication packets" error.

After aborting the job and run the job again the query got completed.


Kindly suggest.

Below are the timeout variables and values.

mysql> show global variables like '%timeout%';
+-------------------------------------+----------+
| Variable_name | Value |
+-------------------------------------+----------+
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| have_statement_timeout | YES |
| innodb_flush_log_at_timeout | 1 |
| innodb_lock_wait_timeout | 50 |
| innodb_print_lock_wait_timeout_info | OFF |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 432000 |
| lock_wait_timeout | 31536000 |
| net_read_timeout | 60 |
| net_write_timeout | 300 |
| rpl_stop_slave_timeout | 31536000 |
| slave_net_timeout | 60 |
| thread_pool_idle_timeout | 60 |
| wait_timeout | 432000 |
+-------------------------------------+----------+
15 rows in set (0.01 sec)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.