Error creating R library
Posted: Tue Mar 12, 2013 4:18 am
I am using the Community Edition of Vertica and trying to create an R library. I followed all of the instructions listed here, and it seems like everything was installed correctly. However, when I try to create the example library, I am getting the following error:
dbadmin=> CREATE LIBRARY rLib AS '/opt/vertica/sdk/examples/RFunctions/RFunctions.R' LANGUAGE 'R';
ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: UDx side process has exited abnormally
I know that they addressed this issue in the documentation as follows:
dbadmin=> CREATE LIBRARY rLib AS '/opt/vertica/sdk/examples/RFunctions/RFunctions.R' LANGUAGE 'R';
ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: UDx side process has exited abnormally
I know that they addressed this issue in the documentation as follows:
However, I checked dbLog and did not see anything about system Renviron. I followed all of the instructions to set the R_HOME variable. Is there any other issue that could be causing this error, or any way I can confirm if R_HOME was set correctly in Vertica?Note: If you get the following error when attempting to create an R library "ROLLBACK 2929: Couldn't create new UDx side process, failed to get UDx side process info from zygote: UDx side process has exited abnormally", and the corresponding dbLog entry states "cannot find system Renviron", then the R_HOME variable has not been set correctly or it is not being picked up by Vertica.