Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Perrin Harkins
On Mon, 2003-11-24 at 16:17, Jordan Lederman wrote: > The only thing that sticks in my mind about this is > that I'm never explicitly releasing the connections. Won't I run out or > waste/leak memory over time? If you always use the same connection info, you should have one connection per proces

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Jordan Lederman
On Monday 24 November 2003 04:13 pm, Perrin Harkins wrote: > On Mon, 2003-11-24 at 15:57, Jordan Lederman wrote: > > The my $dbh line above is located at the beginning of the file. When I > > copy it to the beginning of the sub all is fixed! > > Apache::DBI tries to help you by not keeping persiste

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Perrin Harkins
On Mon, 2003-11-24 at 15:57, Jordan Lederman wrote: > The my $dbh line above is located at the beginning of the file. When I copy it > to the beginning of the sub all is fixed! Apache::DBI tries to help you by not keeping persistent copies of database handles that you open during startup. In thi

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Jordan Lederman
On Monday 24 November 2003 03:49 pm, Perrin Harkins wrote: > On Mon, 2003-11-24 at 15:35, Jordan Lederman wrote: > > > You just have to look at the code you run from httpd.conf and > > > startup.pl to see if it opens any connections. The code you posted > > > looks fine, but what's in Q2::Init? >

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Perrin Harkins
On Mon, 2003-11-24 at 15:35, Jordan Lederman wrote: > > You just have to look at the code you run from httpd.conf and startup.pl > > to see if it opens any connections. The code you posted looks fine, but > > what's in Q2::Init? > > 25 $Apache::DBI::DEBUG = 2; > 26 > 27 my $dbh = D

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Jordan Lederman
On Monday 24 November 2003 03:35 pm, Perrin Harkins wrote: > On Mon, 2003-11-24 at 15:11, Jordan Lederman wrote: > > Honestly I don't yet know enough to tell you. > > You just have to look at the code you run from httpd.conf and startup.pl > to see if it opens any connections. The code you posted

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Perrin Harkins
On Mon, 2003-11-24 at 15:11, Jordan Lederman wrote: > Honestly I don't yet know enough to tell you. You just have to look at the code you run from httpd.conf and startup.pl to see if it opens any connections. The code you posted looks fine, but what's in Q2::Init? > If nothing useful is found he

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Jordan Lederman
On Monday 24 November 2003 03:05 pm, Perrin Harkins wrote: > On Mon, 2003-11-24 at 14:54, Jordan Lederman wrote: > > Well I've upgraded apache and mod_perl to 1.29 and I'm still having the > > same issue. > > Are you opening database connections during server startup? That could > cause this, if y

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Perrin Harkins
On Mon, 2003-11-24 at 14:54, Jordan Lederman wrote: > Well I've upgraded apache and mod_perl to 1.29 and I'm still having the same > issue. Are you opening database connections during server startup? That could cause this, if you have a connection open when the server forks. If that's not it, y

Re: mod_perl + DBI + TT2 giving odd results

2003-11-24 Thread Jordan Lederman
On Friday 21 November 2003 08:15 pm, Perrin Harkins wrote: > On Fri, 2003-11-21 at 19:13, Jordan Lederman wrote: > > The page located at http://perl.apache.org/docs/1.0/guide/ > > debug.html#Handling_the__User_pressed_Stop_button__case > > says that things can be more complex with mod_perl can

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Perrin Harkins
On Fri, 2003-11-21 at 19:13, Jordan Lederman wrote: > The page located at http://perl.apache.org/docs/1.0/guide/ > debug.html#Handling_the__User_pressed_Stop_button__case > says that things can be more complex with mod_perl can you shed any light > on that for me? It simply means that filehan

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Jordan Lederman
On Friday 21 November 2003 06:58 pm, Perrin Harkins wrote: > On Fri, 2003-11-21 at 18:25, Jordan Lederman wrote: > > Just read it -- and I'm trying to digest it all. > > I actually don't think it applies to your problem. You're not supposed > to get that error anymore from users pressing stop, as

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Perrin Harkins
On Fri, 2003-11-21 at 18:25, Jordan Lederman wrote: > Just read it -- and I'm trying to digest it all. I actually don't think it applies to your problem. You're not supposed to get that error anymore from users pressing stop, as I understand it. Are you using the latest mod_perl? > Also, do I n

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Jordan Lederman
On Friday 21 November 2003 02:28 pm, Ged Haywood wrote: > Hi there, > > On Fri, 21 Nov 2003, Jordan Lederman wrote: > > if I hit reload quickly ... > > (32)Broken pipe: client stopped connection... > > what 'feels' like is happening is that... > > When i hit reload before the queries are done... >

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Perrin Harkins
On Fri, 2003-11-21 at 17:26, Jordan Lederman wrote: > I'll try that shortly. Are there any details available on what the problem > with postgres are/were? http://www.gossamer-threads.com/perl/mailarc/gforum.cgi?post=75733;search_string=0x49; I gather it involves problems with leaking file descri

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Jordan Lederman
I'll try that shortly. Are there any details available on what the problem with postgres are/were? --jordan On Friday 21 November 2003 02:06 pm, Perrin Harkins wrote: > On Fri, 2003-11-21 at 13:26, Jordan Lederman wrote: > > The project is an web-based groupware email syste

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Ged Haywood
Hi there, On Fri, 21 Nov 2003, Jordan Lederman wrote: > if I hit reload quickly ... > (32)Broken pipe: client stopped connection... > what 'feels' like is happening is that... > When i hit reload before the queries are done... > often the value of $page_links{numtotal} is 'someguy' > which is a v

Re: mod_perl + DBI + TT2 giving odd results

2003-11-21 Thread Perrin Harkins
On Fri, 2003-11-21 at 13:26, Jordan Lederman wrote: > The project is an web-based groupware email system which runs as > a mod_perl module on apache 1.3.28. Please try upgrading to 1.3.29. There are known problems with Postgres and apache 1.3.28. - Perrin -- Reporting bugs: http://perl.apache