Re: python code just "stops" when attempting and insert

Hi,

2015-01-13 16:43 GMT+01:00 Jem North <[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.
>

If another session has already inserted a row with same primary unique key,
but did not commit, then the RDBMS waits until the other commits or roll
back.

Something like this: https://community.oracle.com/thread/924623



> 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
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>



-- 
Amaury Forgeot d'Arc

------------------------------------------------------------------------------
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

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users