[Zope-DB] mysql / zope db connection issue

[Charlie Clark]

On 2006-04-06 at 09:51:49 [+0200], Chris Withers <chris at simplistix.co.uk> 
wrote:
> >>> Exception Type        Database Error
> >>> Exception Value       updatePerson is not connected to a database
> >> What version of Zope/MySQL/mysqldb/ZMySQLDA are you using?
> > 
> > Zope is 2.6.4
> 
> Good grief. Upgrade. No-one can help you on such an ancient version.

Chris, the underlying code for ZopeDA's hasn't changed for years so it 
shouldn't make much difference what version of Zope he is running. There 
may, of course, be other reasons for running a more recent release.

> > MySql is 3.22.32
> 
> The same is probably true for MySQL...

This still should not be causing this problem. Jamie, you should be talking 
to the DBA or looking at the DB side of things. Is the DB running on the 
same machine as Zope or on the network? What are connection times set to? 
It might simply be that MySQL is running out of connections although this 
usually means that the whole machine runs slow.

Charlie