[Zope] PCGI crash problem with SQL/LIMIT

Mayers, Philip J p.mayers@ic.ac.uk
Mon, 11 Dec 2000 16:42:54 -0000


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                 |
+----------------------------------+