[Zope] PCGI crash problem with SQL/LIMIT

[Mayers, Philip J]

I'm running Zope 2.2.4 and am having a *very* annoying problem (either I'm
missing something, or Zope is broken).

I've got an SQL table called "users". An SQL query of the form:

select * from users limit 10

Works, but:

select * from users

Fails spectacularly - pcgi_publisher crashes with the error message:

Temporarily Unavailable 
The resource you requested is temporarily unavailable - please try again
later. 
 
(116) unable to connect, fd=6 

I then get a 20 second timeout while PCGI restarts Zope. Grr. Help please

Regards,
Phil

+----------------------------------+
| Phil Mayers, Network Support     |
| Centre for Computing Services    |
| Imperial College                 |
+----------------------------------+