Unfortunately this is going to be a very indistinct bug report, but ever since upgrading to 4.10 from 4.9 I am having several problems with mysql. These manifest as programs occasionally failing to connect to the database. Unfortunately I have been unable to track this down as yet due to the fact it only happens once in every few hundred attempts, so trying to actually characterise it is proving almost impossible! Has anyone else seen this ? I am using the system on a test server and am loathe to upgrade the production machines just in case it *isnt* simply some quirk of this machine. -pcf.
From: "Pete French" <petefrench@keithprowse.com>> Unfortunately this is going to be a very indistinct bug > report, but ever since upgrading to 4.10 from 4.9 I am > having several problems with mysql. These manifest as > programs occasionally failing to connect to the database. > Unfortunately I have been unable to track this down as yet > due to the fact it only happens once in every few hundred > attempts, so trying to actually characterise it is proving > almost impossible! > > Has anyone else seen this ? I am using the system on a test > server and am loathe to upgrade the production machines just in case > it *isnt* simply some quirk of this machine. > > -pcf.Do you run a firewall (ipfw) on that machine? Perhaps you are hitting stateful connection limits? I used to set this in /etc/sysctl.conf to avoid the issue for me: # increase the number of dynamic firewall rules allowed net.inet.ip.fw.dyn_max=3000 Tom Veldhouse
> Do you run a firewall (ipfw) on that machine? Perhaps you are hitting > stateful connection limits?Nope, its just straight out of the box with no firewall. Also the connections are local (the scripts run on the same machine). It worked fine under 4.9 - though someone else has said they have seen the same beahviout under 4.9 -pcf.
On Mon, 24 May 2004, Pete French wrote:> Unfortunately this is going to be a very indistinct bug > report, but ever since upgrading to 4.10 from 4.9 I am > having several problems with mysql. These manifest as > programs occasionally failing to connect to the database. > Unfortunately I have been unable to track this down as yet > due to the fact it only happens once in every few hundred > attempts, so trying to actually characterise it is proving > almost impossible! > > Has anyone else seen this ? I am using the system on a test > server and am loathe to upgrade the production machines just in case > it *isnt* simply some quirk of this machine. > > -pcf.Are you sure you're not periodically hitting the maximum thread limit configured within MySQL? - Matt -- Matt Loschert - Software Engineer | email: loschert@servint.com | ServInt Internet Services | web: http://www.servint.net/ | McLean, Virginia USA | phone: (703) 847-1381 |
> Has anyone else seen this ? I am using the system on a test > server and am loathe to upgrade the production machines just in case > it *isnt* simply some quirk of this machine.I have similar problem. Aborted connection XX to db: 'db' user: 'user' host: 'localhost' (Got an error reading communication packets) Do you builded mysql BUILD_OPTIMIZED=yes (default no)?
Hello!> Date: Mon, 24 May 2004 12:56:16 +0100 > From: Pete French <petefrench@keithprowse.com> > > Unfortunately this is going to be a very indistinct bug > report, but ever since upgrading to 4.10 from 4.9 I am > having several problems with mysql. These manifest as > programs occasionally failing to connect to the database.Which version of MySQL server are you using? Has it been built from port or compiled from sources? What threading library does it use (native or linuxthreads)? How many client applications are trying to connect simultaneously? Sincerely, Dmitry -- Atlantis ISP, System Administrator e-mail: dmitry@atlantis.dp.ua nic-hdl: LYNX-RIPE
> Which version of MySQL server are you using? Has it been built from port or > compiled from sources? What threading library does it use (native or > linuxthreads)? How many client applications are trying to connect > simultaneously?4.0.18 - built from source, the only optimisation being -O as I dont trust the higher ones, it is using native threads and there is only one client running on the same machine which is connecting every two minutes doing a select and quitting (and I have chcked that connections are not building up). I see the failed connection 5 to 10 times a day. -pcf.
Pete French typed on a keyboard not too far away, on 5/24/2004 1:56 PM:>Unfortunately this is going to be a very indistinct bug >report, but ever since upgrading to 4.10 from 4.9 I am >having several problems with mysql. These manifest as >programs occasionally failing to connect to the database. >Unfortunately I have been unable to track this down as yet >due to the fact it only happens once in every few hundred >attempts, so trying to actually characterise it is proving >almost impossible! > >Has anyone else seen this ? I am using the system on a test >server and am loathe to upgrade the production machines just in case >it *isnt* simply some quirk of this machine. > >-pcf. >_______________________________________________ >freebsd-stable@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-stable >To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" > > > >Hmm, Anyone came up with more info on this issue yet? It is clear that a lot of people are experiencing the problems described in this thread. (Including me ;)) ---jaco -- Jaco van Tonder Magic Developer :: Premsoft Development (Pty) Ltd Direct: +27 11 312 2122 :: Fax: +27 11 312 2122 :: Mobile: +27 83 417 5424 Email: jaco@premsoft.co.za :: Web: http://www.premsoft.co.za/ Disclaimer: http://www.premsoft.co.za/email_disclaimer.html