Hi, I'm not exactly sure when this started, but within the past few weeks my production ARS has started repeatedly issuing the following three SQL statements:
*SELECT TOP 2 T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier Service') ORDER BY 1 ASC* *SELECT MAX(timestamp) FROM user_cache* *SELECT MAX(timestamp) FROM group_cache* T127 is the User form. It's doing this about 10 times per second. Can anyone shed any light on what it's doing and how I can stop it? Any help would be appreciated. Here is the raw SQL logging should the additional detail be useful: <SQL > <TID: 0000007056> <RPC ID: 0003449550> <Queue: List > <Client-RPC: 390620 > <USER: MidTier Service-- Impersonated by MidTier Service --> <Overlay-Group: 1 > /* Mon Jun 18 2018 07:34:34.8220 */SELECT TOP 2 T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier Service') ORDER BY 1 ASC <SQL > <TID: 0000007056> <RPC ID: 0003449550> <Queue: List > <Client-RPC: 390620 > <USER: MidTier Service-- Impersonated by MidTier Service --> <Overlay-Group: 1 > /* Mon Jun 18 2018 07:34:34.8230 */OK <SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast > <Client-RPC: 390620 > <USER: MidTier Service > <Overlay-Group: 1 > /* Mon Jun 18 2018 07:34:34.8570 */SELECT MAX(timestamp) FROM user_cache <SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast > <Client-RPC: 390620 > <USER: MidTier Service > <Overlay-Group: 1 > /* Mon Jun 18 2018 07:34:34.8580 */OK <SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast > <Client-RPC: 390620 > <USER: MidTier Service > <Overlay-Group: 1 > /* Mon Jun 18 2018 07:34:34.8580 */SELECT MAX(timestamp) FROM group_cache <SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast > <Client-RPC: 390620 > <USER: MidTier Service > <Overlay-Group: 1 > /* Mon Jun 18 2018 07:34:34.8580 */OK Thanks, Charlie
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
