Base table or view already exists Getting the following error on production environment when trying to add a new Field.


  CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'redacted' already exists


Anyone have any idea what could be causing this?
This turned out to be an issue with the mysql server itself, not a Craft CMS issue at all. 

It appears that during a previous field addition, the database server crashed and left hanging temporary files that didn't match with the database itself.

Spun up a new database, copied the DB over and everything worked as expected.