[Catalyst] Zeus and Catalyst

Peter Edwards peter at dragonstaff.co.uk
Wed Jan 12 10:55:03 GMT 2011


On 12 January 2011 09:02, Duncan Garland <Duncan.Garland at motortrak.com>wrot=
e:


> 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=3D0x108af110, imp_sth=3D0x15fdf=
a10)
> at oci8.c:1997
>        my_perl =3D <value optimized out>
>        imp_dbh =3D 0x15594520
>        long_readlen =3D 6553500
>        num_fields =3D <value optimized out>
>        num_errors =3D <value optimized out>
>        has_longs =3D <value optimized out>
>        est_width =3D <value optimized out>
>        nested_cursors =3D <value optimized out>
>        i =3D <value optimized out>
>        status =3D <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=3DUTF-8&q=3Dlibclntsh.so+__read_nocancel<=
http://www.google.co.uk/search?sourceid=3Dchrome&ie=3DUTF-8&q=3Dlibclntsh.s=
o+__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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20110112/306e4=
d97/attachment.htm


More information about the Catalyst mailing list