Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Fetching Madness

by grinder (Bishop)
on Mar 06, 2009 at 21:11 UTC ( #748959=note: print w/ replies, xml ) Need Help??


in reply to Fetching Madness

Sounds like a db lock to me. Are you sure there are no new processes that have been introduced into your workflow recently that could be causing contention?

You should log the database activity using Enterprise Manager and pore (paw?) through the results looking for inserts and/or updates that could be occurring at the same time.

If you can't find out yourself what changed (because remember, your program didn't change, its environment did), then ask around in your workplace. It just might be that you run into someone who says that they moved a job back from 8am to 7am because they need to run some reports afterwards that have to be ready at 7:30.

Good luck.

• another intruder with the mooring in the heart of the Perl


Comment on Re: Fetching Madness
Re^2: Fetching Madness
by jlongino (Parson) on Mar 06, 2009 at 21:38 UTC
    That didn't occur to me. I'll have the Oracle sysadmins look into that possibility. The Oracle database in question is our University's Banner system. Its workload changes constantly and is accessed by multiple systems/applications/users. A difficult task.

    So far, most of our debugging has been from the Perl side and through firewall and IPS monitoring tools. Maybe when we get some feedback from the Oracle sysadmins, we'll get more useful info. That's why I'm trying to concentrate on being able to recognize the problem and gracefully terminate the program.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://748959]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (5)
As of 2014-07-26 06:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (175 votes), past polls