SQL statements return error 8448 with java.lang.OutOfMemoryError

[Weishiun Tsai]

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

[Weishiun Tsai (wei-shiun-tsai)]

Verified on the v1011_0917 build. This problem is no longer seen on the build. QA is able to run the full set of regression tests without running into this problem on this build.