Und der zweite Teil des Logs (Limitierung der Message im Forum erfordert das Aufteilen):
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 452, in connec
t
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1348, in _chec
kout
with util.safe_reraise():
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 147, in
__exit__
raise exc_value.with_traceback(exc_tb)
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1345, in _chec
kout
fairy._connection_record.get_connection()
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 839, in get_co
nnection
self.__connect()
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 902, in __conn
ect
with util.safe_reraise():
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 147, in
__exit__
raise exc_value.with_traceback(exc_tb)
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 898, in __conn
ect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 637, in co
nnect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 615, in c
onnect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "postgr
esdbbackend" (127.0.0.1), port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
(Background on this error at: https://sqlalche.me/e/20/e3q8)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/venv/bin/vwsfriend", line 8, in <module>
sys.exit(main())
^^^^^^
File "/opt/venv/lib/python3.11/site-packages/vwsfriend/vwsfriend_base.py", line 561, in ma
in
mqttCLient.disconnect()
File "/opt/venv/lib/python3.11/site-packages/weconnect_mqtt/weconnect_mqtt_base.py", line
435, in disconnect
disconectPublish.wait_for_publish()
File "/opt/venv/lib/python3.11/site-packages/paho/mqtt/client.py", line 358, in wait_for_p
ublish
raise ValueError('Message is not queued due to ERR_QUEUE_SIZE')
ValueError: Message is not queued due to ERR_QUEUE_SIZE
2023-07-29T03:03:23+0000:ERROR:_internal:Error on request:
Traceback (most recent call last):
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1965, in _ex
ec_single_context
self.dialect.do_execute(
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 921, in d
o_execute
cursor.execute(statement, parameters)
psycopg2.OperationalError: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/venv/lib/python3.11/site-packages/werkzeug/serving.py", line 364, in run_wsgi
execute(self.server.app)
File "/opt/venv/lib/python3.11/site-packages/werkzeug/serving.py", line 325, in execute
application_iter = app(environ, start_response)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 2213, in __call__
return self.wsgi_app(environ, start_response)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 2193, in wsgi_app
response = self.handle_exception(e)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 2190, in wsgi_app
response = self.full_dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 1486, in full_dispatch_re
quest
rv = self.handle_user_exception(e)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 1482, in full_dispatch_re
quest
rv = self.preprocess_request()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 1974, in preprocess_reque
st
rv = self.ensure_sync(before_func)()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/vwsfriend/ui/vwsfriend_ui.py", line 101, in b
efore_request_callback
flask.g.dbsettings = self.app.db.session.query(Settings).first()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2747, in first
return self.limit(1)._iter().first() # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2846, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2246, in exe
cute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2141, in _ex
ecute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 293, in orm_
execute_statement
result = conn.execute(
^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1412, in exe
cute
return meth(
^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 483, in _ex
ecute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1635, in _ex
ecute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1844, in _ex
ecute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1984, in _ex
ec_single_context
self._handle_dbapi_exception(
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2339, in _ha
ndle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1965, in _ex
ec_single_context
self.dialect.do_execute(
File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 921, in d
o_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection un
expectedly
This probably means the server terminated abnormally
before or while processing the request.
[SQL: SELECT settings.id AS settings_id, settings.unit_of_length AS settings_unit_of_length,
settings.unit_of_temperature AS settings_unit_of_temperature, settings.grafana_url AS setti
ngs_grafana_url, settings.vwsfriend_url AS settings_vwsfriend_url, settings.locale AS settin
gs_locale
FROM settings
LIMIT %(param_1)s]
[parameters: {'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-07-29T03:19:05+0000:WARNING:_logger:Error with socket 16 (('169.254.252.41', 5353))): [
Errno 101] Network is unreachable
Traceback (most recent call last):
File "/usr/lib/python3.11/asyncio/selector_events.py", line 1196, in sendto
self._sock.sendto(data, addr)
OSError: [Errno 101] Network is unreachable
Alles anzeigen