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