Service Virtualization

Expand all | Collapse all

SQL query took a long time

  • 1.  SQL query took a long time

    Posted 04-18-2019 12:12 PM

    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)

    zip
    Logs.zip   61K 1 version
    zip
    DBLog1.zip   6K 1 version


  • 2.  Re: SQL query took a long time

    Posted 04-19-2019 04:25 AM

    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



  • 3.  Re: SQL query took a long time

    Posted 04-23-2019 05:23 AM

    Hi Sankar,

     

    Please find attached the DB logs.



  • 4.  Re: SQL query took a long time

    Posted 04-23-2019 05:43 AM

    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



  • 5.  Re: SQL query took a long time

    Posted 04-23-2019 07:37 AM

    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. 



  • 6.  Re: SQL query took a long time

    Posted 04-23-2019 07:48 AM

    Hi Surya

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

     

    -Sankar



  • 7.  Re: SQL query took a long time

    Posted 04-23-2019 10:07 AM

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