We have a table with a few million rows and a dozen columns. Issuing this delete, which refers to roughly half the rows in the table, crashes the node:
DELETE FROM accounts WHERE datasetversion = 4;
Limiting the deletes works, I tried up to 500k without issue.
DELETE FROM accounts WHERE datasetversion = 4 LIMIT 500000;
3 nodes x n1-standard-2 (2 cpu / 7.5gb) with local nvme SSD on GCE with 25% cache/mem settings, 3x RF, this is the only table in the database.
Posted on Github here: https://github.com/cockroachdb/cockroach/issues/32522