ERPNext Conference 2019* ERPNext.com Blog

frappe.exceptions.ValidationError: Too many writes in one request. Please send smaller requests


#1

Bench update give this error:

frappe.exceptions.ValidationError: Too many writes in one request. Please send smaller requests

  1. Any solution around that error?

  2. 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

  3. 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

Many Thanks


#2

Digging into source code I found this:

And setting this self.auto_commit_on_many_writes = True can potentially solve the problem.

Next tasks is 1) to know how to initialize that variable globally or 2) Do witch patch/file I need to put that line into

Any lead will be appreciated


#3

I added the code into the file itself and then bench update --patch did it