Re: [Nss-mysql-users] Locking Issues?

[Theo Zourzouvillys]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 27 August 2002 12:30 am, Guillaume Morin wrote:
> So that is normal. The mutexes are in different virtual environments.

yes, i relealised that afterwards, my bad ;)

> I'd say that mysql just can't answer the queries, that is why you see
> this error. A workaround could to ask the caller to try again if the
> query fails for that reason.

the query doesn't fail though, i've tried running a perl script querying the 
database over and over with the same query as nss-mysql is making, and it 
answers correctly every time.  The query that nss-mysql is sending to the 
server is correct.

it's not because the server has reached maximum number of connections, we're 
only averaging about 30% of our max_connections.  MySQL logs aren't showing 
dropped conenctions due to reaching max.

nss-mysql[18687]: _nss_mysql_check_connection: found a saved MYSQL * 
(0x809bc38)
[snip]
nss-mysql[9537]: _nss_mysql_check_connection: found a saved MYSQL * 
(0x809bc38)

nss-mysql is trying to use the same MYSQL * for both queries, at the same 
time... i don't know whether this is because ssh is fork()'ing then sharing 
the conenction * ?

the loosing MySQL connection is exactly what i have got whenever i mess up 
some of my code that tries to make two queries at the same time using the 
same conenction ;)

> I'll try to implement that in the source.
> I'll keep you posted.

I'm still poking around, but without reading all the code from start to 
finish, i'm not sure i'll get far ;)

 ~ Theo

- -- 
Theo Zourzouvillys
 + Operations Manager
 + Associated Networks Limited
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9ar/Q448CrwpTn6YRApmDAKCh0xkwd0aAK7EqT+KySvqAw9QAHwCfXzGF
CUPq5dciwMCj1EQNOYEqMqQ=
=/DcB
-----END PGP SIGNATURE-----