Re: mod_perl/dbi/apache query will not finish

Поиск
Список
Период
Сортировка
От Keith Keller
Тема Re: mod_perl/dbi/apache query will not finish
Дата
Msg-id 20030115063114.GA11048@wombat.san-francisco.ca.us
обсуждение исходный текст
Ответ на mod_perl/dbi/apache query will not finish  ("Jason S. Friedman" <jason@powerpull.net>)
Список 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 по дате отправления:

Предыдущее
От: "Jason S. Friedman"
Дата:
Сообщение: mod_perl/dbi/apache (...I should have mentioned)
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Upgrading to RH8.0 causes: "An old version of the