I created the mysql DB from a backup of production db.
Production had innodb_file_format
parameter as Barracuda
The new environment had innodb_file_format
parameter as Antelope
The ROW_FORMAT
for the table in production was COMPRESSED
Unfortunately Antelope
db doesn’t support ROW_FORMAT
as COMPRESSED
If I had looked more into the details of information_schema, I could have resolved it eatlier!
CLICK HERE to find out more related problems solutions.