Issues with mysql2/promise about dd-trace-js

[rochdev]

@derN3rd This is definitely an oversight as mysql2/promise is not supported at the moment. For now the safest would be to disable plugins and individually enable the plugins you need (except mysql2 until this is fixed). See the API docs for an example.

[derN3rd]

@rochdev Thanks for your quick reply. I already got it to work with mysql2 plugin disabled, but wasn't sure if I did something wrong.

I will wait for mysql2/promise support then 😄

[rochdev]

It seems this bug actually affects even the callback based version. It doesn't happen when mysql2 is required before the plugin however, so that could be a temporary workaround.

For example:

require('mysql2/promise') // require before to work around the bug
const tracer = require('dd-trace').init()
const mysql2 = require('mysql2/promise') // require again to apply patching

[derN3rd]

It doesn't crash now, but I also get no traces of my mysql2 queries.
Can this be because I have all queries in a external module?
If so, how can I patch the dependencies of this module too?

[rochdev]

@derN3rd It should still be instrumented in external modules if the external module is required after the tracer is initialized.

Could you try something like this:

require('mysql2') // require callback version to avoid race condition with promise patch
const tracer = require('dd-trace').init()
const externalModule = require('external-module')

Also make sure you have re-enabled the plugin.

[derN3rd]

@rochdev Thanks man.
Got it to work. I have to do require('mysql2') first, then initialize dd-trace. Afterwards I can use mysql2 OR mysql2/promise without any problems (Like your example).
I tried to require('mysql2/promise') first, but that doesn't work.

Thanks for the help