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

ER_UNKNOWN_ERROR "Commands out of sync" on INFORMATION_SCHEMA.TABLES when running MTR with --cursor-protocol

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql';
      

      MTR output

      $ ./mtr mytest --cursor-protocol
      Logging: ./mtr  mytest --cursor-protocol
      VS config:
      vardir: /test/mtest/MDEV-31342/MD160926-mariadb-13.1.0-linux-x86_64-opt/mariadb-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/test/mtest/MDEV-31342/MD160926-mariadb-13.1.0-linux-x86_64-opt/mariadb-test/var'...
      Checking supported features...
      MariaDB Version 13.1.0-MariaDB
       - SSL connections supported
       - binaries built with wsrep patch
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029
      SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql';
      main.mytest                              [ fail ]
              Test ended at 2026-09-18 10:28:38
       
      CURRENT_TEST: main.mytest
      mysqltest: At line 1: query 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql'' failed: <Unknown> (2014): Commands out of sync; you can't run this command now
      

      Attachments

        Issue Links

          Activity

            People

              janlindstrom Jan Lindström
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

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