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
Heikki Tuuri wrote:
> Hi!
>
> Then it looks like a problem in the communication or in your client test
> program.
>
> The following error
>
> > Commands out of sync; You can't run this command now (85 occurences)
>
> means that you have issued C API commands to a single MySQL connection in a
> wrong order.
>
> If your application has several client threads, are you sure you create one
> connection to each thread, and issue the C API commands in the right order?
>
> Sometimes people try to use a single connection for several client threads,
> and get the error above.
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
>
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
email: mailto:[EMAIL PROTECTED]
Tel : 04 72 69 42 18
---------------------------------------------------------------------
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
