[
https://issues.apache.org/jira/browse/TRAFODION-225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-225.
----------------------------------
Resolution: Fixed
Assignee: (was: Apache Trafodion)
Fix Version/s: 0.8 (pre-incubation)
> LP Bug: 1307796 - Large query sees operating system error 201
> -------------------------------------------------------------
>
> Key: TRAFODION-225
> URL: https://issues.apache.org/jira/browse/TRAFODION-225
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Priority: Critical
> Fix For: 0.8 (pre-incubation)
>
>
> When running this large query on Trafodion, it returned operating system
> error 201. It did not appear to have any core file generated when this
> happened. This was seen on centos-mapr, a 6-node cluster, but the same query
> will probably encounter similar errors in one form or another if run on other
> clusters.
> The tables are all salted with 12 partitions. To reproduce it will require
> populating the QA g_tpch2x tables first. The query plan is shown in the
> following output before the query execution.
> >>obey mytest.sql;
> >>log mytest.log clear;
> >>
> >>set schema g_tpch2x;
> --- SQL operation complete.
> >>
> >>prepare xx from
> +>select [first 300]
> +>l_orderkey,
> +>cast(sum(l_extendedprice*(1-l_discount)) as numeric(18,2)) as revenue,
> +>o_orderdate,
> +>o_shippriority
> +>from
> +>customer,
> +>orders,
> +>lineitem
> +>where
> +>c_mktsegment = 'HOUSEHOLD'
> +>and c_custkey = o_custkey
> +>and l_orderkey = o_orderkey
> +>and o_orderdate < date '1995-03-12'
> +>and l_shipdate > date '1995-03-12'
> +>group by
> +>l_orderkey,
> +>o_orderdate,
> +>o_shippriority
> +>order by
> +>revenue desc,
> +>o_orderdate;
> --- SQL command prepared.
> >>
> >>explain options 'f' xx;
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> ---- ---- ---- -------------------- -------- -------------------- ---------
> 14 . 15 root 2.33E+003
> 13 . 14 firstn 2.33E+003
> 12 . 13 esp_exchange 1:24(hash2) (m) 2.33E+003
> 11 . 12 sort 2.33E+003
> 10 . 11 hash_partial_groupby 2.33E+003
> 9 . 10 esp_exchange 24(hash2):24(hash2) 2.33E+003
> 8 . 9 hash_partial_groupby 2.33E+003
> 7 2 8 hybrid_hash_join 4.53E+005
> 6 4 7 hybrid_hash_join 4.53E+005
> 5 . 6 esp_exchange 24(hash2):6(range) 5.99E+004
> . . 5 trafodion_scan CUSTOMER 5.99E+004
> 3 . 4 esp_exchange 24(hash2):6(range) 1.45E+006
> . . 3 trafodion_scan ORDERS 1.45E+006
> 1 . 2 esp_exchange 24(rep-b):6(range) 3.29E+001
> . . 1 trafodion_scan LINEITEM 3.29E+001
> --- SQL operation complete.
> >>
> >>execute xx;
> *** ERROR[2034] $Z000E68: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z000E68: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z000E68: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z000E68: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z000E68: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z000E68: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z010PSP: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z010PSP: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z040JGQ: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z040JGQ: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z040JH2: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z040JH2: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z040JGW: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z040JGW: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z010PT2: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z010PT2: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z010PSV: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z010PSV: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z050R96: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z050R96: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z050R9C: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z050R9C: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z050R9I: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z050R9I: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z020HQU: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z020HQU: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z020HQH: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z020HQH: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z020HQN: Operating system error 201 while communicating with
> server process $Z000GFM.
> *** ERROR[2034] $Z020HQN: Operating system error 201 while communicating with
> server process $Z000GFM.
> --- 0 row(s) selected.
> >>
> >>log off;
> >>
> >>
> Assigned to LaunchPad User Mike Hanlon
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
