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

Improve this question
9
  • Increase the timeouts massively
    – nbk
    Jul 29, 2020 at 9:10
  • Looks like network connectivity problems.
    – mustaccio
    Jul 29, 2020 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, 2020 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, 2020 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, 2020 at 16:04

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.