Page repeatedly becomes unresponsive when I tried submitting sales order. What might be the cause? I tried clearing the cache pre and post submission of a sales order. Please refer to the attached image and error report.
Route
Form/Item/4716141
Error Report
Traceback (innermost last):
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/app.py”, line 49, in application
response = frappe.handler.handle()
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/handler.py”, line 66, in handle
execute_cmd(cmd)
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/handler.py”, line 89, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/init.py”, line 531, in call
return fn(*args, **newargs)
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/core/doctype/notification_count/notification_count.py”, line 44, in get_notifications
“open_count”:result}).insert(ignore_permissions=True)
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/model/document.py”, line 154, in insert
self.db_insert()
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 202, in db_insert
), d.values())
File “/home/erpnext/webapps/digitales_testing/frappe-bench/apps/frappe/frappe/database.py”, line 110, in sql
self._cursor.execute(query, values)
File “/home/erpnext/webapps/digitales_testing/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/erpnext/webapps/digitales_testing/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1205, ‘Lock wait timeout exceeded; try restarting transaction’)
Request Data
{
“type”: “POST”,
“args”: {
“cmd”: “frappe.core.doctype.notification_count.notification_count.get_notifications”,
“_type”: “POST”
},
“show_spinner”: false,
“url”: “/”
}
Response JSON
{}