ng6 interface slow
NG6 run view quite long to display clicking on a project in project list view, til we got a blank page
Activating the debug preset in typo3 (https://ng6.toulouse.inra.fr/typo3 > Settings > Configuration Presets > Debug settings > Custom configuration [Active] : BE=1, FE=1, devIPMask=*, displayErrors=1, systemLogLevel=0
refreshing the view displays the error :
Fatal error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 1743296768 bytes) in /var/www/html/ng6/typo3conf/ext/typo3db_legacy/Classes/Database/DatabaseConnection.php on line 503
Increasing memory_limit in php.ini solved for some time, but Fatal error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 1743296768 bytes) in /var/www/html/ng6/typo3conf/ext/typo3db_legacy/Classes/Database/DatabaseConnection.php on line 503
I did not found a way to display sql queries, so I added file_put_contents("/var/www/html/ng6/typo3temp/sql.log", $query."\n",FILE_APPEND); in /var/www/html/ng6/typo3conf/ext/typo3db_legacy/Classes/Database/DatabaseConnection.php > query function while refreshing the page, output SQL log :
nG6_project_analyze.analyze_id WHERE tx_nG6_project.uid=1700
SELECT * FROM tx_nG6_view_project_run WHERE project_id = 1700
SELECT * FROM tx_nG6_view_project_run_analyze WHERE project_id = 1700
SELECT * FROM tx_nG6_view_project_analyze WHERE project_id = 1700
SELECT project_id , count() AS count FROM tx_nG6_view_project_run WHERE project_id = 1700 GROUP BY project_id
SELECT project_id , count() AS count FROM tx_nG6_view_project_run_analyze WHERE project_id = 1700 GROUP BY project_id
SELECT project_id , count(*) AS count FROM tx_nG6_view_project_analyze WHERE project_id = 1700 GROUP BY project_id
SELECT * FROM tx_nG6_view_project_user
in phpMyAdmin :
SELECT count(*) FROM tx_nG6_view_project_user > 13619506!!!!!!!!!!!!
SELECT * FROM fe_rights_levels > 8911!!! whereas we should only have 3 records
refreshing https://ng6.toulouse.inra.fr/projects?tx_nG6_pi1[project_id]=1700 > 2 more records in fe_rights_levels
DELETE FROM fe_rights_levels where uid > 3 : refreshing https://ng6.toulouse.inra.fr/projects?tx_nG6_pi1[project_id]=1700 > the page loading is fast
but 2 more records inserted in fe_rights_levels
