[python-sybase] Sybase ct_fetch error at text sizes > 65536

Joshua Moore-Oliva josh at chatgris.com
Tue, 7 Sep 2004 19:43:48 -0400


There is a textsize setting to retreive large text fields..

If I set this higher than 65536 (using SET TEXTSIZE X; )

and the field data is more than that many characters, Sybase will raise the error

Traceback (most recent call last):
  File "sytest.py", line 16, in ?
    xData = cur.fetchall()
  File "/usr/lib/python2.3/site-packages/Sybase.py", line 733, in fetchall
    return self._fetcher.fetchall()
  File "/usr/lib/python2.3/site-packages/Sybase.py", line 517, in fetchall
    row = self.fetchone()
  File "/usr/lib/python2.3/site-packages/Sybase.py", line 456, in fetchone
    _fetch_rows(self._cmd, self._bufs, self._array)
  File "/usr/lib/python2.3/site-packages/Sybase.py", line 217, in _fetch_rows
    raise Error('ct_fetch')
Sybase.Error: ct_fetch

Since this happens only at >65536 textsize, this must be some kind of buffer problem?

I am using Gentoo with kernel 2.6
python 2.3.3
freetds 0.62.3

Any insight is very appreciated.

Joshua Moore-Oliva.