The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

vsql exit status for "No such file or directory"

Please add non zero exit status for vsql if specified file is not exists

$ vsql -f nonexisting.sql && echo OK || echo FAIL
nonexisting.sql: No such file or directory
OK

Same problem with included files

$ vsql -a -f error.sql && echo OK || echo FAIL
\set ON_ERROR_STOP on
\i nonexisting.sql
vsql:error.sql:2: nonexisting.sql: No such file or directory
select 2;
 ?column?
----------
        2
(1 row)

OK

vsql continues execution without stopping

Answers

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Maybe check if the file exists prior to running vsql?

    Example:

    [dbadmin@localhost ~]$ FILE=/home/dbadmin/run_me.sql
    
    [dbadmin@localhost ~]$ ll $FILE
    ls: cannot access '/home/dbadmin/run_me.sql': No such file or directory
    
    [dbadmin@localhost ~]$ [ -f $FILE ] && vsql -f $FILE || echo "$FILE does not exist."
    /home/dbadmin/run_me.sql does not exist.
    
    [dbadmin@localhost ~]$ echo "SELECT 1 AS some_column;" > $FILE
    
    [dbadmin@localhost ~]$ [ -f $FILE ] && vsql -f $FILE || echo "$FILE does not exist."
     some_column
    -------------
               1
    (1 row)
    
  • Maybe check if the file exists prior to running vsql?

    1. We do that. But this is workaround. And such trick didn't saves us if file became unavailable after check and before vsql starts.
    2. What about included files? Same problem. We do another check via parsing of output. But this is weird.
      Process must return correct exit code. All programs do that.
  • Sorry for some toxic in my opinion )
    I like your product. You made a lot of cool things in Vertica DB.
    Thanks for support and continuous development!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file