Query execution was interrupted

OJS 3.2.1-4

I have a problem with Journals in version 3.2.1-4. This query runs for a long time and results in a lot of processing on the server.
Do you know it could be?

[Tue Aug 24 09:03:51 2021] [error] [client ] PHP Fatal error:  Uncaught Exception: DB Error: Query execution was interrupted Query: SELECT\n\t\t\t\to.submission_id,\n\t\t\t\tMAX(s.context_id) AS journal_id,\n\t\t\t\tMAX(i.date_published) AS i_pub,\n\t\t\t\tMAX(p.date_published) AS s_pub,\n\t\t\t\tCOUNT(*) AS count\n\t\t\tFROM\n\t\t\t\tsubmissions s\n\t\t\t\tJOIN publications p ON (p.publication_id = s.current_publication_id)\n\t\t\t\tJOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId')\n\t\t\t\tJOIN issues i ON (CAST(i.issue_id AS CHAR(20)) = ps.setting_value)\n\t\t\t\tJOIN submission_search_objects o ON (s.submission_id = o.submission_id)\n\t\t\t\tNATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0\n\t\t\tWHERE\n\t\t\t\ts.status = 3 AND\n\t\t\t\ti.published = 1 AND k0.keyword_text = ? AND i.journal_id = ?\n\t\t\tGROUP BY o.submission_id\n\t\t\tORDER BY count DESC\n\t\t\tLIMIT 500 in /var/www/html/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/html/lib/pkp/classes/db/DAO.inc.php(135): DAO->handleError(Object(ADODB_mysqli), 'SELECT\\n\\t\\t\\t\\to.su...')\n in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 703, referer: https://www.google.com/
[Tue Aug 24 09:03:51 2021] [error] [client ] PHP Fatal error:  Uncaught Exception: DB Error: Query execution was interrupted Query: SELECT\n\t\t\t\to.submission_id,\n\t\t\t\tMAX(s.context_id) AS journal_id,\n\t\t\t\tMAX(i.date_published) AS i_pub,\n\t\t\t\tMAX(p.date_published) AS s_pub,\n\t\t\t\tCOUNT(*) AS count\n\t\t\tFROM\n\t\t\t\tsubmissions s\n\t\t\t\tJOIN publications p ON (p.publication_id = s.current_publication_id)\n\t\t\t\tJOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId')\n\t\t\t\tJOIN issues i ON (CAST(i.issue_id AS CHAR(20)) = ps.setting_value)\n\t\t\t\tJOIN submission_search_objects o ON (s.submission_id = o.submission_id)\n\t\t\t\tNATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0\n\t\t\tWHERE\n\t\t\t\ts.status = 3 AND\n\t\t\t\ti.published = 1 AND k0.keyword_text = ? AND i.journal_id = ?\n\t\t\tGROUP BY o.submission_id\n\t\t\tORDER BY count DESC\n\t\t\tLIMIT 500 in /var/www/html/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/html/lib/pkp/classes/db/DAO.inc.php(135): DAO->handleError(Object(ADODB_mysqli), 'SELECT\\n\\t\\t\\t\\to.su...')\n in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 703
[Tue Aug 24 09:03:51 2021] [error] [client ] PHP Fatal error:  Uncaught Exception: DB Error: Query execution was interrupted Query: SELECT\n\t\t\t\to.submission_id,\n\t\t\t\tMAX(s.context_id) AS journal_id,\n\t\t\t\tMAX(i.date_published) AS i_pub,\n\t\t\t\tMAX(p.date_published) AS s_pub,\n\t\t\t\tCOUNT(*) AS count\n\t\t\tFROM\n\t\t\t\tsubmissions s\n\t\t\t\tJOIN publications p ON (p.publication_id = s.current_publication_id)\n\t\t\t\tJOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId')\n\t\t\t\tJOIN issues i ON (CAST(i.issue_id AS CHAR(20)) = ps.setting_value)\n\t\t\t\tJOIN submission_search_objects o ON (s.submission_id = o.submission_id)\n\t\t\t\tNATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0\n\t\t\tWHERE\n\t\t\t\ts.status = 3 AND\n\t\t\t\ti.published = 1 AND k0.keyword_text = ? AND i.journal_id = ?\n\t\t\tGROUP BY o.submission_id\n\t\t\tORDER BY count DESC\n\t\t\tLIMIT 500 in /var/www/html/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/html/lib/pkp/classes/db/DAO.inc.php(135): DAO->handleError(Object(ADODB_mysqli), 'SELECT\\n\\t\\t\\t\\to.su...')\n in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 703, referer: https://scholar.google.com.br/
[Tue Aug 24 09:03:51 2021] [error] [client ] PHP Fatal error:  Uncaught Exception: DB Error: MySQL server has gone away Query: SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ? in /var/www/html/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/html/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT * FROM c...')\n#1 /var/www/html/lib/pkp/classes/db/DAO.inc.php(590): DAO->retrieve('SELECT * FROM c...', Array)\n#2 /var/www/html/lib/pkp/classes/controlledVocab/ControlledVocabEntryDAO.inc.php(107): DAO->getDataObjectSettings('controlled_voca...', 'controlled_voca...', '20859', Object(SubmissionLanguage))\n#3 /var/www/html/lib/pkp/classes/db/DAOResultFactory.inc.php(108): ControlledVocabEntryDAO->_fromRow(Array, Array)\n#4 /var/www/html/lib/pkp/classes/submission/SubmissionLanguageDAO.inc.php(55): DAOResultFactory->next()\n#5 /var/www/html/lib/pkp/classes/publication/PKPPublicationDAO.inc.php(65): SubmissionLanguageDAO->getLanguages(798)\n#6 /var/www/html/classes/publication/PublicationDAO.inc.php(40): PKPPu in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 703
[Tue Aug 24 09:03:51 2021] [error] [client ] PHP Fatal error:  Uncaught Exception: DB Error: MySQL server has gone away Query: UPDATE sessions\n\t\t\t\tSET\n\t\t\t\t\tuser_id = ?,\n\t\t\t\t\tip_address = ?,\n\t\t\t\t\tuser_agent = ?,\n\t\t\t\t\tcreated = ?,\n\t\t\t\t\tlast_used = ?,\n\t\t\t\t\tremember = ?,\n\t\t\t\t\tdata = ?,\n\t\t\t\t\tdomain = ?\n\t\t\t\tWHERE session_id = ? in /var/www/html/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), 'UPDATE sessions...')\n#1 /var/www/html/lib/pkp/classes/session/SessionDAO.inc.php(109): DAO->update('UPDATE sessions...', Array)\n#2 /var/www/html/lib/pkp/classes/session/SessionManager.inc.php(185): SessionDAO->updateObject(Object(Session))\n#3 [internal function]: SessionManager->write('be92s59e792fj38...', '')\n#4 [internal function]: session_write_close()\n#5 {main}\n  thrown in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 703
[Tue Aug 24 09:03:51 2021] [error] [client ] PHP Fatal error:  Uncaught Exception: DB Error: MySQL server has gone away Query: UPDATE sessions\n\t\t\t\tSET\n\t\t\t\t\tuser_id = ?,\n\t\t\t\t\tip_address = ?,\n\t\t\t\t\tuser_agent = ?,\n\t\t\t\t\tcreated = ?,\n\t\t\t\t\tlast_used = ?,\n\t\t\t\t\tremember = ?,\n\t\t\t\t\tdata = ?,\n\t\t\t\t\tdomain = ?\n\t\t\t\tWHERE session_id = ? in /var/www/html/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /var/www/html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), 'UPDATE sessions...')\n#1 /var/www/html/lib/pkp/classes/session/SessionDAO.inc.php(109): DAO->update('UPDATE sessions...', Array)\n#2 /var/www/html/lib/pkp/classes/session/SessionManager.inc.php(185): SessionDAO->updateObject(Object(Session))\n#3 [internal function]: SessionManager->write('u82qh9lv457mdcg...', 'csrf|a:2:{s:9:"...')\n#4 [internal function]: session_write_close()\n#5 {main}\n  thrown in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 703, referer: https://scholar.google.com.br/

Ho @Carlos_Fontes,

I have the same problem, with the same version of OJS. You could solve or know why this happened.