I had the same problem

sp_getapplock refers to SqlServer, which suggest that there is a problem with MySql.EntityFrameworkCore 9.0.0

I saw 2 solutions: 1- Use pre-release version of Pomelo.EntityFrameworkCore.MySql 2- Go back to EF 8

To play safe in prod, I choose option 2