CA Service Management

 View Only
  • 1.  sqlsrvr log warning

    Posted May 02, 2018 10:26 AM

    Hi,

     

    I'm getting the following warning message in the log file:

    sqlagt:select100     7072 SIGNIFICANT  sqlsrvr.c   The limit set by NX_SQL_QUEUE_LIMIT of 200 has been reached. FETCH Message queuing has begun.

     

    Can anyone clarify what is this? It is possible to change the limit so the message disappear?

     

    Thanks in advance.



  • 2.  Re: sqlsrvr log warning
    Best Answer

    Broadcom Employee
    Posted May 02, 2018 10:46 AM

    Francisco, this NX_SQL_QUEUE_LIMIT is the virtdb agent sql queue limit and the message says this agent(sqlagt:select100) has reaches its limit and now another queue(FETCH) starts. You can think about SQL Q the Q before FETCH Q in virtdb. Usually this means there is DB difficulty(DBMS too busy, network delay etc). You could change this value by adding

    @ NX_SQL_QUEUE_LIMIT=1000

    (say you want to change to 1000)

    in NX.env file. This could make this message pop not that often. Thanks _Chi