#82551Upgrade Wizard Deadlock
Description
Hello,
with newer 8.7.x versions, at least with 8.7.7, we experience a deadlock for these DB changes:
CREATE INDEX `cache_id` ON cf_cache_imagesizes (identifier, expires)
CREATE INDEX `cache_id` ON cf_cache_imagesizes_tags (identifier)
CREATE INDEX `cache_tag` ON cf_cache_imagesizes_tags (tag)
The Error message is three times:
SQL-ERROR: Index column size too large. The maximum column size is 767 bytes.
When executed manually, it is considered a “warning” only:
1071 Specified key was too long; max key length is 767 bytes 1478 InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope. 1478 InnoDB: assuming ROW_FORMAT=COMPACT.
We are running Debian 9.1 with Maria 10.1 on the server.
Greetings,
Manuel