SQL statements return error 8448 with java.lang.OutOfMemoryError

Bug #1378926 reported by Weishiun Tsai
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Released
Critical
Selvaganesan Govindarajan

Bug Description

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

Tags: sql-exe
summary: - SQL statement returns error 8448 with java.lang.OutOfMemoryError
+ SQL statements return error 8448 with java.lang.OutOfMemoryError
Changed in trafodion:
assignee: nobody → Selvaganesan Govindarajan (selva-ganesan)
status: New → In Progress
Revision history for this message
Weishiun Tsai (wei-shiun-tsai) wrote :

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.

Changed in trafodion:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.