Hi @Vitaliy and any other interested people,
Looking at our site, I noted the specific areas of the site that were inoperable while we were on 7.4.
On the administration menu, the Users, Articles, and Editorial Activity sections return the HTTP ERROR 500 when they’re accessed. The COUNTER reports work as well as the primary report we utilize, the PKP Usage Statistics Report.
So far, the closest PHP error I can find is the following:
[26-Jan-2022 19:43:29 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘d27451f62ee3f4382a48ced86d3a2fe9’ for key ‘sessions_pkey’ in //ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 //ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 //ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 //ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘INSERT INTO ses…’, Array)
#3 //ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘INSERT INTO ses…’, Array, Object(Clos in //ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
EDIT: As I was writing this out, I was swapping to 7.4 to attempt to recreate the error message and it all works now.
I literally have 0 clue what happened, as I have no information as to what was causing the issue in the first place but it’s all working without any error messages so far. I’ll close this for now and if it happens again, I’ll link back to it and have the logs posted.
Thanks for your help @Vitaliy