Missing ticket updates on high load in MariaDB/MySQL environments

[rolfschmidt]

Infos:

• Used Zammad version: 5.0
• Installation method (source, package, ..): all
• Operating system: all
• Database + version: MariaDB/MySQL all versions
• Elasticsearch version: all
• Browser + version: all
• Ticket#1095730

Expected behavior:

• Ticket updates should not miss if many agents update tickets.

Actual behavior:

• Ticket updates in high load will result in missing ticket updates which will not return any exceptions or errors on database level and zammad or rails level. Also the ticket update SQL will be visible in general log of mysql but not executed.

Steps to reproduce the behavior:

• Can be reproduced with this script (WARNING: This script will create tickets randomly)

test_zammad_load.zip

Yes I'm sure this is a bug and no feature request or a general question