forum.opsi.org

Code: Alles auswählen

[4] [2025-01-03 14:22:08.911] [               ] Could not clear check cache. No Connection to Redis.   (cache.py:29)
[4] [2025-01-03 14:22:12.531] [               ] Failed to setup redis: Error 104 while writing to socket. Connection reset by peer.   (__init__.py:340)
Traceback (most recent call last):
  File "redis/connection.py", line 534, in send_packed_command
ConnectionResetError: [Errno 104] Connection reset by peer

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "opsiconfd/setup/__init__.py", line 338, in setup
  File "opsiconfd/setup/__init__.py", line 65, in setup_redis
  File "opsiconfd/redis.py", line 252, in delete_recursively
  File "redis/commands/core.py", line 3045, in scan_iter
  File "redis/commands/core.py", line 3020, in scan
  File "redis/client.py", line 559, in execute_command
  File "redis/client.py", line 565, in _execute_command
  File "redis/connection.py", line 1422, in get_connection
  File "redis/connection.py", line 369, in connect
  File "redis/connection.py", line 477, in on_connect
  File "redis/connection.py", line 556, in send_command
  File "redis/connection.py", line 545, in send_packed_command
redis.exceptions.ConnectionError: Error 104 while writing to socket. Connection reset by peer.
[4] [2025-01-03 14:22:12.534] [               ] Failed to setup redis downsampling: Error 104 while writing to socket. Connection reset by peer.   (__init__.py:346)
Traceback (most recent call last):
  File "redis/connection.py", line 534, in send_packed_command
ConnectionResetError: [Errno 104] Connection reset by peer

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "opsiconfd/setup/__init__.py", line 344, in setup
  File "opsiconfd/metrics/statistics.py", line 73, in setup_metric_downsampling
  File "redis/client.py", line 559, in execute_command
  File "redis/client.py", line 565, in _execute_command
  File "redis/connection.py", line 1422, in get_connection
  File "redis/connection.py", line 369, in connect
  File "redis/connection.py", line 477, in on_connect
  File "redis/connection.py", line 556, in send_command
  File "redis/connection.py", line 545, in send_packed_command
redis.exceptions.ConnectionError: Error 104 while writing to socket. Connection reset by peer.
[4] [2025-01-03 14:22:12.778] [               ] Could not clear check cache. No Connection to Redis.   (cache.py:29)

Code: Alles auswählen

opsi-package-updater -v install opsi-client-agent hwaudit

Code: Alles auswählen

opsi-package-updater -v --repo uib_windows install

Code: Alles auswählen

[SQL: SELECT COUNT(*) 
FROM PRODUCT_ON_DEPOT AS pod 
WHERE pod.depotId IN %s AND pod.producttype = %s]
[parameters: ([], 'NetbootProduct')]
(Background on this error at: https://sqlalche.me/e/14/f405)

Traceback (most recent call last):
  File "sqlalchemy/engine/base.py", line 1910, in _execute_context
  File "sqlalchemy/engine/default.py", line 736, in do_execute
  File "MySQLdb/cursors.py", line 206, in execute
  File "MySQLdb/cursors.py", line 319, in _query
  File "MySQLdb/connections.py", line 254, in query
MySQLdb.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND pod.producttype = 'NetbootProduct'' at line 3")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "opsiconfd/rest.py", line 240, in create_response
  File "opsiconfd/rest.py", line 231, in exec_func
  File "/usr/lib/opsiconfd/addons/webgui/python/utils.py", line 292, in check_user
    return func(*args, **kwargs)
  File "/usr/lib/opsiconfd/addons/webgui/python/products.py", line 558, in product_count
    count = session.execute(select(text("COUNT(*)")).select_from(text("PRODUCT_ON_DEPOT AS pod")).where(where), params).fetchone()[0]
            ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "opsiconfd/backend/mysql/__init__.py", line 80, in execute
  File "sqlalchemy/orm/session.py", line 1717, in execute
  File "sqlalchemy/engine/base.py", line 1710, in _execute_20
  File "sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
  File "sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
  File "sqlalchemy/engine/base.py", line 1953, in _execute_context
  File "sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
  File "sqlalchemy/util/compat.py", line 211, in raise_
  File "sqlalchemy/engine/base.py", line 1910, in _execute_context
  File "sqlalchemy/engine/default.py", line 736, in do_execute
  File "MySQLdb/cursors.py", line 206, in execute
  File "MySQLdb/cursors.py", line 319, in _query
  File "MySQLdb/connections.py", line 254, in query
sqlalchemy.exc.ProgrammingError: (MySQLdb.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND pod.producttype = 'NetbootProduct'' at line 3")
[SQL: SELECT COUNT(*) 
FROM PRODUCT_ON_DEPOT AS pod 
WHERE pod.depotId IN %s AND pod.producttype = %s]
[parameters: ([], 'NetbootProduct')]
(Background on this error at: https://sqlalche.me/e/14/f405)

Code: Alles auswählen

Failed to get package info from repository 'https://opsipackages.43.opsi.org/stable/packages.msgpack.zstd': HTTPSConnectionPool(host='opsipackages.43.opsi.org', port=443): Max retries exceeded with url: /stable/packages.msgpack.zstd (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f92180ed810>: Failed to establish a new connection: [Errno 111] Connection refused'))