LastaFluteのアプリケーションを AWSのLoad Balancerで2つのサーバーで処理すると、
片方のサーバーでは問題なく取得されるクエリーがもう一つでは結果が取得できません。
たとえば下記のログですが、
select dfloc.ID as ID, dfloc.UUID as UUID, dfloc.LOGIN_ID as LOGIN_ID, dfloc.GRP as GRP, dfloc.DATA as DATA, dfloc.VERSION_NO as VERSION_NO, dfloc.DEL_FLAG as DEL_FLAG, dfloc.REGISTER_DATETIME as REGISTER_DATETIME, dfloc.REGISTER_USER as REGISTER_USER, dfloc.REGISTER_PROCESS as REGISTER_PROCESS, dfloc.UPDATE_DATETIME as UPDATE_DATETIME, dfloc.UPDATE_USER as UPDATE_USER, dfloc.UPDATE_PROCESS as UPDATE_PROCESS
from SESSION dfloc
where dfloc.UUID = '5510521f-688c-47fa-9f9f-ee412879b7c9'
and dfloc.DEL_FLAG = 0
2020-06-29 12:50:25,195 [qtp5599868-30] DEBUG (XLog@log():43) - ===========/ [00m00s007ms (1) first={59575, 5510521f-688c-47fa-9f9f-ee412879b7c9, 401, null, null, 0, 0, 2020-06-29T12:48:17, TL高橋, Login, 2020-06-29T12:48:17, TL高橋, Login}@53c0f8b2]
12:50:25に取得できています。
このデータが他方のサーバーでは下記の様に取得できません。
2020-06-29 12:50:27,204 [qtp1814405959-28] DEBUG (QLog@log():43) -
select dfloc.ID as ID, dfloc.UUID as UUID, dfloc.LOGIN_ID as LOGIN_ID, dfloc.GRP as GRP, dfloc.DATA as DATA, dfloc.VERSION_NO as VERSION_NO, dfloc.DEL_FLAG as DEL_FLAG, dfloc.REGISTER_DATETIME as REGISTER_DATETIME, dfloc.REGISTER_USER as REGISTER_USER, dfloc.REGISTER_PROCESS as REGISTER_PROCESS, dfloc.UPDATE_DATETIME as UPDATE_DATETIME, dfloc.UPDATE_USER as UPDATE_USER, dfloc.UPDATE_PROCESS as UPDATE_PROCESS
from SESSION dfloc
where dfloc.UUID = '5510521f-688c-47fa-9f9f-ee412879b7c9'
and dfloc.DEL_FLAG = 0
2020-06-29 12:50:27,211 [qtp1814405959-28] DEBUG (XLog@log():43) - ===========/ [00m00s007ms (0)]
なにか原因は考えられるでしょうか。
お忙しい所 よろしくおねがいします。
志村