DB failure with PostgreSQL: relation "ignore" does not exist
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	teward001
	Mar 22 2016, 4:26 PM

Description

I receive the following errors when trying to use UserMerge to merge two users, with a PostgreSQL DB backend:

2016-03-22 16:19:33 GMT [12077-1] mediawiki@mediawiki ERROR:  relation "ignore" does not exist at character 52
2016-03-22 16:19:33 GMT [12077-2] mediawiki@mediawiki STATEMENT:  UPDATE /* MergeUser::mergeDatabaseTables foobar */ IGNORE "user_groups" SET ug_user = '1586' WHERE ug_user = '1495'

This suggests that the plugin uses incorrect syntax in SQL to merge users; this is a very big headache unfortunately, as there's no other way to 'delete' users than to merge them into a generic 'target' account that is a catchall for all delete operations.

Details

	Subject	Repo	Branch	Lines +/-
	PostgreSQL: Support UPDATE IGNORE	mediawiki/core	master	+52 -0

Customize query in gerrit

Related Objects
Search...

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.

Status	Assigned	Task
		· · ·
Invalid	None	T2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking)
Resolved	None	T130634 DB failure with PostgreSQL: relation "ignore" does not exist
		· · ·

Event Timeline

teward001 created this task.Mar 22 2016, 4:26 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 22 2016, 4:26 PM

teward001 updated the task description. (Show Details)Mar 22 2016, 4:29 PM

Aklapper renamed this task from DB failure with PostgreSQL to DB failure with PostgreSQL: relation "ignore" does not exist.Mar 22 2016, 5:59 PM

Aklapper added a parent task: T2384: [REPLACED BY TAG] PostgreSQL/pgsql support (tracking).

Do we know if this bug has always existed, or is new?

Change 281238 had a related patch set uploaded (by Jjanes):
PostgreSQL: Support UPDATE IGNORE

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

gerritbot added a project: Patch-For-Review.Apr 3 2016, 12:50 AM

To answer my own question, the problem does not exist in 1.23 but does in all later versions.

It seems like the best solution to fix the core code so that PostgreSQL can emulate UPDATE IGNORE by the use of savepoints, which I have now done by copying the method from the existing emulation used for INSERT.

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

IijimaYun mentioned this in T177972: Incompatible with anything that is not MySQL/MariaDB?.Oct 11 2017, 5:31 PM

Aklapper merged a task: T177972: Incompatible with anything that is not MySQL/MariaDB?.Oct 11 2017, 10:14 PM

Aklapper added a subscriber: IijimaYun.

PokestarFan subscribed.Nov 3 2017, 9:22 PM

matej_suchanek merged a task: T185699: Extension:UserMerge - Database Error: "ERROR: relation "ignore" does not exist".Jun 6 2019, 11:05 AM

matej_suchanek added subscribers: m-art-in, Pasajeros, MarcoAurelio and 2 others.

Aklapper edited projects, added Patch-Needs-Improvement; removed Patch-For-Review.Jun 29 2020, 8:45 AM

Removing task assignee due to inactivity, as this open task has been assigned to the same person for more than two years (see the emails sent to the task assignee on Oct27 and Nov23). Please assign this task to yourself again if you still realistically [plan to] work on this task - it would be welcome.
(See https://www.mediawiki.org/wiki/Bug_management/Assignee_cleanup for tips how to best manage your individual work in Phabricator.)

Aklapper triaged this task as Low priority.Jan 18 2022, 3:23 PM

Change 281238 abandoned by Umherirrender:

[mediawiki/core@master] PostgreSQL: Support UPDATE IGNORE

Reason:

Superseeded by I1409c80b39834d1977c82c489226255a8cc93fd0

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