Skip to main content

Error message detailed description on what happens and what to do...

  • March 31, 2016
  • 6 replies
  • 30 views
jazzmanov

Hi

 

Find out that lots of error codes not described in docs

I need some description on why that errorc occurs, can anybody give some explanation?

 

Error list below,

select * from error_messages

 

I have co-located vertica sql on hadoop cluster, and use hdfs to store projections as Storage Locations.

 

error_level    error_code    message
ERROR    100663808    Received no response from v_mysecondtry_node0003 in get node cell counts
ERROR    16777318    Receive on v_mysecondtry_node0001: Message receipt from v_mysecondtry_node0002 failed [canceled]
ERROR    67371461    Node failure during execution
ERROR    67371461    Execution canceled by operator
ERROR    33557030    Error finalizing ROS DataTarget
ERROR    67137668    Found eligible 1 processes to invite, but no matching nodes in catalog
ERROR    16777318    Receive on v_mysecondtry_node0001: Message receipt from v_mysecondtry_node0003 failed [canceled]
PANIC    16779814    Unable to close sequence file [/home/dbadmin/vertica/catalog/mySecondTry/v_mysecondtry_node0003_catalog/Catalog/sequencegenerator.cat]: Success
ERROR    16777318    Receive on v_mysecondtry_node0002: Message receipt from v_mysecondtry_node0003 failed [canceled]
ERROR    16777318    Send: Connection not open [v_mysecondtry_node0003 tag:1000 plan 49539595903086340]
ERROR    16777318    Send: Connection not open [v_mysecondtry_node0003 tag:1001 plan 49539595903086340]
ERROR    16777318    Receive on v_mysecondtry_node0002: open failed for node v_mysecondtry_node0001 (Consult log for error information) --- has query been cancelled?
ERROR    16777318    Receive on v_mysecondtry_node0002: Message receipt from v_mysecondtry_node0001 failed [canceled]
ERROR    16777318    Send: Connection not open [v_mysecondtry_node0003 tag:1000 plan 49539595903081500]
ERROR    786949    DataTarget: error writing data file to webhdfs://somehost.com:50070/user/dbadmin/vertica/v_mysecondtry_node0003
ERROR    786949    DataTarget: error writing data file to webhdfs://somehost.com:50070/user/dbadmin/vertica/v_mysecondtry_node0002

 

 

    6 replies

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • March 31, 2016

    Hi,

     

           Please open a support case. We will be happy to help you

     

    Sruthi

    jazzmanov
    • jazzmanov
    • Author
    • New Participant
    • April 1, 2016

    I'm not enterprise customer.

    All this errors i've got on community edition, 7.2, three nodes cluster, cpu 5,4,4, ram 10,8,8, hdd, 120,100,100, centos os (first node = name+data node).

     

    With conditions above, can i post to hpe support?

    If yes, provide a link where i can register and create ticket (last month your portals and web insrasructure changes quickly)

    Multiverse
    • Multiverse
    • New Participant
    • April 15, 2016

    I get the same error repeatedly in the logs during our ETL process, and the process fails randomly.  There is no explanation.  The error number 16777318 cannot be found anywhere in the Vertica error codes.  Why does the database produce error codes that are not documented anywhere?

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • April 18, 2016

    HI,

     

        Unfortunately, with these conditions, you cannot open support ticket. Only Enterprise customers can open a ticket. I would say error messages indicate connection issues among nodes. 

     

     

    Sruthi

    jazzmanov
    • jazzmanov
    • Author
    • New Participant
    • June 11, 2016

    SruthiA, thanx for you answereing, but it is not good.

    You say - "Hey, yes, we have errors with strange error codes without explanation, and this is normal situation, if you want we to tell you description - buy vertica".

     

    Not normal, imho.

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • June 13, 2016

    Hi

    Vertica is using WebHDFS (HTTP REST API supports the complete FileSystem interface for HDFS) for accessing its  ROS files that exists on HDFS . I will advice to start trabelshoting your  WebHDFS channel , you can see some examples her :

     

     

    http://stackoverflow.com/questions/10672700/http-request-to-webhdfs-but-empty-reply-from-server

     

     

    I hope you will find it helpful

     

    Thanks 

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement