[wp-trac] [WordPress Trac] #11437: Option inserts triggered from front page can cause duplicate entry errors

[WordPress Trac]

#11437: Option inserts triggered from front page can cause duplicate entry errors
--------------------------+-------------------------------------------------
 Reporter:  ryan          |       Owner:  ryan
     Type:  defect (bug)  |      Status:  new 
 Priority:  normal        |   Milestone:  2.9 
Component:  Database      |     Version:  2.9 
 Severity:  normal        |    Keywords:      
--------------------------+-------------------------------------------------
 {{{
 WordPress database error Duplicate entry
 '_site_transient_timeout_theme_roots' for key 2 for query INSERT INTO
 `options` (`option_name`,`option_value`,`autoload`) VALUES
 ('_site_transient_timeout_theme_roots','1260638876','yes') made by
 require, require_once, require_once, require_once, get_template_directory,
 get_theme_root, get_theme_roots, get_themes, set_site_transient,
 add_site_option, add_option
 }}}

 On a busy site, this insert can be triggered multiple times. A race
 condition results with the losers creating a duplicate key error. One
 solution is to use ON DUPLICATE KEY UPDATE.

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