Last modified: 2014-09-10 14:23:14 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T65997, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 63997 - Replication engine moans because of duplicate entry
Replication engine moans because of duplicate entry
Status: RESOLVED WONTFIX
Product: Commons App
Classification: Unclassified
General (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-04-16 12:06 UTC by nosy
Modified: 2014-09-10 14:23 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description nosy 2014-04-16 12:06:07 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
Comment 1 nosy 2014-09-10 13:45:09 UTC
No fucking one cares, heh
Comment 2 Andre Klapper 2014-09-10 14:23:14 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links