Mx 9 Queue module not polluting the “ConnectionBus_Retrieve” log node - Mendix Forum

Mx 9 Queue module not polluting the “ConnectionBus_Retrieve” log node

4

I upgraded my test project to Mendix 9, to investigate the behavior of my queries on the database in this new version. Setting the “ConnectionBus_Retrieve” log node to “Trace” level, I got overwhelmed by the 72 log lines created every second by the Queue module (see below).

Please, log this information on some other node, such that I can focus on my “own” queries and the Queue module is not polluting the “ConnectionBus_Retrieve” log node anymore.

2021-04-21 14:02:20.851	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.851	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.852	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.852	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.852	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.852	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.852	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 1: '1b8376ee-8dfd-4b06-87b2-8b177370ffb1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 1: '1b8376ee-8dfd-4b06-87b2-8b177370ffb1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 1: '1b8376ee-8dfd-4b06-87b2-8b177370ffb1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 1: '3d3e1ee6-d302-4237-ac5a-120f95122ac2'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 1: '1b8376ee-8dfd-4b06-87b2-8b177370ffb1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)
2021-04-21 14:02:20.853	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)
2021-04-21 14:02:20.854	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.854	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)
2021-04-21 14:02:20.866	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.866	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.866	ConnectionBus_Retrieve	RequestAnalyzer: incoming request InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty]
2021-04-21 14:02:20.866	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.866	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.866	ConnectionBus_Retrieve	Incoming query of type XPath: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.867	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.867	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.867	ConnectionBus_Retrieve	OQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 1: '1b8376ee-8dfd-4b06-87b2-8b177370ffb1'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 1: '3d3e1ee6-d302-4237-ac5a-120f95122ac2'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 1: '3d3e1ee6-d302-4237-ac5a-120f95122ac2'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 2: 'Idle'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Adding select query param: 3: '1'
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	SQL: [d6a6efff-f2b4-32ff-aecc-62afd10fae3f] (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)
2021-04-21 14:02:20.868	ConnectionBus_Retrieve	Data table System.QueuedTask (0 row(s)) (...)

 

asked
1 answers

Same for Scheduled Events and other background tasks.

Created