Hi guys
Tonight in our production TimesTen we found the PERM_IN_USE% has reached to 97%, I then executed the ttComputeTabSizes and somehow invalidated the DB at the end. We have restarted it now.
Could you please adivce what is going on with it? Thank you in advance!
Command> select TABLE_NAME ,TOTAL_BYTES/1024/1024 "BYTES M" from USER_TAB_SIZES order by 2 desc;
0 rows found.
Command> dssize;
The following values are in KB:
PERM_ALLOCATED_SIZE: 77824000
PERM_IN_USE_SIZE: 75106779
PERM_IN_USE_HIGH_WATER: 77659561
TEMP_ALLOCATED_SIZE: 12288000
TEMP_IN_USE_SIZE: 356179
TEMP_IN_USE_HIGH_WATER: 1870411
Command> call ttComputeTabSizes();
994: Data store connection terminated. Please reconnect.
4053: Internal error: Assertion failed: (((sbHBHdr_p) hdr)->sane == ((sbHBSane_t) 0xB0)) [size.c:/main/22:tblSizeOutOfLineBytesForPtn:1356] PID 17805 (ttIsqlCmd) CONN 8 (tt_1122) 2015-08-31 20:48:53.039
The command failed.
disconnect tt_1122;
Disconnecting...
Command> dssize;
An existing connection is required to execute this command.
Try executing "connect [connection_string];" first.
The command failed.
-----
tterrors.log
20:52:34.23 Err : : 15139: TT14005: TimesTen daemon connection failed: Connect attempt by 15357 while invalidation in progress [has_panicked set]
20:52:34.23 Err : : 15139: TT14005: TimesTen daemon connection failed: Connect attempt by 15357 while invalidation in progress [has_panicked set]
20:52:34.24 Err : : 15139: TT14005: TimesTen daemon connection failed: Connect attempt by 15357 while invalidation in progress [has_panicked set]
20:52:34.24 Err : : 15139: TT14005: TimesTen daemon connection failed: Connect attempt by 15357 while invalidation in progress [has_panicked set]
20:52:34.24 Err : : 15139: TT14005: TimesTen daemon connection failed: Connect attempt by 15357 while invalidation in progress [has_panicked set]
20:52:34.24 Err : : 15139: TT14005: TimesTen daemon connection failed: Connect attempt by 15357 while invalidation in progress [has_panicked set]
20:52:34.24 Err : : 15139: TT14005: TimesTen daemon connection failed: Connect attempt by 15357 while invalidation in progress [has_panicked set]
[root@zhengcetoufang124 ~]# free -m
total used free shared buffers cached
Mem: 129050 73802 55247 12470 85 48039
-/+ buffers/cache: 25677 103373
Swap: 9999 16 9983
[ODBC Data Sources]
TT_1122=TimesTen 11.2.2 Driver
[TT_1122]
Driver=/opt/TimesTen/tt1122/lib/libtten.so
DataStore=/opt/TimesTen/tt1122/info/TT_1122
DatabaseCharacterSet=ZHS16GBK
ConnectionCharacterSet=ZHS16GBK
PermSize=76000
TempSize=12000
OracleNetServiceName=vedb
LogFileSize=2048
LogBufMB=2048
LockWait=30
RecoveryThreads=8
LogBufParallelism=8
PrivateCommands=1
ReplicationApplyOrdering=1
ReplicationParallelism=4
ReplicationTrack=4
RangeIndexType=0
Connections=1000
Regards
Li