frappe.exceptions.ValidationError: Too many writes in one request. Please send smaller requests
Any solution around that error?
These tables have grown to big: tabVersion, tabDeleted Document, tabCommunication (2Million records) and tabEmail Queue.
Can I safely empty those table maybe to reduce the size of the DB if that’s the reason
If all the above fails, is there a way to reverse back to the state before bench update? So far the site is stuck at System Updating
We are expecting to fix this by sets of PR to stock related transcations and optimizing them to reduce the number of pending commits or merging multiple commis into a single commit.
We will sponsor the PR to optimize teh stock transaction that requires 1,000’s to 10,000’s of parts in Delivery Note, Purchase Receipt, Landed Cost Vouchers.
Having more than 1,000 items in stock transactions is pretty common in our part of the world where businesses don’t focus on what they want to sell, but want to sell anything and everything.
Please comment or like this post so that we know who else is interested or affected by this problem.