Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Cannot Reproduce
-
Affects Version/s: 10.0.14
-
Fix Version/s: N/A
-
Component/s: Replication
-
Labels:None
-
Environment:Redhat Linux 2.6.32-431.29.2.el6.x86_64
VM on Citrix Xen 16GB RAM 8vcpu
Description
We have had replication stop on our GTID enabled slave when the same events are passing through
Things such as this have failed and skip has been executed to allow replication to continue
Last_Errno: 1396
Last_Error: Error 'Operation CREATE USER failed for 'user1'@'192.168.x.xx'' on query. Default database: 'information_schema'. Query: 'CREATE USER ''user1'@'192.168.x.xx''
Actual user details changed for security reasons
Drop user has stalled and a error from what I believe to be a stored procedure which inserts some records into a table has caused issues.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
We need some more details to understand what the problem here is.
1. You mention "slave when the same events are passing through". Do you mean that you have a setup S1->S2->S3, where S2 is using GTID but S3 is not? Or something else? What makes you think the problem is related to GTID?
2. Might there be some reasonable explanation for the CREATE USER statement to fail, like the user existing before or something like that? What is in the error log? What happens if the CREATE USER statement is run manually on the server?
3. With respect to the "Drop user has stalled and ..." - we really need a detailed, precise description of each problem to be able to say anything meaningful.