4 messages in com.mysql.lists.bugsRe: Replication problem
FromSent OnAttachments
Kevin Roberts17 Aug 2001 13:41 
Sasha Pachev18 Aug 2001 12:48 
Kevin Roberts18 Aug 2001 13:54 
Sasha Pachev20 Aug 2001 09:05 
Subject:Re: Replication problem
From:Kevin Roberts (kev@robertsesq.com)
Date:08/18/2001 01:54:28 PM
List:com.mysql.lists.bugs

----- Original Message ----- From: "Sasha Pachev" <sas@mysql.com> To: "Kevin Roberts" <kev@robertsesq.com>; <bu@lists.mysql.com> Sent: Saturday, August 18, 2001 12:48 PM Subject: Re: Replication problem

On Friday 17 August 2001 14:42, Kevin Roberts wrote:

Does any know how to fix this database replication problem.

Last Lines from Err File

010815 21:38:55 Slave thread exiting, replication stopped in log 'salem-bin.013' at position 6867

010815 21:38:55 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysqladmin start-slave". We stopped at log 'salem-bin.013' position 6867

010815 21:38:55 Slave: error running query 'UPDATE themes SET textcolor='#00000a' WHERE theme_id = 2 AND theme_name = 'Ocean' AND bgcolor = '#FFFFFF' AND textcolor = '#000000' AND color1 = '#CCCCCC' AND color2 = '#9BB6DA' AND table_bgcolor = '#000000' AND header_image = 'images/toxicmold1.gif' AND newtopic_image = 'images/new topic.gif' AND reply_image = 'images/reply.gif' AND linkcolor = '#011001' AND

vlinkcolor

=

'#2100cc' AND theme_default = 0 AND fontface = 'sans-serif' AND

fontsize1

=

'1' AND fontsize2 = '2' AND fontsize3 = '-2' AND fontsize4 = '+1' AND tablewidth = '95%' AND replylocked_image = 'images/reply_locked-dark.jpg''

ERROR: 1146 Table 'mold_db.themes' doesn't exist

.013' at position 6867

The fix is to have the table mold_db.themes on the slave. Your set of tables in the original snapshot and your replication exclusion rules are not consistent.

However, what you have reported is not a repeatable bug (actually, not even a bug at all) and belongs to mys@lists.mysql.com ( or supp@mysql.com if you have purchased a support contract). See guidelines for posting to bugs@ list at http://www.mysql.com/doc/B/u/Bug_reports.html

-- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <sas@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/

Replication does not work from Linux BD to NT DB as the above error is very repeatable. It work for 1 or 2 replications, then it comes up with a error like above. So it look like a bug to me

Kevin