Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.5
-
None
-
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 |
|
+-----------------------------------+------------------------------------------------------------+
|
|