Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3455

Got packets out of order

    XMLWordPrintable

Details

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

      Attachments

        Activity

          People

            Unassigned Unassigned
            alexcool Alex
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.