AnsweredAssumed Answered

SQL query took a long time

Question asked by suryateja24 on Apr 18, 2019
Latest reply on Apr 23, 2019 by suryateja24

Hi Team,


We're frequently getting the below error and due to this we suspect that since it is unable to log the information, VS is becoming unresponsive, even though it displays as up and running in the portal. Please find the below details and help me to resolve the issue. 


DevTest Version : 10.3

Database: MySQL

Devtest components and DB are running in same server

Server: Windows server 2012 R2


2019-04-18 14:29:07,625Z (16:29) [Metrics persister processing 33 objects] WARN  com.itko.lisa.utils.db.LisaSessionCustomizer - SQL query took a long time (1866 ms) : SELECT TXN_COUNTS_ID, VSE_NAME, VS_NAME, COUNTS_DATE, MISSES, REQUEST, SPECIFIC_HITS, TOTAL_COUNT, NODE_HITS FROM VSE_METRICS_TXN_COUNTS WHERE ((((VSE_NAME = ?) AND (VS_NAME = ?)) AND (REQUEST IS NULL)) AND (COUNTS_DATE = ?))


Please find attached the portal, registry and VSE logs for reference.