Timeouts occur when trying to access *Manage>Physical Storage* on Ubuntu 18.04
|Target version:||Release 2.5.1|
|Google Code Legacy ID:||Tested version:||2.5|
Timeouts when trying to access Manage>Physical storage are due to a MYSQL 5.7 optimization setting that defaults to ON when running on Ubuntu 18.04
There is a MySQL bug report here that seems to be this exact issue:
Test query used to trigger behaviour in MySQL console:
select * from physical_object LEFT JOIN physical_object_i18n source ON (physical_object.ID=source.id AND source.CULTURE=physical_object.SOURCE_CULTURE AND source.CULTURE <> 'en') ;
SET SESSION optimizer_switch='block_nested_loop=off'; <-- fixes the issue
Setting this to 'off' will allow access to the manage physical storage pages - but this configuration change will be lost if MySQL is restarted.
It seems to be directly related to the 'left join' combined with the compound ON clause. This test query is based on lib/QubitCultureFallback.class.php criteria added in the physical storage browse query. I expect this slow behaviour will be encountered anywhere we are using QubitCultureFallback.class.php.
#3 Updated by Dan Gillean about 1 year ago
- Category set to Installation
- Status changed from New to QA/Review
2.5 docs updated in the following commit: https://github.com/artefactual/atom-docs/commit/f48b7675fbb0f1c6a071bc6935701ef9397ee69b