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. Solution 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.
Posted in Blog Tagged with: ,

Affiliations

Engagements

  • Oracle OpenWorld 2014
  • Gartner BI Summit 9/3/15-10/3/15
  • UKOUG Business Analytics SIG 12/3/15
  • UKOUG Conference 7/12/15-9/12/15
  • Oracle Ireland Conference 2016 3/3/16-4/3/16
  • UKOUG Systems 2016 12/5/16
  • Oracle OpenWorld 2016
  • POUG 2016 7/10/16
  • DOAG 2016 15/11/16
  • UKOUG 2016 5/12/16

Videos

Posts

  • 2017 (8)
  • 2016 (22)
  • 2015 (22)
  • 2014 (8)
  • 2013 (2)