Send MediaWiki-l mailing list submissions to
mediawiki-l(a)lists.wikimedia.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
or, via email, send a message with subject or body 'help' to
mediawiki-l-request(a)lists.wikimedia.org
You can reach the person managing the list at
mediawiki-l-owner(a)lists.wikimedia.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MediaWiki-l digest..."
Today's Topics:
1. Re: update.php failing with message from LoadBalancer.php
(Mike Brown)
----------------------------------------------------------------------
Message: 1
Date: Tue, 9 Apr 2019 05:49:19 -0700
From: Mike Brown <mike(a)hyperreal.org>
To: mediawiki-l(a)lists.wikimedia.org
Subject: Re: [MediaWiki-l] update.php failing with message from
LoadBalancer.php
Message-ID: <20190409124919.GA61091(a)taz4.hyperreal.org>
Content-Type: text/plain; charset=us-ascii
On Sat, Apr 06, 2019 at 11:38:04PM -0700, Mike Brown wrote:
[3f3634afa8a03289878f8ff9] [no req]
Wikimedia\Rdbms\DBQueryError from
line 1496 of
/usr/local/www/mediawiki/includes/libs/rdbms/database/Database.php: A
database query error has occurred. Did you forget to run your application's
database schema updater after upgrading?
Query: UPDATE `mw_archive` SET ar_rev_id =
'3867' WHERE ar_id = '940'
Function: PopulateArchiveRevId::reassignArRevIds
Error: 1785 Statement violates GTID consistency: Updates to
non-transactional
tables can only be done in either autocommitted
statements or single-statement transactions, and never in the same
statement as updates to transactional tables. (localhost)
This happened because I was upgrading a MySQL-based wiki installation
which
had MyISAM instead of InnoDB tables. I altered the tables (except
searchindex)
to use the InnoDB engine, and then update.php was able to run to
completion.
Perhaps update.php should be fixed to deal with this contingency.
------------------------------
Subject: Digest Footer
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
------------------------------
End of MediaWiki-l Digest, Vol 187, Issue 7
*******************************************