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 --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -----Original Message----- From: Bernard Chambon <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, January 08, 2002 11:16 AM Subject: Re: Lost connection, C API >Heikki Tuuri wrote: >> >> Hi! >> >> Are you running mysqld under the safe_mysqld script, which automatically >> restarts mysqld after a crash? >> >Yes, mysqld started with safe_mysqld script > >> If yes, look at the 'hostname'.err file and send its contents to me. > >Nothing happens in the hostname.err >(I started mysqld this morning at 11:45) > >020107 11:45:08 mysqld started >020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than >1024 >020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 >020107 11:45:10 InnoDB: Started >/opt/mysql/libexec/mysqld: ready for connections > > >With ps ..., I confirm that mysqld processes have NOT restarted >(running since 11:45) > >> >> Or, if you run mysqld from the command prompt, capture what mysqld prints to >> the command prompt window. >> >> If mysqld does not crash, then the problem is probably some client/server >> issue. >> >> Regards, >> >> Heikki > >Has we got a network error yesterday, >I have run another test this night with the following modifications : > >max_connect_errors=65535 >skip-host-cache > >connection to 'localhost' (the client and the serveur run on the same machine) > > >I have got errors like : > MySQL server has gone away (12 occurences) > Commands out of sync; You can't run this command now (85 occurences) > Lost connection to MySQL server during query (only one occurence) > > The transaction overload is about : > 200848 Insert > 486205 Update > 334945 Select > for 8 hours > > >Before restarting the 2nd test I restart mysqld (yesterday at 22:28) >so here is the hotname.err > >--------------------------------------------------- >020107 11:45:08 mysqld started >020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 >020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 >020107 11:45:10 InnoDB: Started >/opt/mysql/libexec/mysqld: ready for connections >020107 22:27:45 /opt/mysql/libexec/mysqld: Normal shutdown > >020107 22:27:45 InnoDB: Starting shutdown... >020107 22:27:58 InnoDB: Shutdown completed >020107 22:27:58 /opt/mysql/libexec/mysqld: Shutdown Complete > >020107 22:27:58 mysqld ended > >020107 22:28:25 mysqld started >020107 22:28:26 Warning: setrlimit couldn't increase number of open files to more than 1024 >020107 22:28:26 Warning: Changed limits: max_connections: 512 table_cache: 251 >020107 22:28:27 InnoDB: Started >/opt/mysql/libexec/mysqld: ready for connections > >Status information: > >Current dir: /opt/mysql/var/ >Current locks: >lock: 83f3ed0: > >lock: 8396308: > >lock: 8395a28: > >lock: 838cfa0: > >lock: 8390c00: > >lock: 838cf00: > >lock: 838ce60: > >lock: 838c588: > >lock: 837e8b8: > >lock: 837ee28: > >lock: 837ed90: > >lock: 83746e0: > >key_cache status: >blocks used: 0 >not flushed: 0 >w_requests: 0 >writes: 0 >r_requests: 0 >reads: 0 > >handler status: >read_key: 5704 >read_next: 1706 >read_rnd 47 >read_first: 394 >write: 1447 >delete 0 >update: 465 > >Table status: >Opened tables: 26 >Open tables: 20 >Open files: 2 >Open streams: 0 > >-- >Bernard CHAMBON >IN2P3 / CNRS (Centre de Calcul de LYON) >Tél : 04 72 69 42 18 >http://www.in2p3.fr/CC --------------------------------------------------------------------- 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
