TallMan206

Done. Everything is out of the GO file and into user scripts. Thanks.

Hi, where should I put them then? I do not want multiple settings in multiple files over my systems where in 3 months I don't know where I changed what. Therefore I did this in ONE file, the GO file. Please, advice me, if you have a better option. Thanks!

Hi @trurl stock go file does indeed help to bring it back to under 2 seconds! The strange thing is, the Go file on my backupserver Epic-Bravo, is the same, except for the starting of the dockers, and the ZFS settings. Epic-Bravo IS quick, so I am very curious what settings cause Epic-Alpha to be slow.

Before I do that, I would love to understand your thoughts why a stock go file would make a difference? No to challenge, but to understand where your thoughts come from?

I have a Dell R720 (main server (Epic-Alpha) and my backupserver is a Supermicro with a X9SCL/X9SCM motherboard. I've added both diagnostics, so they can be compared. epic-alpha-diagnostics-20260401-1628.zip epic-bravo-diagnostics-20260401-1442.zip

I have removed all plugins that could cause the GUI to be slow, but with the dockers that I am running I'm at 7 seconds load, on my Mainserver, and with the same configuration (but without dockers) my backupserver loads in lower than 1 second. What is docker doing that it causes the GUI to be so slow?

How come my Spotweb looks like this now?

EDIT Solved: Issue : version : 9.5.0 edition : MySQL Community Server - GPL log_bin : 1 ← binary log ON binlog_format: ROW gtid_mode : ON ← GTID ON enforce_gtid_consistency: ON So your MySQL is strict GTID + binlog = ON, which does not like what Spotweb’s retrieve code is doing, and that’s why it keep getting: Statement violates GTID consistency: Updates to non-transactional tables... This MySQL config itself will keep breaking Spotweb. I've created a file zz-spotweb-gtid.cnf chmod 644 with the following lines: log_bin=0 skip_log_bin=1 gtid_mode=OFF enforce_gtid_consistency=OFF In UnRAID: Go to Docker → click on mysql-spotweb → Edit. Add a new Path mapping: Host path: /mnt/user/appdata/mysql-spotweb/zz-spotweb-gtid.cnf Container path: /etc/mysql/conf.d/zz-spotweb-gtid.cnf Access mode: Read-only and restart the mysql docker. What is causing my Spotweb to crash with this error? It this related to the mysql DB? SpotWeb v0.68.38.34 on PHP v8.3.27 crashed Fatal error occured during retrieve: HY000: 1785: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables. #0 /var/www/spotweb/lib/dbeng/dbeng_pdo.php(86): dbeng_pdo->exec() #1 /var/www/spotweb/lib/dao/Mysql/Dao_Mysql_Spot.php(51): dbeng_pdo->modify() #2 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(656): Dao_Mysql_Spot->removeSpots() #3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(239): Services_Retriever_Spots->process() #4 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(340): Services_Retriever_Base->loopTillEnd() #5 /var/www/spotweb/retrieve.php(142): Services_Retriever_Base->perform() #6 {main} Finished retrieving spots.

EDIT Solved: Issue : version : 9.5.0 edition : MySQL Community Server - GPL log_bin : 1 ← binary log ON binlog_format: ROW gtid_mode : ON ← GTID ON enforce_gtid_consistency: ON So your MySQL is strict GTID + binlog = ON, which does not like what Spotweb’s retrieve code is doing, and that’s why it keep getting: Statement violates GTID consistency: Updates to non-transactional tables... This MySQL config itself will keep breaking Spotweb. I've created a file zz-spotweb-gtid.cnf chmod 644 with the following lines: log_bin=0 skip_log_bin=1 gtid_mode=OFF enforce_gtid_consistency=OFF In UnRAID: Go to Docker → click on mysql-spotweb → Edit. Add a new Path mapping: Host path: /mnt/user/appdata/mysql-spotweb/zz-spotweb-gtid.cnf Container path: /etc/mysql/conf.d/zz-spotweb-gtid.cnf Access mode: Read-only and restart the mysql docker. What is causing this crash? SpotWeb v0.68.38.34 on PHP v8.3.27 crashed Fatal error occured during retrieve: HY000: 1785: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables. #0 /var/www/spotweb/lib/dbeng/dbeng_pdo.php(86): dbeng_pdo->exec() #1 /var/www/spotweb/lib/dao/Mysql/Dao_Mysql_Spot.php(51): dbeng_pdo->modify() #2 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(656): Dao_Mysql_Spot->removeSpots() #3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(239): Services_Retriever_Spots->process() #4 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(340): Services_Retriever_Base->loopTillEnd() #5 /var/www/spotweb/retrieve.php(142): Services_Retriever_Base->perform() #6 {main} Finished retrieving spots.

Clearly, the Unassigned Devices plugin, especially the Preclear, and the settings of the plugin, caused a lot of polling, making the GUI slow. Also, the IPMI plugin for my Dell R720, polling for temps and fan speeds, adds up to this slowness of the GUI. Removing Preclear (I don't need it at the moment), and changing some settings in the Unassigned Devices plugin made the GUI quicker to a bearable level.

Same plugins like before. Never had a problem. It's the last couple of weeks, after updating to 7.2 that it is slow. You can see my main and backupserver next to each other. Where my main takes 4-5 seconds, the backupserver take less then a second. 2025-11-06 22-48-30.mp4

That was in safe mode. This video is in normal mode. My backupserver is less powerful, and has the same plugins (no docker) and does NOT have this issue. 2025-11-06 13-55-57.mp4

The strangest thing is, my Backupserver has the same config, but is not running docker. That GUI is blazing fast

Hi JorgeB, It's still slower than before, think around 1 second instead of 4 2025-11-06 12-07-40.mp4

Hi, Are you able to help me to find the reason my GUI is so slow? Switching between pages on Unraid for example from Dashboard to Main can take up to 5 seconds. I didn't have this problem before. Thanks unraid-diagnostics-20251106-1149.zip