File system Max size

Question

Question

Rochdi Badis · Jan 16, 2023

Hi Guys,

we are having a problem with the Cache.dat file is not expanding anymore since it has reached 2.2TB, we still have extra 260Gb of free disk space in our drive but for some reason it's raising a FILEFULL which is a result or the database not able to expand.

our server is Amazon could hosted with NVMe drive type (with win server 2016) so shouldn't be a hardware issue as I ran a disk check, so I'm starting to think that maybe that the system might have a Max file size set it that doesn't allow a single file to grow more than 2TB, so how can we the Max file size that can grow up to and is there a tool that could help in this situation to monitor why the database is not expanding ?

Thanks

Product version: Ensemble 2014.1

Discussion (4)2

Log in or sign up to continue

score 0 · Answer 1 · 2023-01-19T09:21:47-05:00

Rochdi,
2.2TB is within the limits I could find for the NTFS file size limits and partition size limits. Caché can grow a CACHE.DAT file to 32TB before reaching its software limit.

From what you've shared, I have a few ideas:

The NTFS partition is limited in size, causing the <FILEFULL>.

There is some Windows policy that is limiting the maximum file size to less than what NTFS allows.

You've encountered an incompatibility between Ensemble 2014.1 and Windows Server 2016 (which is not a supported platform for this version according to documentation -- it's too new).

Your best bet is probably contacting WRC for help in sorting this situation out.

score 0 · Answer 2 · 2023-01-19T09:46:19-05:00

Definitely reach out to the WRC - another "educated" guess from me on potential causes would be filesystem fragmentation. I've seen that cause databases to fail to expand in the past.

score 0 · Answer 3 · 2023-01-23T11:50:22-05:00

Alexander Pettitt · Jan 23, 2023

There are five expansions in less than a single second. Maybe you ran into a race condition.

0 0

score 0 · Answer 4 · 2023-01-27T08:07:07-05:00

Alexander is observant. There are five expansions, but these look like retries, because the size completed doesn't change. Expansion is stuck for some reason. The WRC might be able to find out more from ^SYSLOG if this is continuing to occur.