On Wednesday, August 13, 2003, at 12:32 PM, David Wheeler wrote: The code that's causing the hangup looks like this:
First, we all need to yell at you for not using Apache::DBI. Your code is not doing anything that it doesn't do, and is actually doing less to ensure safety when something crashes. Apache::DBI would issue a rollback if some code crashed part-way through a request.
Yeah, this is some old code. I've been thinking about just using Apache::DBI. Maybe then the problem'll just go away.
At this point, everything hangs, stuck in $dbh->ping.
Does that happen under 1.3.27 too? Is this a nested transaction problem
stemming from the subrequests?
No, it works fine under 1.3.27. There are no subrequests, only secondary requests from the browser (for layers and such).
4166: No handle, connecting. # This shouldn't happen!
That would happen if it failed the ping.
I know, that's why it's so weird!
You can see that this gets really ugly. Anyone seen anything like this,
or have any idea what could be causing these problems?
Try changing your ping method or removing the ping and see if the problem persists.
Not sure I want to go into hacking DBD::Pg's internals at this point...
Thanks for the feedback, Perrin!
David
-- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Kineticode. Setting knowledge in motion.[sm]
