[IABot] If a page includes the same URL twice, it throws an SQL error
Closed, ResolvedPublic

Description

If a page includes the same URL twice, it throws an error when the page is processed by IABot:

Duplicate entry '76183-2' for key 'PRIMARY'

This seems to be happening during the externallinks_enwiki insert for the 2nd instance of the URL. The key is a combination of the page ID and the auto-incremented url_id from externallinks_global.

kaldari created this task.Aug 5 2016, 2:19 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 5 2016, 2:19 AM
Cyberpower678 closed this task as Resolved.Aug 5 2016, 9:13 AM

Should be fixed now. If it still happens, reopen this.

DannyH moved this task from Untriaged to Archive on the Community-Tech board.Aug 9 2016, 6:16 PM