Re: mod_perl/dbi/apache query will not finish

-----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-----