SQL query took a long time

[Suryateja Devanaboina]

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. 

Attachment(s)

Logs.zip   61 KB 1 version

DBLog1.zip   6 KB 1 version

[Sankar Natarajan]

HI Surya

            As I see from the log, this is a warning message, indicative of potential issues in querying the DB. We can rule out network latency since the DB server is local to Devtest. Upon analyzing the vse.log file that has been shared, the following was noticed:

 

Internal Exception: java.sql.BatchUpdateException: Server shutdown in progress
Error Code: 1053

 

This error code 1053 indicates that the DB Service may be not reachable or in a state of shutting down. Could you have the DB server log checked at this time 2019-04-18 13:04:52

 

regards

Sankar

[Suryateja Devanaboina]

Hi Sankar,

 

Please find attached the DB logs.

[Sankar Natarajan]

Thanks Surya. As suspected, the DB server was shutdown at the time mentioned in my first reply. An excerpt from your log file produced below indicates that the DB went through few shutdown cycles. Please could you check this with your DBA as to why the DB was going through frequent shutdown.

 

2019-04-18T13:04:56.374674Z 0 [Note] Shutting down plugin 'CSV'
2019-04-18T13:04:56.374674Z 0 [Note] Shutting down plugin 'sha256_password'
2019-04-18T13:04:56.375636Z 0 [Note] Shutting down plugin 'mysql_native_password'
2019-04-18T13:04:56.376637Z 0 [Note] Shutting down plugin 'binlog'
2019-04-18T13:04:56.383634Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete

[Suryateja Devanaboina]

Hi Sankar,

 

Since virtual services are in unresponsive mode, server was restarted during that time. As mentioned earlier, DevTest components and DB are running in same server. 

[Sankar Natarajan]

Hi Surya

                A deeper diagnosis may be required here. Please open a support case.

 

-Sankar

[Suryateja Devanaboina]

ok sankar. Will raise a support case. Thank you so much for your continuous support.