1 Reply Latest reply: Mar 22, 2013 5:49 AM by Jspalmer-Oracle RSS

    TimesTen 11.2 version : native error 778

    821789
      Hello,

      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 11.2.1.9.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]
      LOCKS=TimesTen Driver

      [ODBC]
      Trace=0
      TraceFile=
      Installdir=/opt/TimesTen/64

      [LOCKS]
      Isolation=1
      Driver=/opt/TimesTen/64/lib/libtten.so
      DataStore=/tmp/TTDataStoreLocks.stor
      AutoCreate=1
      #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.
      OverWrite=0
      DurableCommits=0
      Logging=1
      LogPurge=1
      LockLevel=1
      #Increasing the log file size to allow more than a client. else it was failing with an error. 64 is default.
      LogFileSize=100
      #LogBufSize is replaced by LogBufMB and the default value of LogBufMB is 64MB
      LogBufMB=1000
      PermSize=80
      TempSize=55
      PermWarnThreshold=80
      TempWarnThreshold=80
      Temporary=1
      WaitForConnect=1
      ExclAccess=0
      ThreadSafe=1
      SMPOptLevel = 0
      Preallocate=0
      MemoryLock=4
      LogDir=/tmp/logs

      1. Can some one please point out what's going wrong?
      2. Is there a way to calculate LogBufMB and LogFileSzie?

      Thanks.
      Priya