python code just "stops" when attempting and insert

Jem North <[email protected]> Tue, 13 Jan 2015 15:43:00 +0000 (UTC)
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <[email protected]>
I have a sequence of code that iterates over a collection of data, writing 
subsections into different oracle tables.
For some reason, the process is now intermittently locking up when it 
attempts to insert a new record.

pseudo code for the issue is:

try:
  insert into the table with data;
  record the returned id;
except:
  query the table for the matching data;
  record the returned id;

The exception would be thrown if the record already exists, due to Oracle 
unique indices.

Even when running the python code (2.7) via a debug session in eclipse, 
the process will just hang and cannot be interrupted to examine the 
failure, only terminated.

The process has previously worked fine against the original Oracle 12 
database, but this problem seems to have arisen against a cloned VM.


------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet