When looking at the following page, are you seeing anything out of the ordinary that might look like a rogue query?
Status > Databases
Click the Details button for the DB in question
Also, are there any errors in your database logs?
The data in the cache is stored on the Gateway in the data/datacache directory in a folder named after the database connection you created. This folder doesn’t go away when you delete the DB, and the information contained in it would return if you created a connection of the same name. This is intentional as we don’t want you to lose that data accidently.
If you really need to clear the cache (as well as any of the data that was included in it, i.e. do so at your own risk), you would want to shut Ignition down and rename the DB folder to be something different. On startup a new folder will be created and Store & Forward will start using that folder structure and the cache will be cleared.
If the cache isn’t being cleared though, there is likely a separate cause that you should spend the time to identify. Looking at the logs and queries being run should help identify where an issue might exist.
Thanks,
Garth