You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Ricardo Berlasso <rg...@gmail.com> on 2013/07/24 13:15:12 UTC

Blog, forums and extension sites down

Checking on http://monitoring.apache.org/status/ I can only see the blog in
red, but the forums, which are in green there, do not work:

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an
administrator if this problem persists.


The extension site gives

Error
The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[42000] [1226] User 'a689097admin' has exceeded the
'max_user_connections' resource (current value: 100) in
lock_may_be_available() (line 167 of
/home/project-web/aoo-extensions/htdocs/includes/lock.inc).


Regards
Ricardo

Re: Blog, forums and extension sites down

Posted by janI <ja...@apache.org>.
On 24 July 2013 16:40, Ricardo Berlasso <rg...@gmail.com> wrote:

> 2013/7/24 Roberto Galoppini <ro...@gmail.com>
>
> > 2013/7/24 Ricardo Berlasso <rg...@gmail.com>
> >
> > > Checking on http://monitoring.apache.org/status/ I can only see the
> blog
> > > in
> > > red, but the forums, which are in green there, do not work:
> > >
> > > General Error
> > > SQL ERROR [ mysqli ]
> > >
> > > Too many connections [1040]
> > >
> > > An sql error occurred while fetching this page. Please contact an
> > > administrator if this problem persists.
> > >
> > >
> > > The extension site gives
> > >
> > > Error
> > > The website encountered an unexpected error. Please try again later.
> > > Error message
> > > PDOException: SQLSTATE[42000] [1226] User 'a689097admin' has exceeded
> the
> > > 'max_user_connections' resource (current value: 100) in
> > > lock_may_be_available() (line 167 of
> > > /home/project-web/aoo-extensions/htdocs/includes/lock.inc).
> > >
> >
> > Our MySQL server was unable to serve additional requests, and we
> restarted
> > the server and cleaned the cache table. While our caching system is
> > rebuilding it might be slow.
> >
> > We are now investigating the root cause, that seems to be related to an
> > application issue. We'll keep monitoring the system while working on
> fixing
> > such issue.
> >
> > Roberto
> >
>
> Thanks, Roberto!
>
> Blog seems to work now, but the forum is unstable. Sometimes it is possible
> to connect, but one second later fails again. The status page I linked
> above continuously change between red and green for ooo-forums.apache.org,
> but the truth is that forums are not usable.
>

In general it is a mysql overload problem, this problem then have a number
of sideeffects.

I hope our forum admin, will have a look at in some hours.

rgds
jan I.


>
> Regards
> Ricardo
>
>
> >
> >
> >
> > >
> > >
> > > Regards
> > > Ricardo
> > >
> >
>

Re: Blog, forums and extension sites down

Posted by Ricardo Berlasso <rg...@gmail.com>.
2013/7/24 Roberto Galoppini <ro...@gmail.com>

> 2013/7/24 Ricardo Berlasso <rg...@gmail.com>
>
> > Checking on http://monitoring.apache.org/status/ I can only see the blog
> > in
> > red, but the forums, which are in green there, do not work:
> >
> > General Error
> > SQL ERROR [ mysqli ]
> >
> > Too many connections [1040]
> >
> > An sql error occurred while fetching this page. Please contact an
> > administrator if this problem persists.
> >
> >
> > The extension site gives
> >
> > Error
> > The website encountered an unexpected error. Please try again later.
> > Error message
> > PDOException: SQLSTATE[42000] [1226] User 'a689097admin' has exceeded the
> > 'max_user_connections' resource (current value: 100) in
> > lock_may_be_available() (line 167 of
> > /home/project-web/aoo-extensions/htdocs/includes/lock.inc).
> >
>
> Our MySQL server was unable to serve additional requests, and we restarted
> the server and cleaned the cache table. While our caching system is
> rebuilding it might be slow.
>
> We are now investigating the root cause, that seems to be related to an
> application issue. We'll keep monitoring the system while working on fixing
> such issue.
>
> Roberto
>

Thanks, Roberto!

Blog seems to work now, but the forum is unstable. Sometimes it is possible
to connect, but one second later fails again. The status page I linked
above continuously change between red and green for ooo-forums.apache.org,
but the truth is that forums are not usable.

Regards
Ricardo


>
>
>
> >
> >
> > Regards
> > Ricardo
> >
>

Re: Blog, forums and extension sites down

Posted by Hagar Delest <ha...@laposte.net>.
Forum down again. Right now.

Hagar

Le 25/07/2013 09:50, Rory O'Farrell a écrit :

> On Thu, 25 Jul 2013 08:32:52 +0200
> Hagar Delest <ha...@laposte.net> wrote:
>
>> EN forum is very slow.
>> The too many connections error may come back soon. Do we have to wait for imacat for that?
>>
> Just now (08:50 UTC+1) En-Forum off line again.
> Prior to that, as Hagar says, it was very very slow.
>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Re: Blog, forums and extension sites down

Posted by Rory O'Farrell <of...@iol.ie>.
On Thu, 25 Jul 2013 08:32:52 +0200
Hagar Delest <ha...@laposte.net> wrote:

> EN forum is very slow.
> The too many connections error may come back soon. Do we have to wait for imacat for that?
> 
Just now (08:50 UTC+1) En-Forum off line again.
Prior to that, as Hagar says, it was very very slow.

-- 
Rory O'Farrell <of...@iol.ie>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Re: Blog, forums and extension sites down

Posted by Hagar Delest <ha...@laposte.net>.
EN forum is very slow.
The too many connections error may come back soon. Do we have to wait for imacat for that?

Hagar


Le 24/07/2013 23:39, Andrea Pescetti a écrit :

> Hagar Delest wrote:
>> For the record, forums still down (9 hrs now).
>
> I see everything OK now (blogs, extensions, forums).
>
> Forums have indeed been down until about one hour ago, then Infra restarted the machine, then the machine was up but with extremely high load (I have access to it, but not full privileges) and now load is much lower and the forums are working normally for me.
>
> Regards,
>    Andrea.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Re: Blog, forums and extension sites down

Posted by Andrea Pescetti <pe...@apache.org>.
Hagar Delest wrote:
> For the record, forums still down (9 hrs now).

I see everything OK now (blogs, extensions, forums).

Forums have indeed been down until about one hour ago, then Infra 
restarted the machine, then the machine was up but with extremely high 
load (I have access to it, but not full privileges) and now load is much 
lower and the forums are working normally for me.

Regards,
   Andrea.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Re: Blog, forums and extension sites down

Posted by Hagar Delest <ha...@laposte.net>.
For the record, forums still down (9 hrs now).
This and the signature with the new string 4.0.0 (and 4* to cover future releases) need a quick fix.

Hagar


Le 24/07/2013 17:39, Roberto Galoppini a écrit :

> 2013/7/24 Rory O'Farrell <of...@iol.ie>
>
>> On Wed, 24 Jul 2013 16:33:13 +0200
>> Roberto Galoppini <ro...@gmail.com> wrote:
>>
>>> 2013/7/24 Ricardo Berlasso <rg...@gmail.com>
>>>
>>>> Checking on http://monitoring.apache.org/status/ I can only see the
>> blog
>>>> in
>>>> red, but the forums, which are in green there, do not work:
>>>>
>>>> General Error
>>>> SQL ERROR [ mysqli ]
>>>>
>>>> Too many connections [1040]
>>>>
>>>> An sql error occurred while fetching this page. Please contact an
>>>> administrator if this problem persists.
>>>>
>>>>
>>>> The extension site gives
>>>>
>>>> Error
>>>> The website encountered an unexpected error. Please try again later.
>>>> Error message
>>>> PDOException: SQLSTATE[42000] [1226] User 'a689097admin' has exceeded
>> the
>>>> 'max_user_connections' resource (current value: 100) in
>>>> lock_may_be_available() (line 167 of
>>>> /home/project-web/aoo-extensions/htdocs/includes/lock.inc).
>>>>
>>>
>>> Our MySQL server was unable to serve additional requests, and we
>> restarted
>>> the server and cleaned the cache table. While our caching system is
>>> rebuilding it might be slow.
>>>
>>> We are now investigating the root cause, that seems to be related to an
>>> application issue. We'll keep monitoring the system while working on
>> fixing
>>> such issue.
>>>
>>> Roberto
>>>
>>
>> It would be of interest (but irrelevant to the immediate problem) to know
>> if the server failure was due to a peak or overload possibly arising from
>> the AOO4.0 release.
>>
>
> We found and fixed the problem that was causing AOOE and then AOOT to stop
> working. Actually the extra traffic makes it happen faster, but it wasn't
> the root cause.
>
> Roberto
>
>
>
>>
>> --
>> Rory O'Farrell <of...@iol.ie>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: dev-help@openoffice.apache.org
>>
>>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Re: Blog, forums and extension sites down

Posted by Roberto Galoppini <ro...@gmail.com>.
2013/7/24 Rory O'Farrell <of...@iol.ie>

> On Wed, 24 Jul 2013 16:33:13 +0200
> Roberto Galoppini <ro...@gmail.com> wrote:
>
> > 2013/7/24 Ricardo Berlasso <rg...@gmail.com>
> >
> > > Checking on http://monitoring.apache.org/status/ I can only see the
> blog
> > > in
> > > red, but the forums, which are in green there, do not work:
> > >
> > > General Error
> > > SQL ERROR [ mysqli ]
> > >
> > > Too many connections [1040]
> > >
> > > An sql error occurred while fetching this page. Please contact an
> > > administrator if this problem persists.
> > >
> > >
> > > The extension site gives
> > >
> > > Error
> > > The website encountered an unexpected error. Please try again later.
> > > Error message
> > > PDOException: SQLSTATE[42000] [1226] User 'a689097admin' has exceeded
> the
> > > 'max_user_connections' resource (current value: 100) in
> > > lock_may_be_available() (line 167 of
> > > /home/project-web/aoo-extensions/htdocs/includes/lock.inc).
> > >
> >
> > Our MySQL server was unable to serve additional requests, and we
> restarted
> > the server and cleaned the cache table. While our caching system is
> > rebuilding it might be slow.
> >
> > We are now investigating the root cause, that seems to be related to an
> > application issue. We'll keep monitoring the system while working on
> fixing
> > such issue.
> >
> > Roberto
> >
>
> It would be of interest (but irrelevant to the immediate problem) to know
> if the server failure was due to a peak or overload possibly arising from
> the AOO4.0 release.
>

We found and fixed the problem that was causing AOOE and then AOOT to stop
working. Actually the extra traffic makes it happen faster, but it wasn't
the root cause.

Roberto



>
> --
> Rory O'Farrell <of...@iol.ie>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>

Re: Blog, forums and extension sites down

Posted by Rory O'Farrell <of...@iol.ie>.
On Wed, 24 Jul 2013 16:33:13 +0200
Roberto Galoppini <ro...@gmail.com> wrote:

> 2013/7/24 Ricardo Berlasso <rg...@gmail.com>
> 
> > Checking on http://monitoring.apache.org/status/ I can only see the blog
> > in
> > red, but the forums, which are in green there, do not work:
> >
> > General Error
> > SQL ERROR [ mysqli ]
> >
> > Too many connections [1040]
> >
> > An sql error occurred while fetching this page. Please contact an
> > administrator if this problem persists.
> >
> >
> > The extension site gives
> >
> > Error
> > The website encountered an unexpected error. Please try again later.
> > Error message
> > PDOException: SQLSTATE[42000] [1226] User 'a689097admin' has exceeded the
> > 'max_user_connections' resource (current value: 100) in
> > lock_may_be_available() (line 167 of
> > /home/project-web/aoo-extensions/htdocs/includes/lock.inc).
> >
> 
> Our MySQL server was unable to serve additional requests, and we restarted
> the server and cleaned the cache table. While our caching system is
> rebuilding it might be slow.
> 
> We are now investigating the root cause, that seems to be related to an
> application issue. We'll keep monitoring the system while working on fixing
> such issue.
> 
> Roberto
> 

It would be of interest (but irrelevant to the immediate problem) to know if the server failure was due to a peak or overload possibly arising from the AOO4.0 release.

-- 
Rory O'Farrell <of...@iol.ie>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Re: Blog, forums and extension sites down

Posted by Roberto Galoppini <ro...@gmail.com>.
2013/7/24 Ricardo Berlasso <rg...@gmail.com>

> Checking on http://monitoring.apache.org/status/ I can only see the blog
> in
> red, but the forums, which are in green there, do not work:
>
> General Error
> SQL ERROR [ mysqli ]
>
> Too many connections [1040]
>
> An sql error occurred while fetching this page. Please contact an
> administrator if this problem persists.
>
>
> The extension site gives
>
> Error
> The website encountered an unexpected error. Please try again later.
> Error message
> PDOException: SQLSTATE[42000] [1226] User 'a689097admin' has exceeded the
> 'max_user_connections' resource (current value: 100) in
> lock_may_be_available() (line 167 of
> /home/project-web/aoo-extensions/htdocs/includes/lock.inc).
>

Our MySQL server was unable to serve additional requests, and we restarted
the server and cleaned the cache table. While our caching system is
rebuilding it might be slow.

We are now investigating the root cause, that seems to be related to an
application issue. We'll keep monitoring the system while working on fixing
such issue.

Roberto



>
>
> Regards
> Ricardo
>