This a break off ticket for the issue I mentioned here: #1176754 which is mostly unrelated.

I have verified from a fresh install of rc6 i am getting this somewhat randomly.

User warning: Duplicate entry "ab10516686e2081b09e98da5d5ba176a-77a021332bbcb270ae7d8e90adfc51e" for key "PRIMARY" query: INSERT INTO advagg_bundles (bundle_md5, filename_md5, counter, porder, root) VALUES ("ab10516686e2081b09e98da5d5ba176a", "77a021332bbcb270ae7d8e90adfc51eb", "", "28", "1") in _db_query() (line 148 of /data/all/003/pressflow/includes/database.mysqli.inc).

CommentFileSizeAuthor
#2 advagg-1182754-2.patch1013 bytesmikeytown2

Comments

mikeytown2’s picture

mikeytown2 commented
Component: Bundler » Code

Race condition in the advagg_insert_bundle_db function most likely. Need to use a lock (wait if locked) & should also verify before writing.

mikeytown2’s picture

mikeytown2 commented
Status: Active » Fixed
StatusFileSize
new advagg-1182754-2.patch1013 bytes

I already verify that this entry doesn't exists before, so all I need is a lock. This patch adds in locking for this operation. It has been committed.

devkinetic’s picture

devkinetic commented

Thanks mikeytown2,

I have applied this patch against my site running rc6. I will verify if I receive any more errors of this kind today as I am working. Thanks again for your quick responses!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.