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
RE: Can a big transaction cause the error in max_allowed_packet?
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
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? Second, If the answer to the first question is Yes, it can cause the above error? :query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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