Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • ng6 ng6
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 52
    • Issues 52
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

Maintenance - Mise à jour exceptionnelle Jeudi 8 Juin entre 7h00 et 9h00

  • genotoul-bioinfo
  • ng6ng6
  • Issues
  • #202
Closed
Open
Issue created Apr 30, 2021 by Gerald Salin@gsalinMaintainer

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
image

Edited Apr 30, 2021 by Gerald Salin
Assignee
Assign to
Time tracking