MySQL too many connections.

Hi all,

I'm having an issue with our trac install. We are using the
DbAuth
plugin, and are curious about how DatabaseManager closes
its
connections.

The plugin's main class:
http://trac-hacks.org/browser/dbauthplugin
/0.10/dbauth/auth.py?rev=838

You can see it is calling a CentralDatabaseManager class,
which is
like the DatabaseManager class, perhaps extended. Should
there be some
statements in there to be closing the db connections? I'm
being forced
to restart the mysql server frequently to keep things
limping along
until we figure this out!

I'm not a python guy, so I can't tell where this issue
exists.

Trac 10.4
mysql  Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i486)
using
readline 5.1
Ubuntu Dapper

Thank You,
Chris Hill


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

As to whether or not you should manually be closing cursors
and db
connections, except in certain cases you really shouldn't
have to.
Once the the reference count for the connection object
reaches 0, the
API should close the connection automatically before
deallocating.

So why you're running out of connections I couldn't say
without more details.

On 8/30/07, Chris Hill <ubergeekubergeek.tv> wrote:
>
> Hi all,
>
> I'm having an issue with our trac install. We are using
the DbAuth
> plugin, and are curious about how DatabaseManager
closes its
> connections.
>
> The plugin's main class:
> http://trac-hacks.org/browser/dbauthplugin
/0.10/dbauth/auth.py?rev=838
>
> You can see it is calling a CentralDatabaseManager
class, which is
> like the DatabaseManager class, perhaps extended.
Should there be some
> statements in there to be closing the db connections?
I'm being forced
> to restart the mysql server frequently to keep things
limping along
> until we figure this out!
>
> I'm not a python guy, so I can't tell where this issue
exists.
>
> Trac 10.4
> mysql  Ver 14.12 Distrib 5.0.22, for pc-linux-gnu
(i486) using
> readline 5.1
> Ubuntu Dapper
>
> Thank You,
> Chris Hill
>
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Ah ok! I found that we have been using the same user name
and pass on 
other subsystems in php. Must not be trac, I'll focus my
attention 
elsewhere, thanks!
C

Erik Bray wrote:
> As to whether or not you should manually be closing
cursors and db
> connections, except in certain cases you really
shouldn't have to.
> Once the the reference count for the connection object
reaches 0, the
> API should close the connection automatically before
deallocating.
>
> So why you're running out of connections I couldn't say
without more details.
>
> On 8/30/07, Chris Hill <ubergeekubergeek.tv> wrote:
>   
>> Hi all,
>>
>> I'm having an issue with our trac install. We are
using the DbAuth
>> plugin, and are curious about how DatabaseManager
closes its
>> connections.
>>
>> The plugin's main class:
>> http://trac-hacks.org/browser/dbauthplugin
/0.10/dbauth/auth.py?rev=838
>>
>> You can see it is calling a CentralDatabaseManager
class, which is
>> like the DatabaseManager class, perhaps extended.
Should there be some
>> statements in there to be closing the db
connections? I'm being forced
>> to restart the mysql server frequently to keep
things limping along
>> until we figure this out!
>>
>> I'm not a python guy, so I can't tell where this
issue exists.
>>
>> Trac 10.4
>> mysql  Ver 14.12 Distrib 5.0.22, for pc-linux-gnu
(i486) using
>> readline 5.1
>> Ubuntu Dapper
>>
>> Thank You,
>> Chris Hill
>>
>>
>>     
>
> >   


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---