Roundcube Community Forum

Release Support => Pending Issues => Topic started by: samarthjoshi on March 16, 2022, 10:06:11 AM

Title: SQL errors on roundcube webmail tables
Post by: samarthjoshi 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