[Zope] Sybase error: Products.SybaseDAv2.db.Error: ct_command():

[Chris McDonough]

Hung,

This is strange stuff.  Have you checked the Sybase transaction log
lately?  When it gets full, Zope doesn't like that too much.

Hung Jung Lu wrote:
> 
> Hi,
> 
> I am getting a Sybase error while trying to query
> 
>   select * from myTable
> 
> The error message is:
> 
> "Error, Products.SybaseDAv2.db.Error: ct_command(): user api layer: external
> error: This routine cannot be called while results are pending for a command
> that has been sent to the server."
> 
> I can use isql to see the table without problem. This table does contain a
> few constraint foreign keys, some of them were set to null. Could this be
> the problem? Or does the error have something to do with transactions? I
> have tried to restart Zope and Sybase, but the error persists. If, as the
> error message states, another command has been sent, how can I terminate
> that command?
> 
> thanks in advance,
> 
> Hung Jung
> 
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )

-- 
Chris McDonough
Digital Creations, Inc.
Zope - http://www.zope.org