We have two pod in one service (springboot and hibernate), using azure sql server, but we were using MYSQLDialect(hibernate dialect), so one pod failing in saving item. driver and all were given correctly for azure sql server. error ->** SQLServerException: function last_insert_id not recognized**. but other pod was passing. So, one pod was saving continously with no issues and other pod was passing with this exception. We restarted pods and randomly that pod either fails always to save. Or pass always to save. So, why sometimes pod fails with this exception, as in my local it’s not failing as last_insert_id is not called while saving item. Only in production it fails for some pods sometimes. Let me know the scenario, by which it starts to fail.
Are we missing anything, why it was working from 3-4 months and it starts to fail now and why on restarting it again starts working sometimes. It mostly depending pod to pod. Some pods able to save item some not. Please let me know the reason why it happens so. Is dialect not an issue, as MySQL dialect was also giving the correct saving most of the times in pods. But sometimes in specific pod only it starts giving issues. Please help to find root cause for this.
Using hibernate core 5.6 and hibernate validator 6.1
We were not able to replicate the issue in local and in prod db it starts to fail sometimes. We just try restarting with mysql dialect and sometimes randomly it’s working. We are expecting the reason why this issue starts happening only sometimes, why it’s not able to save items in some pods with same code sometimes. Is there can be other reason which can be unrelated to dialect. Please help to find root cause for this.