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;$x<100;$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
