[
https://issues.apache.org/jira/browse/TRAFODION-3308?focusedWorklogId=243528&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-243528
]
ASF GitHub Bot logged work on TRAFODION-3308:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 16/May/19 18:15
Start Date: 16/May/19 18:15
Worklog Time Spent: 10m
Work Description: Traf-Jenkins commented on issue #1840: [TRAFODION-3308]
Improve error reporting when a process cannot be started
URL: https://github.com/apache/trafodion/pull/1840#issuecomment-493176320
New Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/3218/
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 243528)
Time Spent: 5h (was: 4h 50m)
> 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
> Time Spent: 5h
> 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)
