Setting NX_VIRTDB_SELECT_QUEUE_WARN

[PatsyW]

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

[Raghu Rudraraju]

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

 

[PatsyW]

Where do I find it to change it?

 

Patsy Waring

EOHHS - CA Service Management - Development & Administration

DXC

Office:   617-847-6502

Mobile: [phone]

Mail To: [e-mail]<mailto:[e-mail]>

Mail to: [e-mail]<mailto:[e-mail]>

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

[Raghu Rudraraju]

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

[PatsyW]

That setting isn’t our NX.ENV

 

Patsy Waring

EOHHS - CA Service Management - Development & Administration

DXC

Office:   617-847-6502

Mobile: [phone]

Mail To: [e-mail]<mailto:[e-mail]>

Mail to: [e-mail]<mailto:[e-mail]>

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

[PatsyW]

It is conventional

 

Patsy Waring

EOHHS - CA Service Management - Development & Administration

DXC

Office:   617-847-6502

Mobile: [phone]

Mail To: [e-mail]<mailto:[e-mail]>

Mail to: [e-mail]<mailto:[e-mail]>

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

[Chi Chen]

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

[PatsyW]

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: [phone]

Mail To: [e-mail]<mailto:[e-mail]>

Mail to: [e-mail]<mailto:[e-mail]>

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

[Chi Chen]

Patsy, DP is data partition. Thanks _Chi