On Thursday 20 February 2003 22:32, Jeff Kilbride wrote:
> Hi Guilhem,
>
> Ok, good. At least this is a confirmed bug and not something on my end. :)
Yes, you are not crazy and that's good news.
> Hopefully, this will be considered a "critical" problem and fixed in 3.23,
> since it makes all the replicate_* config commands useless.
Yes, if someone uses LOAD DATA INFILE. There are very good chances that this
bugfix will go in 3.23. But I cannot state it because I'm not alone in the
decision process.
> Was this
> introduced recently?
No, I have checked this and the bug is there since year 2000.
> Can I downgrade to an older 3.23.x to get rid of this
> problem?
Unfortunately not. But as you're using Redhat, you can quickly compile our
source on your slave : pick the source distribution on www.mysql.com and
patch it with the patch I sent you, and you'll immediately have a not-bugged
slave. On a standard Linux box, this could all be done in 1 or 2 hours.
Otherwise you have to wait for the next 3.23.56 (and I don't know when it
will be released).
> ----- Original Message -----
> From: "Guilhem Bichot" <[EMAIL PROTECTED]>
> To: "Jeff Kilbride" <[EMAIL PROTECTED]>
> Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, February 20, 2003 1:06 PM
> Subject: Re: BUG? 3.23.55 not replicating LOAD DATA INFILE
>
> > Hi
> >
> > Thanks for your bug report.
> > In latest 3.23 and 4.0, the slave ignores any LOAD DATA INFILE
> > as long as one of these options is set on the slave :
> >
> > replicate_do_table
> > replicate_wild_do_table
> > replicate_ignore_table
> > replicate_wild_ignore_table
> >
> > regardless of the values of these options, which is a bug.
> > This bug will be fixed in the next 4.0 release and probably in the next
> > 3.23 release (in version 3.23 we currently fix only really critical bugs,
>
> but
>
> > as this bug is very simple to fix, it may get fixed too).
> >
> > If you're using a source distribution, here is a patch for 3.23,
> > for the sql/slave.cc file :
> >
> > ===== slave.cc 1.133 vs edited =====
> > *** /tmp/slave.cc-1.133-4477 Sat Jan 18 22:38:53 2003
> > --- edited/slave.cc Thu Feb 20 22:01:17 2003
> > ***************
> > *** 1091,1096 ****
> > --- 1091,1097 ----
> > tables.db = thd->db;
> > tables.alias= tables.real_name= (char*)lev->table_name;
> > tables.lock_type = TL_WRITE;
> > + tables.updating= 1;
> > // the table will be opened in mysql_load
> > if(table_rules_on && !tables_ok(thd, &tables))
> > {
> >
> > Regards,
> > Guilhem
--
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mgbi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Guilhem Bichot <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Software Developer
/_/ /_/\_, /___/\___\_\___/ Bordeaux, France
<___/ www.mysql.com +33 5 56 88 34 39
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
