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

plugins.processlist fails in buildbot with syntax error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0, 10.1
    • 10.0.36, 10.1.35
    • Tests
    • 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

            sanja Oleksandr Byelkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.