When I run command
SHOW SLAVE STATUS\G, I see
Slave_IO_Running : 'Yes'
Slave_SQL_Running : 'No'
What I've usually done to fix this is to run
STOP SLAVE; SET GLOBAL sql_slave_skip_counter = 1; START SLAVE;
It did not work this time.
When I ran
STOP SLAVE;, I get
SQL Error (1192): Can't execute the given command because you have active locked tables or an active transaction."
I've never seen this before. What can I do to get past it?