[Openinteract-help] db error at random intervals

[Chris M. <Chr...@te...>]

 
Hello,

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
OpenInteract::Error::Main::catch (25) >> Action where the error was thrown
from: <<n/a>>
OpenInteract::Error::Main::catch (35) >> See if class
<<OpenInteract::Error::System>> will take error
>> Error: Cannot connect to db. Info:
$VAR1 = undef;
 
OpenInteract::Error::System::cannot_connect_db('commerce::ErrorObject=HASH(0
x131b870)') called at
/var/www/localperl/lib/site_perl/5.6.1/OpenInteract/Error/Main.pm line 38
        OpenInteract::Error::Main::catch('OpenInteract::Error::Main',
'commerce::ErrorObject=HASH(0x131b870)') called at (eval 444) line 39
        commerce::ErrorObject::throw('commerce::ErrorObject',
'HASH(0x13135dc)') called at
/var/www/localperl/lib/site_perl/5.6.1/OpenInteract/Error.pm line 94
        OpenInteract::Error::throw('OpenInteract::Error', 'HASH(0x13135dc)')
called at /var/www/localperl/lib/site_perl/5.6.1/OpenInteract/Request.pm
line 123
        OpenInteract::Request::throw('OpenInteract::Request=HASH(0xcfcf50)',
'HASH(0x13135dc)') called at
/var/www/localperl/lib/site_perl/5.6.1/OpenInteract.pm line 247
        OpenInteract::check_database('OpenInteract',
'OpenInteract::Request=HASH(0xcfcf50)') called at
/var/www/localperl/lib/site_perl/5.6.1/OpenInteract.pm line 49
        eval {...} called at
/var/www/localperl/lib/site_perl/5.6.1/OpenInteract.pm line 44
        OpenInteract::handler('OpenInteract', 'Apache=SCALAR(0x1094a14)')
called at /dev/null line 0
        eval {...} called at /dev/null line 0
etc...


[db_info main]
db_owner      =
username      = xxxxxx
password      = xxxxxx
dsn           = database=commerceDB
db_name       =
driver_name   = mysql
sql_install   =
long_read_len = 65536
long_trunc_ok = 0

[db_info sbs]
db_owner      =
username      = xxxxxx
password      = xxxxxx
dsn           = SBS
db_name       =
driver_name   = ODBC
sql_install   =
long_read_len = 65536
long_trunc_ok = 0

[db_info uc]
db_owner      =
username      = xxxxxx
password      = xxxxxx
dsn           = database=UC_Contact
db_name       =
driver_name   = mysql
sql_install   =
long_read_len = 65536
long_trunc_ok = 0

Thanks,

Chris McDaniel