Status: Closed (View Workflow)
Affects Version/s: 10.4.19, 10.5.10
Component/s: Storage Engine - InnoDB
Environment:linux gentoo - Intel Xeon-E 2288G (https://www.ovhcloud.com/es-es/bare-metal/infra/infra-2/)
MariaDb server crashes when a query like this is executed repeatedly:
SELECT m.* FROM messenger_messages_fr1 m WHERE (m.delivered_at is null OR m.delivered_at < '2021-07-30 1
1:35:00') AND (m.available_at <= '2021-07-30 12:35:00') AND (m.queue_name = 'mailer_async') ORDER BY available_at ASC LIMIT 1 FOR UPDATE
Logs show this:
0x7faff3f8f640 InnoDB: Assertion failure in file /var/tmp/portage/dev-db/mariadb-10.5.10-r1/work/mysql/storage/innobase/lock/lock0lock.cc line 6682
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
I am using the Messenger component from Symfony, which runs this query, I detected that when 2 servers are connected to the same database, and run the same symfony command for mananing queues, when both commands try to lock the same row repeatedly, this error happens.
This error is experienced both using a single database and multiple in a galera cluster setup.