AnsweredAssumed Answered

Queue in data_engine

Question asked by Miller2012 on Apr 15, 2019
Latest reply on Apr 16, 2019 by danst04

Hi everyone...

I have many queue on data_engine. I think that the problem is bad performance of the db server. But I see this line on the logs file data_engine.

Anyone know what is that????

 

Apr 15 15:57:28:064 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:28:064 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:29:065 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:29:065 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:29:119 [19664] de: Commit - inserted   11 rows to RN_QOS_DATA_0176 in 1792 ms (ms/r:162)

Apr 15 15:57:30:065 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:30:065 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:30:065 [9388] de: qos_data_thread - messages on hub: 12,117, messages in data_engine: 149,430 ( bulk buffers: 149,430, process queue: 0, limit: 100,000 )

Apr 15 15:57:31:066 [9388] de: qos_check - Check Queue Loop.  Connected: 1 vbQueue: 1

Apr 15 15:57:31:066 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:31:066 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:32:067 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:32:067 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:33:067 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:33:067 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:34:068 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:34:068 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:35:068 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:35:068 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:35:068 [9388] de: qos_data_thread - messages on hub: 12,117, messages in data_engine: 149,430 ( bulk buffers: 149,430, process queue: 0, limit: 100,000 )

Apr 15 15:57:36:069 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:36:069 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:37:070 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:37:070 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:38:071 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:38:072 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:39:099 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:39:099 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:40:109 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:40:109 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:40:109 [9388] de: qos_data_thread - messages on hub: 12,117, messages in data_engine: 149,430 ( bulk buffers: 149,430, process queue: 0, limit: 100,000 )

Apr 15 15:57:41:110 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:41:110 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:42:111 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:42:111 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:43:112 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:43:112 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:44:113 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:44:113 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:45:115 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:45:115 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:45:115 [9388] de: qos_data_thread - messages on hub: 12,117, messages in data_engine: 149,430 ( bulk buffers: 149,430, process queue: 0, limit: 100,000 )

Apr 15 15:57:46:115 [9388] de: qos_check - Check Queue Loop.  Connected: 1 vbQueue: 1

Apr 15 15:57:46:115 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:46:115 [9388] de: lockStatisticsFile UNLOCK

Apr 15 15:57:47:116 [9388] de: lockStatisticsFile LOCK

Apr 15 15:57:47:116 [9388] de: lockStatisticsFile UNLOCK

Outcomes