https://bugzilla.wikimedia.org/show_bug.cgi?id=63997
Bug ID: 63997
Summary: Replication engine moans because of duplicate entry
Product: Commons App
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: General
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected]
Web browser: ---
Mobile Platform: ---
Toolserver replication engine stopped updating commons DB because it sees a
duplicate primary key. I guess it might be related to broken program logic.
I would now probably skip this query but I'd get wrong infos in the DB then.
Here is my log:
2014-04-16 11:34:00,981 ERROR Writer [z-dat-s5-b-commons]
java.lang.RuntimeException:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstr
aintViolationException: Duplicate entry '118652385' for key 'rev_id'
2014-04-16 11:34:00,981 DEBUG Writer [z-dat-s5-b-commons] Query:
211727876—211732666
BEGIN;
SET INSERT_ID=32208280
use `commonswiki`; INSERT /* WikiPage::insertOn Steinsplitter */ IGNORE INTO
`page` (page_id,page_namespace,page_title,page_counter,page_r
estrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len)
VALUES (NULL,'6','Rosbach,_evangelische_Kirche.jpg
','0','','0','1','0.410874585270','20140416105946','0','0')
use `commonswiki`; INSERT /* Revision::insertOn Steinsplitter */ INTO
`revision` (rev_id,rev_page,rev_text_id,rev_comment,rev_minor_edit,
rev_user,rev_user_text,rev_timestamp,rev_deleted,rev_len,rev_parent_id,rev_sha1)
VALUES ('118652385','32208280','116197454','Rauenstein mo
ved page [[File:Rosbach, evangelische Kirche.jpg]] to [[File:Rosbach,
evangelische Salvatorkirche.jpg]]: korrekter Name','0','13617','Raue
nstein','20140309204939','0','59','0','seddboxi7btzio5xmbcbv00clhi8rxg')
use `commonswiki`; DELETE /* PageArchive::undeleteRevisions Steinsplitter */
FROM `archive` WHERE ar_namespace = '6' AND ar_title = 'Rosba
ch,_evangelische_Kirche.jpg' AND (1 = 1)
use `commonswiki`; UPDATE /* WikiPage::updateRevisionOn Steinsplitter */
`page` SET page_latest = '118652385',page_touched = '20140416105
946',page_is_new = '1',page_is_redirect = '1',page_len = '59' WHERE page_id =
'32208280' AND page_latest = '0'
use `commonswiki`; REPLACE /* WikiPage::insertRedirectEntry Steinsplitter */
INTO `redirect` (rd_from,rd_namespace,rd_title,rd_fragment,rd
_interwiki) VALUES
('32208280','6','Rosbach,_evangelische_Salvatorkirche.jpg','','')
use `commonswiki`; INSERT /* LinksUpdate::incrTableUpdate Steinsplitter */
IGNORE INTO `pagelinks` (pl_from,pl_namespace,pl_title) VALUES
('32208280','6','Rosbach,_evangelische_Salvatorkirche.jpg')
use `commonswiki`; UPDATE /* LinksUpdate::updateLinksTimestamp Steinsplitter */
`page` SET page_links_updated = '20140416105946' WHERE pa
ge_id = '32208280'
use `commonswiki`; DELETE /* Title::deleteTitleProtection Steinsplitter */ FROM
`protected_titles` WHERE pt_namespace = '6' AND pt_title =
'Rosbach,_evangelische_Kirche.jpg'
use `commonswiki`; REPLACE /* TitleKey::setBatchKeys Steinsplitter */ INTO
`titlekey` (tk_page,tk_namespace,tk_key) VALUES ('32208280','6'
,'ROSBACH, EVANGELISCHE KIRCHE.JPG')
SET INSERT_ID=121488084
use `commonswiki`; REPLACE /* oaiUpdatePage Steinsplitter */ INTO `updates`
(up_page,up_action,up_timestamp,up_sequence) VALUES ('32208280
','modify','20140416105946',NULL)
SET INSERT_ID=85087918
use `commonswiki`; INSERT /* ManualLogEntry::insert Steinsplitter */ INTO
`logging` (log_id,log_type,log_action,log_timestamp,log_user,lo
g_user_text,log_namespace,log_title,log_page,log_comment,log_params) VALUES
(NULL,'delete','restore','20140416105946','2055977','Steinspli
tter','6','Rosbach,_evangelische_Kirche.jpg','32208280','1 revision
restored','a:0:{}')
SET INSERT_ID=123018304
use `commonswiki`; INSERT /* RecentChange::save Steinsplitter */ INTO
`recentchanges` (rc_timestamp,rc_namespace,rc_title,rc_type,rc_sour
ce,rc_minor,rc_cur_id,rc_user,rc_user_text,rc_comment,rc_this_oldid,rc_last_oldid,rc_bot,rc_ip,rc_patrolled,rc_new,rc_old_len,rc_new_len,r
c_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_id) VALUES
('20140416105946','6','Rosbach,_evangelische_Kirche.jpg','3','mw.log'
,'0','32208280','2055977','Steinsplitter','1 revision
restored','0','0','0','93.147.107.25','1','0',NULL,NULL,'0','85087918','delete','res
tore','a:0:{}',NULL)
SET INSERT_ID=120505443
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
