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


Recommended Posts

Anyone knows how much RAM is needed for this, if you're just running it as a farm? I've done all my plotting on other hardware, and am farming 930 plots.

 

I thought 4GB would be well enough for this, since ppl are farming on Raspberry Pi's, but it got unstable and now with 8GB RAM, it's on 5.8 and rising. Is there a memory leak or is it normal?

 

image.png.ee439627a4e37ad11b259b092f347422.png

Link to comment

I'm trying to move my farmer from official client in a Linux VM to Machinaris on my NAS to make things nice and easy. But whenever I make any configuration change and restart Machinaris, it creates a new farmer ID as seen here. To be clear, I am not doing anything other than adding a new path to the config and restarting the container.

 

Have others observed the same behavior? I would like to only have 1 single ID since this is all on one machine and I like clean interfaces lol. Will the "older" ID disappear once the history goes back far enough? I want to avoid having 20 IDs eventually if I continue tweaking the container settings.

Machinaris_Multiple_IDs.png

 

EDIT:

After a while, the old ID disappeared from the Summary plot, but it still exists in other locations, such as the Workers, Wallet, Keys etc views.
Machinaris_Multiple_IDs_2.thumb.png.4c5ba5f72100deb3ee5211daaefce7f0.png

Edited by neodied
Added second half of post with update
Link to comment
On 9/30/2021 at 7:35 AM, Ancan said:

I thought 4GB would be well enough for this, since ppl are farming on Raspberry Pi's, but it got unstable and now with 8GB RAM, it's on 5.8 and rising.

Looks like you're farming both Flax and Chia. I have only Chia farming and my memory usage is stable at 4.1GB. Have you tried removing Flax from your container config?

Link to comment
11 minutes ago, neodied said:

Looks like you're farming both Flax and Chia. I have only Chia farming and my memory usage is stable at 4.1GB. Have you tried removing Flax from your container config?

 

If it's till 4.1GB with only Chia, then I assume my usage is normal. It's been around 5.8-5.9GB since yesterday now.

Link to comment
On 9/30/2021 at 7:35 AM, Ancan said:

Anyone knows how much RAM is needed for this, if you're just running it as a farm? I've done all my plotting on other hardware, and am farming 930 plots.

 

I thought 4GB would be well enough for this, since ppl are farming on Raspberry Pi's, but it got unstable and now with 8GB RAM, it's on 5.8 and rising. Is there a memory leak or is it normal?

 

As a data point, I farm flax and chia and my usage seems to hover around 7.4GB.

Link to comment
13 hours ago, Mr_4braham said:

Can I harvest my existing plots with the new chives, hddcoin and nchain as well? With the new flax separate container does that mean flax will be removed from the original machinaris container? Because it looks like I can still harvest it from the main one.

I started experimenting with this last night. So far there is no way to interact with them.

 

To get them to sync and and report in, the following is required: 

  1. Own IP. The default bridge mode will not work as the worker's name is linked to its IP address.
  2. Adding the following to extra parameters:
    1. -h "<dockername>" -e TZ=<local> -e worker_address=<Worker IP> -e controller_host=<Machinaris IP> -e controller_api_port=8927
      1. EX: -h "chives" -e TZ=America/Los_Angeles -e worker_address=192.168.1.24 -e controller_host=192.168.1.2 -e controller_api_port=8927

I also have not been able to figure out what the worker_api_port is for. None of them are being requested by docker, so the port isn't actually opened. when manually opening the by via -p 8931:8931 (for chives), nothing changes.

 

it appears the built in flax and the addon flax are different.  

 

I was unable to find documentation any of this, so everything done was a guess.

Edited by rukiftw
Link to comment

A Machinaris update is now available with latest bundled components:

  • Chia - Update to version 1.2.8. See their changelog for details.
  • Bladebit - Update to version 1.2.0. See their changelog for details
  • Chia - Update to version 1.2.9. See their changelog for details.

Big thanks to all who contributed including: y2kboy23

 

Regarding development work on upcoming blockchain fork support for Chives, HDDCoin, NChain, and others... it's actively being worked on.  Will release the v0.6.0 development stream work to test stream as soon as it is ready.  Thanks for the interest!

Link to comment
2 hours ago, Ystebad said:

Same problem here except the address slightly different. Cannot access

 Sorry, to hear that.  Please post a full-series of screenshots showing all settings for Machinaris under your Unraid Docker config, more than the snippets posted above.   They seem to show one of the new beta templates for Machinaris forks.

 

It seems like something is wrong with the Unraid Community Apps template for Machinaris which is unchanged for over 20 days now: https://github.com/guydavis/machinaris-unraid/blob/master/machinaris.xml

Link to comment
46 minutes ago, guy.davis said:

 Sorry, to hear that.  Please post a full-series of screenshots showing all settings for Machinaris under your Unraid Docker config, more than the snippets posted above.   They seem to show one of the new beta templates for Machinaris forks.

 

It seems like something is wrong with the Unraid Community Apps template for Machinaris which is unchanged for over 20 days now: https://github.com/guydavis/machinaris-unraid/blob/master/machinaris.xml

 

 

881125648_ScreenShot2021-10-03at11_48_37AM.thumb.png.dc616ec0e318d5e95fedb389984d6a9b.png

917734727_ScreenShot2021-10-03at11_48_52AM.thumb.png.1a5bf94c61442c878e1898c9cb335e04.png

Link to comment

This also shows up on my "fix Common problems":

 

Template URL for docker application machinaris is not the as what the template author specified.The template URL the author specified is https://raw.githubusercontent.com/guydavis/machinaris-unraid/master/machinaris-hddcoin.xml. The template can be updated automatically with the correct URL. 

 

But running "apply fix" doesn't seem to do anything.

 

Trying to open the GUI gives me the same screen noted above but says:

 

This Machinaris worker is controlled at: http://:8926

 

 

Link to comment

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!

 

image.thumb.png.f0295115de48e8c2df2e3d68be744b3b.pngimage.thumb.png.94016aa40ebb00caa665d04dc874ffbe.png

Link to comment
5 hours ago, unkle1977 said:

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!

 

image.thumb.png.f0295115de48e8c2df2e3d68be744b3b.pngimage.thumb.png.94016aa40ebb00caa665d04dc874ffbe.png

 

Sorry to hear that.  Please share:

  1. A screenshot of your Workers page to indicate status of install(s).  
  2. The end of your log files (apisrv.log and webui.log) in /mnt/user/appdata/machinaris/machinaris/logs).  Also available from right-hand side of your Workers page.

 

 

Link to comment

I think I may have to wipe and reinstall, lots of errors and issues in my install

 

Worker Page (none existent !)

image.thumb.png.9da9fc87a4f6709c036e27fde6ba9d6c.png

 

 

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

 

Link to comment
11 hours ago, unkle1977 said:

I think I may have to wipe and reinstall, lots of errors and issues in my install

 

Worker Page (none existent !)

image.thumb.png.9da9fc87a4f6709c036e27fde6ba9d6c.png

 

 

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

 

 

Hmm, let's see if we can get this sorted out.  Please ensure you are using a Repository setting of "ghcr.io/guydavis/machinaris" on the Docker settings for Machinaris:

image.thumb.png.c807bd085ba7d0add49d9b8fb677b676.png

 

Then:

1) Stop Machinaris container

2) Delete /mnt/user/appdata/machinaris/machinaris/dbs/machinaris.db (on the Unraid host filesystem)

3) Start Machinaris container

 

This should ensure you are using the latest release and create a fresh status database on launch.  Please let me know how it goes.

 

Link to comment
On 10/3/2021 at 11:02 AM, guy.davis said:

 Sorry, to hear that.  Please post a full-series of screenshots showing all settings for Machinaris under your Unraid Docker config, more than the snippets posted above.   They seem to show one of the new beta templates for Machinaris forks.

 

It seems like something is wrong with the Unraid Community Apps template for Machinaris which is unchanged for over 20 days now: https://github.com/guydavis/machinaris-unraid/blob/master/machinaris.xml

 

 

Sorry not sure exactly how to do that - tried to just select and copy but it didn't copy a lot of the fields.  Is there a way to export or do I just need to make screen grabs?

Link to comment
3 hours ago, Ystebad said:

1108124752_ScreenShot2021-10-06at1_19_53PM.thumb.png.4202d535727c8980a4b4c87a5383f638.png1519326900_ScreenShot2021-10-06at1_20_10PM.thumb.png.d85165fc65d388e36b71ca092059441c.png1279942592_ScreenShot2021-10-06at1_20_26PM.thumb.png.7e7326b9db0cc33aab8cdbae113fe516.png1192608023_ScreenShot2021-10-06at1_20_35PM.thumb.png.382623c298a9d0e02c4f4f95711f05e2.png

Screen Shot 2021-10-06 at 1.23.52 PM.png

 

Ok, yes the CA templates for your v0.5.7 Machinaris container are contaminated with settings from upcoming v0.6.0 Machinaris (currenly in development) with fork support.  To fix, simply Remove the following from your config shown:

* rpc_port

* protocol_port

* worker_api_port

* worker_host

* controller_host
Then click Apply and the Machinaris container should restart.  

My apologies for the inconvenience.  I am still learning the ins and outs of Unraid application templating.

  • Thanks 1
Link to comment
1 hour ago, Ystebad said:

Yes that fixed it thank you!

 

However under plotting and workers I now see two different choices with with same name.

 

Want to start plotting again, but unsure if I should or which one to select.

 

1596983399_ScreenShot2021-10-08at10_09_58AM.thumb.png.fdb9224f46b1c3ec62fb7f5d4a43c5cd.png1029361484_ScreenShot2021-10-08at10_10_16AM.thumb.png.4a1f0250f4c8dc708b2b1f6beba1bc68.png

 

Hi, there is likely a stale worker left on the Workers page.  Please visit the page and Prune both.  Don't worry if things vanish for 10 mins or so.  The "real" one will begin to re-populate status shortly leaving only one Worker behind.  Hope this helps!

  • Thanks 1
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.