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

[Wong Wah Meng-R32813]

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

[Anthony Tuininga]

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

Post by Wong Wah Meng-R32813
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
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[Wong Wah Meng-R32813]

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:***@gmail.com]
Sent: Tuesday, October 04, 2011 9:58 PM
To: cx-oracle-***@lists.sourceforge.net
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

Post by Wong Wah Meng-R32813
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
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[Anthony Tuininga]

Hi,

I mean threaded = True when creating the connection to the database.

Anthony

On Tue, Oct 4, 2011 at 9:48 PM, Wong Wah Meng-R32813

Post by Wong Wah Meng-R32813
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-----
Sent: Tuesday, October 04, 2011 9:58 PM
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

Post by Wong Wah Meng-R32813
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
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
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
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[Wong Wah Meng-R32813]

Hello Anthony,

I am not sure what happened when I first plug in conn = cx_Oracle.connect(<connection string>, threaded=True) it didn't seem to work, however when I tried again it worked. It works until now, even though I have removed the "threaded=True" from the connect() argument list in my source code.

I have stopped and started my process multiple times and it still works without failure (no more signal failed error), when threaded=True is omitted. Though I have not seen any difference now by including or omitting it from the argument list, I have decided to include it into my source code.

I need to revisit this if on another day bad luck strike me that it gives me that error again. :p

Thanks a lot!

Regards,
Wah Meng

-----Original Message-----
From: Anthony Tuininga [mailto:***@gmail.com]
Sent: Wednesday, October 05, 2011 12:29 PM
To: cx-oracle-***@lists.sourceforge.net
Subject: Re: [cx-oracle-users] ORA-24550: signal received

Hi,

I mean threaded = True when creating the connection to the database.

Anthony

On Tue, Oct 4, 2011 at 9:48 PM, Wong Wah Meng-R32813

Post by Wong Wah Meng-R32813
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-----
Sent: Tuesday, October 04, 2011 9:58 PM
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

Post by Wong Wah Meng-R32813
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
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
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
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users