Error message detailed description on what happens and what to do...
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
Comments
Hi,
Please open a support case. We will be happy to help you
Sruthi
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)
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?
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
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.
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