system-bridge icon indicating copy to clipboard operation
system-bridge copied to clipboard

Published 20 hours ago • verified publisher icon timmo001

Error executing SQL

Open delta010 opened this issue 3 years ago • 4 comments

Description

every time I run python -m systembridgebackend the SQL error shows up. also, there is no GUI .there is an application shortcut but nothing happens if I click it

system bridge version - 3.4.1 python version - 3.10 Linux version - Linux kali 5.18.0-kali5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 5.18.5-1kali5 (2022-07-04) x86_64 GNU/Linux

What Platform / OS are you running?

Linux

What version are you running?

3.4.1

Anything in the logs or a references that might be useful?

python3 -m systembridgebackend        
2022-07-17 19:40:53 INFO (MainThread) [__main__.Main] System Bridge 3.4.1: Startup
2022-07-17 19:40:53 INFO (MainThread) [__main__.Main] Autostart enabled: True
2022-07-17 19:40:54 INFO (MainThread) [systembridgebackend.server.Server] Serving frontend from: /home/ajay/.local/lib/python3.10/site-packages/systembridgefrontend/out
2022-07-17 19:40:54 INFO (MainThread) [systembridgebackend.server.Server] Starting server on port: 9170
[2022-07-17 19:40:54 +0530] [4440] [WARNING] Sanic is running in PRODUCTION mode. Consider using '--debug' or '--dev' while actively developing your application.
2022-07-17 19:40:54 WARNING (MainThread) [sanic.error] Sanic is running in PRODUCTION mode. Consider using '--debug' or '--dev' while actively developing your application.
[2022-07-17 19:40:55 +0530] [4440] [INFO] Sanic Extensions:
2022-07-17 19:40:55 INFO (MainThread) [sanic.root] Sanic Extensions:
[2022-07-17 19:40:55 +0530] [4440] [INFO]   > templating [jinja2==3.0.3]
2022-07-17 19:40:55 INFO (MainThread) [sanic.root]   > templating [jinja2==3.0.3]
[2022-07-17 19:40:55 +0530] [4440] [INFO]   > http 
2022-07-17 19:40:55 INFO (MainThread) [sanic.root]   > http 
[2022-07-17 19:40:55 +0530] [4440] [INFO]   > openapi [http://0.0.0.0:9170/docs]
2022-07-17 19:40:55 INFO (MainThread) [sanic.root]   > openapi [http://0.0.0.0:9170/docs]
[2022-07-17 19:40:55 +0530] [4440] [INFO]   > injection [0 added]
2022-07-17 19:40:55 INFO (MainThread) [sanic.root]   > injection [0 added]
[2022-07-17 19:40:55 +0530] [4440] [INFO] Starting worker [4440]
2022-07-17 19:40:55 INFO (MainThread) [sanic.root] Starting worker [4440]
2022-07-17 19:40:57 INFO (MainThread) [scheduler] RUN TASK "_after_startup"
2022-07-17 19:40:57 INFO (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] Test WebSocket connection before starting GUI. Attempt #1
2022-07-17 19:40:57 INFO (MainThread) [scheduler] END TASK "_after_startup"
2022-07-17 19:40:57 INFO (MainThread) [scheduler] STOP TASK "_after_startup"
2022-07-17 19:40:57 INFO (Thread-2 (start_gui_sync)) [systembridgeshared.websocket_client.WebSocketClient] Connecting to WebSocket: ws://localhost:9170/api/websocket
[2022-07-17 19:40:57 +0530] [4440] [INFO] connection open
2022-07-17 19:40:57 INFO (MainThread) [sanic.root] connection open
2022-07-17 19:40:57 INFO (Thread-2 (start_gui_sync)) [systembridgeshared.websocket_client.WebSocketClient] Connected to WebSocket
2022-07-17 19:40:57 INFO (Thread-2 (start_gui_sync)) [systembridgeshared.websocket_client.WebSocketClient] Closing WebSocket connection
2022-07-17 19:40:57 INFO (MainThread) [systembridgebackend.server.websocket.WebSocketHandler] Unregistering data listener 191dfc76-fb09-4f09-aa1b-dbf97e7f8799
2022-07-17 19:40:57 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Listener not found: 191dfc76-fb09-4f09-aa1b-dbf97e7f8799
2022-07-17 19:40:57 INFO (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] Starting GUI: ['/usr/bin/python3', '-m', 'systembridgegui', 'main']
2022-07-17 19:40:57 INFO (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] GUI started with PID: 4453
[2022-07-17 19:40:59 +0530] [4440] [INFO] connection open
2022-07-17 19:40:59 INFO (MainThread) [sanic.root] connection open
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.server.websocket.WebSocketHandler] Received: REGISTER_DATA_LISTENER
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.server.websocket.WebSocketHandler] Registering data listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Added listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data: ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: battery
2022-07-17 19:40:59 WARNING (MainThread) [systembridgebackend.modules.listeners.Listeners] No data found for module: battery
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: cpu
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Data changed for module: cpu
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Sending 'cpu' data to listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: disk
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Data changed for module: disk
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Sending 'disk' data to listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: display
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Data changed for module: display
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Sending 'display' data to listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: gpu
2022-07-17 19:40:59 WARNING (MainThread) [systembridgebackend.modules.listeners.Listeners] No data found for module: gpu
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: memory
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Data changed for module: memory
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Sending 'memory' data to listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: system
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Data changed for module: system
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Sending 'system' data to listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Finished refreshing data: ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.server.websocket.WebSocketHandler] Received: GET_DATA
2022-07-17 19:40:59 INFO (MainThread) [systembridgebackend.server.websocket.WebSocketHandler] Getting data: ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:41:00 INFO (MainThread) [__main__.Main] System Bridge GUI 3.4.1: Startup
qt.qpa.xcb: could not connect to display 
qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.
This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem.

Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vkkhrdisplay, vnc, wayland-egl, wayland, xcb.

2022-07-17 19:41:00 ERROR (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] GUI exited with code: -6
2022-07-17 19:41:00 INFO (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] Test WebSocket connection before starting GUI. Attempt #2
2022-07-17 19:41:00 INFO (Thread-2 (start_gui_sync)) [systembridgeshared.websocket_client.WebSocketClient] Connecting to WebSocket: ws://localhost:9170/api/websocket
[2022-07-17 19:41:00 +0530] [4440] [INFO] connection open
2022-07-17 19:41:00 INFO (MainThread) [sanic.root] connection open
2022-07-17 19:41:00 INFO (Thread-2 (start_gui_sync)) [systembridgeshared.websocket_client.WebSocketClient] Connected to WebSocket
2022-07-17 19:41:00 INFO (Thread-2 (start_gui_sync)) [systembridgeshared.websocket_client.WebSocketClient] Closing WebSocket connection
2022-07-17 19:41:00 INFO (MainThread) [systembridgebackend.server.websocket.WebSocketHandler] Unregistering data listener 48ff6ae1-4d08-4ef5-9c28-f08d07e4e5cd
2022-07-17 19:41:00 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Listener not found: 48ff6ae1-4d08-4ef5-9c28-f08d07e4e5cd
2022-07-17 19:41:00 INFO (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] Starting GUI: ['/usr/bin/python3', '-m', 'systembridgegui', 'main']
2022-07-17 19:41:00 INFO (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] GUI started with PID: 4459
2022-07-17 19:41:01 INFO (MainThread) [__main__.Main] System Bridge GUI 3.4.1: Startup
qt.qpa.xcb: could not connect to display 
qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.
This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem.

Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vkkhrdisplay, vnc, wayland-egl, wayland, xcb.

2022-07-17 19:41:01 ERROR (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] GUI exited with code: -6
2022-07-17 19:41:01 ERROR (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] Failed to start GUI after 2 attempts
Exception in thread Thread-2 (start_gui_sync):
Traceback (most recent call last):
  File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.10/threading.py", line 953, in run
    self._target(*self._args, **self._kwargs)
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 79, in start_gui_sync
    asyncio.run(
  File "/usr/lib/python3.10/asyncio/runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "uvloop/loop.pyx", line 1501, in uvloop.loop.Loop.run_until_complete
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 61, in start_gui
    await start_gui(
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 61, in start_gui
    await start_gui(
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 27, in start_gui
    raise GUIAttemptsExceededException("Failed to start GUI after 3 attempts")
systembridgebackend.gui.GUIAttemptsExceededException: Failed to start GUI after 3 attempts
2022-07-17 19:41:05 INFO (MainThread) [scheduler] RUN TASK "_update_data"
2022-07-17 19:41:05 INFO (Thread-3) [systembridgebackend.modules.update.Update] Update data
2022-07-17 19:41:05 INFO (MainThread) [scheduler] END TASK "_update_data"
2022-07-17 19:41:05 INFO (MainThread) [scheduler] RUN TASK "_update_frequent_data"
2022-07-17 19:41:05 INFO (Thread-5) [systembridgebackend.modules.update.Update] Update frequent data
2022-07-17 19:41:05 INFO (MainThread) [scheduler] END TASK "_update_frequent_data"
2022-07-17 19:41:06 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO sensors (key, type, name, hardware_type, hardware_name, value, timestamp) VALUES ('temperatures_acpitz_high', 'high', 'high', 'acpitz', 'acpitz', '103.0', 1658067066.0950863) ON CONFLICT(key) DO UPDATE SET value = '103.0', timestamp = 1658067066.0950863 WHERE key = 'temperatures_acpitz_high'
not an error
2022-07-17 19:41:07 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO sensors (key, type, name, hardware_type, hardware_name, value, timestamp) VALUES ('temperatures_nouveau_label', 'label', 'label', 'nouveau', 'nouveau', '', 1658067066.9785776) ON CONFLICT(key) DO UPDATE SET value = '', timestamp = 1658067066.9785776 WHERE key = 'temperatures_nouveau_label'
cannot start a transaction within a transaction
2022-07-17 19:41:07 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_sda_read_time', '234183', 1658067067.6119294) ON CONFLICT(key) DO UPDATE SET value = '234183', timestamp = 1658067067.6119294 WHERE key = 'io_counters_per_disk_sda_read_time'
cannot start a transaction within a transaction
2022-07-17 19:41:07 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO sensors (key, type, name, hardware_type, hardware_name, value, timestamp) VALUES ('temperatures_coretemp_high', 'high', 'high', 'coretemp', 'coretemp', '82.0', 1658067067.7950432) ON CONFLICT(key) DO UPDATE SET value = '82.0', timestamp = 1658067067.7950432 WHERE key = 'temperatures_coretemp_high'
cannot commit - no transaction is active
2022-07-17 19:41:08 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO sensors (key, type, name, hardware_type, hardware_name, value, timestamp) VALUES ('temperatures_coretemp_label', 'label', 'label', 'coretemp', 'coretemp', 'Core 0', 1658067068.1533692) ON CONFLICT(key) DO UPDATE SET value = 'Core 0', timestamp = 1658067068.1533692 WHERE key = 'temperatures_coretemp_label'
not an error
2022-07-17 19:41:09 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: sensors
2022-07-17 19:41:09 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Data changed for module: sensors
2022-07-17 19:41:09 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:41:10 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: display
2022-07-17 19:41:10 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Data changed for module: display
2022-07-17 19:41:10 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:41:10 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Sending 'display' data to listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:41:10 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: DELETE FROM gpu
cannot start a transaction within a transaction
2022-07-17 19:41:10 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_sda2_busy_time', '2128', 1658067070.8555257) ON CONFLICT(key) DO UPDATE SET value = '2128', timestamp = 1658067070.8555257 WHERE key = 'io_counters_per_disk_sda2_busy_time'
cannot start a transaction within a transaction
2022-07-17 19:41:10 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: gpu
2022-07-17 19:41:11 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Data changed for module: gpu
2022-07-17 19:41:11 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137 - ['battery', 'cpu', 'disk', 'display', 'gpu', 'memory', 'system']
2022-07-17 19:41:11 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Sending 'gpu' data to listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:41:11 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('count', '4', 1658067071.0514128) ON CONFLICT(key) DO UPDATE SET value = '4', timestamp = 1658067071.0514128 WHERE key = 'count'
cannot start a transaction within a transaction
2022-07-17 19:41:11 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('frequency_max', '3100.0', 1658067071.5054715) ON CONFLICT(key) DO UPDATE SET value = '3100.0', timestamp = 1658067071.5054715 WHERE key = 'frequency_max'
cannot commit - no transaction is active
2022-07-17 19:41:13 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_sdb1_write_count', '3', 1658067073.3031967) ON CONFLICT(key) DO UPDATE SET value = '3', timestamp = 1658067073.3031967 WHERE key = 'io_counters_per_disk_sdb1_write_count'
cannot start a transaction within a transaction
2022-07-17 19:41:13 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('frequency_3_min', '1600.0', 1658067073.3866153) ON CONFLICT(key) DO UPDATE SET value = '1600.0', timestamp = 1658067073.3866153 WHERE key = 'frequency_3_min'
not an error
^C[2022-07-17 19:41:14 +0530] [4440] [INFO] Stopping worker [4440]
2022-07-17 19:41:14 INFO (MainThread) [sanic.root] Stopping worker [4440]
2022-07-17 19:41:14 INFO (MainThread) [systembridgebackend.server.websocket.WebSocketHandler] Unregistering data listener ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:41:14 INFO (MainThread) [systembridgebackend.modules.listeners.Listeners] Removed listener: ced0fc14-77b4-4baf-8b8b-60d4b8ecc137
2022-07-17 19:41:14 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_sdb1_write_merged_count', '0', 1658067073.9364889) ON CONFLICT(key) DO UPDATE SET value = '0', timestamp = 1658067073.9364889 WHERE key = 'io_counters_per_disk_sdb1_write_merged_count'
cannot start a transaction within a transaction
[2022-07-17 19:41:14 +0530] [4440] [INFO] Server Stopped
2022-07-17 19:41:14 INFO (MainThread) [sanic.root] Server Stopped
2022-07-17 19:41:14 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('stats_ctx_switches', '544773', 1658067074.1123638) ON CONFLICT(key) DO UPDATE SET value = '544773', timestamp = 1658067074.1123638 WHERE key = 'stats_ctx_switches'
cannot start a transaction within a transaction
2022-07-17 19:41:14 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_dm-0_read_time', '698100', 1658067074.655522) ON CONFLICT(key) DO UPDATE SET value = '698100', timestamp = 1658067074.655522 WHERE key = 'io_counters_per_disk_dm-0_read_time'
cannot commit - no transaction is active
2022-07-17 19:41:15 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_dm-0_read_merged_count', '0', 1658067074.9221811) ON CONFLICT(key) DO UPDATE SET value = '0', timestamp = 1658067074.9221811 WHERE key = 'io_counters_per_disk_dm-0_read_merged_count'
cannot start a transaction within a transaction
2022-07-17 19:41:15 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_dm-1_write_bytes', '0', 1658067075.719786) ON CONFLICT(key) DO UPDATE SET value = '0', timestamp = 1658067075.719786 WHERE key = 'io_counters_per_disk_dm-1_write_bytes'
cannot start a transaction within a transaction
2022-07-17 19:41:16 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('io_counters_per_disk_dm-1_read_time', '2628', 1658067075.8955104) ON CONFLICT(key) DO UPDATE SET value = '2628', timestamp = 1658067075.8955104 WHERE key = 'io_counters_per_disk_dm-1_read_time'
cannot start a transaction within a transaction
^C^C^C^C2022-07-17 19:41:17 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('times_percent_iowait', '13.7', 1658067077.594986) ON CONFLICT(key) DO UPDATE SET value = '13.7', timestamp = 1658067077.594986 WHERE key = 'times_percent_iowait'
cannot start a transaction within a transaction
2022-07-17 19:41:18 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('times_percent_steal', '0.0', 1658067077.88687) ON CONFLICT(key) DO UPDATE SET value = '0.0', timestamp = 1658067077.88687 WHERE key = 'times_percent_steal'
cannot start a transaction within a transaction
2022-07-17 19:41:18 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/dev_mountpoint', '/dev', 1658067078.069713) ON CONFLICT(key) DO UPDATE SET value = '/dev', timestamp = 1658067078.069713 WHERE key = 'partitions_/dev_mountpoint'
not an error
2022-07-17 19:41:18 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/dev_fstype', 'devtmpfs', 1658067078.2621236) ON CONFLICT(key) DO UPDATE SET value = 'devtmpfs', timestamp = 1658067078.2621236 WHERE key = 'partitions_/dev_fstype'
cannot commit - no transaction is active
2022-07-17 19:41:21 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/_fstype', 'ext4', 1658067081.4195752) ON CONFLICT(key) DO UPDATE SET value = 'ext4', timestamp = 1658067081.4195752 WHERE key = 'partitions_/_fstype'
cannot start a transaction within a transaction
2022-07-17 19:41:21 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/_opts', 'rw,relatime,errors=remount-ro', 1658067081.5123158) ON CONFLICT(key) DO UPDATE SET value = 'rw,relatime,errors=remount-ro', timestamp = 1658067081.5123158 WHERE key = 'partitions_/_opts'
cannot start a transaction within a transaction
2022-07-17 19:41:21 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/_maxfile', '255', 1658067081.6038845) ON CONFLICT(key) DO UPDATE SET value = '255', timestamp = 1658067081.6038845 WHERE key = 'partitions_/_maxfile'
cannot start a transaction within a transaction
2022-07-17 19:41:21 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/_maxpath', '4096', 1658067081.695691) ON CONFLICT(key) DO UPDATE SET value = '4096', timestamp = 1658067081.695691 WHERE key = 'partitions_/_maxpath'
cannot start a transaction within a transaction
2022-07-17 19:41:22 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/kernel/security_fstype', 'securityfs', 1658067082.2198617) ON CONFLICT(key) DO UPDATE SET value = 'securityfs', timestamp = 1658067082.2198617 WHERE key = 'partitions_/sys/kernel/security_fstype'
cannot start a transaction within a transaction
2022-07-17 19:41:23 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('times_per_cpu_3_user', '6.34', 1658067082.9446766) ON CONFLICT(key) DO UPDATE SET value = '6.34', timestamp = 1658067082.9446766 WHERE key = 'times_per_cpu_3_user'
not an error
2022-07-17 19:41:23 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/dev/shm_opts', 'rw,nosuid,nodev,inode64', 1658067083.4052126) ON CONFLICT(key) DO UPDATE SET value = 'rw,nosuid,nodev,inode64', timestamp = 1658067083.4052126 WHERE key = 'partitions_/dev/shm_opts'
cannot start a transaction within a transaction
2022-07-17 19:41:24 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/run/lock_fstype', 'tmpfs', 1658067084.1281154) ON CONFLICT(key) DO UPDATE SET value = 'tmpfs', timestamp = 1658067084.1281154 WHERE key = 'partitions_/run/lock_fstype'
cannot start a transaction within a transaction
^C^C^C^C^C^C^C
2022-07-17 19:41:32 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/misc_opts', 'rw,nosuid,nodev,noexec,relatime,misc', 1658067092.2965195) ON CONFLICT(key) DO UPDATE SET value = 'rw,nosuid,nodev,noexec,relatime,misc', timestamp = 1658067092.2965195 WHERE key = 'partitions_/sys/fs/cgroup/misc_opts'
cannot start a transaction within a transaction
2022-07-17 19:41:32 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('times_per_cpu_percent_3_steal', '0.0', 1658067092.5608392) ON CONFLICT(key) DO UPDATE SET value = '0.0', timestamp = 1658067092.5608392 WHERE key = 'times_per_cpu_percent_3_steal'
not an error
2022-07-17 19:41:32 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/rdma_device', 'cgroup', 1658067092.9132123) ON CONFLICT(key) DO UPDATE SET value = 'cgroup', timestamp = 1658067092.9132123 WHERE key = 'partitions_/sys/fs/cgroup/rdma_device'
cannot start a transaction within a transaction
2022-07-17 19:41:32 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('times_per_cpu_percent_3_guest_nice', '0.0', 1658067092.8191738) ON CONFLICT(key) DO UPDATE SET value = '0.0', timestamp = 1658067092.8191738 WHERE key = 'times_per_cpu_percent_3_guest_nice'
cannot commit - no transaction is active
2022-07-17 19:41:34 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/devices_device', 'cgroup', 1658067094.054948) ON CONFLICT(key) DO UPDATE SET value = 'cgroup', timestamp = 1658067094.054948 WHERE key = 'partitions_/sys/fs/cgroup/devices_device'
cannot commit - no transaction is active
2022-07-17 19:41:35 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO cpu (key, value, timestamp) VALUES ('usage_3', '0.0', 1658067095.755025) ON CONFLICT(key) DO UPDATE SET value = '0.0', timestamp = 1658067095.755025 WHERE key = 'usage_3'
cannot start a transaction within a transaction
2022-07-17 19:41:36 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/pids_maxpath', '4096', 1658067096.4048028) ON CONFLICT(key) DO UPDATE SET value = '4096', timestamp = 1658067096.4048028 WHERE key = 'partitions_/sys/fs/cgroup/pids_maxpath'
cannot commit - no transaction is active
2022-07-17 19:41:36 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO memory (key, value, timestamp) VALUES ('swap_total', '1027600384', 1658067096.4892802) ON CONFLICT(key) DO UPDATE SET value = '1027600384', timestamp = 1658067096.4892802 WHERE key = 'swap_total'
cannot start a transaction within a transaction
2022-07-17 19:41:36 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO memory (key, value, timestamp) VALUES ('swap_used', '0', 1658067096.6473553) ON CONFLICT(key) DO UPDATE SET value = '0', timestamp = 1658067096.6473553 WHERE key = 'swap_used'
cannot start a transaction within a transaction
2022-07-17 19:41:37 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/hugetlb_device', 'cgroup', 1658067097.1966372) ON CONFLICT(key) DO UPDATE SET value = 'cgroup', timestamp = 1658067097.1966372 WHERE key = 'partitions_/sys/fs/cgroup/hugetlb_device'
cannot commit - no transaction is active
2022-07-17 19:41:38 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO memory (key, value, timestamp) VALUES ('virtual_percent', '32.4', 1658067097.7190535) ON CONFLICT(key) DO UPDATE SET value = '32.4', timestamp = 1658067097.7190535 WHERE key = 'virtual_percent'
cannot start a transaction within a transaction
2022-07-17 19:41:38 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/cpu,cpuacct_mountpoint', '/sys/fs/cgroup/cpu,cpuacct', 1658067098.221323) ON CONFLICT(key) DO UPDATE SET value = '/sys/fs/cgroup/cpu,cpuacct', timestamp = 1658067098.221323 WHERE key = 'partitions_/sys/fs/cgroup/cpu,cpuacct_mountpoint'
not an error
2022-07-17 19:41:38 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/cpu,cpuacct_opts', 'rw,nosuid,nodev,noexec,relatime,cpu,cpuacct', 1658067098.5048366) ON CONFLICT(key) DO UPDATE SET value = 'rw,nosuid,nodev,noexec,relatime,cpu,cpuacct', timestamp = 1658067098.5048366 WHERE key = 'partitions_/sys/fs/cgroup/cpu,cpuacct_opts'
not an error
2022-07-17 19:41:39 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO memory (key, value, timestamp) VALUES ('virtual_slab', '144220160', 1658067099.4213367) ON CONFLICT(key) DO UPDATE SET value = '144220160', timestamp = 1658067099.4213367 WHERE key = 'virtual_slab'
cannot start a transaction within a transaction
2022-07-17 19:41:40 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/sys/fs/cgroup/freezer_maxpath', '4096', 1658067099.779676) ON CONFLICT(key) DO UPDATE SET value = '4096', timestamp = 1658067099.779676 WHERE key = 'partitions_/sys/fs/cgroup/freezer_maxpath'
not an error
2022-07-17 19:41:41 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO network (key, value, timestamp) VALUES ('stat_eth0_duplex', 'NicDuplex.NIC_DUPLEX_FULL', 1658067100.8010402) ON CONFLICT(key) DO UPDATE SET value = 'NicDuplex.NIC_DUPLEX_FULL', timestamp = 1658067100.8010402 WHERE key = 'stat_eth0_duplex'
not an error
2022-07-17 19:41:41 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO network (key, value, timestamp) VALUES ('stat_eth0_speed', '100', 1658067101.3681831) ON CONFLICT(key) DO UPDATE SET value = '100', timestamp = 1658067101.3681831 WHERE key = 'stat_eth0_speed'
not an error
2022-07-17 19:41:46 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO network (key, value, timestamp) VALUES ('stat_veth6444407_mtu', '1500', 1658067106.154562) ON CONFLICT(key) DO UPDATE SET value = '1500', timestamp = 1658067106.154562 WHERE key = 'stat_veth6444407_mtu'
cannot start a transaction within a transaction
2022-07-17 19:41:47 ERROR (Thread-3) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO disk (key, value, timestamp) VALUES ('partitions_/dev/mqueue_fstype', 'mqueue', 1658067107.6853354) ON CONFLICT(key) DO UPDATE SET value = 'mqueue', timestamp = 1658067107.6853354 WHERE key = 'partitions_/dev/mqueue_fstype'
cannot start a transaction within a transaction
2022-07-17 19:41:49 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO network (key, value, timestamp) VALUES ('io_counters_bytes_recv', '1625911', 1658067109.3210618) ON CONFLICT(key) DO UPDATE SET value = '1625911', timestamp = 1658067109.3210618 WHERE key = 'io_counters_bytes_recv'
not an error
2022-07-17 19:41:49 ERROR (Thread-5) [systembridgeshared.database.Database] Error executing SQL: INSERT INTO network (key, value, timestamp) VALUES ('io_counters_packets_recv', '4107', 1658067109.760252) ON CONFLICT(key) DO UPDATE SET value = '4107', timestamp = 1658067109.760252 WHERE key = 'io_counters_packets_recv'
not an error
2022-07-17 19:41:50 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: cpu
2022-07-17 19:41:52 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Data changed for module: cpu
2022-07-17 19:41:52 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: memory
2022-07-17 19:41:52 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Data changed for module: memory
2022-07-17 19:41:52 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: network
2022-07-17 19:41:54 INFO (Thread-5) [systembridgebackend.modules.listeners.Listeners] Data changed for module: network
2022-07-17 19:41:54 INFO (Thread-5) [systembridgebackend.modules.update.Update] Finished updating frequent data
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/user/129/gvfs'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/b433115e9244ab0df18b44096987da3904d664fd6a35bdec675ab0cf23f451c4/merged'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/9872402bb1b470ffe3418a87a2530c9ed5248eb052133bce7afd027311b6bc33/merged'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/docker/netns/5d71ac68a87d'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/docker/netns/06e25c1d3951'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/6d5b6858764fd6b4291482e51681c7dca52de11a65aa463ae5149db6a7f67d42/merged'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/docker/netns/754ef1260199'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/97cd844426d79367fc9e40e87404a9f8e6272a0f2044c44e29b37ed3911c37b6/merged'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/docker/netns/40cf9258f0c0'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/3fc77c62fba023ffcc03f6d0a820e9a30f4f88cdea07f8e37722e0cecf5c4b59/merged'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/docker/netns/4074a9219fa5'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/a8448622389d874ffd8b5a506b4ff78111d0d8dad8e3fdb6d9295b32805e8397/merged'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/docker/netns/9ae710d4ba94'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/94c9aec73d9b840426554f0068222f3095e15a43361da0f2b8a49f0c51e1a46f/merged'
2022-07-17 19:42:26 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/run/docker/netns/default'
2022-07-17 19:42:27 ERROR (Thread-3) [systembridgebackend.modules.disk.Disk] PermissionError: [Errno 13] Permission denied: '/var/lib/docker/overlay2/9bd36e617732e228d75a90995276c7722df4a98de63a9e460524f09c139516bd/merged'
2022-07-17 19:42:29 INFO (Thread-3) [systembridgebackend.modules.system.System] Get latest version from GitHub
2022-07-17 19:42:29 INFO (Thread-3) [systembridgebackend.modules.listeners.Listeners] Refresh data by module: disk
2022-07-17 19:42:29 INFO (Thread-3) [systembridgebackend.modules.listeners.Listeners] Data changed for module: disk
2022-07-17 19:42:29 ERROR (Thread-3) [systembridgebackend.modules.system.System] Error getting data from GitHub: Request exception for 'https://api.github.com/repos/timmo001/system-bridge/releases' with - 
Exception in thread Thread-3:
Traceback (most recent call last):
  File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/data.py", line 28, in run
    asyncio.run(self._update.update_data(self._updated_callback))
  File "/usr/lib/python3.10/asyncio/runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "uvloop/loop.pyx", line 1501, in uvloop.loop.Loop.run_until_complete
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/modules/update.py", line 64, in update_data
    await asyncio.gather(*tasks)
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/modules/update.py", line 51, in _update
    await class_obj["cls"].update_all_data()
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/modules/battery/update.py", line 38, in update_all_data
    await asyncio.gather(
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/modules/battery/update.py", line 33, in update_status
    for key, value in self._battery.status().items():
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/modules/battery/__init__.py", line 20, in status
    return battery.status
  File "/home/ajay/.local/lib/python3.10/site-packages/plyer/utils.py", line 114, in __getattribute__
    result = getattr(object.__getattribute__(self, '_obj'), name)
  File "/home/ajay/.local/lib/python3.10/site-packages/plyer/facades/battery.py", line 42, in status
    return self.get_state()
  File "/home/ajay/.local/lib/python3.10/site-packages/plyer/facades/battery.py", line 49, in get_state
    return self._get_state()
  File "/home/ajay/.local/lib/python3.10/site-packages/plyer/platforms/linux/battery.py", line 81, in _get_state
    percentage = float(
ValueError: could not convert string to float: '0% (should be ignored'
2022-07-17 19:42:29 ERROR (MainThread) [asyncio] Task was destroyed but it is pending!
task: <Task pending name='Task-38' coro=<WebsocketFrameAssembler.get() running at /home/ajay/.local/lib/python3.10/site-packages/sanic/server/websockets/frame.py:117> wait_for=<Future pending cb=[Task.task_wakeup()]>>

Additional information

Screenshot from 2022-07-17 19-52-01 Screenshot from 2022-07-17 19-52-07 Screenshot from 2022-07-17 19-52-10 Screenshot from 2022-07-17 19-52-13 Screenshot from 2022-07-17 19-52-17 Screenshot from 2022-07-17 19-52-21 Screenshot from 2022-07-17 19-52-26

delta010 avatar Jul 17 '22 14:07 delta010

These SQL errors are hiding your actual error which is with the GUI not starting. While valid, they shouldn't affect the application from running (in this case the GUI module)

Here is your error:

2022-07-17 19:41:01 INFO (MainThread) [__main__.Main] System Bridge GUI 3.4.1: Startup
qt.qpa.xcb: could not connect to display 
qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.
This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem.

Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vkkhrdisplay, vnc, wayland-egl, wayland, xcb.

2022-07-17 19:41:01 ERROR (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] GUI exited with code: -6
2022-07-17 19:41:01 ERROR (Thread-2 (start_gui_sync)) [systembridgebackend.server.Server] Failed to start GUI after 2 attempts
Exception in thread Thread-2 (start_gui_sync):
Traceback (most recent call last):
  File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.10/threading.py", line 953, in run
    self._target(*self._args, **self._kwargs)
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 79, in start_gui_sync
    asyncio.run(
  File "/usr/lib/python3.10/asyncio/runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "uvloop/loop.pyx", line 1501, in uvloop.loop.Loop.run_until_complete
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 61, in start_gui
    await start_gui(
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 61, in start_gui
    await start_gui(
  File "/home/ajay/.local/lib/python3.10/site-packages/systembridgebackend/gui.py", line 27, in start_gui
    raise GUIAttemptsExceededException("Failed to start GUI after 3 attempts")
systembridgebackend.gui.GUIAttemptsExceededException: Failed to start GUI after 3 attempts

There appears to be an error with Qt initializing from the dependent package pyside6

timmo001 avatar Jul 17 '22 15:07 timmo001

I got the SQL errors too, even though I'm intentionally running headless per the instructions. I'm setting it up on a Debian Bullseye/stable/11 system, using ansible and this playbook/template. I have an appdata variable defined in my inventory to /opt/appdata which is the root of where I install things like this. Note that I'm installing from my Git branch here to include the #1874 fix. Hopefully this can help repro the issue. systembridge.zip

rpavlik avatar Jul 19 '22 16:07 rpavlik

Hi, i'm running systembridge as systemd unit without gui. My system is debian unstable with python3.10. After those sql errors, i get this exception

Exception in thread Thread-4:
Traceback (most recent call last):
  File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/data.py", line 47, in run
    asyncio.run(self._update.update_frequent_data(self._updated_callback))
  File "/usr/lib/python3.10/asyncio/runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "uvloop/loop.pyx", line 1501, in uvloop.loop.Loop.run_until_complete
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/modules/update.py", line 78, in update_frequent_data
    await sensors_update.update_all_data()
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/modules/sensors/update.py", line 148, in update_all_data
    await asyncio.gather(
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/modules/sensors/update.py", line 67, in update_temperatures
    self._database.write_sensor(
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgeshared/database.py", line 214, in write_sensor
    self.execute_sql(
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgeshared/database.py", line 59, in execute_sql
    self._connection.commit()
sqlite3.DatabaseError: cannot commit - no transaction is active

also

Exception in thread Thread-14:
Traceback (most recent call last):
  File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/data.py", line 47, in run
    asyncio.run(self._update.update_frequent_data(self._updated_callback))
  File "/usr/lib/python3.10/asyncio/runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "uvloop/loop.pyx", line 1501, in uvloop.loop.Loop.run_until_complete
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/modules/update.py", line 78, in update_frequent_data
    await sensors_update.update_all_data()
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/modules/sensors/update.py", line 148, in update_all_data
    await asyncio.gather(
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgebackend/modules/sensors/update.py", line 67, in update_temperatures
    self._database.write_sensor(
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgeshared/database.py", line 214, in write_sensor
    self.execute_sql(
  File "/var/lib/systembridge/lib/python3.10/site-packages/systembridgeshared/database.py", line 58, in execute_sql
    self._connection.execute(sql)
sqlite3.DatabaseError: no more rows available

does it help?

Elkropac avatar Jul 22 '22 13:07 Elkropac

I reported this as a problem in the original comment on the unrelated issue https://github.com/timmo001/system-bridge/issues/1831.

Like @rpavlik, I'm also running in headless mode, so this is definitely unrelated to the GUI error.

ScottG489 avatar Jul 27 '22 13:07 ScottG489

I did have this issue previously as well on manjaro, but one of the newer updates did fix this for me. No SQL Errors (at least not those) are present now and the app starts and i can finally play around with it!

Moerill avatar Sep 12 '22 08:09 Moerill