Skip to main content

External Procedure: Error 7112 - exit status 139

  • September 8, 2017
  • 4 replies
  • 19 views

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

4 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • September 8, 2017

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
  • Author
  • New Participant
  • September 8, 2017

yes, I already did it


Cabrejas
  • Author
  • New Participant
  • September 21, 2017

any updates about this subject?


Cabrejas
  • Author
  • New Participant
  • September 21, 2017

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