Aparently we got the unauthorized connection problem under
control. It seems to us that the exit function override of
Apache::Registry didn't work as expected. In a desperate attempt
did we re-program our scripts to exit-less versions which made
it. Now the connections come and go easily. Anyone experienced
that before?
What makes me scratch my head is the fact that the exit was
placed before the dbi connect call... which leads me to the
conclusion that the exit was simply not executed at all, no
override version or something else. Strange...
No dead connections on the DB we tried Apache::DBI again, btw. .
Guess what? It still doesn't work. Persistance, yes, re-use of
connections, no. The connections were growing and didn't stop
until we HUPed the Apache and disabled Apache::DBI. The sleep
timer in the mysql processlist showed a clear picture of useless
connections. What can that be? Any idea?
Regards,
On Wed, 14 Mar 2001 20:21:15 +0100, Joern Janoschek wrote:
>On Wed, 14 Mar 2001 18:46:31 +0000, Greg Cope wrote:
>
>>There's no reason why Apache::DBI should not work - by the sounds of it
>>the connections strings may have been different ?
>>
>>Apache::DBI works in an environment where on user ID is used to connect
>>to the DB mulitple time. If you use two different connection strings
>>Apache::DBI will try and make both persistent (IIRC).
>>
>>So check your DBI connection strings as they should be indentical.
>
>Here is the problem: The connection strings _are_ the same. No
>change at all between two connects... same host, same user, same
>DB, even the same table (not that it bothers)... nothing
>changes. That's the strange thing and that's what we didn't
>understand at all and what pushed us to the point where we
>disabled Apache::DBI.
>Could it be that there is a connection between the socket
>problem and the ever rising persistent connections? Maybe the
>Apache::DBI cannot share an already connected handle because the
>system says the socket is still in use and not free at all. That
>would explain the unusual behaviour of Apache::DBI...
>Maybe someone who hasn't an explaination could tell me at least
>where to look at? Linux system? Apache? mod_perl? Mysql?
>DBI/DBD?
>
>Thanks anyway,
>
>Jörn Janoschek.
>KLAHOLD - We make IT work! - http://www.klahold.de
>- WebDevelopment - http://www.klahold.de
>- Content-Management-System - http://www.interred.de
>
>
Jörn Janoschek.
KLAHOLD - We make IT work! - http://www.klahold.de
- WebDevelopment - http://www.klahold.de
- Content-Management-System - http://www.interred.de
