I brought up this issue on Zulip, they referred me to this ticket. Commenting here for visibility. My team would really appreciate if this could be hotfixed to 5.6 when merged! Thank you.

https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user/topic/MariaDB.20sequence.20metadata.20failure