Lock wait timeout exceeded

[Guizmo]

Hi,

I’m using Kopano 10.0.6.406 with MySQL 8.0.21 on Debian Buster.

The server often gets inaccessible (several times per day) with server log showing lot of :
[error ] SQL [00000105] result failed: Lock wait timeout exceeded; try restarting transaction, Query: “SELECT 1 FROM properties WHERE hierarchyid IN(5582484) LOCK IN SHARE MODE”
[error ] KDatabase::I_Update() query failed: “Lock wait timeout exceeded; try restarting transaction”, query: INSERT INTO hierarchy (parent, type, flags, owner) values(28745561, 5, 0, 933)

This disappears for few hours after restarting kopano-server, kopano-gateway and MySQL.

Any idea of the source of this problem ?

Thank you in advance

[fbartels]

Hi @guizmo,

this is usually a sign of insufficient database tuning. The database server cannot perform its writes fast enough (data to be updated still locked) and therefore kopano-server will retry the same write later on.

[Guizmo]

Hi @fbartels

Thank you for your answer.

I followed the recommendations from the performances tuning section of manual :
innodb_buffer_pool_size = 8G
innodb_log_file_size = 2G
innodb_log_buffer_size = 512M
max_allowed_packet = 32M

Do you have any suggestion on where to improve tuning or where to look to see what could cause the bottleneck ?

Thanks