[wp-trac] [WordPress Trac] #42422: 'unique' index not removed from the 'slug' column of the 'wp_terms' table

[WordPress Trac]

#42422: 'unique' index not removed from the 'slug' column of the 'wp_terms' table
--------------------------+-----------------------------
 Reporter:  joellisenby   |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Taxonomy      |    Version:  4.8.3
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 This is a follow-up to #22023.

 It appears that on one of my older installations of wordpress the unique
 index was never removed from the 'slug' column of the 'wp_terms' table.
 The latest update 4.8.3 must have stirred something up with wp cron,
 conflicting with the unique status of the column. This has caused
 thousands of the following errors to be logged which in turn caused our
 server to 503 due to hitting the PHP FcgidMaxProcessesPerClass limit.

 Note: this installation has had regular updates since being installed
 years ago.

 {{{
  stderr:
 WordPress database error Duplicate entry 'category-slug' for key 'slug'
 for
 query INSERT INTO `wp_terms` (`name`, `slug`, `term_group`) VALUES
 ('Category Name', 'category-slug', 0) made by do_action_ref_array,
 WP_Hook->do_action,
 WP_Hook->apply_filters, _wp_batch_split_terms, _split_shared_term
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/42422>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform