We are trying to integrate 64-bit 11.2.1_9 TimesTen. and we are getting the following error when performing UPDATE ....................... WHERE ROWID=? operation.
execute on 'SQLExecute(Select then Update: Update)
state=S1000 msg=[TimesTen][TimesTen 126.96.36.199.0 ODBC Driver][TimesTen]TT0778: Log write failed because filesystem is full -- file "logmgr.c", lineno 6873, procedure "sbLogRecInsert" native=778
following is the content of .odbc.ini:
[ODBC Data Sources]
#Making overwrite to 1because of the following reason
#Specifies that the existing database should be overwritten with a new one when a connection is attempted.
#Increasing the log file size to allow more than a client. else it was failing with an error. 64 is default.
#LogBufSize is replaced by LogBufMB and the default value of LogBufMB is 64MB
SMPOptLevel = 0
1. Can some one please point out what's going wrong?
2. Is there a way to calculate LogBufMB and LogFileSzie?
You store your transaction log files in LogDir=/tmp/logs
The error "TT0778: Log write failed because filesystem is full " indicates there is no more space on the disk on which /tmp/logs is created.
This is a Temporary datastore but it will still have transaction log files.