[MDEV-17746] perfschema.dml_threads failed in buildbot with wrong errno Created: 2018-11-16  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/win32-packages/builds/10543

10.2 01d3e401971ab51bb4a2b9c8438b27d0

perfschema.dml_threads                   w1 [ fail ]
        Test ended at 2018-11-14 13:25:20
 
CURRENT_TEST: perfschema.dml_threads
mysqltest: At line 23: query 'update performance_schema.threads
set thread_id=12 where PROCESSLIST_ID=connection_id()' succeeded - should have failed with errno 1683...
 
The result from queries just before the failure was:
select * from performance_schema.threads
where name like 'Thread/%' limit 1;
select * from performance_schema.threads
where name='FOO';
insert into performance_schema.threads
set name='FOO', thread_id=1, processlist_id=2;
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'threads'
update performance_schema.threads
set thread_id=12;
ERROR HY000: Invalid performance_schema usage
update performance_schema.threads
set thread_id=12 where PROCESSLIST_ID=connection_id();



 Comments   
Comment by Marko Mäkelä [ 2022-06-03 ]

This affects also 10.3 and later branches. The test fails quite often on the amd64-windows builder.

10.3 099b9202a5c0496cc4f4024a6e667fd526664f69

perfschema.dml_threads                   w31 [ fail ]
        Test ended at 2022-06-03 10:12:45
CURRENT_TEST: perfschema.dml_threads
mysqltest: At line 23: query 'update performance_schema.threads
set thread_id=12 where PROCESSLIST_ID=connection_id()' succeeded - should have failed with errno 1683...

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