[MDEV-16818] plugins.processlist fails in buildbot with syntax error Created: 2018-07-24  Updated: 2018-08-03  Resolved: 2018-07-24

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0, 10.1
Fix Version/s: 10.0.36, 10.1.35

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
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.


Generated at Thu Feb 08 08:31:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.