You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:39 UTC
[jira] [Created] (TRAFODION-326) LP Bug: 1324574 - mdam access
causes crash
Alice Chen created TRAFODION-326:
------------------------------------
Summary: LP Bug: 1324574 - mdam access causes crash
Key: TRAFODION-326
URL: https://issues.apache.org/jira/browse/TRAFODION-326
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Anoop Sharma
Assignee: Anoop Sharma
Priority: Critical
Fix For: 0.8 (pre-incubation)
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)