Page MenuHomePhabricator
Create Task
Maniphest T361631

Unable to create table cu_useragent on labtestwiki
Closed, ResolvedPublic
Actions

Description

When running the command foreachwiki sql.php ~/T359312.sql on production, the table was not created on labtestwiki because sql.php exited with the error:

-----------------------------------------------------------------
labtestwiki
-----------------------------------------------------------------
Wikimedia\Rdbms\DBConnectionError from line 1138 of /srv/mediawiki/php-1.42.0-wmf.25/includes/libs/rdbms/loadbalancer/LoadBalancer.php: Cannot access the database: Access denied for user 'wikiadmin2023'@'mwmaint1002.eqiad.wmnet' (using password: YES) (clouddb2002-dev)
#0 /srv/mediawiki/php-1.42.0-wmf.25/includes/libs/rdbms/loadbalancer/LoadBalancer.php(794): Wikimedia\Rdbms\LoadBalancer->reportConnectionError()
#1 /srv/mediawiki/php-1.42.0-wmf.25/includes/libs/rdbms/loadbalancer/LoadBalancer.php(782): Wikimedia\Rdbms\LoadBalancer->getServerConnection(0, 'labtestwiki', 8)
#2 /srv/mediawiki/php-1.42.0-wmf.25/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal(-2, Array, 'labtestwiki', 8)
#3 /srv/mediawiki/php-1.42.0-wmf.25/includes/libs/rdbms/database/DBConnRef.php(117): Wikimedia\Rdbms\DBConnRef->ensureConnection()
#4 /srv/mediawiki/php-1.42.0-wmf.25/includes/libs/rdbms/database/DBConnRef.php(227): Wikimedia\Rdbms\DBConnRef->__call('setFlag', Array)
#5 /srv/mediawiki/php-1.42.0-wmf.25/includes/installer/DatabaseUpdater.php(155): Wikimedia\Rdbms\DBConnRef->setFlag(128)
#6 /srv/mediawiki/php-1.42.0-wmf.25/includes/installer/DatabaseUpdater.php(254): MediaWiki\Installer\DatabaseUpdater->__construct(Object(Wikimedia\Rdbms\DBConnRef), true, Object(MwSql))
#7 /srv/mediawiki/php-1.42.0-wmf.25/maintenance/sql.php(93): MediaWiki\Installer\DatabaseUpdater::newForDB(Object(Wikimedia\Rdbms\DBConnRef), true, Object(MwSql))
#8 /srv/mediawiki/php-1.42.0-wmf.25/maintenance/includes/MaintenanceRunner.php(698): MwSql->execute()
#9 /srv/mediawiki/php-1.42.0-wmf.25/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
#10 /srv/mediawiki/multiversion/MWScript.php(158): require_once('/srv/mediawiki/...')
#11 {main}

T359312.sql was defined as the following and is a copy (with a modification to add IF NOT EXISTS) of the SQL file in the repo that added the table:

CREATE TABLE IF NOT EXISTS /*_*/cu_useragent (
  cuua_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
  cuua_text VARBINARY(255) NOT NULL,
  INDEX cuua_text (cuua_text),
  PRIMARY KEY(cuua_id)
) /*$wgDBTableOptions*/;

Related Objects
Search...

StatusSubtypeAssignedTask
 OpenFeatureNoneT315926 Provide a way to search all of the XFF addresses listed in the XFF string
 OpenFeatureNoneT326379 Normalise the XFF and user agent columns
 Resolved• TBolligerT120734 Epic ⚡️ Improve MediaWiki's blocking tools
 OpenNoneT146837 Add ability to search by user agent from CheckUser interface
 OpenNoneT147894 Create index for agent_id columns in the CheckUser result tables
 OpenNoneT305930 Normalize cu_changes table
 OpenNoneT361139 Normalise the user agent column in CheckUser result tables
 OpenNoneT361208 Remove agent columns from CheckUser result tables
 OpenNoneT361206 Stop writing old for user agent schema migration on WMF wikis
 OpenNoneT361205 Stop writing old for user agent schema migration
 OpenNoneT361199 Set user agent schema migration config to read new on WMF wikis
 OpenNoneT361201 Set user agent schema migration config to read new in extension.json
 OpenNoneT361192 Read user agent strings from the cu_useragent table in Special:CheckUser
 OpenNoneT361193 Read user agent strings from the cu_useragent table in the CheckUser API
 OpenNoneT361195 Read user agent strings from the cu_useragent table in Special:Investigate
 OpenNoneT361198 Create a maintenance script to populate the cu_useragent table and agent_id columns with values from the agent columns
 OpenNoneT361196 Write to the cu_useragent table and agent_id columns on WMF wikis
 OpenNoneT361197 Write to the cu_useragent table and agent_id columns on by default in extension.json
 OpenNoneT361174 Write to agent_id columns in the CheckUserInsert service when migration configuration allows it
 OpenNoneT361172 Purge rows from cu_useragent
 OpenNoneT361173 Add schema migration config for cu_useragent table
 ResolvedDreamy_JazzT361140 Add user agent ID column to each CheckUser result table
 ResolvedDreamy_JazzT361928 Update mediawiki.org pages for schema changes made by adding the cu_useragent table
 ResolvedDreamy_JazzT359312 Create cu_useragent table
 ResolvedMarosteguiT361631 Unable to create table cu_useragent on labtestwiki
 OpenNoneT328289 update labtestwiki user and password

Event Timeline

Dreamy_Jazz created this task.Tue, Apr 2, 5:23 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptTue, Apr 2, 5:23 PM
Dreamy_Jazz added a comment.Tue, Apr 2, 5:32 PM

I cannot also connect to that wiki using sql labtestwiki.

This seems to be the same issue as T339958.

Dreamy_Jazz added a subtask: T328289: update labtestwiki user and password.Tue, Apr 2, 5:33 PM
Marostegui closed this task as Resolved.Wed, Apr 3, 5:07 AM
Marostegui claimed this task.
Marostegui subscribed.

Fixed

# sql labtestwiki
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 177084
Server version: 10.4.25-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

wikiadmin2023@10.192.20.6(labtestwiki)>
Marostegui mentioned this in T328289: update labtestwiki user and password.Wed, Apr 3, 5:08 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL