Using frappe_docker, earlier we deployed the application to AWS EC2 and it was working well there. Now, we have migrated to Kubernetes Cluster - AWS Auto Mode EKS, and deployed the frappe erpnext deployment there using the official Frappe ERPNext Helm chart. We were able to successfully, deploy it and everything is working there.
But, there we started getting this below error frequently:
Traceback with variables (most recent call last):
File “apps/frappe/frappe/search/sqlite_search.py”, line 833, in _get_connection
self._set_pragmas(cursor, read_only)
self = <helpdesk.search_sqlite.HelpdeskSearch object at 0x7fe0498da950>
read_only = True
conn = <sqlite3.Connection object at 0x7fe0501c44f0>
cursor = <sqlite3.Cursor object at 0x7fe051bc2dc0>
e = OperationalError(‘database is locked’)
File “apps/frappe/frappe/search/sqlite_search.py”, line 844, in _set_pragmas
cursor.execute(“PRAGMA journal_mode = WAL;”) # Write-Ahead Logging for concurrency
self = <helpdesk.search_sqlite.HelpdeskSearch object at 0x7fe0498da950>
cursor = <sqlite3.Cursor object at 0x7fe051bc2dc0>
is_read = True
sqlite3.OperationalError: database is locked
Traceback with variables (most recent call last):\n File “apps/frappe/frappe/search/sqlite_search.py”, line 833, in _get_connection\n self._set_pragmas(cursor, read_only)\n self = <helpdesk.search_sqlite.HelpdeskSearch object at 0x7f28c3f31190>\n read_only = True\n conn = <sqlite3.Connection object at 0x7f28c03f9990>\n cursor = <sqlite3.Cursor object at 0x7f28c1d14240>\n e = OperationalError(\‘database is locked\’)\n File “apps/frappe/frappe/search/sqlite_search.py”, line 844, in _set_pragmas\n cursor.execute(“PRAGMA journal_mode = WAL;”) # Write-Ahead Logging for concurrency\n self = <helpdesk.search_sqlite.HelpdeskSearch object at 0x7f28c3f31190>\n cursor = <sqlite3.Cursor object at 0x7f28c1d14240>\n is_read = True\nsqlite3.OperationalError: database is locked
Anyone found this? help, if any idea- how to fix this?