[wp-trac] [WordPress Trac] #8949: WP creates duplicate options

WordPress Trac wp-trac at lists.automattic.com
Sat Jan 24 18:29:14 GMT 2009


#8949: WP creates duplicate options
-------------------------------+--------------------------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:  anonymous  
     Type:  defect (bug)       |      Status:  new        
 Priority:  low                |   Milestone:  2.8        
Component:  Optimization       |     Version:  2.7        
 Severity:  minor              |    Keywords:  needs-patch
-------------------------------+--------------------------------------------
 While testing upgrade scripts for very old sites, I've noticed occasional
 duplicates in the option table. Which ones are quite random from a site to
 the next -- but they include things like upgrade_core, and so on, i.e.
 it's definitely not plugin related. I take it that these are created
 during race conditions, where two separate users browse the site, and the
 options created twice.

 Anyway, these could have been avoided in the first place had WP been
 enforcing a unique index on option_name. And it's probably worth getting
 rid of them in the wp upgrade scripts at some point if we enforce such an
 index.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/8949>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list