Perrin Harkins <[EMAIL PROTECTED]> wrote:
> Tyler MacDonald wrote:
> >[Fri Jan 13 23:46:28 2006] [error] [client 192.168.99.112] DBD::Pg::db
> >prepare_cached failed
>
> Do you only have the problem with prepare_cached? Can you replicate it
> in a small script that just connects and does the prepare_cached if you
> restart the database?
Thanks.... after looking over the messages in the (rather large)
thread this has spawned over the weekend, I played around a little bit, and
found I had a package that was cacheing it's database handle in a global. I
ended up writing a InitHandler that runs once per request that throws away
*that* cached copy ($DBH = undef), so that Apache::DBI can do it's job
properly.
Even with this change, I still have to hit reload a few times for
the handle to reconnect, but at least it actually does recover eventually...
before I could hit reload 1,000 times with no change. :)
Thanks,
Tyler
