Page MenuHomePhabricator

Wikibase does not support Postgresql (and does not even mention it requires mysql)
Closed, ResolvedPublic

Description

While installing wikibase, it failed with this error:

Creating wb_changes_subscription table ...[24c8a27fa67b3ebc29b340b1] [no req]   Wikimedia\Rdbms\DBQueryError from line 1457 of /srv/www/mediawiki-1.31.0/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: CREATE TABLE IF NOT EXISTS "wb_changes_subscription" (
 cs_row_id         BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
 cs_entity_id      VARBINARY(255) NOT NULL, -- the ID of the entity subscribed to
 cs_subscriber_id  VARBINARY(255) NOT NULL  -- the ID of the subscriber (e.g. a domain name or database name)
 ) /*$wgDBTableOptions*/

Function: Wikimedia\Rdbms\Database::sourceFile( /srv/www/mediawiki-1.31.0/extensions/Wikibase/repo/includes/Store/Sql/../../../sql/changes_subscription.sql )
Error: 42601 ERROR:  syntax error at or near "AUTO_INCREMENT"
LINHA 2:  cs_row_id         BIGINT NOT NULL PRIMARY KEY AUTO_INCREMEN...

It seems that it does not support PostgreSQL. No single doc mentioned that requirement until I was far into the installation.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Seb35 renamed this task from wikibase does not support Postgresql (and does not even mention it requires mysql) to Wikibase does not support Postgresql (and does not even mention it requires mysql).Jun 29 2019, 10:00 PM
Seb35 edited projects, added MediaWiki-extensions-WikibaseRepository; removed Wikidata.
Seb35 added a subscriber: Seb35.

Change 674087 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/Wikibase@master] Make Postgres work in Wikibase

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

Change 674275 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[integration/config@master] Add Postgres test jobs for Wikibase as experimental

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

Change 674299 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/Wikibase@master] Simplify DatabaseEntityTermsTableProvider logic drastically

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

Change 674275 merged by jenkins-bot:
[integration/config@master] Zuul: [mediawiki/extensions/Wikibase] Add experimental Postgres job

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

Mentioned in SAL (#wikimedia-releng) [2021-03-23T20:44:28Z] <James_F> Zuul: [mediawiki/extensions/Wikibase] Add experimental Postgres job T207226

Change 674533 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/Wikibase@master] Fix most of tests failing in Postgres

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

Change 674087 merged by jenkins-bot:
[mediawiki/extensions/Wikibase@master] Make Postgres work in Wikibase

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

Change 674299 merged by jenkins-bot:
[mediawiki/extensions/Wikibase@master] Simplify DatabaseEntityTermsTableProvider logic drastically

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

Change 674533 merged by jenkins-bot:
[mediawiki/extensions/Wikibase@master] Fix most of tests failing in Postgres

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

Ladsgroup claimed this task.

This is basically done. I make tickets for CI and SqlChangeDispatcher.