Duplicate entry '......' for for key 'sessions_pkey' aflter upgrade to 3.3.0.13

Software Support
1

Hi. Some days ago we upgraded to 3.3.0.13 using the stable-3_3_0 branch

and our logs has started to register those errors:

Jan 26 02:13:57 patty php: PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'islkj86p2oa520jhf02vjk069m' for key 'sessions_pkey' in /var/web1/ojs33/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Jan 26 02:13:57 patty php: #0 /var/web1/ojs33/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): PDOStatement->execute(NULL)
Jan 26 02:57:31 patty php: PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'mvhegbg2lep5qb4ckil2cvn5a8' for key 'sessions_pkey' in /var/web1/ojs33/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Jan 26 02:57:31 patty php: #0 /var/web1/ojs33/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): PDOStatement->execute(NULL)

Those errors were not present with our previous 3.3.0.10 in the same server.

Our php versions is 7.3.31

I have used the “Expire User Sessions” tool in the administration and my sessions table was truncated but the problem persist.

Anybody with the same problem after the upgrade to 3.3.0.13?

I was reading topics related in previous post but they were not helpful.

Regards.

2

Nobody with those duplicate entry in the sessions table?

3

Hello @isaac.marco See this topic PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

4

We’re seeing these too. We’re running 3.3.0.14 with very few changes, implying that the fix above is not working for us. A non-trivial number of these contain the (usually truncated) URL https://tests.arachni-scanner.com/rfi.md5.txt This is probably pen-testers probing us using GitHub - Arachni/arachni: Web Application Security Scanner Framework (possibly even our in-house IT). We’re seeing > 100 of these / day at the moment.

cheers
stuart

[Tue Jun 13 08:52:10.917093 2023] [php7:error] [pid 29599] [client 146.6.15.11:47622] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘fbuaaefbg1i0ov3mbrighsji6jhttp://tests.arachni-scanner.com/rfi.m’ for key ‘sessions.sessions_pkey’ in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119\nStack trace:\n#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): PDOStatement->execute(NULL)\n#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database…