1 Reply Latest reply: Oct 18, 2012 8:20 AM by Jspalmer-Oracle RSS

    11.2.2.4.0 - Problem with temporary space in simple query

    598001
      ttVersion
      TimesTen Release 11.2.2.4.0 (64 bit Linux/x86_64) (timesten:53396) 2012-09-24T08:28:05Z
      Instance admin: root
      Instance home directory: /opt/TimesTen/timesten
      World accessible
      Daemon home directory: /var/TimesTen/timesten

      I get "TT0802: Database temporary space exhausted" error in simple query with small data amount; Timesten try to allocate *40000312* bytes

      describe adm.peer
      Table ADM.PEER:
      Name Null Type
      -----
      PEER_ID NOT NULL TT_SMALLINT
      CLUSTER_ID NOT NULL TT_TINYINT
      DIALECT NOT NULL TT_INTEGER
      HOST NOT NULL TT_VARCHAR(256 BYTE)
      REALM NOT NULL TT_VARCHAR(256 BYTE)
      ADDRESS TT_VARCHAR(256 BYTE)
      PORT NOT NULL TT_INTEGER
      PROTOCOL NOT NULL TT_INTEGER
      AUTO_CONNECT NOT NULL TT_TINYINT
      ENABLED NOT NULL TT_TINYINT
      PRIORITY NOT NULL TT_TINYINT
      MANDATORY NOT NULL TT_TINYINT
      TSTAMP BINARY(8)

      1 rows selected

      describe adm.session
      Table ADM.SESSION:
      Name Null Type
      -----
      SESSION_ID NOT NULL TT_VARCHAR(64 BYTE) inline
      OBJ_ID NOT NULL TT_BIGINT
      PR_OBJ_ID NOT NULL TT_BIGINT
      SUBSCRIBER_ID NOT NULL TT_VARCHAR(32 BYTE) inline
      IP NOT NULL TT_VARCHAR(15 BYTE) inline
      IPV6_PREFIX TT_VARCHAR(39 BYTE) inline
      IPV6_PREFIX_LEN NOT NULL TT_TINYINT
      CREATE_TIME NOT NULL TT_TIMESTAMP
      UPDATE_TIME NOT NULL TT_TIMESTAMP
      RULES_SET_ID NOT NULL TT_BIGINT
      PEER_ID NOT NULL TT_SMALLINT
      MY_PEER_ID NOT NULL TT_SMALLINT
      PROFILE_HASHC NOT NULL TT_BIGINT
      FLAGS NOT NULL TT_INTEGER
      QOS_POLICY_NAME NOT NULL TT_VARCHAR(32 BYTE) inline
      BSID NOT NULL TT_BIGINT
      CONGESTION_FLAG NOT NULL TT_TINYINT
      SERVICE_CATEGORY_ID TT_VARCHAR(32 BYTE) inline
      EVENT_CAUSE NOT NULL TT_TINYINT
      EVENT_TIME TT_TIMESTAMP
      TSTAMP BINARY(8)

      1 rows selected

      select * from adm.peer;
      PEER_ID CLUSTER_ID DIALECT HOST REALM ADDRESS PORT PROTOCOL AUTO_CONNECT ENABLED PRIORITY MANDATORY TSTAMP
      -----
      21 2 0 ddf1.server.com diameter.realm ddf1.server.com 3868 6 1 1 0 1 (null)
      22 2 0 ddf2.server.com diameter.realm ddf2.server.com 3868 6 1 1 1 1 (null)
      101 233 0 peer_101 testik.com peer_101.testik.com 3886 0 0 1 101 0 (null)
      102 233 0 peer_102 testik.com peer_102.testik.com 3886 0 0 1 102 0 (null)
      1 1 0 vr-t500.testik.com diameter.realm vr-t500.testik.com 3868 6 1 1 0 1 (null)
      5 rows selected

      select * from adm.session;
      SESSION_ID OBJ_ID PR_OBJ_ID SUBSCRIBER_ID IP IPV6_PREFIX IPV6_PREFIX_LEN CREATE_TIME UPDATE_TIME RULES_SET_ID PEER_ID MY_PEER_ID PROFILE_HASHC FLAGS QOS_POLICY_NAME BSID CONGESTION_FLAG SERVICE_CATEGORY_ID EVENT_CAUSE EVENT_TIME TSTAMP
      -----
      TEST_SESSION 13300000000020027 0 TEST_SUBSCRIBER 94.25.209.27 0 2012-10-18 12:56:07.155381000 2012-10-18 12:56:07.155381000 1 101 1 0 0 0 0 DEFAULT 0 (null) (null)
      TEST_SESSION2 13300000000020028 13300000000020027 TEST_SUBSCRIBER 94.25.209.27 0 2012-10-18 12:56:07.155687000 2012-10-18 12:56:07.155687000 1 102 1 0 4 0 0 DEFAULT 0 (null) (null)

      2 rows selected

      SELECT p.address, count(*) as session_count from session s, peer p where p.peer_id = s.peer_id group by p.address failed,
      TT0802: Database temporary space exhausted

      dssize
      PERM_ALLOCATED_SIZE:     307200.0
      PERM_IN_USE_SIZE:     61763.0
      PERM_IN_USE_HIGH_WATER:     69393.0
      TEMP_ALLOCATED_SIZE:     37888.0
      TEMP_IN_USE_SIZE:     13494.0
      TEMP_IN_USE_HIGH_WATER:     21307.0

      This is additional error info when this code exuted inside C code:
      [TimesTen][TimesTen 11.2.2.4.0 ODBC Driver][TimesTen]TT0802: Database temporary space exhausted -- file "blk.c", lineno 3477, procedure "sbBlkAlloc"
      ODBC Error/Warning = S1000, Additional Error/Warning = 802
      [TimesTen][TimesTen 11.2.2.4.0 ODBC Driver][TimesTen]TT6221: Temporary data partition free space insufficient to allocate *40000312* bytes of memory -- file "blk.c", lineno 3477, procedure "sbBlkAlloc"
      ODBC Error/Warning = S1000, Additional Error/Warning = 6221

      Edited by: Vladimir Romanov on 18.10.2012 13:13

      Edited by: Vladimir Romanov on 18.10.2012 13:51