#81071Update extension list in EM causes 100% CPU load for very long time
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.