I'm surprised that there hasn't been any reply to this posting. I've
continued to put up with the error 2003 but after several hours I get error
2013 - "Lost connection to MySQL server during query". May I note that the
code works 100% when using local UNIX socket. It's only when using TCP/IIP
that the problem occurs.
Aidan
----- Original Message -----
From: "Aidan" <[EMAIL PROTECTED]>
To: "Mqsl Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 12:38 PM
Subject: 2003 Connection error
> I have coded my own client that uses mysql_real_connect(). The client code
> runs on another machine and there can be up to 120 clients connecting to
the
> database. Each client connects and then disconnects sucessfully for
anything
> up to 5 minutes before the clients start to receive 2003 host connection
> errors. The machine that runs the clients uses SuSE 7.1 (with the latest
> Mysql client patches from the SuSE site). The server machine runs SuSE 7.0
> and the version of Mysql is Ver 11.15 Distrib 3.23.39.
> To solve the problem I make the clients loop round the
mysql_real_connect()
> call until the 2003 error goes away, but this is a waste of resources.
> Does the client throw this kind of error when the server is overloaded or
is
> there a TCP/IP issue that needs fixing with Mysql or my Linux distributon?
>
> Aidan
>
>
> ---------------------------------------------------------------------
> 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
