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 j...@apache.org wrote: On 7 August 2013 21:14, Raphael Bircher r.birc...@gmx.ch wrote: Am 07.08.13 21:04, schrieb Rory O'Farrell: On Wed, 7 Aug

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 khir...@gmail.com 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 j...@apache.org

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

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 ooofo...@free.fr 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

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

2013-08-08 Thread janI
On 8 August 2013 16:25, Rory O'Farrell ofarr...@iol.ie wrote: On Thu, 8 Aug 2013 15:59:36 +0200 (CEST) FR web forum ooofo...@free.fr 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

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.

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

2013-08-08 Thread janI
On 8 August 2013 17:13, FR web forum ooofo...@free.fr 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

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 j...@apache.org wrote: On 8 August 2013 16:25, Rory O'Farrell ofarr...@iol.ie wrote: On Thu, 8 Aug 2013 15:59:36 +0200 (CEST) FR web forum ooofo...@free.fr wrote: Seems fixed but very slow response. No, error still occurs this afternoon.

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-08-07 Thread Ricardo Berlasso
2013/8/7 FR web forum ooofo...@free.fr 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

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 j...@apache.org wrote: On 7 August 2013 17:28, Ricardo Berlasso rgb.m...@gmail.com wrote: 2013/8/7 FR web forum ooofo...@free.fr I pull up this issue. The error occurs again since two weeks. Today, forums

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

2013-08-07 Thread janI
On 7 August 2013 21:14, Raphael Bircher r.birc...@gmx.ch wrote: Am 07.08.13 21:04, schrieb Rory O'Farrell: On Wed, 7 Aug 2013 20:35:30 +0200 janI j...@apache.org wrote: On 7 August 2013 17:28, Ricardo Berlasso rgb.m...@gmail.com wrote: 2013/8/7 FR web forum ooofo...@free.fr I pull

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

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 tasks is

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 ima...@mail.imacat.idv.tw wrote:

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 hagar.del...@laposte.net 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

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 hagar.del...@laposte.net wrote: Le 22/03/2013 23:35, Rob Weir a écrit : On Fri, Mar 22, 2013 at 5:53 PM, Hagar Delest hagar.del...@laposte.net wrote: But there is something I don't catch: the forum has been running fine for the 5 previous years. Has

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

2013-03-22 Thread Rory O'Farrell
Down again 20130322 1145 UTC -- Rory O'Farrell ofarr...@iol.ie - 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-22 Thread Rob Weir
On Fri, Mar 22, 2013 at 7:57 AM, Rory O'Farrell ofarr...@iol.ie 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

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 5:53 PM, Hagar Delest hagar.del...@laposte.net 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

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 the

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

2013-03-21 Thread FR web forum
- Mail original - De: Dave Fisher w...@apache.org 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

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 down

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

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

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 ofarr...@iol.ie - 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-20 Thread Rory O'Farrell
On Wed, 20 Mar 2013 09:07:01 + Rory O'Farrell ofarr...@iol.ie wrote: En Forum down again just now. En-Forum now back - only a 15 min outage this time! -- Rory O'Farrell ofarr...@iol.ie - To unsubscribe, e-mail:

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'Farrell wrote: En Forum down again just now. En

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 ofarr...@iol.ie wrote: On Wed, 20 Mar 2013 09:07:01 + Rory O'Farrell ofarr...@iol.ie 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

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 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 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 Rob Weir
On Wed, Mar 20, 2013 at 12:01 PM, FR web forum ooofo...@free.fr 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

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 pesce...@apache.org wrote: Hagar Delest wrote: It has worked

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-19 Thread Rob Weir
2013/3/19 hagar.del...@laposte.net: 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

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

2013-03-19 Thread hagar . delest
/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 now. I assume we have forum admins working on this? -Rob

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

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 RGB ES
2013/3/19 FR web forum ooofo...@free.fr 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 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 rgb.m...@gmail.com wrote: 2013/3/19 FR web forum ooofo...@free.fr Nagios monitore forums with HTML and SSL services. But it's the MySQL deamon that must be watched. Indeed:

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

2013-03-19 Thread RGB ES
2013/3/19 F C. Costero fjcc.apa...@gmail.com 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 rgb.m...@gmail.com wrote: 2013/3/19 FR web forum ooofo...@free.fr

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:

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 ooofo...@free.fr Still at the same period (since 11:00am this monday). But, this morning 11:00am (UTC+1), the FR 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:

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 ooofo...@free.fr 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

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 figure

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 Rob Weir
On Fri, Mar 15, 2013 at 1:54 PM, hagar.del...@laposte.net 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

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 higher

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 worker

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