search

frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
20.24k stars 7.07k forks source link

Deadlock in the demo while making SI for pos #9298

Closed manassolanki closed 7 years ago

manassolanki commented 7 years ago

make_pos_invoice() File "/Users/manas/frappe-bench/apps/erpnext/erpnext/demo/user/accounts.py", line 112, in make_pos_invoice si.insert() File "/Users/manas/frappe-bench/apps/frappe/frappe/model/document.py", line 192, in insert self.run_before_save_methods() File "/Users/manas/frappe-bench/apps/frappe/frappe/model/document.py", line 772, in run_before_save_methods self.run_method("validate") File "/Users/manas/frappe-bench/apps/frappe/frappe/model/document.py", line 666, in run_method out = Document.hook(fn)(self, *args, kwargs) File "/Users/manas/frappe-bench/apps/frappe/frappe/model/document.py", line 892, in composer return composed(self, method, *args, *kwargs) File "/Users/manas/frappe-bench/apps/frappe/frappe/model/document.py", line 875, in runner add_to_return_value(self, fn(self, args, kwargs)) File "/Users/manas/frappe-bench/apps/frappe/frappe/model/document.py", line 660, in fn = lambda self, *args, *kwargs: getattr(self, method)(args, **kwargs) File "/Users/manas/frappe-bench/apps/erpnext/erpnext/accounts/doctype/sales_invoice/sales_invoice.py", line 55, in validate super(SalesInvoice, self).validate() File "/Users/manas/frappe-bench/apps/erpnext/erpnext/controllers/selling_controller.py", line 37, in validate check_active_sales_items(self) File "/Users/manas/frappe-bench/apps/erpnext/erpnext/controllers/selling_controller.py", line 351, in check_active_sales_items d.income_account) File "/Users/manas/frappe-bench/apps/frappe/frappe/database.py", line 647, in set_value values, debug=debug) File "/Users/manas/frappe-bench/apps/frappe/frappe/database.py", line 138, in sql self._cursor.execute(query, values) File "/Users/manas/frappe-bench/env/lib/python2.7/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/Users/manas/frappe-bench/env/lib/python2.7/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')

mona1977 commented 7 years ago

Actually this problem due to 2 process took each other process, and create deadlock. please can you add my skype - suren_gupta, i will give you some solution which can work.

which Linux are you using?

sg

manassolanki commented 7 years ago

@mona1977 Thanks, now please excuse me. And if you really want to help, send a pull request resolving this issue, I will really appreciate your efforts.

nabinhait commented 7 years ago

It is really difficult to fix this without replicating or seeing "show engine innodb status" output. As we can't replicate and no output of "show engine innodb status" can be found now after 21 days, I am closing this issue.