1

We are getting continuously logs in mysql error logs

2020-07-29T07:46:56.534666Z 111536 [Note] Aborted connection 111536 to db: '' user: '' host: '' (Got an error reading communication packets)

we are using the following

+-----------------------------+----------+
| 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_rollback_on_timeout  | ON       |
| interactive_timeout         | 1800     |
| lock_wait_timeout           | 31536000 |
| net_read_timeout            | 1800     |
| net_write_timeout           | 1800     |
| rpl_stop_slave_timeout      | 31536000 |
| slave_net_timeout           | 60       |
| thread_pool_idle_timeout    | 60       |
| wait_timeout                | 1800     |
+-----------------------------+----------+

we are using percona MySQL server 5.7.30-33

let us know what we are missing or what we can do to resolve the issue.

I have referred some online topics with same errors but nothing resolved the issue

Thanks

9
  • Increase the timeouts massively
    – nbk
    Jul 29 '20 at 9:10
  • Looks like network connectivity problems.
    – mustaccio
    Jul 29 '20 at 12:41
  • 1
    we are using aws infra and vpc network where both client machine & db server reside. I have tested connectivity and privileges with mysql client and connection done without any issue. let us know which timeouts we should increase
    – devops
    Jul 29 '20 at 14:09
  • 1
    yes we have skip-name-resolve in config and user definations are IP based so any impact of skip name-resolve
    – devops
    Jul 31 '20 at 9:17
  • 1
    @ Wilson Hauck config of db : 16 GB ,4 Core,SSD and config details and request details you can check through pastebin.com/Z8Lsxw9F pastebin.com/v9varR27 pastebin.com/PuiLqgSK
    – devops
    Aug 6 '20 at 16:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.