Chambon writes:
> Hello,
>
> No there's no thread in my application,
> the program use fork but of course a new connection is create after each fork()
>
> Today before running another test I do the following
> - drop then create the tables
> - increase the limit for opened file from 1024 to 4096
>
> I run a test for 2 hours and I got :
> -> Lost connection to MySQL (708)
> -> Can't connect to MySQL server (49) //error while trying new
> connection
> 49 errors in 6 seconds in from 14:07:16 to 14:07:22 (due to a
> burst of fork() )
> -> 'ip_adress' is not allowed to connect to this MySQL Server (4)
> //error while trying new connection
> -> Commands out of sync (6)
>
> But apart of these errors I have made many successful insert (4457) , update
> (11594), select (25017)
> that why I am confused and I don't know what to change !
>
> Best regards
>
> --
> Bernard CHAMBON
> IN2P3 / CNRS (Centre de Calcul de LYON)
> email: mailto:[EMAIL PROTECTED]
> Tel : 04 72 69 42 18
Hi!
This seems like a typical programming error in multi-tasking ...
You must enclose mysql_query/mysql_use/fetch_row commands so that no
two processes can go through it in the same time with the same MYSQL
and MYSQL_RES handles.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ 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
