Running the Pulse Install Script

tester

As the dbadmin user, run the install.sql script with vsql:

vsql -f /opt/vertica/packages/pulse/ddl/install.sql

Where should i type in this command to? 

Navin_C

Hi,

vsql is commanline tool for vertica.

vsql -f /opt/vertica/packages/pulse/ddl/install.sql

This command will run the install.sql file inside vertica

vsql -f : stands for running a .sql file

Chris_C

You should run that command in the bash shell of the dbadmin user. 

tester

Hi, it shows me this error message.. How can i resolve it?


vsql:/opt/vertica/packages/pulse/ddl/install.sql:3: WARNING 4973:  The UDx zygote process is down, restarting it...vsql:/opt/vertica/packages/pulse/ddl/install.sql:3: WARNING 4973:  The UDx zygote process is down, restarting it...
vsql:/opt/vertica/packages/pulse/ddl/install.sql:3: ROLLBACK 2175:  An error occurred when loading library file on node v_testdb_node0002, message:
Couldn't create new UDx side process, failed to get UDx side process info from zygote: UDx side process has exited abnormally
vsql:/opt/vertica/packages/pulse/ddl/install.sql:4: ROLLBACK 3861:  Library not found: sentimentlib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:5: ROLLBACK 3861:  Library not found: sentimentlib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:6: ROLLBACK 3861:  Library not found: sentimentlib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:7: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:8: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:9: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:10: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:11: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:12: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:13: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:14: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:15: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:17: ROLLBACK 3861:  Library not found: SentimentLib
vsql:/opt/vertica/packages/pulse/ddl/install.sql:19: ROLLBACK 5403:  User/role "pulse_users" already exists

PRana

The error suggests that the configuration parameter 'JavaBinaryforUDX' has not been set properly. Please run the following command from the vsql prompt to set 'JavaBinaryforUDX' to '<path to your java>'

select set_config_parameter('JavabinaryForUDx', '<path to your java>' );


Pratibha