External Procedure: Error 7112 - exit status 139

Cabrejas

Hi

I have create a unix shell script that is working fine out of Vertica but I got this error calling it from database.
The script call to a C program with several parameters and it looks like script crash in the midle of something (not able to call c program properly?)
I try shell script without parameters and it is fine, but I need the parameters

Thank you

Jim_Knicely

Did you enable SUID (Set owner User ID up on execution) on the script file? The setuid permission bit tells Linux to run a program with the effective user id of the owner instead of the executor.

Example:

[dbadmin@s18384357 ~]$ ls -l runVSQL.sh
-rwxr-xr-x 1 dbadmin verticadba 126 Dec  4  2015 runVSQL.sh

[dbadmin@s18384357 ~]$ chmod u+s runVSQL.sh

[dbadmin@s18384357 ~]$ ls -l runVSQL.sh
-rwsr-xr-x 1 dbadmin verticadba 126 Dec  4  2015 runVSQL.sh

See:
https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/ExtendingVertica/ExternalProcedures/ImplementingExternalProcedures.htm

Cabrejas

yes, I already did it

Cabrejas

any updates about this subject?

Cabrejas

Hi Jim, I already sent to you an email with the summary following the flow proposed by HP but is still not working, so please, let me know another step that we could try in this topic

thank you and regards