Page MenuHomePhabricator

Duplicate key errors (tracking)
Open, LowPublic

Description

We're seeing spikes of 'duplicate key' errors lasting multiple days.

Trend for May 1 - July 24:

1$ zgrep -c 'Duplicate entry' exception.log-20150[567]*
2exception.log-20150501.gz:5
3exception.log-20150502.gz:3
4exception.log-20150503.gz:11
5exception.log-20150504.gz:7
6exception.log-20150506.gz:6
7exception.log-20150507.gz:6
8exception.log-20150508.gz:2
9exception.log-20150509.gz:1
10exception.log-20150510.gz:5
11exception.log-20150511.gz:5
12exception.log-20150512.gz:0
13exception.log-20150513.gz:4
14exception.log-20150514.gz:2
15exception.log-20150515.gz:4
16exception.log-20150516.gz:3
17exception.log-20150517.gz:5
18exception.log-20150518.gz:2
19exception.log-20150519.gz:8
20exception.log-20150520.gz:0
21exception.log-20150521.gz:3
22exception.log-20150522.gz:1
23exception.log-20150523.gz:1
24exception.log-20150524.gz:4
25exception.log-20150525.gz:1
26exception.log-20150526.gz:1
27exception.log-20150527.gz:2
28exception.log-20150528.gz:36
29exception.log-20150529.gz:3
30exception.log-20150530.gz:5
31exception.log-20150531.gz:1
32exception.log-20150601.gz:1
33exception.log-20150602.gz:1
34exception.log-20150603.gz:4
35exception.log-20150604.gz:2
36exception.log-20150605.gz:3
37exception.log-20150606.gz:1
38exception.log-20150607.gz:3
39exception.log-20150608.gz:1
40exception.log-20150609.gz:5
41exception.log-20150610.gz:193
42exception.log-20150611.gz:212
43exception.log-20150612.gz:524
44exception.log-20150613.gz:37
45exception.log-20150614.gz:363
46exception.log-20150615.gz:859
47exception.log-20150616.gz:463
48exception.log-20150617.gz:347
49exception.log-20150618.gz:355
50exception.log-20150619.gz:806
51exception.log-20150620.gz:558
52exception.log-20150621.gz:359
53exception.log-20150622.gz:230
54exception.log-20150623.gz:125
55exception.log-20150624.gz:54
56exception.log-20150625.gz:49
57exception.log-20150626.gz:55
58exception.log-20150627.gz:54
59exception.log-20150628.gz:22
60exception.log-20150629.gz:11
61exception.log-20150630.gz:19
62exception.log-20150701.gz:27
63exception.log-20150702.gz:45
64exception.log-20150703.gz:13
65exception.log-20150704.gz:17
66exception.log-20150705.gz:9
67exception.log-20150706.gz:9
68exception.log-20150707.gz:54
69exception.log-20150708.gz:43
70exception.log-20150709.gz:15
71exception.log-20150710.gz:21
72exception.log-20150711.gz:26
73exception.log-20150712.gz:74
74exception.log-20150713.gz:22
75exception.log-20150714.gz:50
76exception.log-20150715.gz:52
77exception.log-20150716.gz:47
78exception.log-20150717.gz:42
79exception.log-20150718.gz:40
80exception.log-20150719.gz:40
81exception.log-20150720.gz:19
82exception.log-20150721.gz:56
83exception.log-20150722.gz:111
84exception.log-20150723.gz:107
85exception.log-20150724.gz:55

Event Timeline

ori created this task.Jul 24 2015, 5:28 PM
ori updated the task description. (Show Details)
ori raised the priority of this task from to High.
ori added a subscriber: ori.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 24 2015, 5:28 PM
jcrespo moved this task from Triage to Backlog on the DBA board.Jul 24 2015, 5:35 PM
ori added a comment.Jul 24 2015, 5:47 PM
<jynus> I do not know much about mediawiki, but probably some of these are ok to fail at db level- the difference may be that it shold not fail at app level

That sounds right to me.

Legoktm closed subtask Restricted Task as Invalid.Aug 9 2015, 10:15 PM
Danny_B renamed this task from Tracking: duplicate key errors to Duplicate key errors (tracking).May 27 2016, 5:57 PM
Marostegui moved this task from Backlog to Meta/Epic on the DBA board.Nov 7 2017, 3:11 PM
jcrespo lowered the priority of this task from High to Normal.Mar 26 2018, 8:09 PM
jcrespo moved this task from Meta/Epic to Blocked external/Not db team on the DBA board.

I can only see 11 entries in the last month: Normal or low.

jcrespo lowered the priority of this task from Normal to Low.Mar 26 2018, 8:11 PM

Actually, we had 0 in the last month, I searched for duplicate key and got unrelated errors for "on duplicate key" syntax.