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!