Hi,
This is similair to a problem i am experciencing using the DBPool and
PostGresQL. Using the pyPgSQL module, i get connections that begin to go
IDLE in SELECT and IDLE in TRANSACTION when viewed via the 'ps' util.
The DBPool seems to be able to recover from this during the course of
normal
On Nov 10, 2003, at 3:45 PM, Frank Barknecht wrote:
Hallo,
Ian Bicking hat gesagt: // Ian Bicking wrote:
FWIW, my understanding is that MySQL connections are quick to make and
you don't gain much from pooling (at least if the server is on the
same
host as the client). So it might not be so bad to
Hallo,
Ian Bicking hat gesagt: // Ian Bicking wrote:
> FWIW, my understanding is that MySQL connections are quick to make and
> you don't gain much from pooling (at least if the server is on the same
> host as the client). So it might not be so bad to avoid pooling
> connections entirely. I k
Hallo,
Aaron Held hat gesagt: // Aaron Held wrote:
> Sorry,
> I had the same problem with pgSQL a little over a year ago. I'm a fan
> of Postgres and have had million row tables, but you will get the same
> connection issue.
So, may I ask: What did you do then? I mean, lots of us need (and use
Hallo,
Ben Parker hat gesagt: // Ben Parker wrote:
> This problem could be a server timeout. mysql has a default 8-hour timeout
> for inactive connections. Do these errors occur after about 8 hours of
> inactivity?
No, I can crash it directly after the start. It's more a problem of
too much activ
On Nov 10, 2003, at 12:48 PM, Thomas E Jenkins wrote:
Postgres definitely does not exhibit this behavior. Since I inherited
a
lot of databases I have a fair mix of both MySQL and Postgres. I
struggled for a long time with MySQL lost connection problems hanging
the app server, however once I swit
On Mon, 2003-11-10 at 15:14, Aaron Held wrote:
> Sorry,
> I had the same problem with pgSQL a little over a year ago. I'm a fan
> of Postgres and have had million row tables, but you will get the same
> connection issue.
I'm guessing it must be harder to expose this error in postgres since I
ha
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Frank
> Barknecht
> Sent: Monday, November 10, 2003 10:53 AM
> To: 'Webware discuss'
> Subject: Re: [Webware-discuss] 'Lost connection to MySQL server during
> query'
>
>
> Hallo,
> Thomas E Jenkins hat ges
Sorry,
I had the same problem with pgSQL a little over a year ago. I'm a fan
of Postgres and have had million row tables, but you will get the same
connection issue.
-Aaron
Frank Barknecht wrote:
Hallo,
Thomas E Jenkins hat gesagt: // Thomas E Jenkins wrote:
On Mon, 2003-11-10 at 05:25, Fr
Hallo,
Thomas E Jenkins hat gesagt: // Thomas E Jenkins wrote:
> Postgres definitely does not exhibit this behavior. Since I inherited a
> lot of databases I have a fair mix of both MySQL and Postgres. I
> struggled for a long time with MySQL lost connection problems hanging
> the app server, ho
On Mon, 2003-11-10 at 13:29, Frank Barknecht wrote:
> Hallo,
> Thomas E Jenkins hat gesagt: // Thomas E Jenkins wrote:
> > The only way I found to prevent these stale connections is to explicitly
> > build a new one for every group of DB operations. That of course throws
> > away any connection po
On Nov 10, 2003, at 12:29 PM, Frank Barknecht wrote:
Well, I'm using SQLObject, so I'm dependent on SQLObject's pooling
(maybe this can be switched off, though, I didn't look). I'm really
considering to switch to Postgresql now, which is possible thanks to
the abstraction provided by SQLObject, but
Hallo,
Thomas E Jenkins hat gesagt: // Thomas E Jenkins wrote:
> On Mon, 2003-11-10 at 05:25, Frank Barknecht wrote:
> > Tried now, but it didn't help. I might have to live with this problem,
> > but then I would need a way to restart the AppServer with a "kill -9
> > allAppServerPIDs" beforehand
On Mon, 2003-11-10 at 05:25, Frank Barknecht wrote:
> Hallo,
> Stephan Diehl hat gesagt: // Stephan Diehl wrote:
>
> > I've seen this as well (I think there was already a discussion a while back
> > about this). I'm using my own object wrapper, so it's safe to say that it has
> > nothing to do w
Hallo,
Stephan Diehl hat gesagt: // Stephan Diehl wrote:
> I've seen this as well (I think there was already a discussion a while back
> about this). I'm using my own object wrapper, so it's safe to say that it has
> nothing to do with SQLObjects or MiddleKit.
> But, I've only see the MySQL erro
15 matches
Mail list logo
