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