Hi, I have a problem with one machine running Debian kernels 2.4.7 (2.4.9) on Intel EtherExperssPro100 and mysql-3.23.39. When I try to upload data into database, I get the error in %Subj%. The command used is: bioadmin@caribou$ cat apernix.contig.sql | mysql --host=pednew ApernixK1 ERROR 2006 at line 30: MySQL server has gone away bioadmin@caribou$ ls -la apernix.contig.sql -rw-r--r-- 1 bioadmin users 1670573 Aug 21 13:13 apernix.contig.sql bioadmin@caribou$ >From the size of file imported it's clean, that we shouldn't exceed 16MB limit of mysql. (Yes, I have set max_allowed_packet=16M in my.conf). As far as I understand we can't set max_allowed_packet to higher value. Anyway, in this case the file has 1.6MB, so it should fit into 16MB. When I upgraded on this EtherExperssPro100 machine mysql to 3.23.41, the mysql client gives me again back the 200^ error, BUT in mysqld-logfile is not anymore the error message pointing to max_allowed_packet! Even worse, no new lines appended relating to this test case. ------------------- In real, we have another machine running Redhat with 2.2.19 kernel, same mysql version, same config file and 3Com905B. And, the shell command above successfully imports the 1.6MB file into database. From reading Changelog at mysql.com I see that to avoid some network problems net_buffer_length is being kept small. Does it mean that broken packets do enter mysql? I thought they get assembled at the TCP/IP layer. Although, I read that net_buffer_length should be smaller than max_allowed_packet, i.e. under 16MB, right? On the machine with 3Com card I have successfully tested even max_allowed_packet=96M with no problems. Although I'm trying to believe it could be a kernel-network problem, it might mysql. Does anyone have some suggestions? TIA -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs <[EMAIL PROTECTED]> Faculty of Science, The Charles University --------------------------------------------------------------------- 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
