Author Topic: SQL errors on roundcube webmail tables  (Read 1307 times)

Offline samarthjoshi

  • Newbie
  • *
  • Posts: 1
SQL errors on roundcube webmail tables
« on: March 16, 2022, 10:06:11 AM »
We are using Roundcube Webmail 1.4.3 and in our SQL logs we are getting many INSERT and UPDATE errors on roundcube tables like 'session', 'cache_index' and 'cache_messages'.

We are using MariaDB as a database in a 3 node multi-master configuration and the SQL logs are filled with errors on these tables.
Due to such a large number of logs the server goes down.

The INSERT statements fail due to an error of "ERROR 1062: Duplicate entry '...' for key 'PRIMARY'"
and the UPDATE statements fails giving an error of "ERROR 1213: Deadlock found when trying to get lock; try restarting transaction"

sql error logs are attached below