Bug #16026 probléme of creation of a trigger on a waiter of replication
Submitted: 28 Dec 2005 3:27 Modified: 2 Jan 2006 11:27
Reporter: benhamou ariel Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.17 OS:Windows (windows 2003 server)
Assigned to: CPU Architecture:Any

[28 Dec 2005 3:27] benhamou ariel 
Description:
 have 2 waiters one is the maitre the other the slave when I want to create a trigger in the errors of the logs it marks: <Error 'Trigger does> and are code is 1360 

How to repeat:
to put in replication 2 waiters and makes a create trigger. To look at fatty with the order < show Slave status > the fields last_errno and last_error 

Suggested fix:
very very important because the triggers take many resource and to divide the spots I need executer the < select > on the waiter of replication
[28 Dec 2005 10:07] Valeriy Kravchuk 
Thank you for a problem report. So, you are trying to create triggers on master and these statements are not replicated on slave, both running 5.0.17, right?

Please, send the exact CREATE TABLE statement for the table you are adding triggers to, and the exact CREATE TRIGGER statement you are trying to perform.

Send also the error log for both master and slaves for the appropriate period.
[2 Jan 2006 11:27] benhamou ariel 
The probléme is regulated with version 5.0.18
[2 Jan 2006 11:27] benhamou ariel 
The probléme is regulated with version 5.0.18