I am using Magento 1.x on Google Cloud SQL for years. Yesterday this error appeared while I was trying to reindex catalog_product_price index:
SQLSTATE[HY000]: General error: 1813 Tablespace '`myproductiondb`.`catalog_product_index_price_idx`' exists. in /var/www/html/lib/Zend/Db/Statement/Pdo.php:234
I have tried to get rid of a tablespace using:
DROP TABLESPACE catalog_product_index_price_idx Engine=InnoDB;
Command runs successfully, yet the error 1813 appears again when I try to reindex prices.
Any hints?
I haven't found "proper" solution. So I've dumped original database, created new database and imported data from original one there. I've changed the scripts to connect to new database and everything works now.