[
https://issues.apache.org/jira/browse/TRAFODION-3308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-3308.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.4
> Uninformative error messages when executables are unavailable
> -------------------------------------------------------------
>
> Key: TRAFODION-3308
> URL: https://issues.apache.org/jira/browse/TRAFODION-3308
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.4
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Major
> Fix For: 2.4
>
> Time Spent: 5h 20m
> Remaining Estimate: 0h
>
> When the tdm_arkcmp executable is unavailable on a Trafodion node due to a
> file system error, we get the following less-than-informative error:
> {quote}>>create schema scythians;
> *** ERROR[2012] Server process tdm_arkcmp could not be created on \\NSK -
> Operating system error 4022, TPCError = 53, error detail = 0. (See variants
> of Seabed procedure msg_mon_start_process for details).
> *** ERROR[2013] Server process tdm_arkcmp could not be created on \\NSK -
> Operating system error 4022.
> *** ERROR[2002] Internal error: cannot create compiler.
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
> >>
> {quote}
> We get a similarly uninformative series of errors when the tdm_arkesp
> executable is unavailable:
> {quote}>>prepare s1 from select * From t1 where b = 6;
> --- SQL command prepared.
> >>explain options 'f' s1;
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> ---- ---- ---- -------------------- -------- -------------------- ---------
> 2 . 3 root 1.30E+004
> 1 . 2 esp_exchange 1:2(hash2) 1.30E+004
> . . 1 trafodion_scan T1 1.30E+004
> --- SQL operation complete.
> >>execute s1;
> *** ERROR[2012] Server process tdm_arkesp could not be created on \NSK cpu 0
> - Operating system error 4022, TPCError = 53, error detail = 0. (See
> variants of Seabed procedure msg_mon_start_process for details).
> *** ERROR[2013] Server process tdm_arkesp could not be created on \NSK cpu 0
> - Operating system error 4022.
> *** ERROR[2012] Server process tdm_arkesp could not be created on \NSK cpu 0
> - Operating system error 4022, TPCError = 53, error detail = 0. (See
> variants of Seabed procedure msg_mon_start_process for details).
> --- 0 row(s) selected.
> >>
> {quote}
> Among the issues with these error messages:
> # They do not give the correct node name where we were trying to create the
> process, but instead report NSK.
> # Error 2013 is completely redundant; everything it says is in error 2012.
> # Error 2012 could be much more informative. Text could be added explaining
> the meaning of the error codes given.
> # In the tdm_arkcmp case, error 2002 adds no information at all.
> To reproduce these issues on a development instance, first create a table T1
> with one million rows (so a parallel plan will be picked for the tdm_arkesp
> example). Then go to the trafodion/core/sql/lib/linux/64bit/debug directory
> and rename the tdm_arkcmp and tdm_arkesp executables to something else. Try
> any DDL command to get the tdm_arkcmp failure. Try any parallel DML statement
> to get the tdm_arkesp failure.
> It is likely that similar issues exist for other processes, e.g. tdm_udrserv.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
