[
https://issues.apache.org/jira/browse/TRAFODION-322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-322.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.0 (pre-incubation)
> LP Bug: 1324326 - left join BMO return ERROR[1] problem_with_server_read
> ------------------------------------------------------------------------
>
> Key: TRAFODION-322
> URL: https://issues.apache.org/jira/browse/TRAFODION-322
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Apache Trafodion
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> ================================================================================
> Spooling started at May 29, 2014 12:28:20 AM
> ================================================================================
> SQL>env;
> COLSEP " "
> HISTOPT DEFAULT [No expansion of script files]
> IDLETIMEOUT 30 min(s)
> LIST_COUNT 0 [All Rows]
> LOG FILE a03log
> LOG OPTIONS CLEAR,CMDTEXT ON
> MARKUP RAW
> PROMPT SQL>
> SCHEMA SEABASE
> SERVER rhel-cdh1.hpl.hp.com:37800
> SQLTERMINATOR ;
> STATISTICS OFF
> TIME OFF
> TIMING OFF
> USER trafodion
> SQL>set schema g_hpit;
> --- SQL operation complete.
> SQL>prepare xx from
> select [last 1] * from PERF_SUM_F fact
> left outer join CUST_ACCT_HIER_D cust on
> fact.SLDT_CUST_ACCT_HIER_KY = cust.CUST_ACCT_HIER_KY
> order by cust.cust_acct_hier_ky;
> --- SQL command prepared.
> SQL>explain options 'f' xx;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> ---- ---- ---- -------------------- -------- -------------------- ---------
>
> 5 . 6 root 5.00E+003
> 4 . 5 firstn 5.00E+003
> 3 . 4 sort 5.00E+003
> 2 1 3 left_hybrid_hash_joi 5.00E+003
> . . 2 trafodion_scan PERF_SUM_F 1.00E+002
> . . 1 trafodion_scan CUST_ACCT_HIER_D 1.00E+002
> --- SQL operation complete.
> SQL>explain xx;
>
> ------------------------------------------------------------------ PLAN
> SUMMARY
> MODULE_NAME .............. DYNAMICALLY COMPILED
> STATEMENT_NAME ........... XX
> PLAN_ID .................. 212268083306579339
> ROWS_OUT ............. 5,000
> EST_TOTAL_COST ........... 0.01
> STATEMENT ................ select [last 1] *
> from PERF_SUM_F fact
> left outer join
> CUST_ACCT_HIER_D cust on
> fact.SLDT_CUST_ACCT_HIER_KY =
> cust.CUST_ACCT_HIER_KY
>
> order by cust.cust_acct_hier_ky
>
>
> ------------------------------------------------------------------ NODE
> LISTING
> ROOT ====================================== SEQ_NO 6 ONLY CHILD 5
> REQUESTS_IN .............. 1
> ROWS_OUT ............. 5,000
> EST_OPER_COST ............ 0
> EST_TOTAL_COST ........... 0.01
> DESCRIPTION
> max_card_est ....... 5,000
> fragment_id ............ 0
> parent_frag ............ (none)
> fragment_type .......... master
> statement_index ........ 0
> affinity_value ......... 0
> est_memory_per_cpu ..... 16906 KB
> max_max_cardinality .... 0
> total_overflow_size .... 0.00 KB
> xn_access_mode ......... read_only
> xn_autoabort_interval 0
> auto_query_retry ....... enabled
> plan_version ....... 2,600
> embedded_arkcmp ........ used
> LDAP_USERNAME .......... TRAFODION
> SCHEMA ................. G_HPIT
> select_list ............ TRAFODION.G_HPIT.PERF_SUM_F.DT_MTH_KY,
> TRAFODION.G_HPIT.PERF_SUM_F.CTRY_KY,
> TRAFODION.G_HPIT.PERF_SUM_F.QTA_PROD_LN_KY,
> TRAFODION.G_HPIT.PERF_SUM_F.RTE_TO_MKT_KY,
>
> TRAFODION.G_HPIT.PERF_SUM_F.SLDT_CUST_ACCT_HIER_KY
> ,
> TRAFODION.G_HPIT.PERF_SUM_F.SO_GRS_EXT_US_DLR_AM
> ,
> TRAFODION.G_HPIT.PERF_SUM_F.SO_NET_EXT_US_DLR_AM
> , TRAFODION.G_HPIT.PERF_SUM_F.SHIP_GRS_US_DLR_AM,
> TRAFODION.G_HPIT.PERF_SUM_F.SHIP_NET_US_DLR_AM,
>
> TRAFODION.G_HPIT.PERF_SUM_F.REV_GRS_REV_US_DLR_AM,
> TRAFODION.G_HPIT.PERF_SUM_F.SO_DTL_QT,
> TRAFODION.G_HPIT.PERF_SUM_F.REV_DISC_US_DLR_AM,
>
> TRAFODION.G_HPIT.PERF_SUM_F.REV_TRD_DISC_FEE_US_DL
> R_AM, TRAFODION.G_HPIT.PERF_SUM_F.SHIP_QT,
>
> TRAFODION.G_HPIT.PERF_SUM_F.REV_PRC_PROT_US_DLR_AM
> ,
> TRAFODION.G_HPIT.PERF_SUM_F.REV_NET_REV_US_DLR_A
> M,
> TRAFODION.G_HPIT.PERF_SUM_F.REV_PROD_AND_SRVC_C
> ST_OF_SLS_US_DLR_AM,
> TRAFODION.G_HPIT.PERF_SUM_F.R
> EV_WARR_LEM_CST_US_DLR_AM,
>
> TRAFODION.G_HPIT.PERF_SUM_F.REV_SUPLY_CHAIN_CST_US
> _DLR_AM,
> TRAFODION.G_HPIT.PERF_SUM_F.REV_END_OF_LI
> FE_CST_US_DLR_AM,
> TRAFODION.G_HPIT.PERF_SUM_F.REV_
> OTHR_CST_OF_SLS_US_DLR_AM,
>
> TRAFODION.G_HPIT.PERF_SUM_F.REV_TOT_PROD_SLS_CST_U
> S_DLR_AM,
> TRAFODION.G_HPIT.PERF_SUM_F.REV_TOT_SRVC
> S_SLS_CST_US_DLR_AM,
> TRAFODION.G_HPIT.PERF_SUM_F.R
> EV_PROD_GRS_MRGN_US_DLR_AM,
>
> TRAFODION.G_HPIT.PERF_SUM_F.REV_SRVCS_GRS_MRGN_US_
> DLR_AM,
> instantiate_null(TRAFODION.G_HPIT.CUST_ACC
> T_HIER_D.CUST_ACCT_HIER_KY),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .CUST_AMID_LVL_2_HSTD_CTRY_KY),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .SRC_SYS_KY),
> instantiate_null(TRAFODION.G_HPIT.CU
> ST_ACCT_HIER_D.CUST_AMID_LVL_3_HSTD_CTRY_KY),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .CUST_AMID_LVL_2_ID),
> instantiate_null(TRAFODION.G
>
> _HPIT.CUST_ACCT_HIER_D.CUST_AMID_LVL_4_HSTD_CTRY_K
> Y),
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HI
> ER_D.CUST_AMID_LVL_2_NM),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .CUST_AMID_LVL_2_SHT_NM),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .CUST_AMID_LVL_2_IND_VERT_CD),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .CUST_AMID_LVL_2_IND_VERT_NM),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .CUST_AMID_LVL_2_IND_SEG_CD),
>
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D
> .CUST_AMID_LVL_2_IND_SEG_NM),
> instantiate_null(TRAFODION.G_HP***LINES
> DROPPED***
> FIRSTN ==================================== SEQ_NO 5 ONLY CHILD 4
> REQUESTS_IN .............. 1
> ROWS_OUT ............. 5,000
> EST_OPER_COST ............ 0
> EST_TOTAL_COST ........... 0.01
> DESCRIPTION
> max_card_est ....... 5,000
> fragment_id ............ 0
> parent_frag ............ (none)
> fragment_type .......... master
>
>
> SORT ====================================== SEQ_NO 4 ONLY CHILD 3
> REQUESTS_IN .............. 1
> ROWS_OUT ............. 5,000
> EST_OPER_COST ............ 0.01
> EST_TOTAL_COST ........... 0.01
> DESCRIPTION
> memory_quota ........... 328 MB
> max_card_est ....... 5,000
> fragment_id ............ 0
> parent_frag ............ (none)
> fragment_type .......... master
> est_memory_per_cpu ..... 16342 KB
> sort_type .............. full
> sort_key ...............
> instantiate_null(TRAFODION.G_HPIT.CUST_ACCT_HIER_D.C
> UST_ACCT_HIER_KY)
>
>
> LEFT_HYBRID_HASH_JOIN ===================== SEQ_NO 3 CHILDREN 2, 1
> REQUESTS_IN .............. 1
> ROWS_OUT ............. 5,000
> EST_OPER_COST ............ 0.01
> EST_TOTAL_COST ........... 0.01
> DESCRIPTION
> memory_quota ........... 328 MB
> max_card_est ....... 5,000
> fragment_id ............ 0
> parent_frag ............ (none)
> fragment_type .......... master
> est_memory_per_cpu ..... 563 KB
> join_type .............. left
> join_method ............ hash
> hash_join_predicates ... (TRAFODION.G_HPIT.PERF_SUM_F.SLDT_CUST_ACCT_HIER_KY
> =
> TRAFODION.G_HPIT.CUST_ACCT_HIER_D.CUST_ACCT_HIER
> _KY)
>
>
> TRAFODION_SCAN ============================ SEQ_NO 2 NO CHILDREN
> TABLE_NAME ............... PERF_SUM_F
> REQUESTS_IN .............. 1
> ROWS_OUT ............... 100
> EST_OPER_COST ............ 0.01
> EST_TOTAL_COST ........... 0.01
> DESCRIPTION
> max_card_est ......... 100
> fragment_id ............ 0
> parent_frag ............ (none)
> fragment_type .......... master
> scan_type .............. subset scan of table TRAFODION.G_HPIT.PERF_SUM_F
> FACT
> columns ................ all
> begin_keys(incl)
> end_keys(incl)
> key_columns ............ _SALT_, DT_MTH_KY, CTRY_KY, QTA_PROD_LN_KY,
> RTE_TO_MKT_KY, SLDT_CUST_ACCT_HIER_KY
>
>
> TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
> TABLE_NAME ............... CUST_ACCT_HIER_D
> REQUESTS_IN .............. 1
> ROWS_OUT ............... 100
> EST_OPER_COST ............ 0.01
> EST_TOTAL_COST ........... 0.01
> DESCRIPTION
> max_card_est ......... 100
> fragment_id ............ 0
> parent_frag ............ (none)
> fragment_type .......... master
> scan_type .............. subset scan of table
> TRAFODION.G_HPIT.CUST_ACCT_HIER
> _D CUST
> columns ................ all
> begin_keys(incl)
> end_keys(incl)
> key_columns ............ _SALT_, CUST_ACCT_HIER_KY
> --- SQL operation complete.
> SQL>execute xx;
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> SQL>get statistics for qid current progress;
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> SQL>get statistics for statement xx;
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> SQL>log off;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
