Page MenuHomePhabricator

Installation of Mediawiki 1.22.1 fails with PostgreSQL at "Creating main page": sequence externallinks_el_id_seq is missing
Closed, ResolvedPublic

Description

Author: gebhkla

Description:
Screenshot

The installation on a PostgreSQL backend fails while creating the main page, because the sequence externallinks_el_id_seq is missing (see screenshot).


Version: 1.22.1
Severity: major
OS: Linux
Platform: PC

Attached:

MW-1-22-1-Install-error.png (567×975 px, 71 KB)

Details

Reference
bz60083

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:56 AM
bzimport set Reference to bz60083.
bzimport added a subscriber: Unknown Object (MLST).

gebhkla wrote:

Patch

Patch for mediawiki 1.22.1 which solved the problem.

Attached:

gebhkla wrote:

In /maintenance/postgres/tables.sql the name of the sequence must be changed to externallinks_el_id_seq and the installation succeeds.

Thanks for your patch & investigation!

You are welcome to use Developer access

https://www.mediawiki.org/wiki/Developer_access

to submit this as a Git branch directly into Gerrit:

https://www.mediawiki.org/wiki/Git/Tutorial

Putting your branch in Git makes it easier to review it quickly.
If you don't want to set up Git/Gerrit, you can also use https://tools.wmflabs.org/gerrit-patch-uploader/
Thanks again! We appreciate your contribution.

Change 109713 had a related patch set uploaded by Umherirrender:
Correct sequence name for fresh Postgres installation

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

Change 109713 merged by jenkins-bot:
Correct sequence name for fresh Postgres installation

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

Change 110922 had a related patch set uploaded by Nemo bis:
Correct sequence name for fresh Postgres installation

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

Change 110922 abandoned by Siebrand:
Correct sequence name for fresh Postgres installation

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

Change 110922 restored by Nemo bis:
Correct sequence name for fresh Postgres installation

Reason:
I don't see any such requirement in the backport policy, feel free to propose changes. https://www.mediawiki.org/wiki/Backporting_fixes#Backports_to_stable.2Fsupported_release
Gerrit is where the queue for non-rejected backport requests lives.

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

Change 110922 abandoned by Nemo bis:
Correct sequence name for fresh Postgres installation

Reason:
Ok thanks, that's clear enough. I'm not interested in being involved in release notes merge conflicts.

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

Change 110922 restored by MarkAHershberger:
Correct sequence name for fresh Postgres installation

Reason:
I will take care of notes.

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

Change 110922 merged by jenkins-bot:
Correct sequence name for fresh Postgres installation

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

Now backported, will be part of release 1.22.3

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.