On 12 January 2011 09:02, Duncan Garland <[email protected]>wrote:
> 0x0000003bbe20d8e0 in __read_nocancel () from /lib64/libpthread.so.0 > (gdb) (gdb) #0 0x0000003bbe20d8e0 in __read_nocancel () from > /lib64/libpthread.so.0 > No symbol table info available. > #1 0x00002ac7089512a2 in snttread () from > /oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 > #14 0x00002ac70861bb27 in OCIStmtExecute () from > /oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 > #15 0x00002ac70803adc9 in ora_describe (h=0x108af110, imp_sth=0x15fdfa10) > at oci8.c:1997 > my_perl = <value optimized out> > imp_dbh = 0x15594520 > long_readlen = 6553500 > num_fields = <value optimized out> > num_errors = <value optimized out> > has_longs = <value optimized out> > est_width = <value optimized out> > nested_cursors = <value optimized out> > i = <value optimized out> > status = <value optimized out> > When you execute an Oracle statement OCIStmtExecute () it gets stuck in __read_nocancel (). Looks like it's either blocked waiting on an uncommitted session elsewhere or you've hit an Oracle bug. Use the Oracle tools to see what other queries are hanging around when it happens. See if there are reports of deadlocks or anything in the db error log. You can also check out http://www.google.co.uk/search?ie=UTF-8&q=libclntsh.so+__read_nocancel<http://www.google.co.uk/search?sourceid=chrome&ie=UTF-8&q=libclntsh.so+__read_nocancel> https://savannah.cern.ch/support/?106453 https://savannah.cern.ch/bugs/?47435 etc. This kind of weirdness is one of the reasons I'm not an Oracle lover :-~ Regards, Peter http://perl.dragonstaff.co.uk
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
