-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 hi,
any ideas what could be causing this? this happens when apache has reached its max_client limit. using 3.23.45 011127 18:16:30 InnoDB: Started /home/attila/mysql-max-3.23.45-pc-linux-gnu-i686/bin/mysqld: ready for connecti 011127 18:35:45 read_const: Got error 146 when reading table ./h2_2/users 011127 18:35:48 read_const: Got error 146 when reading table ./h2_23/users InnoDB: Warning: a long semaphore wait: - --Thread 12976157 has waited at btr0cur.c line 348 for 127.00 seconds the semap X-lock on RW-latch at 50adcbb8 created in file buf0buf.c line 348 a writer (thread id 12976157) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file ../include/btr0btr.ic line 28 Last time write locked in file btr0pcur.c line 228 InnoDB: Warning: a long semaphore wait: - --Thread 13377598 has waited at ../include/btr0btr.ic line 28 for 121.00 second S-lock on RW-latch at 50adcbb8 created in file buf0buf.c line 348 a writer (thread id 12976157) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file ../include/btr0btr.ic line 28 Last time write locked in file btr0pcur.c line 228 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: thanks, Attila ........................................................................... There are many kinds of people in the world. Are you one of them? - --- Public key: http://civ.hu/attila.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8A9NADeyfLhmXxQwRAsXdAJ9ZH4It71cQTM1RAOekt4Yo4LC5NgCeOOce /0MvcStxUa459lRpNWLQvfg= =HEaZ -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php