adonisjs / lucid

AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
https://lucid.adonisjs.com/
MIT License
1.02k stars 189 forks source link

`node ace db:truncate` throws the error deadlock detected #1027

Open mdsadique-inam opened 1 month ago

mdsadique-inam commented 1 month ago

Package version

@adonisjs/lucid@20.5.1

Describe the bug

node ace db:truncate throws the error deadlock detected but when I run all truncate queries from Datagrip console it runs successfully

Reproduction repo

No response

Proof of error

https://github.com/adonisjs/lucid/assets/104680493/7e11b3dc-7956-492a-bbfa-2226e468c27f

mdsadique-inam commented 1 month ago

Hi @thetutlage :wave: Added the proof of error in the description of this issue