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.