4 Replies Latest reply: May 22, 2014 10:28 AM by Jspalmer-Oracle RSS

    Data store connection terminated by TimesTen Server

    Ben O'Keeffe

      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