Clarity Service Management

Expand all | Collapse all

Setting NX_VIRTDB_SELECT_QUEUE_WARN

  • 1.  Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 08:55 AM

    I am getting an error message in the stdlog about NX_VIRTB_SELECT_QUEUE_WARN is currently set at 3000 milliseconds.  We are getting delayed server errors.  Would it be possible to bump this number to 6000 until we can find the cause?  I suspect it is Scoreboard queries but I have to prove it before the customer will let me change the queries.  One user has a query that the count is 34,800 and the same user has another query over 9000



  • 2.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 09:53 AM

    Patsy,

     

    You could bump it to  

     

    @NX_VIRTB_SELECT_QUEUE_WARN=6000 

     

    A restart of SDM is needed for this to be effective.

     

    Is this AA or conventional?

     

    _R

     



  • 3.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 09:58 AM

    Where do I find it to change it?

     

    Patsy Waring

    EOHHS - CA Service Management - Development & Administration

    DXC

    Office:   617-847-6502

    Mobile: 321-863-4544

    Mail To: Patricia.waring@massmall.state.ma.us<mailto:Patricia.waring@massmall.state.ma.us>

    Mail to: Patricia.waring@DXC.COM<mailto:Patricia.waring@DXC.COM>

    100 Hancock Street - 5th floor- 5217, Quincy, Mass 02171



  • 4.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 10:00 AM

    Oops sorry.  NX_ROOT/NX.env file.

     

    You may need to do the same to the NX_ROOT/pdmconf/NX.env_NT.tpl  file too  and change them back once you get to the root cause

     

    _R



  • 5.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 10:02 AM

    That setting isn’t our NX.ENV

     

    Patsy Waring

    EOHHS - CA Service Management - Development & Administration

    DXC

    Office:   617-847-6502

    Mobile: 321-863-4544

    Mail To: Patricia.waring@massmall.state.ma.us<mailto:Patricia.waring@massmall.state.ma.us>

    Mail to: Patricia.waring@DXC.COM<mailto:Patricia.waring@DXC.COM>

    100 Hancock Street - 5th floor- 5217, Quincy, Mass 02171



  • 6.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 10:00 AM

    It is conventional

     

    Patsy Waring

    EOHHS - CA Service Management - Development & Administration

    DXC

    Office:   617-847-6502

    Mobile: 321-863-4544

    Mail To: Patricia.waring@massmall.state.ma.us<mailto:Patricia.waring@massmall.state.ma.us>

    Mail to: Patricia.waring@DXC.COM<mailto:Patricia.waring@DXC.COM>

    100 Hancock Street - 5th floor- 5217, Quincy, Mass 02171



  • 7.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 10:08 AM

    Patsy, you could set the variable to 6000 however I am not sure this will help resolve the server delay error. You should be right that the scoreboard queries cause the clog...why the user wants to look at 34800 tickets in one node? It does not make sense to me as this does not help the user anyway. You may want to restrict(like use DP) what kind of tickets the users can query. By the way, if you constantly see long running queris("The following statement took ...") in stdlog, you would need to investigate. Thanks _Chi



  • 8.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 10:16 AM

    What is DP?  I am trying everything to figure out this delayed server response error.  People are ever losing tickets.  They enter them but they never make it to the database.   Some of our long running queries are running for over a million milliseconds.

     

    Patsy Waring

    EOHHS - CA Service Management - Development & Administration

    DXC

    Office:   617-847-6502

    Mobile: 321-863-4544

    Mail To: Patricia.waring@massmall.state.ma.us<mailto:Patricia.waring@massmall.state.ma.us>

    Mail to: Patricia.waring@DXC.COM<mailto:Patricia.waring@DXC.COM>

    100 Hancock Street - 5th floor- 5217, Quincy, Mass 02171



  • 9.  Re: Setting NX_VIRTDB_SELECT_QUEUE_WARN

    Posted 11-08-2018 10:20 AM

    Patsy, DP is data partition. Thanks _Chi