Page MenuHomePhabricator

Vagrant flow role: SELECT command denied to user 'wikiadmin'@'localhost' for table 'flow_revision'
Open, Needs TriagePublic

Description

When provisioning the flow role on a fresh box, I got

==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: Wikimedia\Rdbms\DBQueryError from line 1626 of /vagrant/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? 
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: Query: SELECT  rev_type_id  FROM `flow_revision`    WHERE rev_type = 'header' AND (rev_type_id > '')  ORDER BY rev_type_id ASC LIMIT 200  
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: Function: FlowPopulateLinksTables::processHeaders
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: Error: 1142 SELECT command denied to user 'wikiadmin'@'localhost' for table 'flow_revision' (127.0.0.1)
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: 
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #0 /vagrant/mediawiki/includes/libs/rdbms/database/Database.php(1610): Wikimedia\Rdbms\Database->getQueryException('SELECT command ...', 1142, 'SELECT  rev_typ...', 'FlowPopulateLin...')
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #1 /vagrant/mediawiki/includes/libs/rdbms/database/Database.php(1587): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('SELECT command ...', 1142, 'SELECT  rev_typ...', 'FlowPopulateLin...')
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #2 /vagrant/mediawiki/includes/libs/rdbms/database/Database.php(1166): Wikimedia\Rdbms\Database->reportQueryError('SELECT command ...', 1142, 'SELECT  rev_typ...', 'FlowPopulateLin...', false)
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #3 /vagrant/mediawiki/includes/libs/rdbms/database/Database.php(1832): Wikimedia\Rdbms\Database->query('SELECT  rev_typ...', 'FlowPopulateLin...')
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #4 /vagrant/mediawiki/extensions/Flow/maintenance/FlowPopulateLinksTables.php(52): Wikimedia\Rdbms\Database->select(Array, Array, Array, 'FlowPopulateLin...', Array)
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #5 /vagrant/mediawiki/extensions/Flow/maintenance/FlowPopulateLinksTables.php(32): FlowPopulateLinksTables->processHeaders(Object(Flow\Data\Listener\ReferenceRecorder))
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #6 /vagrant/mediawiki/maintenance/Maintenance.php(1759): FlowPopulateLinksTables->doDBUpdates()
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #7 /vagrant/mediawiki/maintenance/update.php(209): LoggedUpdateMaintenance->execute()
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #8 /vagrant/mediawiki/maintenance/doMaintenance.php(99): UpdateMediaWiki->execute()
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #9 /vagrant/mediawiki/maintenance/update.php(270): require_once('/vagrant/mediaw...')
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #10 /var/www/w/MWScript.php(98): require_once('/vagrant/mediaw...')
==> default: Notice: /Stage[main]/Mediawiki/Exec[update_all_databases]/returns: #11 {main}

DB looked fine, next provisioning worked fine, seems to have fixed the issue.