Trafodion

mdam access causes crash

Bug #1324574 reported by Anoop Sharma
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Released
High
Anoop Sharma
Trafodion r0.8

Bug 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';
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f87b20def16, pid=26701, tid=140220624505504
#
# JRE version: OpenJDK Runtime Environment (7.0_45-b15) (build 1.7.0_45-mockbuild_2013_10_22_03_37-b00)
# Java VM: OpenJDK 64-Bit Server VM (24.45-b08 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [libexecutor.so+0x1a2f16] ExHbaseScanSQTaskTcb::getProbeResult(char*&)+0xb6
#
# 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.

Tags: sql-exe
Anoop Sharma (anoop-sharma)
Changed in trafodion:
importance: Undecided → High
assignee: nobody → Ravisha Neelakanthappa (ravisha-neelakanthappa)
Anoop Sharma (anoop-sharma)
Changed in trafodion:
assignee: Ravisha Neelakanthappa (ravisha-neelakanthappa) → Anoop Sharma (anoop-sharma)
Anoop Sharma (anoop-sharma)
Changed in trafodion:
status: New → In Progress
Stacey Johnson (sjohnson-w)
information type: Proprietary → Public
Revision history for this message
Anoop Sharma (anoop-sharma) wrote :

fixed in July RC1 bld

Changed in trafodion:
status: In Progress → Fix Committed
QF Chen (qifan-chen)
tags: added: sql-exe
Alice Chen (alchen)
Changed in trafodion:
milestone: none → r0.8
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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