[Systems] MySQL timeout execution errors and other errors on wiki.sugarlabs.org in the last ~3 days.

[Alex Perez]

James,
> James Cameron <mailto:quozl at laptop.org>
> April 29, 2020 at 5:20 PM
> Thanks Alex.
>
> I'm in even worse situation with wiki.laptop.org, and last looked into
> this in December 2018, so I don't think I can be of any help.  What
> blocked my upgrade was use of the Semantic MediaWiki plugin, but I
> don't know if Sugar Labs Wiki is using that.
Thanks. We do not appear to be using Semantic MediaWiki on the Sugar 
Labs wiki, though we are using two-dozen other extensions.

It does look like there's a current version of Semantic Mediawiki, 
3.1.6, released April 19 of this year:
https://www.semantic-mediawiki.org/wiki/Semantic_MediaWiki_3.1.6_released
> Here's my list of links in my notes of the day.
>
> https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Debian_or_Ubuntu
> https://www.mediawiki.org/wiki/Manual:Moving_a_wiki
> https://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki
> https://www.mediawiki.org/wiki/Manual:Upgrading#How_do_I_upgrade_from_a_really_old_version?_In_one_step,_or_in_several_steps?
> https://www.semantic-mediawiki.org/wiki/Semantic_MediaWiki
>
> On Wed, Apr 29, 2020 at 05:08:59PM -0700, Alex Perez wrote:
>> on Sunjammer, we are still running Mediawiki version 1.28.1, released in April
>> of 2017. The last release in the 1.28 sequence was 1.28.3, released in November
>> of 2017. Sunjammer is running PHP 7.3.6, as provided with Ubuntu 16.04, despite
>> the fact that Sunjammer is running Ubuntu 18.04, according to 'lsb_release -a'
>>
>> Over the last few days, we've had quite a few errors:
>>
>> $grep -i rror /var/log/apache2/wiki.sugarlabs.org/wiki.sugarlabs.org-error.log
>> | grep -i "Maximum execution time of 30 seconds exceeded" | wc -l
>> 35
>> $ grep -i rror wiki.sugarlabs.org-error.log | grep -i "unable to stat" | wc -l
>> 264
>>
>> 20 of these errors are on various lines of /srv/www-sugarlabs/wiki/includes/
>> libs/rdbms/database/Database.php
>> The remaining fifteen were timeouts in the related /srv/www-sugarlabs/wiki/
>> includes/libs/rdbms/database/DatabaseMysqli.php on line 46
>>
>> Since this is an old version of MediaWiki, with known vulnerabilities, I would
>> like to propose we update it immediately. I am not comfortable doing so
>> unilaterally. If anyone is willing to help, and has any level of familiarity
>> with how we have deployed MediaWiki in the past, please assist.
>> _______________________________________________
>> Systems mailing list
>> Systems at lists.sugarlabs.org
>> http://lists.sugarlabs.org/listinfo/systems
> Alex Perez <mailto:aperez at alexperez.com>
> April 29, 2020 at 5:08 PM
> on Sunjammer, we are still running Mediawiki version 1.28.1, released 
> in April of 2017. The last release in the 1.28 sequence was 1.28.3, 
> released in November of 2017. Sunjammer is running PHP 7.3.6, as 
> provided with Ubuntu 16.04, despite the fact that Sunjammer is running 
> Ubuntu 18.04, according to 'lsb_release -a'
>
> Over the last few days, we've had quite a few errors:
>
> $grep -i rror 
> /var/log/apache2/wiki.sugarlabs.org/wiki.sugarlabs.org-error.log | 
> grep -i "Maximum execution time of 30 seconds exceeded" | wc -l
> 35
> $ grep -i rror wiki.sugarlabs.org-error.log | grep -i "unable to stat" 
> | wc -l
> 264
>
> 20 of these errors are on various lines of 
> /srv/www-sugarlabs/wiki/includes/libs/rdbms/database/Database.php
> The remaining fifteen were timeouts in the related 
> /srv/www-sugarlabs/wiki/includes/libs/rdbms/database/DatabaseMysqli.php 
> on line 46
>
> Since this is an old version of MediaWiki, with known vulnerabilities, 
> I would like to propose we update it immediately. I am not comfortable 
> doing so unilaterally. If anyone is willing to help, and has any level 
> of familiarity with how we have deployed MediaWiki in the past, please 
> assist.
>
>
> _______________________________________________
> Systems mailing list
> Systems at lists.sugarlabs.org
> http://lists.sugarlabs.org/listinfo/systems

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sugarlabs.org/archive/systems/attachments/20200430/4833ae63/attachment.htm>