[Python-sybase-misc] Sybase hang with cursors

[Abel Q. <bel...@ho...>]

Hello,

I am experiencing what appears to be a Sybase ASE hang when executing a 
particular query. When executing that query from another db client (Aqua 
Data Studio), the query takes about 3-4 seconds to complete, but from Python 
it simply never completes. The Sybase host is in Linux. Below I show some 
details of the call as well as the output of a stored proc that shows 
information about sybase processes.

I also bring to your attention that the same query to Sybase on a Solaris 
machine works fine. It does not hang.

What could I do to get rid of this problem?

I contacted the dba's in our organization. Their response was that they do 
not support CURSORS in SYBASE because they are difficult to debug and 
analize, and that was the end of it.

-----------------------------------
the Python sequence:
db = Sybase.connect('NYFICCTP02', 'quiroa', 'AbelQuiros')
c = db.cursor()
c.execute("select CustomerId from BeneficialOwner where 
BeneficialOwner='640935301'")

-----------------------------------
the output of stored proc that shows process info:
spid     loginame  db.table                                       locktype 
page            status       hostprocess   program    cmd
------- --------- -----------------------------        -----------  --------- 
      ---------  ------------  ----------   ------------
2374   quiroa      ConfTrack.CommDirectory         Sh_intent    0 
running    :4928                                FETCH CURSOR
2374   quiroa      ConfTrack.CommDirectory         Sh_page     134095302 
running    :4928                                FETCH CURSOR
2374   quiroa      ConfTrack.PmtCustomer             Sh_intent    0 
running    :4928                                FETCH CURSOR
2374   quiroa      ConfTrack.PmtCustomer             Sh_page     16434233 
running    :4928                                FETCH CURSOR
2374   quiroa      amhub.ACCOUNT                     Sh_intent    0 
running    :4928                                FETCH CURSOR
2374   quiroa      amhub.ACCOUNT                     Sh_page     2684147 
running    :4928                                FETCH CURSOR
2374   quiroa      entity_master.AltIdCombined       Sh_intent    0 
running    :4928                                FETCH CURSOR
2374   quiroa      entity_master.AltIdCombined       Sh_page     377944 
running    :4928                                FETCH CURSOR
2374   quiroa      entity_master.AltIdCombined       Sh_page     377946 
running    :4928                                FETCH CURSOR
2374   quiroa      entity_master.EAR_AccountRole Sh_intent     0 
running    :4928                                FETCH CURSOR
2374   quiroa      entity_master.EAR_AccountRole Sh_page      235696 
running    :4928                                FETCH CURSOR
2374   quiroa      entity_master.EAR_PickList        Sh_intent      0 
running    :4928                                FETCH CURSOR
2374   quiroa      entity_master.EAR_PickList        Sh_page       332666 
running    :4928                                FETCH CURSOR