Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20745

Error 1156 if compression enabled and SQL select text is 27k long

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2.27
    • 10.2
    • Server
    • None
    • CentOS Linux release 7.6.1810 (Core)

    Description

      Error 1156 if compression enabled by client (CLIENT_COMPRESS) and SQL select text is 27k long, 100% resproducible:
      errno=1156(08S01), Got packets out of order

      Never occurs if compression disabled.

      See the full select text in attachment - vrfstaticroute_table_and_select.txt

      Debugged it setting breakpoint on the places where "packets out of order" condition detected, e.g. on net_serv.cc's "goto packets_out_of_order", see gdb_mysqld_packets_out_of_order_1.txt

      Workarounded it by changing if condition in my_real_read, see net_serv.cc.fixed:

      if (net->buff[ net->where_b + 3 ] != ( uchar )net->pkt_nr)
      =>
      if (net->buff[ net->where_b + 3 ] != ( uchar )net->compress_pkt_nr
      &&
      net->buff[ net->where_b + 3 ] != ( uchar )net->pkt_nr)

      But not sure at all if it is a correct solution

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            ykantoni YURII KANTONISTOV
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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