ArchiveProcessing: duplicate idArchive
|Reported by:||vipsoft||Owned by:|
Description (last modified by vipsoft)
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '166-done' for key 'PRIMARY'
I don't know if this is the root cause or a contributing factor, but loadNextIdArchive() does not auto-increment. (klando's pgsql port uses a sequence object here. However, if archiving should fail, it results in an orphaned row.)
The quick fix is to add the IGNORE (discard) keyword to the INSERT.
Ideally, Multiple concurrent archiving processes should be avoidable...
Change History (5)
comment:3 Changed 4 years ago by vipsoft (robocoder)
- Milestone changed from 1 - Piwik 0.5 to 1 - Piwik 0.5.1