[jira] [Created] (TRAFODION-685) LP Bug: 1378926 - SQL statements return error 8448 with java.lang.OutOfMemoryError

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-685:
------------------------------------

             Summary: LP Bug: 1378926 - SQL statements return error 8448 with java.lang.OutOfMemoryError
                 Key: TRAFODION-685
                 URL: https://issues.apache.org/jira/browse/TRAFODION-685
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Selvaganesan Govindarajan
            Priority: Blocker


After moving to hbase 0.98, tests constantly run into error 8448 indicating java.lang.OutOfMemoryError: Java heap space.  Here is an example of such error:

SQL>prepare s1 from
Select a_l, d_r
from (
Select a
from p3
where (32 = (d - e))
) T1(a_l)
inner join (
Select b, d
from p4
where ((e - b) = e)
) T2(b_r, d_r)
on ((a_l > (a_l + 7)) OR (a_l > d_r))
order by 1, 2
;
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::init returned error HBASE_ACCESS_ERROR(-705). Cause:
java.lang.OutOfMemoryError: Java heap space
. [2014-10-08 08:03:15]
*** ERROR[4082] Object TRAFODION.FULLOUTERJOINS_TEST_SQL7.P3 does not exist or is inaccessible. [2014-10-08 08:03:15]
*** ERROR[8822] The statement was not prepared. [2014-10-08 08:03:15]

Originally this problem was tracked by another bug report https://bugs.launchpad.net/bugs/1378089 ‘Drop table hangs for more than 8 hours’.  But while a run on the v1007 daily build + trafodion-HBaseAccess-0.9.0.jar UTT did not see the hang problem, it still saw at least 1262 occurrences of the java.lang.OutOfMemoryError.  For now, we are going to track the OutOfMemoryError issue separately with this bug report.

-bash-4.1$ grep OutOfMemoryError */*.log | wc -l
1262



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)