New Deadlock?
I discovered a possible deadlock in at least one CaosDB instance. When several (~10¹) insertions and updates, including adding references from old to new entities are performed over the curse of roughly an hour, the server may freeze entirely when adding a reference to a list property of an old entity (unclear whether this really matters or whether this can occur with any edit). Afterwards no entities can be retrieved and there's no response to any queries; db.Info()
, login and welcome page still work though.
The only possibly related error in the server logs is the following data truncation error that is put out some time (several 10 minutes) after the deadlock occurred and then re-appears hourly (do we have some benchmarks that run hourly?):
ERROR org.caosdb.server.database.misc.RootBenchmark - org.caosdb.server.database.exceptions.TransactionException: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'value' at row 1
Other than that, there is no info in the linkahaed or the mariadb logs.
This is not reproducible very well, since after restarting the server, redoing the edit that seemingly caused the deadlock will work without causing any problems.