Hi,
I have a problem with an application connecting to a TimesTen database, but the connection is being terminated by the server and I cannot work out why (the error seems internal)
In summary, the application reads blocks of data from one schema, performs some processing, then writes output to a separate schema. When the read operation is simple (reading from one table only), it runs without error. When the read operation becomes more complex (reading from sub-tables using an IN clause, the JDBC connection reports that the connection has been broken as the server exited unexpectedly.
The tterrors.log file contains the following error information:
16:40:35.11 Warn: : 26246: TimesTen Daemon Release 11.2.2.4.1.opadev started.
16:53:17.79 Err : SRV: 26345: EventID=5| Socket recv() failed. Error (104): Connection reset by peer. File: /ade/vespa_20121029_kaiser-tt_29086/timesten/VisiChannel/oc/src/vostcpip.cpp; Line: 668
16:53:17.79 Err : SRV: 26331: EventID=5| Socket recv() failed. Error (104): Connection reset by peer. File: /ade/vespa_20121029_kaiser-tt_29086/timesten/VisiChannel/oc/src/vostcpip.cpp; Line: 668
16:53:17.79 Err : SRV: 26345: EventID=68| Failed to read request from client. Closing connection without reply.
16:53:17.79 Err : SRV: 26331: EventID=68| Failed to read request from client. Closing connection without reply.
16:53:20.37 Err : SRV: 26410: EventID=3| Socket send() failed. Error (104): Connection reset by peer. File: /ade/vespa_20121029_kaiser-tt_29086/timesten/VisiChannel/oc/src/vostcpip.cpp; Line: 762
16:57:31.39 Err : : 26246: 26483/0x82ca90: Assertion failed: sbPtIsCharConst(maxExp) [genTree.c:/main/155:genOrderInList():4555] PID 26483 (ttcserver) CONN 1 (javaw) 2014-02-05 16:57:31.396
16:57:31.39 Err : : 26246: 26483/0x82ca90: Assert SQL='SELECT HOUSEHOLD_MEMBER_ID,HOUSEHOLD_ID,AGE FROM UK_DATA_HOUSEHOLD_MEMBER WHERE HOUSEHOLD_ID IN ('3', '2', '10', '1', '7', '6', '5', '4', '9', '8') '
16:57:31.39 Err : : 26246: 26483/0x82ca90: Data store marked invalid [genTree.c:/main/155:genOrderInList():4555] PID 26483 (ttcserver) CONN 1 (javaw) Context 0x82ca90
16:57:31.71 Err : : 26246: 26250/0x7fe3b00009e0: IndexGC could not start a transaction
16:57:31.71 Warn: : 26246: 26250/0xec53a0: Forced Disconnect /var/TimesTen/opadev/opadev_db
16:57:31.71 Warn: : 26246: 26250/0x7fe3b00009e0: Forced Disconnect /var/TimesTen/opadev/opadev_db
16:57:31.71 Warn: : 26246: 26250 ----------: Disconnecting from an old instance
16:57:31.71 Err : : 26250: subd: IndexGC thread terminated with error
16:57:31.71 Warn: : 26246: 26483 exited while connected to data store '/var/TimesTen/opadev/opadev_db' shm 1509982213 count=1
16:57:33.58 Err : : 26246: TT14000: TimesTen daemon internal error: Could not connect to subdaemon port 9327 [stopManaging - err 799 (Protocol error trying to talk to daemon at port 9327)]
16:57:33.58 Err : : 26246: TT14012: TimesTen daemon subdaemon failed: Error 791 unmanaging, invalidating
16:57:33.58 Warn: : 26246: 26250 ------------------: subdaemon process exited
16:57:33.58 Warn: : 26246: 26250 exited while connected to data store '/var/TimesTen/opadev/opadev_db' shm 1509982213 count=9
16:57:33.58 Warn: : 26246: daRecovery: subdaemon 26250, managing data store, failed: invalidate (failcode=202)
To me, this looks like an internal error in TimesTen.
Any ideas what is going on (running out of memory maybe)?
How do I raise this as an SR or search through the existing SR and bug reports for TimesTen?
Thanks,
Ben