Hallo,
Aaron Held hat gesagt: // Aaron Held wrote:
> 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.
Late answer, but this week the shop I developed finally went (or had
to go, x-
On Wednesday 12 November 2003 05:04 pm, Warren Smith wrote:
> Jacob Hanson said:
> > It seems like dbPool ought to be able to trap an error like this
> > gracefully and seamlessly open new, replacement connections without
> > notice. At least that's what I would expect it to do. Maybe it still
> >
Jacob Hanson said:
> It seems like dbPool ought to be able to trap an error like this
> gracefully and seamlessly open new, replacement connections without
> notice. At least that's what I would expect it to do. Maybe it still
> needs a bit of work?
I think it does. I needed a database connection
Tuesday, November 11, 2003, 8:56:19 AM, you wrote:
> Actually you are correct,
> I thought about this last night and remembered that the app in question
> was losing its connection to the database due to the firewall
> configuration. It was fixed by convincing the sysadmin that his
> firewall ne
On Nov 11, 2003, at 9:54 AM, Aaron Held wrote:
Here is my ugly work-around:
I had a midnight script that would import shut down webware, start up
another instance of webware that would put up a 'System undergoing
update, back in xxxminutes',
then it would drop the indexes, import 250k records, d
Actually you are correct,
I thought about this last night and remembered that the app in question
was losing its connection to the database due to the firewall
configuration. It was fixed by convincing the sysadmin that his
firewall needs to let idle connections from the webserver to the db
se
Here is my ugly work-around:
I had a midnight script that would import shut down webware, start up
another instance of webware that would put up a 'System undergoing
update, back in xxxminutes',
then it would drop the indexes, import 250k records, delete 250k
records, rebuild indexes and vaccum
On Nov 10, 2003, at 2:35 PM, 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 know this isn't
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
> que
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
Hallo,
I have a problem with my Webware/SQLObject application again. :(
It's a webshop running Webware and using SQLObject. If I click like a
mad scientist on Mozilla's Reload-button I am able to crash the
Webware server. The error I get is:
...
File "/usr/lib/python2.2/site-packages/SQLObject
24 matches
Mail list logo
