CheckUser causes foreign key constraint violation on page delete on PostgreSQL (insert or update on table "cu_changes" violates foreign key constraint "cu_changes_cuc_page_id_fkey")
Closed, DuplicatePublic
Actions

Assigned To

None

Authored By

	Yetanotherusername
	Nov 4 2016, 2:38 AM

Description

MediaWiki 1.27.1
PHP 5.5.9-1ubuntu4.20
PostgreSQL 9.3.14

I get an error when I attempt to delete a page. I get the following error:

Query:

INSERT INTO "cu_changes" (cuc_id,cuc_namespace,cuc_title,cuc_minor,cuc_user,cuc_user_text,cuc_actiontext,cuc_comment,cuc_this_oldid,cuc_last_oldid,cuc_type,cuc_timestamp,cuc_ip,cuc_ip_hex,cuc_xff,cuc_xff_hex,cuc_agent,cuc_page_id) VALUES ('6481','0','Deletetest','0','2','Tynian','Tynian deleted page Deletetest','Deletion test','0','0','3','2016-10-31 05:35:33 GMT','68.106.57.89','446A3959',0,NULL,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/53.0.2785.143 Chrome/53.0.2785.143 Safari/537.36','4364')

Function: CheckUserHooks::updateCheckUserData
Error: 23503 ERROR: insert or update on table "cu_changes" violates foreign key constraint "cu_changes_cuc_page_id_fkey" DETAIL: Key (cuc_page_id)=(4364) is not present in table "page".

If I comment out the CheckUser extension, I am able to delete the page. I have upgraded CheckUser from Git, but get the same results.

Related Objects

Mentioned In: T241827: CheckUser causes a foreign key constraint failure on PostgreSQL when creating a new user
Mentioned Here: rECHU2577b230e912: Localisation updates from https://translatewiki.net.
rECHU8fafbe85d3e9: Localisation updates from http://translatewiki.net.

Event Timeline

Yetanotherusername created this task.Nov 4 2016, 2:38 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 4 2016, 2:38 AM

Ciencia_Al_Poder added projects: CheckUser, PostgreSQL.Nov 4 2016, 2:40 AM

Restricted Application added a subscriber: JEumerus. · View Herald TranscriptNov 4 2016, 2:40 AM

Paladox subscribed.Nov 4 2016, 8:27 AM

Thanks for reporting this! Which exact CU version is this about (see Special:Version)?

CheckUser 2.3 (8fafbe8)

@Yetanotherusername that is a really old commit, please update to the latest in branch REL1_27.

Yes, sorry. I had forgotten I was running an older snapshot for testing purposes.

Did a git update. Now running 2.4 (2577b23) 14:40, November 1, 2016.

Same result.

Lahwaacz subscribed.Jan 3 2020, 10:48 AM

Lahwaacz mentioned this in T241827: CheckUser causes a foreign key constraint failure on PostgreSQL when creating a new user.Jan 3 2020, 10:54 AM

saper renamed this task from Database error on PostgreSQL: insert or update on table "cu_changes" violates foreign key constraint "cu_changes_cuc_page_id_fkey" to CheckUser causes foreign key constraint violation on page delete on PostgreSQL (insert or update on table "cu_changes" violates foreign key constraint "cu_changes_cuc_page_id_fkey").Jan 3 2020, 1:05 PM

Umherirrender closed this task as a duplicate of T36372: New User hook broken for PG, breaks normal logging.Jan 21 2022, 11:06 PM

CheckUser causes foreign key constraint violation on page delete on PostgreSQL (insert or update on table "cu_changes" violates foreign key constraint "cu_changes_cuc_page_id_fkey")Closed, DuplicatePublicActions

Description

Related Objects

Event Timeline

CheckUser causes foreign key constraint violation on page delete on PostgreSQL (insert or update on table "cu_changes" violates foreign key constraint "cu_changes_cuc_page_id_fkey")
Closed, DuplicatePublic
Actions