Re: [Openinteract-help] db error at random intervals

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> at seemingly random intervals, I get the Website down/technical
> reasons/database problem page showing up on my site and hundreds of cannot
> connect to db/angry mob of users emails in my mailbox.  The problem seems to
> be corrected temporarily when I stop/start the server.  I've included below
> a message from my error log and below that the datasource section of my
> server.ini.  Can anyone suggest a reason for this or a possible solution? 
> 
> This is OI version 1.56
> 
> OpenInteract::parse_uri (181) >> Original path: (/idex.html)
> OpenInteract::parse_uri (189) >> Items in the path:  idex.html
> OpenInteract::parse_uri (202) >> Action found from URL: idex.html
> OpenInteract::parse_uri (209) >> Original path/query string set to:
> /idex.html
> OpenInteract::Request::lookup_conductor (224) >> Find conductor for action
> (idex.html)
> OpenInteract::Request::lookup_action (253) >> Find action corresponding to
> (idex.html)
> OpenInteract::Request::lookup_action (264) >> Using 'notfound' action
> OpenInteract::Request::lookup_action (274) >> Found action info for
> (idex.html)
> OpenInteract::find_action_handler (232) >> Found OpenInteract::UI::Main //
> handler for conductor
> Found item: HASH

This last line should read:

Found item: DBI::db

And means that somehow we're not getting a database handle back. It 
might be that the handle has timed out and can't be used anymore. 
Are you using Apache::DBI?

In the meantime I'll probably make a change so that when this 
happens we'll expire the Apache child so it doesn't hang around and 
keep answering requests with a stale db handle.

Chris