I have a strange problem that I’m hoping people way smarter than I have either run into or figured out.
I have several websites running under Lucee/Tomcat and IIS. I’ve stored all the data the websites use in a database (lets say it’s called “storage”) with my Client Variables stored in a separate database (Client Variables cf_client_data) with both in MS SQL Server. All the websites work just fine with no visibly apparent issues.
The problem started when I realized there were an absolutely insane amount of entries in my cf_client_data database and I didn’t understand how that could be since we didn’t have that much traffic. After MUCH exploration, I realized that if I deleted all of the records in cf_client_data, they would still be created even if I removed all of the directories to the websites so it was impossible for anyone to be on them and logging in or accessing any data.
With no website directories able to be hit, the database was still showing the creation of hundreds of client variables in the database per minute. I’m at a loss since I cannot figure out what is generating them.
The entries in cf_client_data ‘name’ includes the name of the active database that the website uses. Can anyone explain to me how Client Variables can be created in a database when no one is hitting any websites associated with databases I’m using? I would like to bring this down to reasonable levels without feeling that Skynet is somehow going to take over everything by magically replicating millions of Client Variables with seemingly no reason.
To sum up:
- Lucee/Tomcat is running
- IIS is running
- SQL server is running with databases “storage” and “client variables cf_client_data” active.
- Website directories have been removed so no one can hit them.
- Client Variables are being created in “client variables cf_client_data” by the hundreds per minute.
If the first question can be solved, how does Lucee purge old Client Variables? In Coldfusion, there was an option to automatically purge unused Client Variables at a set interval. If Lucee doesn’t do this automatically, are there any code examples of how to do it?
Version: Lucee 126.96.36.199
Servlet Container: Apache Tomcat/8.5.33
Windows Server 2016 Datacenter
MS SQL Server
I hope I have explained this strange behavior well enough and thank you everyone for taking the time to read this.