[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16511470#comment-16511470 ]
Sandhya Sundaresan commented on TRAFODION-3107: ----------------------------------------------- Explain plan shows the 16MB columns with 5MB data being selected out : |1. Explain after 50 rows: SQL>Explain select * from JDBC_PERFORMANCE.CLOB_PERFORMANCE; ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... NOT NAMED PLAN_ID .................. 212395526813421710 ROWS_OUT ............... 100 EST_TOTAL_COST ........... 0.18 STATEMENT ................ select * from JDBC_PERFORMANCE.CLOB_PERFORMANCE; ------------------------------------------------------------------ NODE LISTING ROOT ====================================== SEQ_NO 2 ONLY CHILD 1 REQUESTS_IN .............. 1 ROWS_OUT ............... 100 EST_OPER_COST ............ 0 EST_TOTAL_COST ........... 0.18 DESCRIPTION est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB max_card_est ......... 100 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master record_length 16,777,226 affinity_value ......... 0 max_max_cardinality 100 xn_access_mode ......... read_only xn_autoabort_interval 0 auto_query_retry ....... enabled plan_version ....... 2,600 embedded_arkcmp ........ used ObjectUIDs ............. 1283125847997263334 select_list ............ TRAFODION.JDBC_PERFORMANCE.CLOB_PERFORMANCE.ID, TRAFODION.JDBC_PERFORMANCE.CLOB_PERFORMANCE.LOB_CO LUMN TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN TABLE_NAME ............... CLOB_PERFORMANCE REQUESTS_IN .............. 1 ROWS_OUT ............... 100 EST_OPER_COST ............ 0.18 EST_TOTAL_COST ........... 0.18 DESCRIPTION max_card_est ......... 100 fragment_id ............ 0 parent_frag ............ (none) fragment_type .......... master record_length 16,777,226 scan_type .............. subset scan of table TRAFODION.JDBC_PERFORMANCE.CLOB _PERFORMANCE object_type ............ Trafodion columns ................ all begin_keys(incl) end_keys(incl) cache_size ........... 100 cache_blocks ........... OFF probes ................. 1 rows_accessed ........ 100 column_retrieved ....... #1:1 key_columns ............ ID --- SQL operation complete.| > selct count(0) with long varchar hitting jvm OOM error > -------------------------------------------------------- > > Key: TRAFODION-3107 > URL: https://issues.apache.org/jira/browse/TRAFODION-3107 > Project: Apache Trafodion > Issue Type: Bug > Reporter: Sandhya Sundaresan > Assignee: Sandhya Sundaresan > Priority: Major > Fix For: 2.3 > > > selct count(0) hitting jvm OOM error when clob as varchar and insert some 5MB > images. > org.trafodion.jdbc.t4.TrafT4Exception: *** ERROR[8448] Unable to access Hbase > interface. Call to ExpHbaseInterface::nextRow returned error > HBASE_ACCESS_ERROR(-706). Cause: java.util.concurrent.ExecutionException: > org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after > attempts=3, exceptions: > Tue Jun 05 10:53:33 CST 2018, > RpcRetryingCaller\{globalStartTime=1528167213257, pause=100, retries=3}, > java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space > Tue Jun 05 10:53:34 CST 2018, > RpcRetryingCaller\{globalStartTime=1528167213257, pause=100, retries=3}, > java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space > Tue Jun 05 10:53:34 CST 2018, > RpcRetryingCaller\{globalStartTime=1528167213257, pause=100, retries=3}, > java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space > > java.util.concurrent.FutureTask.report(FutureTask.java:122) > java.util.concurrent.FutureTask.get(FutureTask.java:192) > org.trafodion.sql.HTableClient.fetchRows(HTableClient.java:1287) Caused by > org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after > attempts=3, exceptions: > Tue Jun 05 10:53:33 CST 2018, > RpcRetryingCaller\{globalStartTime=1528167213257, pause=100, retries=3}, > java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space > Tue Jun 05 10:53:34 CST 2018, > RpcRetryingCaller\{globalStartTime=1528167213257, pause=100, retries=3}, > java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space > Tue Jun 05 10:53:34 CST 2018, > RpcRetryingCaller\{globalStartTime=1528167213257, pause=100, retries=3}, > java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space > > org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:157) > org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:80) > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > java.lang.Thread.run(Thread.java:745) Caused by > java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space > org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:218) > org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:397) > org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:371) > org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:136) > org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:80) > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > java.lang.Thread.run(Thread.java:745) Caused by > java.lang.OutOfMemoryError: Java heap space. [2018-06-05 10:53:34] > at > org.trafodion.jdbc.t4.TrafT4Messages.throwSQLException(TrafT4Messages.java:211) > at > org.trafodion.jdbc.t4.InterfaceResultSet.fetch(InterfaceResultSet.java:857) > at org.trafodion.jdbc.t4.TrafT4ResultSet.next(TrafT4ResultSet.java:2786) > at > org.jdbctest.performance.lob.LobPerformance.test_clob_photo_normal(LobPerformance.java:1469) > at > org.jdbctest.performance.lob.LobPerformance.test_jdbc_api(LobPerformance.java:374) > at > org.jdbctest.performance.lob.LobPerformance.main(LobPerformance.java:319) -- This message was sent by Atlassian JIRA (v7.6.3#76005)