Hello folks,

In the last couple of days we came across a number of situations where data dictionary failed to complete upgrade; Examples:

1) This one gave us some hint (error 197)

But doesn't give us a table/tablespace name or path, nor it suggests what can be done.

2) But this other one tell us nothing: 

How to repeat:

Uncertain; We believe it could be due to some inconsistency (orphans?) but couldn't find any tmp table or such that was in (for example) innodb_tablespaces but not in innodb_tables or.

Suggested fix:

Increase verbosity!

• Print out to the error log current step of the DD upgrade process

• Print out file path/tablespace name and/or id causing the errors 

• Print out possible suggestions to fix where sensible