MariaDB 10.3 (min) vs 10.6 (intended for queues)

[iBotPeaches]

So I was investigating a deadlock issue we had with queues - it was bugging me because I was up to date on Laravel and couldn't quite figure it out. I just knew I was on Maria 10.5.x and had constant deadlocks.

So I start googling and find this: #31287, which then I can't find any reference to Maria in it.

I double check docs and 10.5 is above minimum, so I must be good.

I then find PR for the Maria upgrade - #39396, examine the diff and it says "Maria 10.6+" basically in code - https://github.com/laravel/framework/pull/39396/files

So then I figure it out. We are behind on Maria versions leading to not having SKIP LOCKED and we schedule some RDS upgrades and problem goes away.

Since the DB driver is optional - I don't think its fair to say the minimum DB for Laravel is 10.6 for Maria, but I also think this should be in the docs somewhere. So you understand what you need for the queue system to preform as intended.

Do you think some notes in the queue section would suffice? https://laravel.com/docs/9.x/queues#driver-prerequisites - just trying to brainstorm where these notes could belong.