[MDEV-9464] perfschema.global_read_lock fails when executed after perfschema.dml_setup_instruments Created: 2016-01-26  Updated: 2016-02-12  Resolved: 2016-02-12

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

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

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/5374/steps/test_6/logs/stdio

perfschema.global_read_lock              w3 [ fail ]
        Test ended at 2016-01-25 16:06:12
 
CURRENT_TEST: perfschema.global_read_lock
--- /mnt/buildbot/build/mariadb-10.1.10/mysql-test/suite/perfschema/r/global_read_lock.result	2016-01-25 09:53:30.000000000 +0200
+++ /mnt/buildbot/build/mariadb-10.1.10/mysql-test/suite/perfschema/r/global_read_lock.reject	2016-01-25 16:06:11.000000000 +0200
@@ -27,7 +27,7 @@
 from performance_schema.events_waits_current
 where event_name like "wait/synch/cond/sql/MDL_context::COND_wait_status";
 event_name	short_source	timer_end	timer_wait	operation
-wait/synch/cond/sql/MDL_context::COND_wait_status	mdl.cc:	SET	SET	timed_wait
+wait/synch/cond/sql/MDL_context::COND_wait_status	mdl.cc:	NULL	NULL	timed_wait
 unlock tables;
 update performance_schema.setup_instruments set enabled='NO';
 update performance_schema.setup_instruments set enabled='YES';

Reproducible by running

perl ./mtr perfschema.dml_setup_instruments perfschema.global_read_lock --noreorder



 Comments   
Comment by Elena Stepanova [ 2016-02-12 ]

https://github.com/MariaDB/server/commit/2c79f57530e0094038c4bebb799df6be602473e3

commit 2c79f57530e0094038c4bebb799df6be602473e3
Author: Elena Stepanova <elenst@montyprogram.com>
Date:   Fri Feb 12 03:47:25 2016 +0200
 
    MDEV-9464 perfschema.global_read_lock fails when executed after perfschema.dml_setup_instruments
    
    dml_setup_instruments did not restore settings in setup_instruments table
    after updating it as a part of the test flow

Generated at Thu Feb 08 07:34:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.