Re: DBI TimeOuts

This doesn't deal with your main question, but your if-block could be rewritten a little more cleanly as:

if ( $@ ) {
    ++$ConnectAttempts;
    print "", ( $@ =~ /DB CONN FAIL/ )
                 ? "CONNECT TIMED OUT\n"
                 : "SOME OTHER CONNECTION PROBLEM\n";
}
else {
    print "CONNECT IS GOOD\n";
}
[download]

Update: fixed print statement.

Comment on Re: DBI TimeOuts Download Code

Replies are listed 'Best First'.
Re^2: DBI TimeOuts by daveime (Novice) on Jun 25, 2004 at 18:11 UTC
Further to my original post, I've been logging the die statements ... I've seen occasionally that the cleanup fails with this error ... (in cleanup) dbih_getcom handle DBI::db=HASH(0x8388b30) is not a DBI handle (has no magic) My concern is that this cleanup failure may be wasting resources / memory etc., and eventually kill the server. Anyone have any views ? BTW, thanks for the if-block rewrite kesterkester.	[reply]

Replies are listed 'Best First'.

Re^2: DBI TimeOuts
by daveime (Novice) on Jun 25, 2004 at 18:11 UTC

Further to my original post, I've been logging the die statements ... I've seen occasionally that the cleanup fails with this error ... (in cleanup) dbih_getcom handle DBI::db=HASH(0x8388b30) is not a DBI handle (has no magic) My concern is that this cleanup failure may be wasting resources / memory etc., and eventually kill the server. Anyone have any views ? BTW, thanks for the if-block rewrite kesterkester.

[reply]