[jira] [Created] (TRAFODION-3308) Uninformative error messages when executables are unavailable

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

David Wayne Birdsall created TRAFODION-3308:
-----------------------------------------------

             Summary: 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


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)