Issue Bug Closed

#82551Upgrade Wizard Deadlock

SICOR KDL GmbH 09/25/17, 11:11 updated 10/02/18, 10:55

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

Reviews 1