Description:
Symptom 1:
------------------------------------------------------------------
main.events_2 [ fail ]
mysqltest: At line 121: query 'select release_lock("test_lock2_1")' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
get_lock("test_lock2_1", 20)
1
create event закачка21 on schedule every 10 hour do select get_lock("test_lock2_1", 20);
"Should have only 2 processes: the scheduler and the locked event"
select /*3*/ user, host, db, command, state, info
from information_schema.processlist
where (info like "select get_lock%" OR user='event_scheduler')
order by info;
user host db command state info
event_scheduler localhost NULL Daemon Waiting for next activation NULL
root localhost events_test Connect User lock select get_lock("test_lock2_1", 20)
set global event_scheduler=off;
"Should have only our process now:"
select /*4*/ user, host, db, command, state, info
from information_schema.processlist
where (info like "select get_lock%" OR user='event_scheduler')
order by info;
user host db command state info
root localhost events_test Connect User lock select get_lock("test_lock2_1", 20)
select release_lock("test_lock2_1");
------------------------------------------------------------------
Symptom 2:
------------------------------------------------------------------
main.events_2 [ fail ]
CURRENT_TEST: main.events_2
mysqltest: At line 76: query 'select release_lock("test_lock2")' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
select count(*) from mysql.event;
count(*)
0
"ENABLE the scheduler and get a lock"
set global event_scheduler=on;
select get_lock("test_lock2", 20);
get_lock("test_lock2", 20)
1
"Create an event which tries to acquire a mutex. The event locks on the mutex"
create event закачка on schedule every 10 hour do select get_lock("test_lock2", 20);
"Should have only 2 processes: the scheduler and the locked event"
select /*2*/ user, host, db, command, state, info
from information_schema.processlist
where (info like "select get_lock%" OR user='event_scheduler')
order by info;
user host db command state info
event_scheduler localhost NULL Daemon Waiting for next activation NULL
root localhost events_test Connect User lock select get_lock("test_lock2", 20)
"Release the mutex, the event worker should finish."
select release_lock("test_lock2");
------------------------------------------------------------------
How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.events_2