[wp-trac] [WordPress Trac] #17210: Massive duplication of oEmbed postmeta

[WordPress Trac]

#17210: Massive duplication of oEmbed postmeta
--------------------------+------------------------------
 Reporter:  archon810     |       Owner:  Viper007Bond
     Type:  defect (bug)  |      Status:  accepted
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Embeds        |     Version:  3.1
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------------------

Comment (by archon810):

 After doing more extensive research and stracing Apache threads, I believe
 I've finally root caused this bug.

 It seems like all the duplicate oembed entries are created due to #17560
 that I opened earlier today. (Please read it first, then proceed).

 I've reset to_ping on all posts that had it set to
 {{{
 (comma
 separated)
 }}}
 which was about 850 out of almost 3000 posts, and none of the subsequent
 new posts contain duplicate oembed keys anymore.

 I then cleared all oembed keys from the db (128k entries) and monitored
 the situation for an hour. No duplicates were created.

 Then, to verify the theory, I went back to the backups of the postmeta and
 posts tables and cross referenced the embeds that are created over and
 over with the posts they appear in. In such comparison, as I suspected,
 most (95%) posts containing those embeds had that corrupt to_ping column.

 Now, it's beyond my knowledge scope why exactly what is happening here is
 happening, but my guess is somewhere in wp-cron, paths get crossed, and
 duplicate oembed entries are created all over the place.

 Please validate my assumptions - I know I'm onto something here. It's a
 great feeling to kill 2 birds with 1 stone.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17210#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software