[MXS-3456] Got packets out of order Created: 2021-03-24  Updated: 2021-03-24  Resolved: 2021-03-24

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: 2.5.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alex Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Debian



 Description   

We have two servers behind maxscale. Master is running on InnoDB, Slave is running on TokuDB. On slave we see these kind a messages in slow log and error log.

"Change user" command lasts for a second and "Got packets out of order" in error.log about same connection.

Mysql slow log:

# 
# # Time: 700101  3:00:01
# User@Host: meshok7[meshok7] @ sensored [10.0.0.1]
# Thread_id: 17142520  Schema: meshok  QC_hit: No
# Query_time: 1.002349  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 18446744073709546879
SET timestamp=1;
# administrator command: Change user;

error.log:

2021-03-24 10:32:01 17142520 [Warning] Aborted connection 17142520 to db: 'meshok' user: 'meshok7' host: 'sensored' (Got packets out of order)

show global variables like '%version%';
+-----------------------------------+------------------------------------------------------------+
| Variable_name                     | Value                                                      |
+-----------------------------------+------------------------------------------------------------+
| in_predicate_conversion_threshold | 1000                                                       |
| protocol_version                  | 10                                                         |
| slave_type_conversions            |                                                            |
| system_versioning_alter_history   | ERROR                                                      |
| system_versioning_asof            | DEFAULT                                                    |
| tls_version                       | TLSv1.1,TLSv1.2,TLSv1.3                                    |
| tokudb_version                    | 5.6.49-89.0                                                |
| version                           | 10.4.17-MariaDB-1:10.4.17+maria~stretch-log                |
| version_comment                   | mariadb.org binary distribution                            |
| version_compile_machine           | x86_64                                                     |
| version_compile_os                | debian-linux-gnu                                           |
| version_malloc_library            | jemalloc 3.6.0-0-g46c0af68bd248b04df75e4f92d5fb804c3d75340 |
| version_source_revision           | 5fbfdae130950d0a5a07d4b909f3bf1ff0498d34                   |
| version_ssl_library               | OpenSSL 1.1.0l  10 Sep 2019                                |
| wsrep_patch_version               | wsrep_26.22                                                |
+-----------------------------------+------------------------------------------------------------+


Generated at Thu Feb 08 04:21:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.