Re: [HTCondor-users] condor can't find its own program executable

[John M Knoeller <johnkn@xxxxxxxxxxx>]

Try adding 
transfer_executable = false
to your submit file.

  universe = LOCAL
  executable   = /usr/bin/psql
  transfer_executable = false
  arguments = "-d bmrbeverything -U postgres -f /websites/webapi/wsgi/releases/v2/server/wsgi/utils/sql/initialize.sql"
  setenv = TRUE

-----Original Message-----
From: Dimitri Maziuk <dmaziuk@xxxxxxxxxxxxx> 
Sent: Friday, March 29, 2019 1:36 PM
To: John M Knoeller <johnkn@xxxxxxxxxxx>; HTCondor-Users Mail List <htcondor-users@xxxxxxxxxxx>
Subject: Re: [HTCondor-users] condor can't find its own program executable

On 3/29/19 12:42 PM, John M Knoeller wrote:
> If it is not a shell script, then 
> /bin/sh /usr/pgsql-10/bin/psql
> 
> is expected to fail. 
> 
> Why it doesn't work when you tell HTCondor that /usr/pgsql-10/bin/psql is the executable, 
> my best guess is that the environment is different between running the program yourself
> and running as a local universe job.
> 
> try adding
> 
> setenv = true
> 
> to your submit file.  That will take pass the environment at submit time into the local universe job.

with

> universe = LOCAL
> executable   = /usr/bin/psql
> arguments = "-d bmrbeverything -U postgres -f /websites/webapi/wsgi/releases/v2/server/wsgi/utils/sql/initialize.sql"
> setenv = TRUE
...

I get

> could not find a "condor_exec.exe" to execute
> could not find a "condor_exec.exe" to execute
> condor_exec.exe: could not find own program executable

However with

> universe = LOCAL
> executable   = /bin/sh
> arguments = "-c '/usr/bin/psql -d bmrbeverything -U postgres -f /websites/webapi/wsgi/releases/v2/server/wsgi/utils/sql/initialize.sql' "
> setenv = TRUE
it runs.

So there is some shell magic involved in postgres...

-- 
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu