MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jose Julian Buda Date:January 9 2009 5:37pm
Subject:Re: Mysql Replication out of sync
View as plain text  
maybe if you put on the slave server :

mysql> STOP SLAVE;
mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
mysql> START SLAVE;

then just to check take a look at this lines :

mysql> show slave status\G;
...
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
...


it will restart the replication, but you have to check then why this happened, just in
case...


  ----- Original Message ----- 
  From: Shain Miley 
  To: mysql@stripped 
  Sent: Friday, January 09, 2009 3:17 PM
  Subject: Mysql Replication out of sync


  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


  -- 
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


  __________ Información de NOD32, revisión 3749 (20090107) __________

  Este mensaje ha sido analizado con  NOD32 antivirus system
  http://www.nod32.com


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