The script and specs you provided are not enough to make any reasonable
recommendation. Also you might want to run a trace DBI->trace(2,
"trace.log") on your script and retrive after the freeze up. The file might
get pretty large, but look towards the bottom of trace.log once the script
stops functioning.
Ilya
-----Original Message-----
From: Ken Speich
To: [EMAIL PROTECTED]
Sent: 9/10/01 9:06 AM
Subject: DBI Freezeup?
A little bit a a peculiar situation I am running into...
I have a script that I wrote that runs in an endless while loop. the
structure is basically like this:
ConnectToDB();
while(1) {
do all my stuff in here...
}
The script works fine... except that every once in a while, the database
connection seems to lock up. The script will not die, but instead will
just stop functioning at a point where there was a database action
hapenning via the DBI.
I am using an Oracle DB, version 8.1.6.3.0
My DBI Version is 1.14
My DBD::Oracle version is 1.06
I am working on a Solaris 7 machine.
I am going to get my versions of DBI and DBD upgraded today. I was just
wondering if anyone had seen this problem before, and if anyone knew
what
caused it and what I could do to fix it...
--Kenny
--
Ken Speich Manager, Network Surveillance Tools
[EMAIL PROTECTED] T: (301) 561-2637
[EMAIL PROTECTED] P: (877) 658-2899
"How can you shoot the devil in the back? What if you miss?"
