ERROR: Got an error writing communication packets - Source

Revision: 126120
User: Michael Ryan
Date: 2023-05-24 02:40

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    |
+---------------------------------------+----------+

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

ERROR: Got an error writing communication packets - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB