Re: [Zope-DB] mysql / zope db connection issue
On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this problem. Jamie, you should be talking to the DBA or looking at the DB side of things. Well it is a volunteer operation, so we don't specifically have a dba, but will talk with the person who set up the db. Is the DB running on the same machine as Zope or on the network? Yes. What are connection times set to? Do you mean the connection timeout time? It might simply be that MySQL is running out of connections although this usually means that the whole machine runs slow. We upped the # of connections and I have seen 51 connections open at one time. Not sure the rate at which people are accessing the form and submitting it, but I believe it may be 25-50 a day. Jamie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] mysql / zope db connection issue
On 2006-04-06 at 16:34:01 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this problem. Jamie, you should be talking to the DBA or looking at the DB side of things. Well it is a volunteer operation, so we don't specifically have a dba, but will talk with the person who set up the db. Is the DB running on the same machine as Zope or on the network? Yes. What are connection times set to? Do you mean the connection timeout time? Yes. The default for these are very high which often causes problems for applications that don't implement connection pooling. However, as I previously said this is unlikely to be the source of the problem. It might simply be that MySQL is running out of connections although this usually means that the whole machine runs slow. We upped the # of connections and I have seen 51 connections open at one time. Not sure the rate at which people are accessing the form and submitting it, but I believe it may be 25-50 a day. At that rate there is no reason on the Zope side for the connection being dropped. There could be a problem with the underlying Python driver and thus the ZopeDA so you might want to install the latest version of both: http://sourceforge.net/project/showfiles.php?group_id=22307 MySQL 3.2 is still supported. But you should also run Zope in debug mode and see what gets written to the error log. Charlie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] mysql / zope db connection issue
Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. Jamie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] mysql / zope db connection issue
Thanks for the suggestions, Charlie. Will try as you suggested. Jamie On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: On 2006-04-06 at 16:34:01 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this problem. Jamie, you should be talking to the DBA or looking at the DB side of things. Well it is a volunteer operation, so we don't specifically have a dba, but will talk with the person who set up the db. Is the DB running on the same machine as Zope or on the network? Yes. What are connection times set to? Do you mean the connection timeout time? Yes. The default for these are very high which often causes problems for applications that don't implement connection pooling. However, as I previously said this is unlikely to be the source of the problem. It might simply be that MySQL is running out of connections although this usually means that the whole machine runs slow. We upped the # of connections and I have seen 51 connections open at one time. Not sure the rate at which people are accessing the form and submitting it, but I believe it may be 25-50 a day. At that rate there is no reason on the Zope side for the connection being dropped. There could be a problem with the underlying Python driver and thus the ZopeDA so you might want to install the latest version of both: http://sourceforge.net/project/showfiles.php?group_id=22307 MySQL 3.2 is still supported. But you should also run Zope in debug mode and see what gets written to the error log. Charlie -- Jamie O'Keefe www.jamesokeefe.org jokeefe.typepad.com - my personal blog jokeefe.typepad.com/green_politics/ - my political blog jokeefe.typepad.com/nonviolence/ - my blog on nonviolence ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] mysql / zope db connection issue
--On 6. April 2006 14:46:36 -0400 Jamie O'Keefe [EMAIL PROTECTED] wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Huh...google will tell you that it runs even on Windows. -aj --- - Andreas JungZOPYX Ltd. Co KG- - E-mail: [EMAIL PROTECTED] Web: www.zopyx.com, www.zopyx.de - --- pgpt9j8A3STBo.pgp Description: PGP signature ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] mysql / zope db connection issue
On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. PostgreSQL was developed at the University of California, Berkeley and runs on a huge range of problems. I prefer it over MySQL but I am not convinced that switching to PostgreSQL will solve your problems and, of course, will involve all the work of migration. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ 2005-10-17: Released mxODBC.Zope.DA 1.0.9http://zope.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] mysql / zope db connection issue
--On 6. April 2006 21:51:05 +0200 Charlie Clark [EMAIL PROTECTED] wrote: On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. PostgreSQL was developed at the University of California, Berkeley and runs on a huge range of problems. problems? you mean systems :-) -aj pgpZvGcsVmzJX.pgp Description: PGP signature ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db