Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7999

FEDERATED engine not reconnecting on wait_timeout exceeded

Details

    Description

      When using Federated engine, if connection is closed on source server because wait_time is exceeded, client gets "Got packets out of order" error.

      This happens on 8.0.24 and later, not earlier. Possibly this is related to the more informative error message when connection is closed because of wait_timeout? Using "kill <id>;" on connections opened by Federated do not show this issue.

      "Client" side of Federated shows no error in log, the server holding the table shows "The client was disconnected by the server because of inactivity".

      How to repeat:
      dbdeployer deploy multiple --nodes 2 8.0.26 --my-cnf-options federated --my-cnf-options log_error_verbosity=3

      n2 -e "set global wait_timeout=5"
      n2 -e "create table test.f (id int primary key); insert into test.f values(1)"

      n1 -e "create server test foreign data wrapper test1 options (user 'msandbox', password 'msandbox', host '127.0.0.1', port 26729, database 'test');"
      n1 -e "create table test.f (id int primary key) engine=federated connection='test';"

      n1 -e "select * from test.f; select sleep(10); select * from test.f;"

      +----+
      | id |
      +----+
      |  1 |
      +----+
      +-----------+
      | sleep(10) |
      +-----------+
      |         0 |
      +-----------+
      ERROR 1156 (08S01) at line 1: Got packets out of order
      

      Attachments

        Issue Links

          Activity

            People

              kamil.holubicki Kamil Holubicki
              sami.ahlroos Sami Ahlroos
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1 hour, 18 minutes Original Estimate - 1 hour, 18 minutes
                  1h 18m
                  Remaining:
                  Time Spent - 1 day, 3 hours, 52 minutes Remaining Estimate - 1 hour, 7 minutes
                  1h 7m
                  Logged:
                  Time Spent - 1 day, 3 hours, 52 minutes Remaining Estimate - 1 hour, 7 minutes
                  1d 3h 52m

                  Smart Checklist