Hi,
I have a script which runs in non-stop in the background on a HPUX system.
It checks various table in my database and updates some rows when needed. It
connects to the database (Oracle 8.1.7.2.0) once at startup and then execute
a never ending loop with the update statements, sleep(15) and loop..
So far so good. However, we've noticed that somehow tables remain locked due
to this script running non-stop. We did NOT have this problem when the
script was run every minute from a crontab. Thats not desirable due to slow
connects.
Does anyone have experience with using DBD:Oracle in a never-exiting
process/script ? It appears to be a cleanup problem of some sort but I'm at
a loss as to WHERE the problem is located. I finish and undef every
statement-handler I use, most of which are "my" into a sub-routine and thus
destroy on returns anyway.
Locks and problems in the database DO dissappear when we stop and re-start
the script so it's definitly related to it.
Suggestions ???
-----------------------------------
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support
"If at first you don't succeed, skydiving isn't for you"
