[TRAFODION-326] LP Bug: 1324574 - mdam access causes crash

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.8 (pre-incubation)
• Component/s: sql-exe
• External issue URL: https://bugs.launchpad.net/bugs/1324574
• Assignee: Anoop Sharma
• Reporter: Anoop Sharma
• Created: 22/Jul/15 18:15
• Updated: 31/Aug/15 04:19
• Resolved: 31/Aug/15 04:04

Description

This was seen on the moonshot system.
If mdam is turned off, query runs fine.

CREATE TABLE TRAFODION.MINOTAUR.EVENTS_LOAD75
(
SRCIP CHAR(45) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, SRCPORT INT NO DEFAULT NOT NULL NOT DROPPABLE
, DSTIP VARCHAR(45) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, DSTPORT INT NO DEFAULT NOT NULL NOT DROPPABLE
, AGENTRECEIPTTIME TIMESTAMP(0) NO DEFAULT NOT NULL NOT
DROPPABLE
, CATEGORYOUTCOME VARCHAR(30) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, CATEGORYSIGNIFICANCE VARCHAR(30) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, DEVICESEVERITY VARCHAR(30) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, CATEGORYDEVICETYPE VARCHAR(30) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, DEVICECUSTOMSTRING1 VARCHAR(30) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, FLEXSTRING1 VARCHAR(30) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, EVENT_ID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, PRIMARY KEY (SRCIP ASC, AGENTRECEIPTTIME ASC, EVENT_ID ASC)
)
SALT USING 75 PARTITIONS
;

>>set statistics on;
>>cqd parallel_num_esps '24';

— SQL operation complete.
>>cqd max_esps_per_cpu_per_op '8';

— SQL operation complete.
>>select * from events_load75<<+ cardinality 10e6 >> where srcip = '120.120.120.1' and agentreceipttime = timestamp '2014-05-28 15:10:33';
#

1. A fatal error has been detected by the Java Runtime Environment:
   #
2. SIGSEGV (0xb) at pc=0x00007f87b20def16, pid=26701, tid=140220624505504
   #
3. JRE version: OpenJDK Runtime Environment (7.0_45-b15) (build 1.7.0_45-mockbuild_2013_10_22_03_37-b00)
4. Java VM: OpenJDK 64-Bit Server VM (24.45-b08 mixed mode linux-amd64 compressed oops)
5. Problematic frame:
6. C [libexecutor.so+0x1a2f16] ExHbaseScanSQTaskTcb::getProbeResult(char*&)+0xb6
   #
7. Core dump written. Default location: /home/trafodion/traf_40705/sql/scripts/core or core.26701

>>explain a;

------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... A
PLAN_ID .................. 212268085107739068
ROWS_OUT ........ 10,000,000
EST_TOTAL_COST ........... 0.02
STATEMENT ................ select *
from events_load75<<+ cardinality 10e6 >>
where srcip = '120.120.120.1' and agentreceipttime =
timestamp '2014-05-28 15:10:33';

------------------------------------------------------------------ NODE LISTING
ROOT ====================================== SEQ_NO 3 ONLY CHILD 2
REQUESTS_IN .............. 1
ROWS_OUT ........ 10,000,000
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.02
DESCRIPTION
max_card_est ........... 1e+07
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
affinity_value ......... 0
est_memory_per_cpu ..... 63 KB
max_max_cardinality .... 0
total_overflow_size .... 0.00 KB
esp_2_node_map ......... (\NSK:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1)
xn_access_mode ......... read_only
xn_autoabort_interval 0
auto_query_retry ....... enabled
plan_version ....... 2,600
embedded_arkcmp ........ used
IS_SQLCI ............... ON
LDAP_USERNAME
SCHEMA ................. MINOTAUR
PARALLEL_NUM_ESPS ..... 24
MAX_ESPS_PER_CPU_PER_OP 8
select_list ............ %('120.120.120.1'), TRAFODION.MINOTAUR.EVENTS_LOAD75
.SRCPORT, TRAFODION.MINOTAUR.EVENTS_LOAD75.DSTIP,
TRAFODION.MINOTAUR.EVENTS_LOAD75.DSTPORT,
%(2014-05-28 15:10:33),
TRAFODION.MINOTAUR.EVENTS_LOAD75.CATEGORYOUTCOME,
TRAFODION.MINOTAUR.EVENTS_LOAD75.CATEGORYSIGNIFICA
NCE, TRAFODION.MINOTAUR.EVENTS_LOAD75.DEVICESEVERI
TY, TRAFODION.MINOTAUR.EVENTS_LOAD75.CATEGORYDEVIC
ETYPE, TRAFODION.MINOTAUR.EVENTS_LOAD75.DEVICECUST
OMSTRING1, TRAFODION.MINOTAUR.EVENTS_LOAD75.FLEXST
RING1, TRAFODION.MINOTAUR.EVENTS_LOAD75.EVENT_ID
input_variables ........ %('120.120.120.1'), %(2014-05-28 15:10:33)

ESP_EXCHANGE ============================== SEQ_NO 2 ONLY CHILD 1
REQUESTS_IN .............. 1
ROWS_OUT ........ 10,000,000
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.02
DESCRIPTION
max_card_est ........... 1e+07
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... esp
est_memory_per_cpu ..... 63 KB
buffer_size ....... 30,388
record_length ........ 256
parent_processes ....... 1
child_processes ....... 15
child_partitioning_func range partitioned 15 ways on
(TRAFODION.MINOTAUR.EVENTS_LOAD75."SALT",
TRAFODION.MINOTAUR.EVENTS_LOAD75.SRCIP,
TRAFODION.MINOTAUR.EVENTS_LOAD75.AGENTRECEIPTTIME,
TRAFODION.MINOTAUR.EVENTS_LOAD75.EVENT_ID) with
boundaries(c(<min>) c('<min>') c(<min>) c(<min>)
;c(5) c('''<region boundary>''') c(0001-01-01
00:00:00) c(-9223372036854775808) ;c(10)
c('''<region boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(15) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(20) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(25) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(30) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(35) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(40) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(45) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(50) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(55) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(60) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(65) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) ;c(70) c('''<region
boundary>''') c(0001-01-01 00:00:00)
c(-9223372036854775808) )
seamonster_query ....... no
seamonster_exchange .... no

TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... EVENTS_LOAD75
REQUESTS_IN .............. 1
ROWS_OUT ........ 10,000,000
EST_OPER_COST ............ 0.02
EST_TOTAL_COST ........... 0.02
DESCRIPTION
max_card_est ........... 1e+07
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... esp
scan_type .............. subset scan limited by mdam of table
TRAFODION.MINOTAUR.EVENTS_LOAD75
key_columns ............ SALT, SRCIP, AGENTRECEIPTTIME, EVENT_ID
executor_predicates .... ((SALT < \:sys_HostVarHi0) or (_SALT =
\:_sys_HostVarHi0) and ((%('120.120.120.1') <
\:_sys_HostVarHi1) or (%('120.120.120.1') =
\:_sys_HostVarHi1) and ((%(2014-05-28 15:10:33) <
\:_sys_HostVarHi2) or (%(2014-05-28 15:10:33) =
\:_sys_HostVarHi2) and case(if_then_else((0 <>
\:_sys_hostVarExclRange),
(EVENT_ID < \:_sys_HostVarHi3),
(EVENT_ID <= \:sys_HostVarHi3)))))) and ((_SALT
> \:sys_HostVarLo0) or (_SALT =
\:_sys_HostVarLo0) and ((%('120.120.120.1') >
\:_sys_HostVarLo1) or (%('120.120.120.1') =
\:_sys_HostVarLo1) and ((%(2014-05-28 15:10:33) >
\:_sys_HostVarLo2) or (%(2014-05-28 15:10:33) =
\:_sys_HostVarLo2) and (EVENT_ID >=
\:sys_HostVarLo3)))) and ((_SALT <
\:sys_HostVarHi0) or (_SALT = \:_sys_HostVarHi0)
and ((%('120.120.120.1') < \:_sys_HostVarHi1) or
(%('120.120.120.1') = \:_sys_HostVarHi1) and
((%(2014-05-28 15:10:33) < \:_sys_HostVarHi2) or
(%(2014-05-28 15:10:33) = \:_sys_HostVarHi2) and
(EVENT_ID <= \:_sys_HostVarHi3))))
mdam_disjunct .......... (SALT = \:sys_HostVarHi0) and (_SALT =
\:sys_HostVarLo0) and (_SALT =
\:_sys_HostVarHi0) and (SRCIP =
%('120.120.120.1')) and (AGENTRECEIPTTIME =
%(2014-05-28 15:10:33))
mdam_disjunct .......... (SALT = \:sys_HostVarHi0) and (_SALT =
\:sys_HostVarLo0) and (_SALT =
\:_sys_HostVarHi0) and (EVENT_ID <=
\:_sys_HostVarHi3) and (SRCIP =
%('120.120.120.1')) and (AGENTRECEIPTTIME =
%(2014-05-28 15:10:33))
mdam_disjunct .......... (SALT = \:sys_HostVarHi0) and (_SALT =
\:sys_HostVarLo0) and (_SALT =
\:_sys_HostVarHi0) and (SRCIP =
%('120.120.120.1')) and (AGENTRECEIPTTIME =
%(2014-05-28 15:10:33))
mdam_disjunct .......... (SALT = \:sys_HostVarHi0) and (_SALT =
\:sys_HostVarLo0) and (_SALT <
\:_sys_HostVarHi0) and (SRCIP =
%('120.120.120.1')) and (AGENTRECEIPTTIME =
%(2014-05-28 15:10:33))
mdam_disjunct .......... (SALT = \:sys_HostVarHi0) and (_SALT =
\:_sys_HostVarLo0) and (EVENT_ID >=
\:sys_HostVarLo3) and (_SALT =
\:_sys_HostVarHi0) and (SRCIP =
%('120.120.120.1')) and (AGENTRECEIPTTIME =
%(2014-05-28 15:10:33))
mdam_disjunct .......... (SALT = \:sys_HostVarHi0) and (_SALT =
\:_sys_HostVarLo0) and (EVENT_ID >=
\:sys_HostVarLo3) and (_SALT =
\:_sys_HostVarHi0) and (EVENT_ID <=
\:_sys_HostVarHi3) and (SRCIP =
%('120.120.120.1')) and (AGENTRECEIPTTIME =
%(2014-05-28 15:10:33))
mdam_disjunct .......... (SALT = \:sys_HostVarHi0) and (_SALT =
\:_sys_HostVarLo0) and (EVENT_ID >=
\:sys_HostVarLo3) and (_SALT =
\:_sys_HostVarHi0) and (SRCIP =**LINES DROPPED**

— SQL operation complete.