I have a database with around 10 Milion records in SLE,
Repost Item Valuation is ending always with error like:
erpnext.stock.doctype.repost_item_valuation.repost_item_valuation.repost_entries
Traceback (most recent call last):
File “/home/infinity/frappe-bench/env/lib/python3.8/site-packages/rq/worker.py”, line 1013, in perform_job
rv = job.perform()
File “/home/infinity/frappe-bench/env/lib/python3.8/site-packages/rq/job.py”, line 709, in perform
self._result = self._execute()
File “/home/infinity/frappe-bench/env/lib/python3.8/site-packages/rq/job.py”, line 732, in _execute
result = self.func(*self.args, **self.kwargs)
File “/home/infinity/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 177, in execute_job
frappe.db.commit()
File “/home/infinity/frappe-bench/apps/frappe/frappe/database/database.py”, line 921, in commit
self.sql(“commit”)
File “/home/infinity/frappe-bench/apps/frappe/frappe/database/database.py”, line 193, in sql
self._cursor.execute(query)
File “/home/infinity/frappe-bench/env/lib/python3.8/site-packages/pymysql/cursors.py”, line 148, in execute
result = self._query(query)
File “/home/infinity/frappe-bench/env/lib/python3.8/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “/home/infinity/frappe-bench/env/lib/python3.8/site-packages/pymysql/connections.py”, line 547, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File “/home/infinity/frappe-bench/env/lib/python3.8/site-packages/pymysql/connections.py”, line 793, in _execute_command
raise err.InterfaceError(0, “”)
pymysql.err.InterfaceError: (0, ‘’)
As well as
erpnext.stock.doctype.repost_item_valuation.repost_item_valuation.repost_entries
Work-horse was terminated unexpectedly (waitpid returned None)
25-05-2025 07:00:22
long
As well as
erpnext.stock.doctype.repost_item_valuation.repost_item_valuation.repost_entries
Moved to FailedJobRegistry at 2025-05-25 05:52:32.292993
Any suggestions will be appreciated.