Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread Rory O'Farrell
On Thu, 8 Aug 2013 16:39:04 +0200 janI wrote: > On 8 August 2013 16:25, Rory O'Farrell wrote: > > > On Thu, 8 Aug 2013 15:59:36 +0200 (CEST) > > FR web forum wrote: > > > > > >Seems fixed but very slow response. > > > No, error still occurs this afternoon. > > > Very annoying for end-users. >

Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread janI
On 8 August 2013 17:13, FR web forum wrote: > >We already have a admin, and I hope that the admin soon will be active. > > >I have access to the server and have offered to help the admin, but got no > >response. I know the general setup (mysql, httpd and ubuntu) quite well, > > From beginning, I

Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread FR web forum
>We already have a admin, and I hope that the admin soon will be active. >I have access to the server and have offered to help the admin, but got no >response. I know the general setup (mysql, httpd and ubuntu) quite well, >From beginning, I asked to check the MySQL max_connections parameter. In

Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread janI
On 8 August 2013 16:25, Rory O'Farrell wrote: > On Thu, 8 Aug 2013 15:59:36 +0200 (CEST) > FR web forum wrote: > > > >Seems fixed but very slow response. > > No, error still occurs this afternoon. > > Very annoying for end-users. > > And we are on august (low traffic with vacations). > > I'm afr

Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread Rory O'Farrell
On Thu, 8 Aug 2013 15:59:36 +0200 (CEST) FR web forum wrote: > >Seems fixed but very slow response. > No, error still occurs this afternoon. > Very annoying for end-users. > And we are on august (low traffic with vacations). > I'm afraid about september, forums will be completly unavailable. > I

Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread FR web forum
>Seems fixed but very slow response. No, error still occurs this afternoon. Very annoying for end-users. And we are on august (low traffic with vacations). I'm afraid about september, forums will be completly unavailable. - To uns

Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread Kazunari Hirano
Hi, Seems fixed but very slow response. Thanks, khirano On Thu, Aug 8, 2013 at 8:22 PM, Kazunari Hirano wrote: > Hi, > http://forum.openoffice.org/ja/forum/ is still getting the error. > Not fixed yet? > > Thanks, > khirano > > > On Thu, Aug 8, 2013 at 4:35 AM, janI wrote: > >> On 7 August 2

Re: Forums down (SQL error: Too many connections [1040])

2013-08-08 Thread Kazunari Hirano
Hi, http://forum.openoffice.org/ja/forum/ is still getting the error. Not fixed yet? Thanks, khirano On Thu, Aug 8, 2013 at 4:35 AM, janI wrote: > On 7 August 2013 21:14, Raphael Bircher wrote: > > > Am 07.08.13 21:04, schrieb Rory O'Farrell: > > > > On Wed, 7 Aug 2013 20:35:30 +0200 > >> ja

Re: Forums down (SQL error: Too many connections [1040])

2013-08-07 Thread janI
On 7 August 2013 21:14, Raphael Bircher wrote: > Am 07.08.13 21:04, schrieb Rory O'Farrell: > > On Wed, 7 Aug 2013 20:35:30 +0200 >> janI wrote: >> >> On 7 August 2013 17:28, Ricardo Berlasso wrote: >>> >>> 2013/8/7 FR web forum I pull up this issue. > The error occurs again

Re: Forums down (SQL error: Too many connections [1040])

2013-08-07 Thread Raphael Bircher
Am 07.08.13 21:04, schrieb Rory O'Farrell: On Wed, 7 Aug 2013 20:35:30 +0200 janI wrote: On 7 August 2013 17:28, Ricardo Berlasso wrote: 2013/8/7 FR web forum I pull up this issue. The error occurs again since two weeks. Today, forums alternate between error 1040 and being slower than

Re: Forums down (SQL error: Too many connections [1040])

2013-08-07 Thread Rory O'Farrell
On Wed, 7 Aug 2013 20:35:30 +0200 janI wrote: > On 7 August 2013 17:28, Ricardo Berlasso wrote: > > > 2013/8/7 FR web forum > > > > > I pull up this issue. > > > The error occurs again since two weeks. > > > > > > > > Today, forums alternate between error 1040 and being slower than a snail. >

Re: Forums down (SQL error: Too many connections [1040])

2013-08-07 Thread janI
On 7 August 2013 17:28, Ricardo Berlasso wrote: > 2013/8/7 FR web forum > > > I pull up this issue. > > The error occurs again since two weeks. > > > > > Today, forums alternate between error 1040 and being slower than a snail. > It is not possible to access them right now. > I think you have so

Re: Forums down (SQL error: Too many connections [1040])

2013-08-07 Thread Ricardo Berlasso
2013/8/7 FR web forum > I pull up this issue. > The error occurs again since two weeks. > > Today, forums alternate between error 1040 and being slower than a snail. It is not possible to access them right now. Regards Ricardo > >For interested look at: > > >INFRA-6097 which request mysql opt

Re: Forums down (SQL error: Too many connections [1040])

2013-08-07 Thread FR web forum
I pull up this issue. The error occurs again since two weeks. >For interested look at: >INFRA-6097 which request mysql optimization and >INFRA-6098 which request httpd/ats/php optimization >They are assigned to me, but when I do it, I need somebody to help >test...any volunteers ?

Re: Forums down (SQL error: Too many connections [1040])

2013-04-02 Thread janI
For interested look at: INFRA-6097 which request mysql optimization and INFRA-6098 which request httpd/ats/php optimization They are assigned to me, but when I do it, I need somebody to help test...any volunteers ? rgds jan I. On 2 April 2013 13:03, imacat wrote: > Waoh... You are awesome!

Re: Forums down (SQL error: Too many connections [1040])

2013-04-02 Thread imacat
Waoh... You are awesome! On 2013/04/02 15:22, janI said: > HI. > > I have now been on the forum vm, testing my new access. > > While I was in there I made a couple of observations: > > 1) number of apache work thread > mysql max_connections, which is generally > a bad idea. The number of work t

Re: Forums down (SQL error: Too many connections [1040])

2013-04-02 Thread janI
HI. I have now been on the forum vm, testing my new access. While I was in there I made a couple of observations: 1) number of apache work thread > mysql max_connections, which is generally a bad idea. The number of work tasks is higher than the actual load calls for, so the work parameter shoul

Re: Forums down (SQL error: Too many connections [1040])

2013-03-25 Thread FR web forum
Well, it's 11 o'clock in the morning and MySQL is outage. :-( - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Forums down (SQL error: Too many connections [1040])

2013-03-23 Thread Rob Weir
On Mar 23, 2013, at 7:24 AM, Hagar Delest wrote: > Le 22/03/2013 23:35, Rob Weir a écrit : >> On Fri, Mar 22, 2013 at 5:53 PM, Hagar Delest >> wrote: >>> But there is something I don't catch: the forum has been running fine for >>> the 5 previous years. Has any change been made to the system re

Re: Forums down (SQL error: Too many connections [1040])

2013-03-23 Thread Andrea Pescetti
Hagar Delest wrote: Le 22/03/2013 23:35, Rob Weir a écrit : Didn't we just run into an attachment size limitation right before this happened? Only in one of the NL area, it was fixed by some clean up and anyway this can be easily changed from the admin panel. No need of specific access and no l

Re: Forums down (SQL error: Too many connections [1040])

2013-03-23 Thread Hagar Delest
Le 22/03/2013 23:35, Rob Weir a écrit : On Fri, Mar 22, 2013 at 5:53 PM, Hagar Delest wrote: But there is something I don't catch: the forum has been running fine for the 5 previous years. Has any change been made to the system recently? I can't see why it should suddenly stop working like that

Re: Forums down (SQL error: Too many connections [1040])

2013-03-22 Thread Rob Weir
On Fri, Mar 22, 2013 at 5:53 PM, Hagar Delest wrote: > Le 22/03/2013 13:10, Rob Weir a écrit : > >> I know it upset some when I said it originally, but this is why I said >> in the website strategic plan wilki page that one of our biggest risks >> is: >> >> "Sustainability concerns due to our use

Re: Forums down (SQL error: Too many connections [1040])

2013-03-22 Thread Hagar Delest
Le 22/03/2013 13:10, Rob Weir a écrit : I know it upset some when I said it originally, but this is why I said in the website strategic plan wilki page that one of our biggest risks is: "Sustainability concerns due to our use of unsupported applications (from Apache Infra perspective), including

Re: Forums down (SQL error: Too many connections [1040])

2013-03-22 Thread Rob Weir
On Fri, Mar 22, 2013 at 7:57 AM, Rory O'Farrell wrote: > Down again 20130322 1145 UTC > I know it upset some when I said it originally, but this is why I said in the website strategic plan wilki page that one of our biggest risks is: "Sustainability concerns due to our use of unsupported applica

Re: Forums down (SQL error: Too many connections [1040])

2013-03-22 Thread Rory O'Farrell
Down again 20130322 1145 UTC -- Rory O'Farrell - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Forums down (SQL error: Too many connections [1040])

2013-03-21 Thread Dave Fisher
The community still needs a LAMP / MySQL sysadmin to check the tuning so that connection leaks don't take it down later (or sooner) If someone in the project did the work we should be informed. Thanks, Dave On Mar 21, 2013, at 10:14 AM, FR web forum wrote: > Well, the forums are fluids now (se

Re: Forums down (SQL error: Too many connections [1040])

2013-03-21 Thread FR web forum
Well, the forums are fluids now (seems to be good since 01:00pm UTC+1). Who is the pixie or the little fairy? Congratulations to this mysterious wizard. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additiona

Re: Forums down (SQL error: Too many connections [1040])

2013-03-21 Thread Andrea Pescetti
FR web forum wrote: Result of my dialog with #asfinfra ... The issue is that MySQL has not been tuned and needs to be. You should contact the OOO community. OK, even though this does not explain why the forum performance degraded only in the last weeks. Infra is right in saying that they can

Re: Forums down (SQL error: Too many connections [1040])

2013-03-21 Thread Alexander Thurgood
Le 20/03/13 21:14, Hagar Delest a écrit : > With each passing day, we lose users that >> search some help on other forums. > Not only that, but the wealth of information that is already there is no longer accessible. And yes, before the switch to new hosting, I can not remember it ever being do

Re: Forums down (SQL error: Too many connections [1040])

2013-03-21 Thread FR web forum
- Mail original - De: "Dave Fisher" >In these situations it is best to get on irc #asfinfra and ask >in general about it. Imacat might be there but there is usually >at least one infra person on line. Result of my dialog with #asfinfra [11:15] <@pctony> fr__: this service is technicall

Re: Forums down (SQL error: Too many connections [1040])

2013-03-21 Thread FR web forum
>> It has worked fine the 5 previous years. So there must be somthing that >> has been done on the hosting part. Maybe because PhpBB is outdated now. We are still in 3.0.9 instead of 3.0.11 >I was probably just lucky, but I never saw the forum offline >these days. Maybe because you stop just at

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread Dave Fisher
In these situations it is best to get on irc #asfinfra and ask in general about it. Imacat might be there but there is usually at least one infra person on line. Sent from my iPhone On Mar 20, 2013, at 2:15 PM, Andrea Pescetti wrote: > Hagar Delest wrote: >> It has worked fine the 5 previous

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread Rob Weir
On Wed, Mar 20, 2013 at 12:01 PM, FR web forum wrote: >>If this is going to be a regular occurrence > Sorry but the best thing to do is to fix this issue. Yes, that would be best. But this does not appear to be happening very quickly, so my suggestion is one way to keep the users informed while

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread Andrea Pescetti
Hagar Delest wrote: It has worked fine the 5 previous years. So there must be somthing that has been done on the hosting part. Someone must have taken action here (imacat again, maybe?) since both yesterday and today we had outages and then the normal functioning was restored. I was probably

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread Hagar Delest
Le 20/03/2013 17:01, FR web forum a écrit : If this is going to be a regular occurrence Sorry but the best thing to do is to fix this issue. Since a couple of days, I asked to check the MySQL max_connections parameter. Somebody did it? With each passing day, we lose users that search some help

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread FR web forum
>If this is going to be a regular occurrence Sorry but the best thing to do is to fix this issue. Since a couple of days, I asked to check the MySQL max_connections parameter. Somebody did it? With each passing day, we lose users that search some help on other forums. --

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread Rob Weir
On Wed, Mar 20, 2013 at 5:22 AM, Rory O'Farrell wrote: > On Wed, 20 Mar 2013 09:07:01 + > Rory O'Farrell wrote: > >> En Forum down again just now. >> > > En-Forum now back - only a 15 min outage this time! > If this is going to be a regular occurrence, I wonder if we should put some sort of

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread hagar . delest
Forum back but not very stable. Hagar > Message du 20/03/13 10:22 > De : "Rory O'Farrell" > A : dev@openoffice.apache.org > Copie à : > Objet : Re: Forums down (SQL error: Too many connections [1040]) > > On Wed, 20 Mar 2013 09:07:01 + > Rory O'F

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread Rory O'Farrell
On Wed, 20 Mar 2013 09:07:01 + Rory O'Farrell wrote: > En Forum down again just now. > En-Forum now back - only a 15 min outage this time! -- Rory O'Farrell - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.or

Re: Forums down (SQL error: Too many connections [1040])

2013-03-20 Thread Rory O'Farrell
En Forum down again just now. -- Rory O'Farrell - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread Hagar Delest
Le 20/03/2013 00:02, RGB ES a écrit : ES forum is working at normal speed too. EN seems fine too. According to the statistics, that made almost 11 hours down. Hagar - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread RGB ES
2013/3/19 F C. Costero > The English forum is back up. I haven't checked any others. > Francis > ES forum is working at normal speed too. Regards Ricardo > > > On Tue, Mar 19, 2013 at 9:31 AM, RGB ES wrote: > > > 2013/3/19 FR web forum > > > > > Nagios monitore forums with HTML and SSL ser

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread F C. Costero
The English forum is back up. I haven't checked any others. Francis On Tue, Mar 19, 2013 at 9:31 AM, RGB ES wrote: > 2013/3/19 FR web forum > > > Nagios monitore forums with HTML and SSL services. > > But it's the MySQL deamon that must be watched. > > > > Indeed: Forums are green on the statu

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread RGB ES
2013/3/19 FR web forum > Nagios monitore forums with HTML and SSL services. > But it's the MySQL deamon that must be watched. > Indeed: Forums are green on the status page now, but they do not work. Regards Ricardo > > > > -

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread FR web forum
Nagios monitore forums with HTML and SSL services. But it's the MySQL deamon that must be watched. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread Andrea Pescetti
hagar.delest wrote: Forums are down again. Same error. Maybe for one hour now. This is monitored at http://status.apache.org/ (it is listed under "ooo-forums.apache.org"). The red status only means that the relevant people have already received a notification, not that someone is actively wor

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread hagar . delest
Message du 19/03/13 12:38 > De : "Rob Weir" > A : dev@openoffice.apache.org, hagar.del...@laposte.net > Copie à : > Objet : Re: Forums down (SQL error: Too many connections [1040]) > > 2013/3/19 : > > Forums are down again. Same error. > > Maybe for one hour

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread Rob Weir
2013/3/19 : > Forums are down again. Same error. > Maybe for one hour now. > I assume we have forum admins working on this? -Rob > Hagar > - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional command

Re: Forums down (SQL error: Too many connections [1040])

2013-03-19 Thread hagar . delest
Forums are down again. Same error. Maybe for one hour now. Hagar Laposte.net, messager officiel du Rallye des Gazelles en 2013 ! Pour suivre le Rallye Aïcha des Gazelles et soutenir les participantes, cliquez sur www.laposte.net/thematique/rallye-des-gazelles

Re: Forums down (SQL error: Too many connections [1040])

2013-03-18 Thread RGB ES
Right now, EN and ES forums are quite unstable, giving the "too many connections" error every now and then, and being quite slow the rest of the time. 2013/3/18 FR web forum > Still at the same period (since 11:00am this monday). > > >But, this morning 11:00am (UTC+1), the FR forum is slow agai

Re: Forums down (SQL error: Too many connections [1040])

2013-03-18 Thread FR web forum
Still at the same period (since 11:00am this monday). >But, this morning 11:00am (UTC+1), the FR forum is slow again. >>> Maybe the MySQL max_connections parameter must be increase. >Do you have check this point? - To unsubscri

Re: Forums down (SQL error: Too many connections [1040])

2013-03-15 Thread Rob Weir
On Fri, Mar 15, 2013 at 1:54 PM, wrote: > It should be much higher on the EN forum. > The 294 figure (statistics information at the bottom of the forum index page) > is an instantaneous measurement. > Do we know what the timeout is for a connection? I don't know if it is the same here, but in

Re: Forums down (SQL error: Too many connections [1040])

2013-03-15 Thread hagar . delest
It should be much higher on the EN forum. The 294 figure (statistics information at the bottom of the forum index page) is an instantaneous measurement. Hagar > De : "FR web forum" > But, in FR forum, we have specific statistics. > In 2012: average of 6,892 visits per day > In 2013 (for 3 first

Re: Forums down (SQL error: Too many connections [1040])

2013-03-15 Thread FR web forum
>Reports from other forums using phpBB software suggest that overflowing >log files can cause this problem. Maybe >I note that the maximum number of users listed by the Forum reports has >remained static at 294 since 25 October 2012; I have never observed a >number of users close to that figu

Re: Forums down (SQL error: Too many connections [1040])

2013-03-15 Thread Rory O'Farrell
On Fri, 15 Mar 2013 11:04:09 +0100 (CET) FR web forum wrote: > >The forum are back now. > Thanks imacat > But, this morning 11:00am (UTC+1), the FR forum is slow again. > > >>> Maybe the MySQL max_connections parameter must be increase. > Do you have check this point? > Reports from other forum

Re: Forums down (SQL error: Too many connections [1040])

2013-03-15 Thread FR web forum
>The forum are back now. Thanks imacat But, this morning 11:00am (UTC+1), the FR forum is slow again. >>> Maybe the MySQL max_connections parameter must be increase. Do you have check this point? - To unsubscribe, e-mail: dev-uns

Re: Forums down (SQL error: Too many connections [1040])

2013-03-14 Thread imacat
Dear all, The forum are back now. On 2013/03/15 00:24, imacat said: > Hmm... we seem to lost the forums now. > I'd written to the infra team for help on reboot. We shall see later. > > On 2013/03/13 18:22, janI said: >> HI. >> >> It sounds more like a mismatch between the number of httpd wo

Re: Forums down (SQL error: Too many connections [1040])

2013-03-14 Thread imacat
Hmm... we seem to lost the forums now. I'd written to the infra team for help on reboot. We shall see later. On 2013/03/13 18:22, janI said: > HI. > > It sounds more like a mismatch between the number of httpd worker tasks and > mysql max_connections. It is important that max_connections is high

Re: Forums down (SQL error: Too many connections [1040])

2013-03-13 Thread janI
HI. It sounds more like a mismatch between the number of httpd worker tasks and mysql max_connections. It is important that max_connections is higher than the number of work tasks (or with fast-cgi the number of php processes). When correctly configured you will just experience longer reply times,

Re: Forums down (SQL error: Too many connections [1040])

2013-03-13 Thread FR web forum
Hello, Forums are outage again this morning with same error. Maybe the MySQL max_connections parameter must be increase. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@ope

Forums down (SQL error: Too many connections [1040])

2013-03-12 Thread Hagar Delest
Hi, The forums have been running rather slowly recently. There are even error messages on the FR forum. Right now I can't reach the EN forum... And I confirm the error message: General Error SQL ERROR [ mysqli ] Too many connections [1040] Could someone have a look please? TIA Hagar -