I have created some query tags with simple SELECT queries and FLOAT datatype. I have selected FIXED execution mode with a rate of 1 second. The problem is that these tags are not executing at all. I have double checked my queries in the query browser and they run perfectly find and within milliseconds. My deadband is set to zero in tag properties. I have checked and verified everything that I can think of but I just cannot get these tags to execute their queries at the defined rate. They are ONLY executing when the tags are restarted.
What version of Ignition are you using? There was a regression in 8.1.20 that could cause DB tags to not execute... if it's not that then you may need to call support and let them take a look.