Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

BoxLang: Our new JVM Dynamic Language made by Ortus! Check it out: https://www.boxlang.io

Executing Event That Uses QB From Interceptor Generates CBDebugger Exception

Description

Here are the steps to reproduce the issue:

1. In Commandbox:

  • coldbox create app

  • install cbdebugger

  • install qb

  • coldbox create interceptor name=app

2. In /config/coldbox.cfc register the interceptor:

interceptors = [{ class="interceptors.app", properties={} }];

3. Create a new interceptor method in interceptors/app.cfc for the `afterAspectsLoad`:

function afterAspectsLoad( event ) { runEvent( "Main.index" ); }

4. Create a connection to a datasource (any datasource will do) and define it in Application.cfc
this.datasource = "anything";

5. Update the Main.index handler to inject `qb` and run a simple query. It will look something like this:

component extends="coldbox.system.EventHandler" { property name="qb" inject="provider:QueryBuilder@qb"; function index( event, rc, prc ) { // execute a query - anything is fine qb.select().from( "user" ).get(); prc.welcomeMessage = "Welcome to ColdBox!";event.setView( "main/index" ); event.setView( "main/index" ); }

6. Configure cbdebugger with the defaults + qb enabled

// Debugger Settings cbDebugger = { // Master switch to enable/disable request tracking into storage facilities. enabled : true, // Turn the debugger UI on/off by default. You can always enable it via the URL using your debug password // Please note that this is not the same as the master switch above // The debug mode can be false and the debugger will still collect request tracking debugMode : true, // The URL password to use to activate it on demand debugPassword : "cb:null", // Request Tracker Options requestTracker : { // Track all cbdebugger events, by default this is off, turn on, when actually profiling yourself :) How Meta! trackDebuggerEvents : false, // Store the request profilers in heap memory or in cachebox, default is cachebox storage : "cachebox", // Which cache region to store the profilers in cacheName : "template", // Expand by default the tracker panel or not expanded : true, // Slow request threshold in milliseconds, if execution time is above it, we mark those transactions as red slowExecutionThreshold : 1000, // How many tracking profilers to keep in stack: Default is to monitor the last 20 requests maxProfilers : 50, // If enabled, the debugger will monitor the creation time of CFC objects via WireBox profileWireBoxObjectCreation : false, // Profile model objects annotated with the `profile` annotation profileObjects : false, // If enabled, will trace the results of any methods that are being profiled traceObjectResults : false, // Profile Custom or Core interception points profileInterceptions : false, // By default all interception events are excluded, you must include what you want to profile includedInterceptions : [], // Control the execution timers executionTimers : { expanded : true, // Slow transaction timers in milliseconds, if execution time of the timer is above it, we mark it slowTimerThreshold : 250 }, // Control the coldbox info reporting coldboxInfo : { expanded : false }, // Control the http request reporting httpRequest : { expanded : false, // If enabled, we will profile HTTP Body content, disabled by default as it contains lots of data profileHTTPBody : false } }, // ColdBox Tracer Appender Messages tracers : { enabled : true, expanded : false }, // Request Collections Reporting collections : { // Enable tracking enabled : false, // Expanded panel or not expanded : false, // How many rows to dump for object collections maxQueryRows : 50, // Max number to use when dumping objects via the top argument maxDumpTop: 5 }, // CacheBox Reporting cachebox : { enabled : false, expanded : false }, // Modules Reporting modules : { enabled : false, expanded : false }, // Quick and QB Reporting qb : { enabled : true, expanded : false, // Log the binding parameters logParams : true }, // cborm Reporting cborm : { enabled : false, expanded : false, // Log the binding parameters (requires CBORM 3.2.0+) logParams : true }, // Async Manager Reporting async : { enabled : true, expanded : false } }

7. In commandbox: server start
When the server starts or when performing fwreinit, you will see the following error key [QBQUERIES] doesn't exist:

Attachments

1

Activity

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Fix versions

Priority

Sentry

Created September 30, 2021 at 6:36 PM
Updated April 21, 2022 at 9:49 PM
Resolved April 21, 2022 at 9:49 PM

Flag notifications