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
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.
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 progressError 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
Please find attached the DB logs.
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
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.
A deeper diagnosis may be required here. Please open a support case.
ok sankar. Will raise a support case. Thank you so much for your continuous support.