Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
None
-
None
Description
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