Issue Bug Closed

#81070Update extension list in EM causes 100% CPU load for very long time

Jan Kornblum 04/28/17, 20:44 updated 05/01/17, 20:28

Description

After clearing all rows from tx_extensionmanager_domain_model_extension, retrieving the extension list causes 100% CPU load for many minutes.

Server: Ubuntu 16.04 LTS
PHP: 7.0.15
MySQL: 5.7.18 (5.7.18-0ubuntu0.16.04.1 for Linux on x86_64version)
TYPO3: 7.6.18

—-

mysql> show full processlist\G
*************************** 1. row ***************************
Id: 30
User: root
Host: localhost
db: NULL
Command: Sleep
Time: 928
State:
Info: NULL
*************************** 2. row ***************************
Id: 35
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: starting
Info: show full processlist
*************************** 3. row ***************************
Id: 42
User: typo3
Host: localhost:45972
db: typo3
Command: Query
Time: 527
State: Sending data
Info: SELECT a.uid AS uid FROM tx_extensionmanager_domain_model_extension a LEFT JOIN tx_extensionmanager_domain_model_extension b ON a.repository = b.repository AND a.extension_key = b.extension_key AND a.integer_version < b.integer_version WHERE a.repository = 1 AND b.extension_key IS NULL ORDER BY a.uid

—-

Perhaps this is related to this MySQL bug:

_High CPU usage issue/stuck queries with 5.7.6-m16_
https://bugs.mysql.com/bug.php?id=76402

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.