Project

General

Profile

Actions

Bug #82551

closed

Upgrade Wizard Deadlock

Added by SICOR KDL GmbH over 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2017-09-25
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

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


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #82080: Indexes too large for some tables with utf8mb4Closed2017-08-11

Actions
Related to TYPO3 Core - Feature #80398: Make default charset and collation for new tables configurableClosed2017-03-22

Actions
Actions

Also available in: Atom PDF