Ancan Posted September 30, 2021 Share Posted September 30, 2021 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? Quote Link to comment
neodied Posted September 30, 2021 Share Posted September 30, 2021 (edited) 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. 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. Edited September 30, 2021 by neodied Added second half of post with update Quote Link to comment
neodied Posted September 30, 2021 Share Posted September 30, 2021 Solving my own issue I found the option under Workers to "Prune", which appears to be exactly what I needed. After using this on the previous ID, all the interfaces show only this remaining worker ID. Quote Link to comment
neodied Posted October 1, 2021 Share Posted October 1, 2021 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? Quote Link to comment
Ancan Posted October 1, 2021 Share Posted October 1, 2021 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. Quote Link to comment
DoeBoye Posted October 1, 2021 Share Posted October 1, 2021 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. Quote Link to comment
Mr_4braham Posted October 2, 2021 Share Posted October 2, 2021 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. Quote Link to comment
rukiftw Posted October 2, 2021 Share Posted October 2, 2021 (edited) 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: Own IP. The default bridge mode will not work as the worker's name is linked to its IP address. Adding the following to extra parameters: -h "<dockername>" -e TZ=<local> -e worker_address=<Worker IP> -e controller_host=<Machinaris IP> -e controller_api_port=8927 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 October 2, 2021 by rukiftw Quote Link to comment
guy.davis Posted October 2, 2021 Author Share Posted October 2, 2021 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! Quote Link to comment
Spazhead Posted October 3, 2021 Share Posted October 3, 2021 upadte, cannot access web gui, keeps saying its controlled by my IP address. I click on link , endless loop.... Quote Link to comment
Spazhead Posted October 3, 2021 Share Posted October 3, 2021 only way for me to get in was to add http://192.168.2.56:8926/plotting/jobs plus still IP hostname not fixed yet. Quote Link to comment
Ystebad Posted October 3, 2021 Share Posted October 3, 2021 4 hours ago, Spazhead said: upadte, cannot access web gui, keeps saying its controlled by my IP address. I click on link , endless loop.... Same problem here except the address slightly different. Cannot access Quote Link to comment
guy.davis Posted October 3, 2021 Author Share Posted October 3, 2021 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 Quote Link to comment
Spazhead Posted October 3, 2021 Share Posted October 3, 2021 i temporary fixed my issue by deleting the 3 new lines, and restarting the docker.. hope it gets fixed soon.. Quote Link to comment
Spazhead Posted October 3, 2021 Share Posted October 3, 2021 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 Quote Link to comment
Ystebad Posted October 3, 2021 Share Posted October 3, 2021 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 Quote Link to comment
unkle1977 Posted October 4, 2021 Share Posted October 4, 2021 I'm having an issue where Machinaris on unraid loads, the farmer is running, but I am unable to change any of the settings (all blank) and I cannot start a plotter as the button is not there. It is like something has been corrupted, but I want o have to avoid downloading the whole blockchain again with a clean install. The same happens on test and main versions. Help! Quote Link to comment
guy.davis Posted October 4, 2021 Author Share Posted October 4, 2021 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! Sorry to hear that. Please share: A screenshot of your Workers page to indicate status of install(s). 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. Quote Link to comment
unkle1977 Posted October 4, 2021 Share Posted October 4, 2021 I think I may have to wipe and reinstall, lots of errors and issues in my install Worker Page (none existent !) Webui.log (some funny errors here) 2021-10-04 16:38:27 [1791] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:38:27 [1791] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:38:27 [1791] [INFO] Listening at: http://0.0.0.0:8926 (1791) 2021-10-04 16:38:27 [1791] [INFO] Listening at: http://0.0.0.0:8926 (1791) 2021-10-04 16:38:27 [1791] [INFO] Using worker: sync 2021-10-04 16:38:27 [1791] [INFO] Using worker: sync 2021-10-04 16:38:27 [1794] [INFO] Booting worker with pid: 1794 2021-10-04 16:38:27 [1794] [INFO] Booting worker with pid: 1794 2021-10-04 16:38:27 [1795] [INFO] Booting worker with pid: 1795 2021-10-04 16:38:27 [1795] [INFO] Booting worker with pid: 1795 2021-10-04 16:38:31 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:31 +0100] "GET / HTTP/1.1" 200 676 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:31 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:31 +0100] "GET /static/landing.gif HTTP/1.1" 304 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:32 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:32 +0100] "GET /static/favicon.ico HTTP/1.1" 200 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:34 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:34 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:34 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:34 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:35 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:35 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET / HTTP/1.1" 200 676 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /static/landing.gif HTTP/1.1" 304 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:38 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:38 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET / HTTP/1.1" 200 676 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /static/landing.gif HTTP/1.1" 304 0 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:39 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:39 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:46 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:46 +0100] "GET /plotting/jobs HTTP/1.1" 200 16930 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:46 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:46 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:48 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:48 +0100] "GET /plotting/jobs HTTP/1.1" 200 16930 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:48 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:48 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:49 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:49 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:49 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:49 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:49 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:49 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:50 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:50 +0100] "GET /wallet HTTP/1.1" 200 11579 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:50 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:50 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/wallet" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /plotting/jobs HTTP/1.1" 200 16930 "http://192.168.1.9:8926/wallet" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:52 [1794] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:38:52 [1794] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/plotting/jobs" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:38:52 [1795] [INFO] 192.168.1.120 - - [04/Oct/2021:16:38:52 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:45:28 [2271] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:45:28 [2271] [INFO] Starting gunicorn 20.1.0 2021-10-04 16:45:28 [2271] [INFO] Listening at: http://0.0.0.0:8926 (2271) 2021-10-04 16:45:28 [2271] [INFO] Listening at: http://0.0.0.0:8926 (2271) 2021-10-04 16:45:28 [2271] [INFO] Using worker: sync 2021-10-04 16:45:28 [2271] [INFO] Using worker: sync 2021-10-04 16:45:28 [2274] [INFO] Booting worker with pid: 2274 2021-10-04 16:45:28 [2274] [INFO] Booting worker with pid: 2274 2021-10-04 16:45:28 [2275] [INFO] Booting worker with pid: 2275 2021-10-04 16:45:28 [2275] [INFO] Booting worker with pid: 2275 2021-10-04 16:45:44 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:45:44 +0100] "GET /index HTTP/1.1" 302 228 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:45:44 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:45:44 +0100] "GET /controller HTTP/1.1" 200 1509 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:45:44 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:45:44 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:16 [2275] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:16 [2275] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:16 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:16 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:16 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:16 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:24 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:24 +0100] "GET /index HTTP/1.1" 302 228 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:24 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:24 +0100] "GET /controller HTTP/1.1" 200 1509 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:24 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:24 +0100] "GET /static/hierarchy.png HTTP/1.1" 304 0 "http://192.168.1.9:8926/controller" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:28 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:28 +0100] "GET /farming/workers HTTP/1.1" 200 10594 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:28 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:28 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/workers" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:29 [2274] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:29 [2274] [INFO] Unable to find a worker with hostname 'Tower' 2021-10-04 16:50:29 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:29 +0100] "GET /farming/plots HTTP/1.1" 200 485681 "http://192.168.1.9:8926/farming/workers" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:50:29 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:50:29 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:51:16 [2275] [INFO] 192.168.1.120 - - [04/Oct/2021:16:51:16 +0100] "GET /farming/workers HTTP/1.1" 200 10594 "http://192.168.1.9:8926/farming/plots" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" 2021-10-04 16:51:16 [2274] [INFO] 192.168.1.120 - - [04/Oct/2021:16:51:16 +0100] "GET /static/styles.css HTTP/1.1" 304 0 "http://192.168.1.9:8926/farming/workers" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36" aspisrv.log end extract (lots of errors) 2021-10-04 16:47:32 [2269] [INFO] Running job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:47:32 BST)" (scheduled at 2021-10-04 16:47:32.963308+01:00) 2021-10-04 16:47:34 [2269] [INFO] Running job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:47:34 BST)" (scheduled at 2021-10-04 16:47:34.842159+01:00) 2021-10-04 16:47:36 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:36 +0100] "POST /challenges/ HTTP/1.1" 201 7746 "-" "python-requests/2.26.0" 2021-10-04 16:47:36 [2269] [INFO] Job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:49:57 BST)" executed successfully 2021-10-04 16:47:38 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:47:38 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:47:38 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:38 +0100] "POST /workers/ HTTP/1.1" 500 46 "-" "python-requests/2.26.0" 2021-10-04 16:47:38 [2269] [INFO] Job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:20 BST)" executed successfully 2021-10-04 16:47:45 [2269] [INFO] Running job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:18 BST)" (scheduled at 2021-10-04 16:47:45.487320+01:00) 2021-10-04 16:47:46 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:46 +0100] "DELETE /plottings/Tower HTTP/1.1" 204 0 "-" "python-requests/2.26.0" 2021-10-04 16:47:46 [2269] [INFO] Job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:18 BST)" executed successfully 2021-10-04 16:47:59 [2269] [INFO] Running job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:50 BST)" (scheduled at 2021-10-04 16:47:59.600139+01:00) 2021-10-04 16:47:59 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:47:59 +0100] "POST /alerts/ HTTP/1.1" 201 4130 "-" "python-requests/2.26.0" 2021-10-04 16:47:59 [2269] [INFO] Job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:50:50 BST)" executed successfully 2021-10-04 16:49:57 [2269] [INFO] Running job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:20 BST)" (scheduled at 2021-10-04 16:49:57.412934+01:00) 2021-10-04 16:49:57 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:49:57 +0100] "POST /challenges/ HTTP/1.1" 201 7504 "-" "python-requests/2.26.0" 2021-10-04 16:49:57 [2269] [INFO] Job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:20 BST)" executed successfully 2021-10-04 16:50:00 [2269] [INFO] Running job "stats_disk (trigger: cron[minute='*/10'], next run at: 2021-10-04 17:00:00 BST)" (scheduled at 2021-10-04 16:50:00+01:00) 2021-10-04 16:50:00 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:00 +0100] "POST /stats/plottingdiskused/ HTTP/1.1" 201 12621 "-" "python-requests/2.26.0" 2021-10-04 16:50:00 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:00 +0100] "POST /stats/plottingdiskfree/ HTTP/1.1" 201 12907 "-" "python-requests/2.26.0" 2021-10-04 16:50:00 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:00 +0100] "POST /stats/plotsdiskused/ HTTP/1.1" 201 12764 "-" "python-requests/2.26.0" 2021-10-04 16:50:01 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:01 +0100] "POST /stats/plotsdiskfree/ HTTP/1.1" 201 12621 "-" "python-requests/2.26.0" 2021-10-04 16:50:01 [2269] [INFO] Job "stats_disk (trigger: cron[minute='*/10'], next run at: 2021-10-04 17:00:00 BST)" executed successfully 2021-10-04 16:50:18 [2269] [INFO] Running job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:12 BST)" (scheduled at 2021-10-04 16:50:18.548802+01:00) 2021-10-04 16:50:19 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:19 +0100] "DELETE /plottings/Tower HTTP/1.1" 204 0 "-" "python-requests/2.26.0" 2021-10-04 16:50:19 [2269] [INFO] Job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:12 BST)" executed successfully 2021-10-04 16:50:20 [2269] [INFO] Running job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:53 BST)" (scheduled at 2021-10-04 16:50:20.887799+01:00) 2021-10-04 16:50:24 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:50:24 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:50:24 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:50:24 +0100] "POST /workers/ HTTP/1.1" 500 46 "-" "python-requests/2.26.0" 2021-10-04 16:50:24 [2269] [INFO] Job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:52:53 BST)" executed successfully 2021-10-04 16:50:50 [2269] [INFO] Running job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:24 BST)" (scheduled at 2021-10-04 16:50:50.404164+01:00) 2021-10-04 16:50:50 [2269] [INFO] Job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:53:24 BST)" executed successfully 2021-10-04 16:52:20 [2269] [INFO] Running job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:54:39 BST)" (scheduled at 2021-10-04 16:52:20.163428+01:00) 2021-10-04 16:52:20 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:52:20 +0100] "POST /challenges/ HTTP/1.1" 201 7262 "-" "python-requests/2.26.0" 2021-10-04 16:52:20 [2269] [INFO] Job "challenges (trigger: interval[0:02:00], next run at: 2021-10-04 16:54:39 BST)" executed successfully 2021-10-04 16:52:53 [2269] [INFO] Running job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:50 BST)" (scheduled at 2021-10-04 16:52:53.421711+01:00) 2021-10-04 16:52:56 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:52:56 [2306] [ERROR] Exception on /workers/ [POST] Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: NOT NULL constraint failed: workers.port The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 83, in view return self.dispatch_request(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask/views.py", line 157, in dispatch_request return meth(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/etag.py", line 106, in wrapper resp = func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/webargs/core.py", line 450, in wrapper return func(*args, **kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/arguments.py", line 77, in wrapper return func(*f_args, **f_kwargs) File "/chia-blockchain/venv/lib/python3.9/site-packages/flask_smorest/response.py", line 73, in wrapper func(*args, **kwargs)) File "/machinaris/api/views/workers/resources.py", line 49, in post db.session.commit() File "<string>", line 2, in commit File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit self._transaction.commit(_to_root=self.future) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3339, in flush self._flush(objects) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush transaction.rollback(_capture_exception=True) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush flush_context.execute() File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj _emit_insert_statements( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements c = connection._execute_20( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1478, in _execute_clauseelement ret = self._execute_context( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context self._handle_dbapi_exception( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2023, in _handle_dbapi_exception util.raise_( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1799, in _execute_context self.dialect.do_execute( File "/chia-blockchain/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: workers.port [SQL: INSERT INTO workers (hostname, displayname, mode, services, url, config, latest_ping_result, ping_success_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('Tower', 'Tower', 'fullnode', '{"plotman_status": "stopped", "archiver_status": "disabled", "chia_farm_status": "Farming", "chiadog_status": "running", "flax_farm_status": "Farming", "flaxdog_status": "running"}', 'http://Tower:8927', '{"plotting_enabled": true, "archiving_enabled": false, "farming_enabled": true, "harvesting_enabled": true, "flax_enabled": true, "now": "2021-10-04 ... (138 characters truncated) ... _version": "1.2.9", "flax_version": "0.1.2", "flaxdog_version": "0.6.0", "madmax_version": "a9f35cd", "bladebit_version": "", "is_controller": false}', None, None, None)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2021-10-04 16:52:56 [2306] [INFO] 192.168.1.9 - - [04/Oct/2021:16:52:56 +0100] "POST /workers/ HTTP/1.1" 500 46 "-" "python-requests/2.26.0" 2021-10-04 16:52:56 [2269] [INFO] Job "workers (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:50 BST)" executed successfully 2021-10-04 16:53:12 [2269] [INFO] Running job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:42 BST)" (scheduled at 2021-10-04 16:53:12.467739+01:00) 2021-10-04 16:53:13 [2307] [INFO] 192.168.1.9 - - [04/Oct/2021:16:53:13 +0100] "DELETE /plottings/Tower HTTP/1.1" 204 0 "-" "python-requests/2.26.0" 2021-10-04 16:53:13 [2269] [INFO] Job "plottings (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:42 BST)" executed successfully 2021-10-04 16:53:24 [2269] [INFO] Running job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:41 BST)" (scheduled at 2021-10-04 16:53:24.591082+01:00) 2021-10-04 16:53:24 [2269] [INFO] Job "alerts (trigger: interval[0:02:00], next run at: 2021-10-04 16:55:41 BST)" executed successfully Quote Link to comment
guy.davis Posted October 5, 2021 Author Share Posted October 5, 2021 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 !) 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: 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. Quote Link to comment
Ystebad Posted October 6, 2021 Share Posted October 6, 2021 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? Quote Link to comment
Ystebad Posted October 6, 2021 Share Posted October 6, 2021 (edited) Edited October 6, 2021 by Ystebad Quote Link to comment
guy.davis Posted October 6, 2021 Author Share Posted October 6, 2021 3 hours ago, Ystebad said: 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. 1 Quote Link to comment
Ystebad Posted October 8, 2021 Share Posted October 8, 2021 (edited) 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. Edited October 8, 2021 by Ystebad Quote Link to comment
guy.davis Posted October 8, 2021 Author Share Posted October 8, 2021 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. 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! 1 Quote Link to comment
Recommended Posts
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.