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.

_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reply via email to