"Vinod Panicker" <[EMAIL PROTECTED]> wrote: > > "Vinod Panicker" <[EMAIL PROTECTED]> wrote: > >> Also, the slave stopped due to an error of a duplicate key! Why >> should it have a problem with inserting data that went through fine on the > master? > > Could you describe your problem more detailed? What is the table type? Did > it happen with HEAP table? What is the failed query? > > --- The slave got an error running an insert into a 4 field table with a > primary key set on a column 'userid'. The slave SQL thread apparently > stopped and the slave IO thread continued running, but the table stopped > getting updated. The table type again was HEAP.
Check data on slave. Does this value really exist? Probably your master server was restarted that was the reason why data in your HEAP tables could be lost on the master, but not on the slave. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
