I have tested Can't cancel builds with pending state but then looking closer to the sqlite db and confirmed by the drone UI, the build items are success/error but not pending.
So this may be a problem related with the drone-cli?
Here is the output:
❯ drone queue ls item #134 Status: pending Machine: OS: linux Arch: amd64 Variant: Version:
And the corresponding jobs: