Re: mod_perl/dbi/apache query will not finish - Mailing list pgsql-novice

From Keith Keller
Subject Re: mod_perl/dbi/apache query will not finish
Date
Msg-id 20030115063114.GA11048@wombat.san-francisco.ca.us
Whole thread Raw
In response to mod_perl/dbi/apache query will not finish  ("Jason S. Friedman" <jason@powerpull.net>)
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, Jan 15, 2003 at 05:13:32AM +0000, Jason S. Friedman wrote:
> I send a query to the Postgres backend using a mod_perl script and DBI.
> I watch the trace log, it looks something like this:
> [snips]
> And that's it.  I can see that it wants to return 76 rows, but it stops at row28.  Sometimes, several minutes later,
itdoes return the remaining rows, but by then the browser has given up. 

What happens when you run the script from the commandline, or
in a CGI-but-not-mod_perl environment?  In particular, if running
the script from a command prompt exhibits the same behaviour,
I'd suspect some code that you're using that's changed in
DBI versions.  (That's probably a good place to start, since
you mentioned that the queries run fine from psql.)

- --keith

- --
kkeller@speakeasy.net
public key:  http://wombat.san-francisco.ca.us/kkeller/kkeller.asc
alt.os.linux.slackware FAQ:  http://wombat.san-francisco.ca.us/cgi-bin/fom
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAj4lAC8ACgkQhVcNCxZ5ID8ijACdF4Pj4QGr6Xxr9+N/uGVV7Sbb
xcQAnRrfJySCPo8A7sjAonQNh72db0JK
=FPVE
-----END PGP SIGNATURE-----

pgsql-novice by date:

Previous
From: "Jason S. Friedman"
Date:
Subject: mod_perl/dbi/apache (...I should have mentioned)
Next
From: Oliver Elphick
Date:
Subject: Re: Upgrading to RH8.0 causes: "An old version of the