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

plugins.processlist fails in buildbot with syntax error

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0, 10.1
    • Fix Version/s: 10.0.36, 10.1.35
    • Component/s: Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-ppc64le/builds/2984

      plugins.processlist 'innodb_plugin'      w3 [ fail ]
              Test ended at 2018-07-19 03:17:20
       
      CURRENT_TEST: plugins.processlist
      mysqltest: At line 13: query 'select regexp_replace("$s", '(?s)^.*MySQL thread id $id,.*root([^\n]*)\n.*', '\\\\1') as `state from show engine innodb status`' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ';;
       2: len 7; hex 9d0000023e0110; asc     >  ;;
       3: len 4; hex 80000001; asc    ' at line 1
       
      The result from queries just before the failure was:
      create table t1 (a int) engine=innodb;
      start transaction;
      insert t1 values (1);
      

      It was fixed in 10.3:
      https://github.com/MariaDB/server/commit/0d745343fc1e274a938bef9e91b18c508076ae62
      and also
      https://github.com/MariaDB/server/commit/78a0646fe4ab7d58d900192ef7f4df905ed7442e

      both fixes need to be backported.

        Attachments

          Activity

            People

            • Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: