Re: [cx-oracle-users] ORA-24550: signal received

[Wong W. Meng-R. <r3...@fr...>]

Hello Anthony,

Do you mean I can pass in threaded=true when creating the connection to database (cx_Oracle.connect method)? Or do you mean the --enable-thread setting during the build of the python executable?

Regards,
Wah Meng

-----Original Message-----
From: Anthony Tuininga [mailto:ant...@gm...] 
Sent: Tuesday, October 04, 2011 9:58 PM
To: cx-...@li...
Subject: Re: [cx-oracle-users] ORA-24550: signal received

Hi,

If you have multiple threads, make sure that you specify threaded =
True when creating the connection or you will run into difficulties.
The reason this is not default is that there is a performance penalty
that is unnecessary when running single threaded -- which is the most
common mode anyway.

Hope that helps.

Anthony

On Tue, Oct 4, 2011 at 4:27 AM, Wong Wah Meng-R32813
<r3...@fr...> wrote:
> Hello guys,
>
>
>
> Has anyone seen this befote?
>
>
>
> I am migrating my RMI application from python 1.5.2 (oracledb) to 2.7.1
> (cx_Oracle). When I start up my DbAccessMgr, previously utilizing oracledb
> to connect to database, I encountered below error. I haven't traced down to
> exactly which code is producing this error however it seems that this is
> generated after I spawn off 4 parallel threads instance for the database
> connection from my application.
>
>
>
> The funnier thing is I am able to launch my DbAccessMgr successfully without
> this error after every 2 failures. My DBA told me this should be application
> specific unless I can show otherwise. Appreciate any input out there.
> Thanks!
>
>
>
> (PS: My platform in HP-UX11.31 and cx_Oracle was compiled against Oracle
> 11.1 library using HP-UX C Compiler)
>
>
>
> ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=2]
> [si_addr=0000000000000000]
>
>
>
> sendsig: useracc failed. 0x9fffffff5feb6200 0x00000000005000
>
>
>
> Pid 8162 was killed due to failure in writing the signal context - possible
> stack overflow.
>
>
>
> Regards,
>
> Wah Meng
>
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users