Po pobraniu danych licznika wyrzuca błedy i nieaktualizuje stanu

[brzezio2]

Po skonfigurowaniu zgodnie z zaleceniem pobiera dane z liczników i po jakims czasie wyrzuca ponizsze błedy:

      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3249, in execute_sql with __exception_wrapper: File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3019, in exit__ reraise(new_type, new_type(exc_value, *exc_args), traceback) File "/app/venv/lib/python3.11/site-packages/peewee.py", line 192, in reraise raise value.with_traceback(tb) File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3251, in execute_sql cursor.execute(sql, params or ()) peewee.OperationalError: database is locked 2024-01-30 00:15:49,183 - api - ERROR - Exception on /14935453/A+/2 [GET] Traceback (most recent call last): File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3251, in execute_sql cursor.execute(sql, params or ()) sqlite3.OperationalError: database is locked

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 1455, in wsgi_app response = self.full_dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 869, in full_dispatch_request rv = self.handle_user_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 867, in full_dispatch_request rv = self.dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 852, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(*view_args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/api.py", line 174, in get_countners meter_result = meters_query.execute() ^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 1971, in inner return method(self, database, args, *kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 2042, in execute return self._execute(database) ^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 2215, in _execute cursor = database.execute(self) ^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3259, in execute return self.execute_sql(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3249, in execute_sql with __exception_wrapper: File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3019, in exit__ reraise(new_type, new_type(exc_value, exc_args), traceback) File "/app/venv/lib/python3.11/site-packages/peewee.py", line 192, in reraise raise value.with_traceback(tb) File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3251, in execute_sql cursor.execute(sql, params or ()) peewee.OperationalError: database is locked 2024-01-30 00:15:49,179 - api - ERROR - Exception on /14935453/A+/1 [GET] Traceback (most recent call last): File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3251, in execute_sql cursor.execute(sql, params or ()) sqlite3.OperationalError: database is locked

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 1455, in wsgi_app response = self.full_dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 869, in full_dispatch_request rv = self.handle_user_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 867, in full_dispatch_request rv = self.dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/flask/app.py", line 852, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(*view_args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/api.py", line 174, in get_countners meter_result = meters_query.execute() ^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 1971, in inner return method(self, database, args, *kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 2042, in execute return self._execute(database) ^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 2215, in _execute cursor = database.execute(self) ^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3259, in execute return self.execute_sql(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3249, in execute_sql with __exception_wrapper: File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3019, in exit__ reraise(new_type, new_type(exc_value, exc_args), traceback) File "/app/venv/lib/python3.11/site-packages/peewee.py", line 192, in reraise raise value.with_traceback(tb) File "/app/venv/lib/python3.11/site-packages/peewee.py", line 3251, in execute_sql cursor.execute(sql, params or ()) peewee.OperationalError: database is locked

[tcich]

taki błąd może wystąpić w przypadku jednoczesnych wielu zapytań do api, to jest ograniczenie sqlLite, jak często odpytujesz api o dane?