Lock wait timeout error

Hello,

We are experiencing more and more "Lock wait timeout" errors using Rollbase.
We have 30 customers on the same Rollbase database and overall the application runs very smoothly.
(Saving a records usually only takes 1 second)

But sometimes after saving a record, we have to wait 30 seconds and then see a "Lock wait timeout" error. We are pretty sure that this is not a trigger code problem or infinite loop since we only experience this very rarely. All of our customers experience this "lock wait timeout" error on different objects, at least 2 or 3 times a day.

All of our customers share the same database in one server (MySQL), our Rollbase database is 14GB large. Why do we experience this issues? Do you have any configuration tips to avoid this?

Kind regards,

Romain.

Continue reading...