-----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

Reply via email to