01 April 2013

"TT0802: Data store space exhausted" and "TT0778: Log write failed because filesystem is full" errors


A few days ago, we have encounter a timesten error:

[TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT0802: Data store space exhausted -- file "blk.c", lineno 3260, procedure "sbBlkAlloc"
*** ODBC Error/Warning = S1000, TimesTen Error/Warning = 802
[TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT6220: Permanent data partition free space insufficient to allocate 5640 bytes of memory -- file "blk.c", lineno 3260, procedure "sbBlkAlloc"
*** ODBC Error/Warning = S1000, TimesTen Error/Warning = 6220

When we analyze, we see that the PermSize parameter is insufficient for loading database into the memory.  We update the PermSize in the sys.odbc.ini file and restart timesten daemon.(you can read this post for restarting timesten daemon)

sys.odbc.ini
[tt01]
PermSize=51200
….


After fixing this error, we got another error:

[TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT0778: Log write failed because filesystem is full -- file "logmgr.c", lineno
6065, procedure "sbLogRecInsert"
*** ODBC Error/Warning = S1000, TimesTen Error/Warning = 778

This error is because of DataStore path have not enough space as the parameter PermSize.

$ df -k .
/timesten         (/dev/lvtimesten) :  5205785 total allocated Kb
                                                 558788 free allocated Kb
                                                 4646997 used allocated Kb
                                                    90 % allocation used

sys.odbc.ini
[tt01]
..
DataStore=/timesten/TimesTen/tt1121/DataStore/ttds
PermSize=51200

After giving enough disk space to the filesytem, error is gone.
/dev/lvtimesten
                   58490880 4660048 50466552    8% /timesten