ERROR: Got an error writing communication packets
I'm running a query and then I encountered this error:
2023-05-24 12:20:07 36700 [Warning] Aborted connection 36700 to db: 'unconnected' user: 'testuser' host: '10.137.24.218' (Got an error writing communication packets) 2023-05-24 12:20:50 36701 [Warning] Aborted connection 36701 to db: 'unconnected' user: 'testuser' host: '10.136.52.117' (Got an error writing communication packets)
Here's my configuration:
MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet'; +--------------------+------------+
| Variable_name | Value |
+--------------------+------------+
| max_allowed_packet | 1073741824 |
+--------------------+------------+
MariaDB [(none)]> SHOW VARIABLES LIKE '%timeout%'; +---------------------------------------+----------+
| Variable_name | Value |
+---------------------------------------+----------+
| connect_timeout | 28800 |
| deadlock_timeout_long | 50000000 |
| deadlock_timeout_short | 10000 |
| delayed_insert_timeout | 300 |
| idle_readonly_transaction_timeout | 0 |
| idle_transaction_timeout | 0 |
| idle_write_transaction_timeout | 0 |
| innodb_flush_log_at_timeout | 1 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | ON |
| interactive_timeout | 28800 |
| lock_wait_timeout | 86400 |
| net_read_timeout | 28800 |
| net_write_timeout | 28800 |
| rpl_semi_sync_master_timeout | 1000 |
| rpl_semi_sync_slave_kill_conn_timeout | 5 |
| slave_net_timeout | 60 |
| thread_pool_idle_timeout | 60 |
| wait_timeout | 28800 |
+---------------------------------------+----------+
