.useTransaction() is ignored and the default connection is used about lucid HOT 4 CLOSED

Not sure I get the issue properly. Is that that the trx is using a different database connection and the Model is using a different database connection?

from lucid.

Not sure I get the issue properly. Is that that the trx is using a different database connection and the Model is using a different database connection?

That's right. It looks like the trx is set correctly for the model, when I check with user.$trx. Now I've found that await user.save() also works as expected.

I wonder if it's specific to the .delete() method. I did use the lucid-softdeletes package when I was on v5, but I am pretty sure I removed everything related to that already.

from lucid.

Looking the code, the delete method should work same the save method. Can you dig into the node_modules and check if this method receives the correct transaction? https://github.com/adonisjs/lucid/blob/develop/src/orm/base_model/index.ts#L2012

from lucid.

Closing since no answer from issue reporter.

from lucid.