Re: Execute shell script from trigger/procedure

[Ravi Teja Pattam]

Hi Peter,

I have written a trigger code which will run after update, but when im doing this im getting below error.

delimiter ;;
create trigger mytrigger1 after update on flag
for each row
begin
STOP SLAVE IO_THREAD;
end;
;;delimiter ;

The Flag table is getting locked and STOP SLAVE doesnt work giving error stating below

Error 'Can't execute the given command because you have active locked tables or an active transaction' on query. Default database: 'test1'. Query: 'update flag set flag_value='1' where flag_value='0''



Regrds,
Ravi