unkle1977

I think I may have to wipe and reinstall, lots of errors and issues in my install Worker Page (none existent !) Webui.log (some funny errors here) 2021-10-04 16:38:27 [1791] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:38:27 [1791] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:38:27 [1791] [INFO] Listening at: http://0.0.0.0:8926 (1791) 2021-10-04 16:38:27 [1791] [INFO] Listening at: http://0.0.0.0:8926 (1791) 2021-10-04 16:38:27 [1791] [INFO] Using worker: sync 2021-10-04 16:38:27 [1791] [INFO] Using worker: sync 2021-10-04 16:38:27 [1794] [INFO] Booting worker with pid: 1794 2021-10-04 16:38:27 [1794] [INFO] Booting worker with pid: 1794 2021-10-04 16:38:27 [1795] [INFO] Booting worker with pid: 1795 2021-10-04 16:38:27 [1795] [INFO] Booting worker with pid: 1795 2021-10-04 16:38:31 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:31 +0100] "GET / HTTP/1.1" 200 676 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:31 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:31 +0100] "GET /static/landing.gif HTTP/1.1" 304 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:32 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:32 +0100] "GET /static/favicon.ico HTTP/1.1" 200 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:34 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:34 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:34 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:34 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:35 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:35 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET / HTTP/1.1" 200 676 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /static/landing.gif HTTP/1.1" 304 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET / HTTP/1.1" 200 676 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /static/landing.gif HTTP/1.1" 304 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:46 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:46 +0100] "GET /plotting/jobs HTTP/1.1" 200 16930 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:46 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:46 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:48 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:48 +0100] "GET /plotting/jobs HTTP/1.1" 200 16930 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:48 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:48 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:49 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:49 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:49 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:49 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:49 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:49 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:50 +0100] "GET /wallet HTTP/1.1" 200 11579 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:50 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:50 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/wallet" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /plotting/jobs HTTP/1.1" 200 16930 "http://192.168.1.9:8926/wallet" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:52 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:52 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:45:28 [2271] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:45:28 [2271] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:45:28 [2271] [INFO] Listening at: http://0.0.0.0:8926 (2271) 2021-10-04 16:45:28 [2271] [INFO] Listening at: http://0.0.0.0:8926 (2271) 2021-10-04 16:45:28 [2271] [INFO] Using worker: sync 2021-10-04 16:45:28 [2271] [INFO] Using worker: sync 2021-10-04 16:45:28 [2274] [INFO] Booting worker with pid: 2274 2021-10-04 16:45:28 [2274] [INFO] Booting worker with pid: 2274 2021-10-04 16:45:28 [2275] [INFO] Booting worker with pid: 2275 2021-10-04 16:45:28 [2275] [INFO] Booting worker with pid: 2275 2021-10-04 16:45:44 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:45:44 +0100] "GET /index HTTP/1.1" 302 228 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:45:44 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:45:44 +0100] "GET /controller HTTP/1.1" 200 1509 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:45:44 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:45:44 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:16 [2275] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:16 [2275] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:16 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:16 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:16 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:16 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:24 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:24 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:24 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:24 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:24 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:24 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:28 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:28 +0100] "GET /farming/workers HTTP/1.1" 200 10594 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:28 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:28 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/workers" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:29 [2274] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:29 [2274] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:29 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:29 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/farming/workers" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:29 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:29 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:51:16 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:51:16 +0100] "GET /farming/workers HTTP/1.1" 200 10594 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:51:16 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:51:16 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/workers" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" aspisrv.log end extract (lots of errors) 2021-10-04 16:47:32 [2269] [INFO] Running job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:47:32 BST)" (scheduled at 2021-10-04 16:47:32.963308+01:00) 2021-10-04 16:47:34 [2269] [INFO] Running job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:47:34 BST)" (scheduled at 2021-10-04 16:47:34.842159+01:00) 2021-10-04 16:47:36 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:36 +0100] "POST /challenges/ HTTP/1.1" 201 7746 "-" "python-requests/2.26.0" 2021-10-04 16:47:36 [2269] [INFO] Job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:49:57 BST)" executed successfully 2021-10-04 16:47:38 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:47:38 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:47:38 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:38 +0100] "POST /workers/ HTTP/1.1" 500 46 "-" "python-requests/2.26.0" 2021-10-04 16:47:38 [2269] [INFO] Job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:20 BST)" executed successfully 2021-10-04 16:47:45 [2269] [INFO] Running job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:18 BST)" (scheduled at 2021-10-04 16:47:45.487320+01:00) 2021-10-04 16:47:46 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:46 +0100] "DELETE /plottings/Tower HTTP/1.1" 204 0 "-" "python-requests/2.26.0" 2021-10-04 16:47:46 [2269] [INFO] Job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:18 BST)" executed successfully 2021-10-04 16:47:59 [2269] [INFO] Running job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:50 BST)" (scheduled at 2021-10-04 16:47:59.600139+01:00) 2021-10-04 16:47:59 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:59 +0100] "POST /alerts/ HTTP/1.1" 201 4130 "-" "python-requests/2.26.0" 2021-10-04 16:47:59 [2269] [INFO] Job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:50 BST)" executed successfully 2021-10-04 16:49:57 [2269] [INFO] Running job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:20 BST)" (scheduled at 2021-10-04 16:49:57.412934+01:00) 2021-10-04 16:49:57 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:49:57 +0100] "POST /challenges/ HTTP/1.1" 201 7504 "-" "python-requests/2.26.0" 2021-10-04 16:49:57 [2269] [INFO] Job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:20 BST)" executed successfully 2021-10-04 16:50:00 [2269] [INFO] Running job "stats_disk (trigger: cron[minute='*/10'], next run at: 2021-10-04 17:00:00 BST)" (scheduled at 2021-10-04 16:50:00+01:00) 2021-10-04 16:50:00 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:00 +0100] "POST /stats/plottingdiskused/ HTTP/1.1" 201 12621 "-" "python-requests/2.26.0" 2021-10-04 16:50:00 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:00 +0100] "POST /stats/plottingdiskfree/ HTTP/1.1" 201 12907 "-" "python-requests/2.26.0" 2021-10-04 16:50:00 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:00 +0100] "POST /stats/plotsdiskused/ HTTP/1.1" 201 12764 "-" "python-requests/2.26.0" 2021-10-04 16:50:01 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:01 +0100] "POST /stats/plotsdiskfree/ HTTP/1.1" 201 12621 "-" "python-requests/2.26.0" 2021-10-04 16:50:01 [2269] [INFO] Job "stats_disk (trigger: cron[minute='*/10'], next run at: 2021-10-04 17:00:00 BST)" executed successfully 2021-10-04 16:50:18 [2269] [INFO] Running job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:12 BST)" (scheduled at 2021-10-04 16:50:18.548802+01:00) 2021-10-04 16:50:19 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:19 +0100] "DELETE /plottings/Tower HTTP/1.1" 204 0 "-" "python-requests/2.26.0" 2021-10-04 16:50:19 [2269] [INFO] Job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:12 BST)" executed successfully 2021-10-04 16:50:20 [2269] [INFO] Running job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:53 BST)" (scheduled at 2021-10-04 16:50:20.887799+01:00) 2021-10-04 16:50:24 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:50:24 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:50:24 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:24 +0100] "POST /workers/ HTTP/1.1" 500 46 "-" "python-requests/2.26.0" 2021-10-04 16:50:24 [2269] [INFO] Job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:53 BST)" executed successfully 2021-10-04 16:50:50 [2269] [INFO] Running job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:24 BST)" (scheduled at 2021-10-04 16:50:50.404164+01:00) 2021-10-04 16:50:50 [2269] [INFO] Job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:24 BST)" executed successfully 2021-10-04 16:52:20 [2269] [INFO] Running job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:54:39 BST)" (scheduled at 2021-10-04 16:52:20.163428+01:00) 2021-10-04 16:52:20 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:52:20 +0100] "POST /challenges/ HTTP/1.1" 201 7262 "-" "python-requests/2.26.0" 2021-10-04 16:52:20 [2269] [INFO] Job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:54:39 BST)" executed successfully 2021-10-04 16:52:53 [2269] [INFO] Running job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:50 BST)" (scheduled at 2021-10-04 16:52:53.421711+01:00) 2021-10-04 16:52:56 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:52:56 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:52:56 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:52:56 +0100] "POST /workers/ HTTP/1.1" 500 46 "-" "python-requests/2.26.0" 2021-10-04 16:52:56 [2269] [INFO] Job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:50 BST)" executed successfully 2021-10-04 16:53:12 [2269] [INFO] Running job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:42 BST)" (scheduled at 2021-10-04 16:53:12.467739+01:00) 2021-10-04 16:53:13 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:53:13 +0100] "DELETE /plottings/Tower HTTP/1.1" 204 0 "-" "python-requests/2.26.0" 2021-10-04 16:53:13 [2269] [INFO] Job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:42 BST)" executed successfully 2021-10-04 16:53:24 [2269] [INFO] Running job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:41 BST)" (scheduled at 2021-10-04 16:53:24.591082+01:00) 2021-10-04 16:53:24 [2269] [INFO] Job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:41 BST)" executed successfully

I'm having an issue where Machinaris on unraid loads, the farmer is running, but I am unable to change any of the settings (all blank) and I cannot start a plotter as the button is not there. It is like something has been corrupted, but I want o have to avoid downloading the whole blockchain again with a clean install. The same happens on test and main versions. Help!

I've just upgrade the motherboard, cpu and memory in my unraid set up, booted back up and the cache and one of my drives is now not recognised by the serial number in the array. these are the correct drives as I've checked to nmy screenshot from before the change. I don't want to lose any data if possible, so it would be great if someone could advise me the best way to proceed. New Config etc? Diagnostics attached as well tower-diagnostics-20200414-1210.zip

I love the ease of use of Unraid, it is so easy to set up I'd like to see some easier way of accessing the servers from outside the network that does not need an IT Degree