Page MenuHomePhabricator

Table babel already exists error with sqlite database
Closed, ResolvedPublicBUG REPORT

Description

List of steps to reproduce (step by step, including full links if applicable):

  • Install MediaWiki (I used name) and choose SQLite as database.
  • Follow instructions to install babel and other extensions in MLEB.
  • Run php maintenance/update.php

What happens?:
The maintenance script aborted with following error:

...babel table already exists.
Modifying babel_lang field of table babel...Wikimedia\Rdbms\DBQueryError from line 1749 of /var/www/html/w/includes/libs/rdbms/database/Database.php: Error 1: table babel already exists
Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/html/w/extensions/Babel/sql/sqlite/babel-babel_lang-length.sql )
Query: CREATE TABLE babel (
 babel_user INTEGER  NOT NULL,
 babel_lang BLOB NOT NULL,
 babel_level BLOB NOT NULL,
 PRIMARY KEY ( babel_user, babel_lang )
 )

What should have happened instead?:
The maintenance script should finish without error.

Software version (if not a Wikimedia wiki), browser information, screenshots, other information, etc.: the master branch

Event Timeline

Change 789778 had a related patch set uploaded (by Lucas Werkmeister (WMDE); author: Lucas Werkmeister (WMDE)):

[mediawiki/extensions/Babel@master] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789778

Change 789779 had a related patch set uploaded (by WhitePhosphorus; author: WhitePhosphorus):

[mediawiki/extensions/Babel@master] Fix maintenance script error

https://gerrit.wikimedia.org/r/789779

Change 789779 abandoned by WhitePhosphorus:

[mediawiki/extensions/Babel@master] Fix maintenance script error

Reason:

conflicting

https://gerrit.wikimedia.org/r/789779

Change 789833 had a related patch set uploaded (by Umherirrender; author: Lucas Werkmeister (WMDE)):

[mediawiki/extensions/Babel@REL1_38] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789833

Change 789834 had a related patch set uploaded (by Umherirrender; author: Lucas Werkmeister (WMDE)):

[mediawiki/extensions/Babel@REL1_37] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789834

Change 789835 had a related patch set uploaded (by Umherirrender; author: Lucas Werkmeister (WMDE)):

[mediawiki/extensions/Babel@REL1_36] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789835

Change 789836 had a related patch set uploaded (by Umherirrender; author: Lucas Werkmeister (WMDE)):

[mediawiki/extensions/Babel@REL1_35] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789836

Umherirrender triaged this task as Low priority.
Umherirrender removed a project: Patch-For-Review.

Change 789833 merged by jenkins-bot:

[mediawiki/extensions/Babel@REL1_38] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789833

Change 789834 merged by jenkins-bot:

[mediawiki/extensions/Babel@REL1_37] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789834

Change 789835 merged by jenkins-bot:

[mediawiki/extensions/Babel@REL1_36] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789835

Change 789836 merged by jenkins-bot:

[mediawiki/extensions/Babel@REL1_35] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789836

Change 789778 merged by jenkins-bot:

[mediawiki/extensions/Babel@master] Fix temporary table name in sqlite schema change

https://gerrit.wikimedia.org/r/789778