DB Error: Duplicate entry 'xxxxxx' for key 'sessions_pkey'

@asmecher,

I enabled the debug on and show stats on and here is the stack trace, It seems it is trying to insert, not sure whether it is the expected behaviour:

(mysql): SET NAMES ‘utf8’
(mysql): INSERT INTO sessions (session_id, ip_address, user_agent, created, last_used, remember, data, domain) VALUES (‘cuff3emf3rirk9qtkubgnlp6o5’, ‘122.172.129.23’, ‘Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36’, 1497097561, 1497097561, 0, ‘’, ‘ayushdhara.in’)
1062: Duplicate entry ‘cuff3emf3rirk9qtkubgnlp6o5’ for key ‘sessions_pkey’
ADOConnection._Execute(INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
('cuff3…) % line 845, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(?, ?, …, Array[8]) % line 226, file: DAO.inc.php
DAO.update(INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(?, ?, …, Array[8]) % line 88, file: SessionDAO.inc.php
SessionDAO.insertSession(Object:Session) % line 91, file: SessionManager.inc.php
SessionManager.SessionManager(Object:SessionDAO, Object:Request) % line 130, file: SessionManager.inc.php
DB Error: Duplicate entry ‘cuff3emf3rirk9qtkubgnlp6o5’ for key ‘sessions_pkey’

Stack Trace:

File: /var/www/tangenti/data/www/ayushdhara.in/lib/pkp/classes/session/SessionDAO.inc.php line 88
Function: DAO->update(“INSERT INTO sessions (session_id, ip_address, user_agent, cr…”, Array(8))

File: /var/www/tangenti/data/www/ayushdhara.in/lib/pkp/classes/session/SessionManager.inc.php line 91
Function: SessionDAO->insertSession(Object(Session))

File: /var/www/tangenti/data/www/ayushdhara.in/lib/pkp/classes/session/SessionManager.inc.php line 130
Function: SessionManager->SessionManager(Object(SessionDAO), Object(Request))

File: /var/www/tangenti/data/www/ayushdhara.in/classes/security/Validation.inc.php line 379
Function: SessionManager->getManager()

File: /var/www/tangenti/data/www/ayushdhara.in/lib/pkp/classes/core/PKPPageRouter.inc.php line 66
Function: Validation->isLoggedIn()

File: /var/www/tangenti/data/www/ayushdhara.in/lib/pkp/classes/core/Dispatcher.inc.php line 117
Function: PKPPageRouter->isCacheable(Object(Request))

File: /var/www/tangenti/data/www/ayushdhara.in/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))

File: /var/www/tangenti/data/www/ayushdhara.in/index.php line 64
Function: PKPApplication->execute()

Please let me know if something can be observed here to fix the issue.

Note:
Made it as Under Maintenance for now not to show errors to customers.