Last modified: 2014-09-10 14:23:14 UTC
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
No fucking one cares, heh
nosy: I have no idea why this ticket was filed against the Commons Mobile application which is pretty unmaintained, so that's why not many people cared.