openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: ooo-forums downtime
Date Wed, 10 Jan 2018 11:15:34 GMT
However such things could (IMO should) be noted in upcoming
maintenance (i.e. scheduled downtime)

On 10 January 2018 at 09:53, Greg Stein <gstein@gmail.com> wrote:
> status.apache.org reports services that are *down*, rather than individual
> bugs/problems.
>
> Thanks,
> -g
>
> On Wed, Jan 10, 2018 at 2:03 AM, FR web forum <oooforum@free.fr> wrote:
>>
>> I note that give you this information next time
>> Why these outages are not reported in http://status.apache.org
>>
>>
>> ----- Mail original -----
>> > De: "Chris Lambertus" <cml@apache.org>
>> > À: private@infra.apache.org
>> > Cc: "Andrea Pescetti" <pescetti@apache.org>, 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 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, 2018, at 5:49 PM, Chris Lambertus <cml@apache.org> wrote:
>> > >
>> > >
>> > > 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 <pescetti@apache.org>
>> > >> wrote:
>> > >>
>> > >> 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 ]
>> > >>>
>> > >>> Expression #1 of ORDER BY clause is not in SELECT list,
>> > >>> references
>> > >>> column 'forumaoo_fr.t.topic_last_post_time' which is not in
>> > >>> SELECT list;
>> > >>> this is incompatible with DISTINCT [3065]
>> > >>>
>> > >>> And in Italian:
>> > >>> SQL ERROR [ mysqli ]
>> > >>>
>> > >>> Expression #1 of ORDER BY clause is not in SELECT list,
>> > >>> references
>> > >>> column 'forumaoo_it.t.topic_last_post_time' which is not in
>> > >>> SELECT list;
>> > >>> this is incompatible with DISTINCT [3065]
>> > >>>
>> > >>> Hagar
>> > >>>
>> > >>>
>> > >>> Le 04/01/2018 à 21:33, Hagar Delest a écrit :
>> > >>>> 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 not in
>> > >>>> SELECT
>> > >>>> list; this is incompatible with DISTINCT [3065]
>> > >>>>
>> > >>>> SQL
>> > >>>>
>> > >>>> SELECT DISTINCT SQL_CALC_FOUND_ROWS t.topic_id FROM
>> > >>>> phpbb_en_topics t,
>> > >>>> phpbb_en_posts p WHERE MATCH (p.post_subject, p.post_text)
>> > >>>> AGAINST
>> > >>>> ('+solved ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER
>> > >>>> BY
>> > >>>> t.topic_last_post_time DESC LIMIT 250
>> > >>>>
>> > >>>> The same search is fine when set to display results as posts.
>> > >>>>
>> > >>>> Could you have a look please?
>> > >>>> Thanks
>> > >>>>
>> > >>>> Hagar
>> > >>>>
>> > >>>>
>> > >>>> Le 04/01/2018 à 03:30, Chris Lambertus a écrit :
>> > >>>>>> On Jan 1, 2018, at 2:24 PM, Chris Lambertus <cml@apache.org>
>> > >>>>>> 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
>> > >>>>>>
>> > >>>>>>
>> > >>>>>
>> > >>>>> Hi all,
>> > >>>>>
>> > >>>>> This move has been completed. Spot checks on the forums
look
>> > >>>>> good.
>> > >>>>>
>> > >>>>> -Chris
>> > >>>>>
>> > >>>>
>> > >>>
>> > >>>
>> > >>>
>> > >>> ---------------------------------------------------------------------
>> > >>> 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


Mime
View raw message