Re: [cx-oracle-users] ORA-24550: signal received
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracle-users] ORA-24550: signal received
|
From: Wong W. Meng-R. <r3...@fr...> - 2011-10-09 07:51:09
|
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:ant...@gm...] Sent: Wednesday, October 05, 2011 12:29 PM To: cx-...@li... 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 <r3...@fr...> wrote: > 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 > > > > ------------------------------------------------------------------------------ > 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 |
