unkle1977

October 4, 2021

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

October 4, 2021

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!

April 14, 2020

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

January 7, 2020

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

unkle1977

Posts

Joined

Last visited

Content Type

Profiles

Forums

Downloads

Store

Gallery

Bug Reports

Documentation

Landing

Posts posted by unkle1977

[Support] Machinaris - Chia cryptocurrency farming + Plotman plotting + Unraid WebUI

[Support] Machinaris - Chia cryptocurrency farming + Plotman plotting + Unraid WebUI

Changed Mobo / CPU and now some drives are not recognised

Unraid Forum 100K Giveaway