MySQL 3.23 Lost Connection
Adam, Tuesday, March 05, 2002, 10:14:28 PM, you wrote: A I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel A 2.4.17, and glibc 2.1. A Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and A headed the warnings and downgraded to 2.95. A Randomly I get the Lost Connection using PHP 4.1.2... Any idea why? Connection lost error occurs when communication bug or bug in the client take place. You can find description of error, if you check the following links. Probably they will help you: http://www.mysql.com/doc/G/o/Gone_away.html http://www.mysql.com/doc/P/a/Packet_too_large.html A Adam -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: MySQL 3.23 Lost Connection
Yes thank you for these links. I have already read the documentation as the first thing I did. The second thing I did was recompile. The third thing I did was subscribe to the list. I can write a php script like this: ? $o=mysql_connect(localhost,root,xxx); mysql_select_db(db,$o); for ($x=0;$x100;$x++) { $row=mysql_query(select firstName from users limit 1); if (!row) echo Failed; } mysql_close($o); ? I will run this. A lot of the time I wont get anything to the screen. Other times I will get a bunch of Failed. Completely Random. Oh, users has 17 rows in it. Machine is a dual p3-500 with 1gb RAM. I've tried recompiling with GCC 2.95, 2.96 and 3.04. I've tried this under GLIBC 2.1.3 and 2.2.5. Running linux kernel 2.4.17. Tried default startup, and my own options that works well on another production server of a similar configuration. Apache/PHP and Qmail work flawlessly on this machine. Thanks for everyones help on this matter! -adam -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: MySQL 3.23 Lost Connection Adam, Tuesday, March 05, 2002, 10:14:28 PM, you wrote: A I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel A 2.4.17, and glibc 2.1. A Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and A headed the warnings and downgraded to 2.95. A Randomly I get the Lost Connection using PHP 4.1.2... Any idea why? Connection lost error occurs when communication bug or bug in the client take place. You can find description of error, if you check the following links. Probably they will help you: http://www.mysql.com/doc/G/o/Gone_away.html http://www.mysql.com/doc/P/a/Packet_too_large.html A Adam -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
MySQL 3.23 Lost Connection
Hello. I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel 2.4.17, and glibc 2.1. Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and headed the warnings and downgraded to 2.95. Randomly I get the Lost Connection using PHP 4.1.2... Any idea why? Thanks Adam - 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
MySQL 3.23 Lost Connection
Hello. I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel 2.4.17, and glibc 2.1. Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and headed the warnings and downgraded to 2.95. Randomly I get the Lost Connection using PHP 4.1.2... Any idea why? Thanks Adam - 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: MySQL 3.23 Lost Connection
Happens randomly among all my scripts. Mysql is being started with: /usr/sbin/mysqld --basedir=/ --datadir=/usr/local/lib/mysql --user=mysql --pid-file=/usr/local/lib/mysql/mysqld.pid --skip-locking -O max_connect_errors=1 -O back_log=30 -O max_connections=580 -O table_cache=512 -O Machine has a gig of ram. Very little traffic. adam -Original Message- From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 3:52 PM To: Adam Helfgott Subject: Re: MySQL 3.23 Lost Connection Hi, Perhaps a mysql thread which runs out of memory ? Regards, Jocelyn Fournier - Original Message - From: Adam Helfgott [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 9:32 PM Subject: MySQL 3.23 Lost Connection Hello. I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel 2.4.17, and glibc 2.1. Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and headed the warnings and downgraded to 2.95. Randomly I get the Lost Connection using PHP 4.1.2... Any idea why? Thanks Adam - 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