search

anhnongdan / bimax_ha_migration

all db backup, recovery and migration scenarios for bimax
0 stars 0 forks source link

Problem with temp_archive table after restoring #14

Closed anhnongdan closed 6 years ago

anhnongdan commented 6 years ago 
INFO [2017-09-29 09:50:08] Error: Got invalid response from API request: ?module=API&method=API.get&idSite=2004&period=day&date=2017-09-29,2017-09-29&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:182:"SQLSTATE[HY000]: General error: 1813 Tablespace for table '`pw2`.`piwik_archive_blob_temp_2017_09_29`' exists. Please DISCARD the tablespace before IMPORT. - caused by plugin Actions";}'

Error: Got invalid response from API request: ?module=API&method=API.get&idSite=2004&period=day&date=2017-09-29,2017-09-29&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:182:"SQLSTATE[HY000]: General error: 1813 Tablespace for table '`pw2`.`piwik_archive_blob_temp_2017_09_29`' exists. Please DISCARD the tablespace before IMPORT. - caused by plugin Actions";}'

INFO [2017-09-29 09:40:09] Error: Got invalid response from API request: ?module=API&method=API.get&idSite=2014&period=day&date=2017-09-29,2017-09-29&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:158:"SQLSTATE[HY000]: General error: 1813 Tablespace for table '`pw2`.`piwik_archive_numeric_temp_2017_09_29`' exists. Please DISCARD the tablespace before IMPORT.";}'
anhnongdan commented 6 years ago

Work around: Copy idb and frm files of 2 archive temp tables of 'today' to destination DB and access to mysql cli.

The 2 tables will be there.

anhnongdan commented 6 years ago

Add temp archive to backup. Actually just 3 couples.

b147b3addd9de1ae9ee6b7b6c91e786b0d347a7b