MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Shain Miley Date:January 9 2009 5:17pm
Subject:Mysql Replication out of sync
View as plain text  
Hello all,
I noticed that my two Mysql slave servers were running out of sync this 
morning.  After looking into it...it appears that yesterday when I tried 
to change the username of a user on the master server...it caused some 
issues on the slaves.  Here is what I was able to pull from the slave 
error logs:

090108 16:46:05 [ERROR] Slave SQL: Error 'Operation CREATE USER failed 
for 'root'@'127.0.0.1'' on query. Default database: 'mysql'. Query: 
'CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY PASSWORD 
'*3313E27C7AD7F792A60D5D651029375E60'', Error_code: 1396

090108 16:46:05 [Warning] Slave: Operation CREATE USER failed for 
'root'@'127.0.0.1' Error_code: 1396

090108 16:46:05 [ERROR] Error running query, slave SQL thread aborted. 
Fix the problem, and restart the slave SQL thread with "SLAVE START". We 
stopped at log 'master-bin.000008' position 970652826


Can anyone tell me if/how I can remove that statement from the log 
file...so I can restart the slave?

Is there a better way to fix this?

Thanks,

Shain

Thread
long login times?Jed Reynolds6 Jan
  • Re: long login times?Jim Ginn6 Jan
    • Re: long login times?Jed Reynolds6 Jan
      • Mysql Replication out of syncShain Miley9 Jan
  • Re: Mysql Replication out of syncJose Julian Buda9 Jan
    • Re: Mysql Replication out of syncShain Miley9 Jan