Hi, it is understood that the offload file limit is 10GB by default (i.e.: when either Cassandra or Elastic is offline data is pushed to offload sqlite files in c:/Skyline DataMiner/Offload folder).
Can I ask for further clarification that this 10GB limit is enforced at the folder level? (i.e.: if the total size of the folder is 10GB, then the offload mechanism will stop storing further data in sqlite files and data-loss is expected).
This reason behind this question is to help define customer acceptance/validation testing.
Hi Bing,
The size of 10GB is enforced on the SQLite database level, we calculate the actual amount of data stored in the database file(s) and stop writing if the configured threshold is passed. In the offload folder there are also transaction log files, these are not taken into account, it's purely the actual data in the database file(s).
To be more specific, we launch the following queries towards the sqlite database file(s) and sum the result for comparison:
SELECT page_count * page_size as size FROM pragma_page_count(), pragma_page_size();