Re: [External] : callTimeout takes no effect (cx_Oracle 8.1; Oracle client 18.3)
Zongheng Yang <[email protected]> Thu, 22 Apr 2021 20:02:22 -0700
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAG2+eoimJv-XPpNcvpqtZeF4jppM=nondN5xyt+oz4uqjE7ZCg@mail.gmail.com> |
--===============6865537987384808677== Content-Type: multipart/alternative; boundary="00000000000001cdd105c09b07d6" --00000000000001cdd105c09b07d6 Content-Type: text/plain; charset="UTF-8" Tried out upgrading Oracle 19c, and optionally adding to the script (the dir in which the modified sqlnet.ora lives): cx_Oracle.init_oracle_client(config_dir="/u01/app/oracle/product/19.0.0/dbhome_1/network/admin") Same issue still persists. OS is Oracle Linux 7.7. $ python test.py 8.1.0 (19, 3, 0, 0, 0) Call timeout set at 500 milliseconds... Fetch of current date before timeout: 2021-04-23 03:01:27 Sleeping...should time out... Fetch of current date after timeout: 2021-04-23 03:01:37 On Thu, Apr 22, 2021 at 3:59 PM Zongheng Yang <[email protected]> wrote: > Thanks for the quick response! > > (base) [oracle@oracle-test18 ~]$ grep disable_oob > $ORACLE_HOME/network/admin/sqlnet.ora > #disable_oob = ON > disable_oob = ON > > With this change, and running SHUTDOWN then STARTUP, the same issue > persists. No timeout effect. > > > On Thu, Apr 22, 2021 at 3:51 PM Christopher Jones < > [email protected]> wrote: > >> >> On 23/4/21 8:44 am, ConcreteVitamin wrote: >> >> Hi, >> >> I'm using the following script, modified from samples/CallTimeout.py >> (changing into cx_Oracle.connect(mode=cx_Oracle.SYSDBA) & using a 500ms >> timeout), and *callTimeout is not taking effects*: >> >> import cx_Oracle >> print(cx_Oracle.version, cx_Oracle.clientversion()) >> >> connection = cx_Oracle.connect(mode=cx_Oracle.SYSDBA) >> >> connection.callTimeout = 500 >> print("Call timeout set at", connection.callTimeout, "milliseconds...") >> >> cursor = connection.cursor() >> cursor.execute("select sysdate from dual") >> today, = cursor.fetchone() >> print("Fetch of current date before timeout:", today) >> >> # dbms_session.sleep() replaces dbms_lock.sleep() from Oracle Database 18c >> sleep_proc_name = "dbms_session.sleep" \ >> if int(connection.version.split(".")[0]) >= 18 \ >> else "dbms_lock.sleep" >> >> print("Sleeping...should time out...") >> try: >> cursor.callproc(sleep_proc_name, (3,)) >> except cx_Oracle.DatabaseError as e: >> print("ERROR:", e) >> >> cursor.execute("select sysdate from dual") >> today, = cursor.fetchone() >> print("Fetch of current date after timeout:", today) >> >> >> The output is: >> >> $ python test.py >> 8.1.0 (18, 3, 0, 0, 0) >> Call timeout set at 500 milliseconds... >> Fetch of current date before timeout: 2021-04-22 22:39:30 >> Sleeping...should time out... >> Fetch of current date after timeout: 2021-04-22 22:39:33 >> >> >> Note that (from the output), I'm using *cx_Oracle 8.1 and Oracle client >> library 18.3* --- both satisfy this feature's requirements. The DB is >> freshly installed on an Oracle Linux box. >> >> Is there a pointer on how to resolve this? *Is it possible something >> about connect(mode=cx_Oracle.SYSDBA) made the timeout a no-op? *Or, >> should I upgrade to Oracle 19 and retry? >> >> Start by setting disable_oob=on in a sqlnet.ora file on your Python >> machine. The OOB setting is a common gotcha. See >> https://cx-oracle.readthedocs.io/en/latest/user_guide/initialization.html#optional-oracle-client-configuration-files >> >> Or upgrade to 19c Oracle client libraries, which auto-detect the >> necessary OOB setting. >> >> -- https://twitter.com/ghrd >> >> _______________________________________________ >> cx-oracle-users mailing list >> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> > --00000000000001cdd105c09b07d6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Tried out upgrading Oracle 19c, and optionally adding to t= he script (the dir in which the modified sqlnet.ora lives):<div><br><div>= =C2=A0 =C2=A0 cx_Oracle.init_oracle_client(config_dir=3D"/u01/app/orac= le/product/19.0.0/dbhome_1/network/admin")<br></div><div><br></div><di= v>Same issue still persists.=C2=A0 OS is Oracle Linux 7.7.</div><div><br></= div><div>$ python test.py<br>8.1.0 (19, 3, 0, 0, 0)<br>Call timeout set at = 500 milliseconds...<br>Fetch of current date before timeout: 2021-04-23 03:= 01:27<br>Sleeping...should time out...<br>Fetch of current date after timeo= ut: 2021-04-23 03:01:37<br></div><div><br></div><div><br></div></div></div>= <br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu= , Apr 22, 2021 at 3:59 PM Zongheng Yang <<a href=3D"mailto:zongheng.y@gm= ail.com">[email protected]</a>> wrote:<br></div><blockquote class=3D"= gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20= 4,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Thanks for the quick res= ponse!</div><div><br></div>(base) [oracle@oracle-test18 ~]$ grep disable_oo= b $ORACLE_HOME/network/admin/sqlnet.ora<br>#disable_oob =3D ON<br>disable_o= ob =3D ON<br><div><br></div><div>With this change, and running SHUTDOWN the= n STARTUP, the same issue persists.=C2=A0 No timeout effect.</div><div><br>= </div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_= attr">On Thu, Apr 22, 2021 at 3:51 PM Christopher Jones <<a href=3D"mail= to:[email protected]" target=3D"_blank">christopher.jones@oracle= .com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar= gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1= ex"> =20 <div> <p><br> </p> <div>On 23/4/21 8:44 am, ConcreteVitamin wrote:<br> </div> <blockquote type=3D"cite"> =20 <div dir=3D"ltr">Hi, <div><br> </div> <div>I'm using the following script, modified from samples/CallTimeout.py (changing into cx_Oracle.connect(mode=3Dcx_Oracle.SYSDBA) & using a 500ms timeout), and <b>callTimeout is not taking effects</b>:</div> <div><br> </div> <blockquote style=3D"margin:0px 0px 0px 40px;border:none;padding:0p= x"> <div><font face=3D"monospace">import cx_Oracle</font></div> <div><font face=3D"monospace">print(cx_Oracle.version, cx_Oracle.clientversion())</font></div> <div><font face=3D"monospace"><br> </font></div> <div><font face=3D"monospace">connection =3D cx_Oracle.connect(mode=3Dcx_Oracle.SYSDBA)</font></div> <div><font face=3D"monospace"><br> </font></div> <div><font face=3D"monospace">connection.callTimeout =3D 500</fon= t></div> <div><font face=3D"monospace">print("Call timeout set at&quo= t;, connection.callTimeout, "milliseconds...")</font></= div> <div><font face=3D"monospace"><br> </font></div> <div><font face=3D"monospace">cursor =3D connection.cursor()</fon= t></div> <div><font face=3D"monospace">cursor.execute("select sysdate from dual")</font></div> <div><font face=3D"monospace">today, =3D cursor.fetchone()</font>= </div> <div><font face=3D"monospace">print("Fetch of current date before timeout:", today)</font></div> <div><font face=3D"monospace"><br> </font></div> <div><font face=3D"monospace"># dbms_session.sleep() replaces dbms_lock.sleep() from Oracle Database 18c</font></div> <div><font face=3D"monospace">sleep_proc_name =3D "dbms_session.sleep" \</font></div> <div><font face=3D"monospace">=C2=A0 =C2=A0 =C2=A0 =C2=A0 if int(connection.version.split(".")[0]) >=3D 18 \<= /font></div> <div><font face=3D"monospace">=C2=A0 =C2=A0 =C2=A0 =C2=A0 else &q= uot;dbms_lock.sleep"</font></div> <div><font face=3D"monospace"><br> </font></div> <div><font face=3D"monospace">print("Sleeping...should time out...")</font></div> <div><font face=3D"monospace">try:</font></div> <div><font face=3D"monospace">=C2=A0 =C2=A0 cursor.callproc(sleep_proc_name, (3,))</font></div> <div><font face=3D"monospace">except cx_Oracle.DatabaseError as e:</font></div> <div><font face=3D"monospace">=C2=A0 =C2=A0 print("ERROR:&qu= ot;, e)</font></div> <div><font face=3D"monospace"><br> </font></div> <div><font face=3D"monospace">cursor.execute("select sysdate from dual")</font></div> <div><font face=3D"monospace">today, =3D cursor.fetchone()</font>= </div> <div><font face=3D"monospace">print("Fetch of current date a= fter timeout:", today)</font></div> </blockquote> <div><br> </div> <div>The output is:</div> <div><br> </div> <blockquote style=3D"margin:0px 0px 0px 40px;border:none;padding:0p= x"> <div><font face=3D"monospace">$ python test.py</font></div> <div><font face=3D"monospace">8.1.0 (18, 3, 0, 0, 0)</font></div> <div><font face=3D"monospace">Call timeout set at 500 milliseconds...</font></div> <div><font face=3D"monospace">Fetch of current date before timeout: 2021-04-22 22:39:30</font></div> <div><font face=3D"monospace">Sleeping...should time out...</font= ></div> <div><font face=3D"monospace">Fetch of current date after timeout: 2021-04-22 22:39:33</font></div> </blockquote> <div><br> </div> <div>Note that (from the output), I'm using <b>cx_Oracle 8.1 and Oracle client library 18.3</b> --- both satisfy this feature's=C2=A0requirements.=C2=A0 The DB is freshly installe= d on an Oracle Linux box.</div> <div><br> </div> <div>Is there a pointer on how to resolve this?=C2=A0 <b>Is it possible something about=C2=A0connect(mode=3Dcx_Oracle.SYSDBA) = made the timeout a no-op?=C2=A0 </b>Or, should I upgrade to Oracle 1= 9 and retry?</div> <div><br> </div> </div> </blockquote> <p>Start by setting <font face=3D"monospace">disable_oob=3Don</font> in a sqlnet.ora file on your Python machine. The OOB setting is a common gotcha. See <a href=3D"https://cx-oracle.readthedocs.io/en/latest/user_guide/initializa= tion.html#optional-oracle-client-configuration-files" target=3D"_blank">htt= ps://cx-oracle.readthedocs.io/en/latest/user_guide/initialization.html#opti= onal-oracle-client-configuration-files</a></p> <p> Or upgrade to 19c Oracle client libraries, which auto-detect the necessary OOB setting.<br> </p> <pre cols=3D"150">--=20 <a href=3D"https://twitter.com/ghrd" target=3D"_blank">https://twitter.com/= ghrd</a> </pre> </div> _______________________________________________<br> cx-oracle-users mailing list<br> <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_blank">= cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> <a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" re= l=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/list= info/cx-oracle-users</a><br> </blockquote></div> </blockquote></div> --00000000000001cdd105c09b07d6-- --===============6865537987384808677== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============6865537987384808677== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users --===============6865537987384808677==--