[OJS 3.3.0-10] 7 ERROR: duplicate key value violates unique constraint "sessions_pkey"

Oi pessoal,
estou encontrando esse erro no meu log.
Alguém teria alguma sugestão do que pode estar acontecendo?

 PHP Fatal error:  Uncaught PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "sessions_pkey"
DETAIL:  Key (session_id)=(rttsmiudi6keesu14tu18aiom1) already exists. in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()
#2 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('INSERT INTO ses...', Array)
#3 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#4 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#5 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement('INSERT INTO ses...', Array)
#6 /var/www/ojs-3.3.0-10/lib/pkp/classes/db/DAO.inc.php(138): Illuminate\\Database\\Capsule\\Manager::__callStatic('affectingStatem...', Array)
#7 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionDAO.inc.php(72): DAO->update('INSERT INTO ses...', Array)
#8 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(89): SessionDAO->insertObject(Object(Session))
#9 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(129): SessionManager->__construct(Object(SessionDAO), Object(Request))
#10 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#11 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#12 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#13 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#14 /var/www/ojs-3.3.0-10/index.php(68): PKPApplication->execute()
#15 {main}

Next Doctrine\\DBAL\\Driver\\PDO\\Exception: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "sessions_pkey"
DETAIL:  Key (session_id)=(rttsmiudi6keesu14tu18aiom1) already exists. in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException))
#1 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\\DBAL\\Driver\\PDOStatement->execute()
#2 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('INSERT INTO ses...', Array)
#3 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#4 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#5 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement('INSERT INTO ses...', Array)
#6 /var/www/ojs-3.3.0-10/lib/pkp/classes/db/DAO.inc.php(138): Illuminate\\Database\\Capsule\\Manager::__callStatic('affectingStatem...', Array)
#7 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionDAO.inc.php(72): DAO->update('INSERT INTO ses...', Array)
#8 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(89): SessionDAO->insertObject(Object(Session))
#9 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(129): SessionManager->__construct(Object(SessionDAO), Object(Request))
#10 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#11 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#12 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#13 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#14 /var/www/ojs-3.3.0-10/index.php(68): PKPApplication->execute()
#15 {main}

Next Illuminate\\Database\\QueryException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "sessions_pkey"
DETAIL:  Key (session_id)=(rttsmiudi6keesu14tu18aiom1) already exists. (SQL: INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(rttsmiudi6keesu14tu18aiom1, 168.119.65.115, Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/), 1647386413, 1647386413, 0, , periodicos.ufes.br)) in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#1 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#2 /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement('INSERT INTO ses...', Array)
#3 /var/www/ojs-3.3.0-10/lib/pkp/classes/db/DAO.inc.php(138): Illuminate\\Database\\Capsule\\Manager::__callStatic('affectingStatem...', Array)
#4 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionDAO.inc.php(72): DAO->update('INSERT INTO ses...', Array)
#5 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(89): SessionDAO->insertObject(Object(Session))
#6 /var/www/ojs-3.3.0-10/lib/pkp/classes/session/SessionManager.inc.php(129): SessionManager->__construct(Object(SessionDAO), Object(Request))
#7 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#8 /var/www/ojs-3.3.0-10/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#9 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#10 /var/www/ojs-3.3.0-10/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#11 /var/www/ojs-3.3.0-10/index.php(68): PKPApplication->execute()
#12 {main}
  thrown in /var/www/ojs-3.3.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: https://periodicos.ufes.br/index.php/argumentum/article/view/10517

@Adriano_Jose,

replicando a resposta postada aqui:

https://forum.ibict.br/t/3-3-0-7-com-postgres-artigos-somem-da-edicao-ao-ser-publicado/3528/4

Acredito que esse problema não interfira no funcionamento do sistema, pois esse erro

ERROR:  duplicate key value violates unique constraint "sessions_pkey"

acontece quando o sistema tenta criar um novo registro na tabela sessions que contem essas informações de sessões do usuário. Portanto, esses de dados só ficam ativos quando existe sessões ativas.

Uma forma de contornar esse problema, é Expirar as sessões de usuários na área de Funções Administrativas com o perfil de administrador.
Realiza esse procedimento na manutenção diária do sistema, por exemplo antes de realizar o backup do banco de dados, pois esse procedimento irá expirar todas as sessões de usuários.

Acredito que feito isso somente uma vez o problema desaparecerá.

2 curtidas