[wp-trac] [WordPress Trac] #31388: Database Error During Upgrade

[WordPress Trac]

#31388: Database Error During Upgrade
--------------------------+---------------------
 Reporter:  miqrogroove   |       Owner:  dd32
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  4.2.3
Component:  Database      |     Version:  4.2
 Severity:  normal        |  Resolution:  fixed
 Keywords:                |     Focuses:
--------------------------+---------------------

Comment (by dd32):

 > Thank your for great input. A quick note to "This isn't actually a
 problem, only a warning". It is actually an MySQL error, not a warning.

 @jstensved Correct :) It's a MySQL Error, but only a warning in the
 context of the upgrade routine (Bad choice of words really on my behalf
 there). The reason I explained it as a warning only, was that in this
 scenario, as mentioned above, that specific query failing has no impact on
 the site (As the order of queries is effectively `DROP INDEX, DROP INDEX +
 ADD INDEX, ADD INDEX`).

 So, as a result of that failed query, no site would've been left without
 an index (unless the index creation query failed), as any site that hit
 this error, had already dropped the index, and would've been on it's way
 to re-create it shortly thereafter in the upgrade routine.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/31388#comment:22>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform