Thanks for your rapid reply. :) I'm using MySQL 4.0.5a binary from MySQL AB.
-- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -----Original Message----- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 29, 2002 7:48 PM > To: [EMAIL PROTECTED] > Subject: Re: Can a big transaction cause the error in > max_allowed_packet? > > > Ha-nyung, > > ----- Original Message ----- > From: ""Chung Ha-nyung"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Friday, November 29, 2002 8:25 AM > Subject: Can a big transaction cause the error in max_allowed_packet? > > > > > > My table structure is very simple and does not use big column like > > text nor blub at all. > > But when I load several million rows into master server using > > mysqlimport, on slave I > > got the error like > > > > 021129 13:24:40 Error reading packet from server: log event entry > > exceeded max_allowed_packet; Increase max_allowed_packet on master > > (server_errno=1236) > > 021129 13:24:40 Got fatal error 1236: 'log event entry exceeded > > max_allowed_packet; Increase max_allowed_packet on master' > from master > > when reading data from binary log > > > > I have two questions. > > First, mysqlimport does not commit until the entire data > are imported? > > it uses LOAD DATA INFILE, which does not COMMIT before the > data has been > imported. > > > Second, If the answer to the first question is Yes, it can > cause the > > above error? > > I guess yes. This is the 3rd similar bug report associated > with big imports. > I will forward this to the replication developer of MySQL AB. > > What is your MySQL version? > > > :query > > > > -- > > Chung Ha-nyung <alita@[neowiz.com|kldp.org]> > > Sayclub <http://www.sayclub.com> > > NeoWiz <http://www.neowiz.com> > > Heikki Tuuri > Innobase Oy > --- > InnoDB - transactions, row level locking, and foreign key > support for MySQL > See http://www.innodb.com, download MySQL-Max from > http://www.mysql.com > > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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