[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mediawiki-l
Subject:    Re: [MediaWiki-l] update.php failing with message from LoadBalancer.php
From:       Mike Brown <mike () hyperreal ! org>
Date:       2019-04-09 12:49:19
Message-ID: 20190409124919.GA61091 () taz4 ! hyperreal ! org
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]