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)) (...)
Same for Scheduled Events and other background tasks.