[python-sybase] Pulling my hair out about a query...

Skip Montanaro skip at pobox.com
Tue, 22 Jun 2004 22:47:18 -0500


--3j6cyn8gRz
Content-Type: text/plain; charset=us-ascii
Content-Description: message body text
Content-Transfer-Encoding: 7bit


    Dave> Ooops.  I was confusing the Sybase module with another one of my 
    Dave> modules...  Should have checked the code.  Try this:

    Dave> import Sybase

    Dave> Sybase._ctx.debug = 1
    Dave> Sybase.set_debug(open('debug.log', 'w'))
    Dave>      :

Thanks, that worked much better.  Attached is the debug.log file.  I don't
see anything obvious, but I'm not really sure what I'm looking at either...

Skip


--3j6cyn8gRz
Content-Type: application/octet-stream
Content-Disposition: attachment;
        filename="debug.log"
Content-Transfer-Encoding: base64

Y3RfY29uX2FsbG9jKGN0eDAsICZjb25uKSAtPiBDU19TVUNDRUVELCBjb25uMApjdF9jb25f
cHJvcHMoY29ubjAsIENTX1NFVCwgQ1NfVVNFUk5BTUUsICIqKioiLCBDU19OVUxMVEVSTSwg
TlVMTCkgLT4gQ1NfU1VDQ0VFRApjdF9jb25fcHJvcHMoY29ubjAsIENTX1NFVCwgQ1NfUEFT
U1dPUkQsICIqKioiLCBDU19OVUxMVEVSTSwgTlVMTCkgLT4gQ1NfU1VDQ0VFRApzZXJ2ZXJt
c2dfY2IKc2VydmVybXNnX2NiCmN0X2Nvbm5lY3QoY29ubjAsICIqKioiLCBDU19OVUxMVEVS
TSkgLT4gQ1NfU1VDQ0VFRApjdF9vcHRpb25zKGNvbm4wLCBDU19TRVQsIENTX09QVF9DSEFJ
TlhBQ1RTLCAxLCBDU19VTlVTRUQsIE5VTEwpIC0+IENTX1NVQ0NFRUQKQ3Vyc29yLmV4ZWN1
dGUKX2xvY2s6IGNvdW50IC0+IDEKY3RfY21kX2FsbG9jKGNvbm4wLCAmY21kKSAtPiBDU19T
VUNDRUVELCBjbWQwCl9sb2NrOiBjb3VudCAtPiAyCl9zZXRfc3RhdGU6IF9MQVpZX0lETEUK
X3VubG9jazogY291bnQgLT4gMQpjdF9jb21tYW5kKGNtZDAsIENTX0xBTkdfQ01ELCAiU0VM
RUNUIHRyYWRlX3RpbWUsIHByaWNlCiAgRlJPTSB1bmRlcmx5aW5nX2RhaWx5X2ZwCiAgV0hF
UkUgc3ltYm9sID0gQHN5bQogICAgQU5EIGluc3RydW1lbnQgPSBAaW5zdAogICAgQU5EIHRy
YWRlX3RpbWUgQkVUV0VFTiBAc3RhcnQgQU5EIEBlbmQKICAgIEFORCAocHJpY2VfdHlwZT0n
SCcgb3IgcHJpY2VfdHlwZT0nTCcpCiAgT1JERVIgQlkgdHJhZGVfdGltZSBERVNDCiIsIENT
X05VTExURVJNLCBDU19VTlVTRUQpIC0+IENTX1NVQ0NFRUQKY3RfcGFyYW0oY21kMCwgJmRh
dGFidWYwLT5mbXQ9W25hbWU6IkBzeW0iIHR5cGU6Q1NfQ0hBUl9UWVBFIHN0YXR1czpDU19J
TlBVVFZBTFVFIGZvcm1hdDpDU19GTVRfTlVMTFRFUk0gY291bnQ6MSBtYXhsZW5ndGg6MyBz
Y2FsZTowIHByZWNpc2lvbjowXSwgZGF0YWJ1ZjAtPmJ1ZmYsIDIsIDApIC0+IENTX1NVQ0NF
RUQKY3RfcGFyYW0oY21kMCwgJmRhdGFidWYxLT5mbXQ9W25hbWU6IkBzdGFydCIgdHlwZTpD
U19EQVRFVElNRV9UWVBFIHN0YXR1czpDU19JTlBVVFZBTFVFIGZvcm1hdDpDU19GTVRfVU5V
U0VEIGNvdW50OjEgbWF4bGVuZ3RoOjggc2NhbGU6MCBwcmVjaXNpb246MF0sIGRhdGFidWYx
LT5idWZmLCA4LCAwKSAtPiBDU19TVUNDRUVECmN0X3BhcmFtKGNtZDAsICZkYXRhYnVmMi0+
Zm10PVtuYW1lOiJAZW5kIiB0eXBlOkNTX0RBVEVUSU1FX1RZUEUgc3RhdHVzOkNTX0lOUFVU
VkFMVUUgZm9ybWF0OkNTX0ZNVF9VTlVTRUQgY291bnQ6MSBtYXhsZW5ndGg6OCBzY2FsZTow
IHByZWNpc2lvbjowXSwgZGF0YWJ1ZjItPmJ1ZmYsIDgsIDApIC0+IENTX1NVQ0NFRUQKY3Rf
cGFyYW0oY21kMCwgJmRhdGFidWYzLT5mbXQ9W25hbWU6IkBpbnN0IiB0eXBlOkNTX0NIQVJf
VFlQRSBzdGF0dXM6Q1NfSU5QVVRWQUxVRSBmb3JtYXQ6Q1NfRk1UX05VTExURVJNIGNvdW50
OjEgbWF4bGVuZ3RoOjIgc2NhbGU6MCBwcmVjaXNpb246MF0sIGRhdGFidWYzLT5idWZmLCAx
LCAwKSAtPiBDU19TVUNDRUVECmN0X3NlbmQoY21kMCkgLT4gQ1NfU1VDQ0VFRApfc3RhcnRf
cmVzdWx0cwpjdF9yZXN1bHRzKGNtZDAsICZyZXN1bHQpIC0+IENTX1NVQ0NFRUQsIENTX1JP
V19SRVNVTFQKY3RfcmVzX2luZm8oY21kMCwgQ1NfTlVNREFUQSwgJnZhbHVlLCBDU19VTlVT
RUQsIE5VTEwpIC0+IENTX1NVQ0NFRUQsIDIKY3RfZGVzY3JpYmUoY21kMCwgMSwgJmZtdCkg
LT4gQ1NfU1VDQ0VFRCwgZGF0YWZtdDA9W25hbWU6InRyYWRlX3RpbWUiIHR5cGU6Q1NfREFU
RVRJTUVfVFlQRSBzdGF0dXM6Q1NfVVBEQVRBQkxFIGZvcm1hdDpDU19GTVRfVU5VU0VEIGNv
dW50OjAgbWF4bGVuZ3RoOjggc2NhbGU6MCBwcmVjaXNpb246MF0KY3RfYmluZChjbWQwLCAx
LCAmZGF0YWZtdDAtPmZtdD1bbmFtZToidHJhZGVfdGltZSIgdHlwZTpDU19EQVRFVElNRV9U
WVBFIHN0YXR1czpDU19VUERBVEFCTEUgZm9ybWF0OkNTX0ZNVF9VTlVTRUQgY291bnQ6MSBt
YXhsZW5ndGg6OCBzY2FsZTowIHByZWNpc2lvbjowXSwgZGF0YWJ1ZjQtPmJ1ZmYsIGRhdGFi
dWY0LT5jb3BpZWQsIGRhdGFidWY0LT5pbmRpY2F0b3IpIC0+IENTX1NVQ0NFRUQsIGRhdGFi
dWY0CmN0X2Rlc2NyaWJlKGNtZDAsIDIsICZmbXQpIC0+IENTX1NVQ0NFRUQsIGRhdGFmbXQx
PVtuYW1lOiJwcmljZSIgdHlwZTpDU19GTE9BVF9UWVBFIHN0YXR1czpDU19VUERBVEFCTEUg
Zm9ybWF0OkNTX0ZNVF9VTlVTRUQgY291bnQ6MCBtYXhsZW5ndGg6OCBzY2FsZTowIHByZWNp
c2lvbjowXQpjdF9iaW5kKGNtZDAsIDIsICZkYXRhZm10MS0+Zm10PVtuYW1lOiJwcmljZSIg
dHlwZTpDU19GTE9BVF9UWVBFIHN0YXR1czpDU19VUERBVEFCTEUgZm9ybWF0OkNTX0ZNVF9V
TlVTRUQgY291bnQ6MSBtYXhsZW5ndGg6OCBzY2FsZTowIHByZWNpc2lvbjowXSwgZGF0YWJ1
ZjUtPmJ1ZmYsIGRhdGFidWY1LT5jb3BpZWQsIGRhdGFidWY1LT5pbmRpY2F0b3IpIC0+IENT
X1NVQ0NFRUQsIGRhdGFidWY1Cl9zZXRfc3RhdGU6IF9MQVpZX0ZFVENISU5HCl9sb2NrOiBj
b3VudCAtPiAyCl9sb2NrOiBjb3VudCAtPiAzCl9mZXRjaF9yb3dzCmN0X2ZldGNoKGNtZDAs
IENTX1VOVVNFRCwgQ1NfVU5VU0VELCBDU19VTlVTRUQsICZyb3dzX3JlYWQpIC0+IENTX0VO
RF9EQVRBLCAwCl9mZXRjaF9yb3djb3VudApjdF9yZXN1bHRzKGNtZDAsICZyZXN1bHQpIC0+
IENTX1NVQ0NFRUQsIENTX0NNRF9ET05FCmN0X3Jlc19pbmZvKGNtZDAsIENTX1JPV19DT1VO
VCwgJnZhbHVlLCBDU19VTlVTRUQsIE5VTEwpIC0+IENTX1NVQ0NFRUQsIDAKX3NldF9zdGF0
ZTogX0xBWllfRU5EX1JFU1VMVApfdW5sb2NrOiBjb3VudCAtPiAyCl91bmxvY2s6IGNvdW50
IC0+IDEKY3RfY2FuY2VsKGNvbm4wLCBOVUxMLCBDU19DQU5DRUxfQUxMKSAtPiBDU19TVUND
RUVECl91bmxvY2s6IGNvdW50IC0+IDAKY3RfY21kX2Ryb3AoY21kMCkgLT4gQ1NfU1VDQ0VF
RApjdF9jb25fcHJvcHMoY29ubjAsIENTX0dFVCwgQ1NfQ09OX1NUQVRVUywgJnZhbHVlLCBD
U19VTlVTRUQsIE5VTEwpIC0+IENTX1NVQ0NFRUQsIENTX0NPTlNUQVRfQ09OTkVDVEVECmN0
X2Nsb3NlKGNvbm4wLCBDU19GT1JDRV9DTE9TRSkgLT4gQ1NfU1VDQ0VFRApjdF9jb25fZHJv
cChjb25uMCkgLT4gQ1NfU1VDQ0VFRAo=
--3j6cyn8gRz--