fix(database): prevent lock table overflow in model:prune by chunking transactions

fix(database): prevent lock table overflow in model:prune by chunking transactions #32064