Hi,
I updated my OJS from 3.4.0.1 to 3.4.0.2 on 25th of August and on 26th of August my php error log shows the following Fatal error:
[26-Aug-2023 18:31:44 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘tn3crv1i1p0le3os4hr0djt2ah’ for key ‘sessions_pkey’ in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570
Stack trace:
#0 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): PDOStatement->execute()
#1 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database{closure}()
#2 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(577): Illuminate\Database\Connection->run()
#4 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\Database\Connection->affectingStatement()
#5 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Database\DatabaseManager->__call()
#6 /home/seisense/journal.seisense.com/lib/pkp/classes/db/DAO.php(170): Illuminate\Support\Facades\Facade::__callStatic()
#7 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionDAO.php(82): PKP\db\DAO->update()
#8 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionManager.php(375): PKP\session\SessionDAO->insertObject()
#9 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionManager.php(61): PKP\session\SessionManager->createSession()
#10 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionManager.php(70): PKP\session\SessionManager->__construct()
#11 /home/seisense/journal.seisense.com/lib/pkp/classes/security/Validation.php(402): PKP\session\SessionManager::getManager()
#12 /home/seisense/journal.seisense.com/lib/pkp/classes/core/PKPPageRouter.php(84): PKP\security\Validation::isLoggedIn()
#13 /home/seisense/journal.seisense.com/lib/pkp/classes/core/Dispatcher.php(139): PKP\core\PKPPageRouter->isCacheable()
#14 /home/seisense/journal.seisense.com/lib/pkp/classes/core/PKPApplication.php(387): PKP\core\Dispatcher->dispatch()
#15 /home/seisense/journal.seisense.com/index.php(21): PKP\core\PKPApplication->execute()
#16 {main}Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘tn3crv1i1p0le3os4hr0djt2ah’ for key ‘sessions_pkey’ (SQL: INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(tn3crv1i1p0le3os4hr0djt2ah, 40.77.202.144, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/112.0.0.0 Safari/537.36, 1693074704, 1693074704, 0, , journal.seisense.com)) in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(577): Illuminate\Database\Connection->run()
#2 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\Database\Connection->affectingStatement()
#3 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Database\DatabaseManager->__call()
#4 /home/seisense/journal.seisense.com/lib/pkp/classes/db/DAO.php(170): Illuminate\Support\Facades\Facade::__callStatic()
#5 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionDAO.php(82): PKP\db\DAO->update()
#6 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionManager.php(375): PKP\session\SessionDAO->insertObject()
#7 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionManager.php(61): PKP\session\SessionManager->createSession()
#8 /home/seisense/journal.seisense.com/lib/pkp/classes/session/SessionManager.php(70): PKP\session\SessionManager->__construct()
#9 /home/seisense/journal.seisense.com/lib/pkp/classes/security/Validation.php(402): PKP\session\SessionManager::getManager()
#10 /home/seisense/journal.seisense.com/lib/pkp/classes/core/PKPPageRouter.php(84): PKP\security\Validation::isLoggedIn()
#11 /home/seisense/journal.seisense.com/lib/pkp/classes/core/Dispatcher.php(139): PKP\core\PKPPageRouter->isCacheable()
#12 /home/seisense/journal.seisense.com/lib/pkp/classes/core/PKPApplication.php(387): PKP\core\Dispatcher->dispatch()
#13 /home/seisense/journal.seisense.com/index.php(21): PKP\core\PKPApplication->execute()
#14 {main}
thrown in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760
Any good idea to resolve this fatal error!
PHP: 8.1
Regards
seisense