TimesTen 778: Log write failed because file system is full

TimesTen 778: Log write failed because file system is full

A problem I recently encountered in TimesTen.  So we decided to delete 150gb of data and reload some new data but after finishing the reload and trying to create an index we see the following message:

We then investigate the tterrors.log file and we can see the following:

So what’s happened here?, we know we had enough capacity on this server when we started the delete.

What has happened is that when we decided to remove large amounts of data and reload, this information was written into tt_aggr_store transaction log files, waiting to be checkpointed. Once TimesTen has finished check pointing, these files will be removed. But we have a situation here, our filesystem is full and we need to release some space for the checkpoint to finish, if we log into TimesTen and do ttckpthistory we can see the checkpoint is in progress and at 43% by looking at the 2nd column in from the end (on the in progress checkpoint). If after a few minutes you do ttckpthistory again, this number should rise.


To allow this checkpoint to finish you will have to delete any unnecessary log files that may exist or move them to another file-system, and in the future when reloading – maybe load in smaller batches and keep monitoring the transaction logs and checkpoints.