[MDEV-31455] main.events_stress or events.events_stress fails with view-protocol Created: 2023-06-11  Updated: 2023-09-27  Resolved: 2023-09-27

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3

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

Issue Links:
Relates
relates to MDEV-31457 main.delete_use_source fails (hangs) ... Closed

 Description   

10.4 f5dceafd

$ perl ./mtr main.events_stress --view-protocol
 
main.events_stress                       [ fail ]
        Test ended at 2023-06-11 22:00:09
 
CURRENT_TEST: main.events_stress
mysqltest: At line 48: query 'SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS' failed: 1146: Table 'events_test.mysqltest_tmp_v' doesn't exist
 
The result from queries just before the failure was:
< snip >
CREATE TABLE events_test.fill_it3(test_name varchar(20), occur datetime);
CREATE USER event_user2@localhost;
CREATE DATABASE events_conn2_db;
GRANT ALL ON *.* TO event_user2@localhost;
CREATE USER event_user3@localhost;
CREATE DATABASE events_conn3_db;
GRANT ALL ON *.* TO event_user3@localhost;
connect  conn2,localhost,event_user2,,events_conn2_db;
"In the second connection we create some events which won't be dropped till the end"
connect  conn3,localhost,event_user3,,events_conn3_db;
"In the second connection we create some events which won't be dropped till the end"
connection default;
USE events_conn1_test2;
CREATE EVENT ev_drop1 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
CREATE EVENT ev_drop2 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
CREATE EVENT ev_drop3 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
USE events_test;
SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS;

In 11.x the test was relocated to events suite, but the failure remains the same.



 Comments   
Comment by Lena Startseva [ 2023-08-11 ]

Fixed in branch bb-10.4-MDEV-31457-vp

Comment by Lena Startseva [ 2023-09-27 ]

Fixed in fec93e7155393f8807a8006934b774e4166a7290

Generated at Thu Feb 08 10:24:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.