[TECHNICAL-SUPPORT] LPS-39276 Lock service should always use the primary database node if read/write splitting is enabled

Hi Shuyang,

you are already familiar with this issue.
We talked to @zsigmondrab, and he agreed that as there is a bug, we should try to handle it.
Could you please review the changes?

Thanks is advance,
Tamás