Re: ooo-forums downtime

2018-01-10 Thread Chris Lambertus
Unfortunately, some slowdowns are inevitable. We cannot keep the old database hardware alive, and this is a necessary transition step until we can move the ooo-forums phpBB software to a new host. > On Jan 10, 2018, at 2:49 PM, Hagar Delest wrote: > > Hi, > > Thanks for the bug fix related

Re: ooo-forums downtime

2018-01-10 Thread Hagar Delest
Hi, Thanks for the bug fix related to the search by topics, this is a great news. The forum still lags compared to before the server switch. Have tried to clean the cookies but no change. Hagar Le 10/01/2018 à 18:48, Andrea Pescetti a écrit : On 10/01/2018 Greg Stein wrote:> status.apache.or

Re: ooo-forums downtime

2018-01-10 Thread Chris Lambertus
All, There is monitoring for ooo-forums. As I stated, this outage did not trip the monitors. The duration was likely too short. If the duration was noted to be longer than 5 minutes or so, it’s possible there is a problem with the monitoring that needs to be looked into, but when I took the for

Re: ooo-forums downtime

2018-01-10 Thread Andrea Pescetti
On 10/01/2018 Greg Stein wrote:> status.apache.org reports services that are *down*, rather than individual bugs/problems. Just to be clear, we had two different issues here: 1. Some advanced search options broke due to incompatibility with the new SQL server (and this is fixed, which is grea

Re: ooo-forums downtime

2018-01-10 Thread sebb
.@infra.apache.org >> > Cc: "Andrea Pescetti" , dev@openoffice.apache.org >> > Envoyé: Mercredi 10 Janvier 2018 03:22:04 >> > Objet: Re: ooo-forums downtime >> > >> > >> > I’ve pushed a change which fixes this on the database side. I

Re: ooo-forums downtime

2018-01-10 Thread Greg Stein
- Mail original - > > De: "Chris Lambertus" > > À: priv...@infra.apache.org > > Cc: "Andrea Pescetti" , dev@openoffice.apache.org > > Envoyé: Mercredi 10 Janvier 2018 03:22:04 > > Objet: Re: ooo-forums downtime > > > > > > I

Re: ooo-forums downtime

2018-01-10 Thread FR web forum
10 Janvier 2018 03:22:04 > Objet: Re: ooo-forums downtime > > > I’ve pushed a change which fixes this on the database side. I also > saw the email about the forum being down yesterday, but it was a > transient problem. It would be helpful for me to know what the start > time a

Re: ooo-forums downtime

2018-01-09 Thread Chris Lambertus
I’ve pushed a change which fixes this on the database side. I also saw the email about the forum being down yesterday, but it was a transient problem. It would be helpful for me to know what the start time and duration was for any future reports of slowness or outages. -Chris > On Jan 4

Re: ooo-forums downtime

2018-01-04 Thread Chris Lambertus
There may not be anything we can do about this until phpBB is upgraded. I put the wiki database move on hold until I can look into it more. > On Jan 4, 2018, at 2:42 PM, Andrea Pescetti wrote: > > CCing Chris for the two messages below. Maybe a SQL version issue? > Regards, > Andrea. > > On

Re: ooo-forums downtime

2018-01-04 Thread Andrea Pescetti
CCing Chris for the two messages below. Maybe a SQL version issue? Regards, Andrea. On 04/01/2018 21:59, Hagar Delest wrote: Note: same for the other languages (Italian anf French tested). The DISTINCT 3065 thing seems a common one: In French forum: Erreur générale SQL ERROR [ mysqli ] Expr

Re: ooo-forums downtime

2018-01-04 Thread Hagar Delest
Note: same for the other languages (Italian anf French tested). The DISTINCT 3065 thing seems a common one: In French forum: Erreur générale SQL ERROR [ mysqli ] Expression #1 of ORDER BY clause is not in SELECT list, references column 'forumaoo_fr.t.topic_last_post_time' which is not in SELEC

Re: ooo-forums downtime

2018-01-04 Thread Hagar Delest
Hi, Since the move, we noticed that when performing an advanced search that should display the results as topics, then we get an error: General Error SQL ERROR [ mysqli ] Expression #1 of ORDER BY clause is not in SELECT list, references column 'forumaoo_en.t.topic_last_post_time' which is no

Re: ooo-forums downtime

2018-01-03 Thread Chris Lambertus
> On Jan 1, 2018, at 2:24 PM, Chris Lambertus wrote: > > Hi folks, > > At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB > forum databases to a new server. The forums will be offline during this > process, and is expected to take about 2 hours. > > -Chris > ASF Infra

Re: ooo-forums downtime

2018-01-01 Thread Andrea Pescetti
Chris Lambertus wrote: This is ONLY to move the back-end MySQL database onto a new box. Thanks for the explanation. Then this is indeed low-risk and the more challenging tasks will come with https://issues.apache.org/jira/browse/INFRA-13281 which I will continue to monitor. Regards, Andr

Re: ooo-forums downtime

2018-01-01 Thread Chris Lambertus
> On Jan 1, 2018, at 2:46 PM, Andrea Pescetti wrote: > > Chris Lambertus wrote: >> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB >> forum databases to a new server. > > Can you elaborate more, or tell us what the best place for further > discussions is? This is

Re: ooo-forums downtime

2018-01-01 Thread Andrea Pescetti
Chris Lambertus wrote: At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB forum databases to a new server. Can you elaborate more, or tell us what the best place for further discussions is? This is good news in itself, but I believe I'm the only active project membe

ooo-forums downtime

2018-01-01 Thread Chris Lambertus
Hi folks, At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB forum databases to a new server. The forums will be offline during this process, and is expected to take about 2 hours. -Chris ASF Infra signature.asc Description: Message signed with OpenPGP