Re: Start slave fails
Hi Monica,
The error message indicates that a query has failed to successfully execute on the slave. Each time I try to skip over the failing query, it again stops at the next one. Here is an extract from the slave logfile (some data changed to protect the client's interest):
100324 15:19:04 Slave: error running query 'insert into pctEvents values (0,424236254,'TRIGGER',now(),'******','NONE','NONE','0424236254 has just triggered','58',11020751,2000,'0000-00-00 00:00:00',0,'','108960223','MA******T','',2)'
100324 15:19:04 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysqladmin start-slave". We stopped at log 'vfaul139-bin.086' position 325196853
100324 15:19:04 Slave thread exiting, replication stopped in log 'vfaul139-bin.086' at position 325196853
100324 15:19:24 Slave: connected to master 'repl@vfaul139:3306', replication started in log 'vfaul139-bin.086' at position 325196853
ERROR: 1062 Duplicate entry '' for key 2
100324 15:19:24 Slave: error running query 'insert into smss values(0,"61424236254",1,1,"******",5,1,"Congrats! Descriptive sentence",0,0,"NO",0,0,1,0,unix_timestamp(),0,"",0,"$$$$$$")'
100324 15:19:24 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysqladmin start-slave". We stopped at log 'vfaul139-bin.086' position 325197115