Fail to install Vertica Extention Packages (CREATE LIBRARY rollback)
Hi,
I'm trying to install Vertica Extention Packages (https://github.com/vertica/Vertica-Extension-Packages) and fail when create library:
CREATE LIBRARY StringsLib AS '/tmp/Vertica-Extension-Packages-master/strings_package/lib/StringsLib.so'
with error:
Query execution failed
Reason:
SQL Error [4236] [V1001]: [Vertica]VJDBC ROLLBACK: One or more nodes did not open a data connection to this node. This may indicate a network configuration problem. Check that the private interfaces used for communication among the cluster hosts reside in the same subnet and are returned first by host address lookup
One node configuration, all is simple, doing query as dbadmin. I spent evening with no result. What i'm doing wrong?
0
Answers
At times this error message is misleading. could you please share vertica.log for review?
Sure, I have lost my hope to solve it (
The try and fail is here
2018-12-13 20:42:08.524 Init Session:7fbe197fa700 @v_datamart_node0001: 00000/2705: Connection received: host=::1 port=44664 (connCnt 8)
2018-12-13 20:42:08.524 Init Session:7fbe197fa700 @v_datamart_node0001: 00000/4540: Received SSL negotiation startup packet
2018-12-13 20:42:08.524 Init Session:7fbe197fa700 @v_datamart_node0001: 00000/4691: Sending SSL negotiation response 'N'
2018-12-13 20:42:08.524 Init Session:7fbe197fa700 @v_datamart_node0001: 00000/4686: Authentication - sendAuthRequest: user=dbadmin database=dbadmin host=::1 authType=3
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/2705: Connection received: host=::1 port=44666 (connCnt 8)
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/4540: Received SSL negotiation startup packet
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/4691: Sending SSL negotiation response 'N'
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/4686: Authentication - sendAuthRequest: user=dbadmin database=dbadmin host=::1 authType=3
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700-a000000000a437 [Txn] Begin Txn: a000000000a437 'check_login_history'
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700-a000000000a437 [Txn] Rollback Txn: a000000000a437 'check_login_history'
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/4686: Authentication - sendAuthRequest: user=dbadmin database=dbadmin host=::1 authType=0
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/2703: Connection authenticated: user=dbadmin database=dbadmin host=::1
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/2609: Client pid: 26533
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/7400: Current idle session timeout = UNLIMITED
2018-12-13 20:42:13.478 Init Session:7fbe1b7fe700 @v_datamart_node0001: 00000/8081: Current session grace period: UNLIMITED
2018-12-13 20:42:13.479 Init Session:7fbe1b7fe700 [Session] [Query] TX:0(v_datamart_node0001-517867:0xe98) select version();
2018-12-13 20:42:13.479 Init Session:7fbe1b7fe700-a000000000a438 [Txn] Begin Txn: a000000000a438 'select version();'
2018-12-13 20:42:13.485 Init Session:7fbe1b7fe700-a000000000a438 [Session] [Query] TX:a000000000a438(v_datamart_node0001-517867:0xe98) CREATE LIBRARY StringsLib AS '/home/dbadmin/Vertica-Extension-Packages-master/strings_package/lib/StringsLib.so';
2018-12-13 20:42:13.485 Init Session:7fbe1b7fe700-a000000000a438 [Txn] Starting Commit: Txn: a000000000a438 'select version();' 3018
2018-12-13 20:42:13.485 Init Session:7fbe1b7fe700 [Txn] Commit Complete: Txn: a000000000a438 at epoch 0x525 and global catalog version 3018
2018-12-13 20:42:13.486 Init Session:7fbe1b7fe700-a000000000a43a [Txn] Begin Txn: a000000000a43a 'CREATE LIBRARY StringsLib AS '/home/dbadmin/Vertica-Extension-Packages-master/strings_package/lib/StringsLib.so';'
2018-12-13 20:42:13.486 Init Session:7fbe1b7fe700-a000000000a43a [Command] Processing Create Library statement
2018-12-13 20:42:13.487 Init Session:7fbe1b7fe700-a000000000a43a [EE] Trying to set up a new UDx side process
2018-12-13 20:42:13.514 Init Session:7fbe1b7fe700-a000000000a43a @v_datamart_node0001: V1001/4236: One or more nodes did not open a data connection to this node. This may indicate a network configuration problem. Check that the private interfaces used for communication among the cluster hosts reside in the same subnet and are returned first by host address lookup
LOCATION: openRecv, /scratch_a/release/svrtar2886/vbuild/vertica/Dist/Sockets/Messenger.cpp:1783
2018-12-13 20:42:13.514 Init Session:7fbe1b7fe700-a000000000a43a [Txn] Rollback Txn: a000000000a43a 'CREATE LIBRARY StringsLib AS '/home/dbadmin/Vertica-Extension-Packages-master/strings_package/lib/StringsLib.so';'
2018-12-13 20:42:13.514 Init Session:7fbe1b7fe700-a000000000a43a [Catalog] Transaction contains incomplete objects. Removing them now
2018-12-13 20:42:13.514 Init Session:7fbe1b7fe700-a000000000a43a [Catalog] Removing incomplete object 45035996274790758 from transaction.
2018-12-13 20:42:13.514 Init Session:7fbe1b7fe700 [Session] [Query] TX:0(v_datamart_node0001-517867:0xe98) ;
2018-12-13 20:42:13.515 Init Session:7fbe1b7fe700 [Session] [Query] TX:0(v_datamart_node0001-517867:0xe98) CREATE FUNCTION EditDistance AS LANGUAGE 'C++' NAME 'EditDistanceFactory' LIBRARY StringsLib NOT FENCED;
Is THP disabled in your cluster?
Yeah, they are disabled.
I think a problem is with nodes definitions. In configs I found two nodes (Node0001 and v_DataMart_Node0001, or something like this) with the same ip. But admintools show only one node by that common ip. I guess it happened because I have not declared --data-dir parameter during installaton, and got default path for data /home/dbadmin. After that I made new database at /vdb (new directory), and get mess with nodes and paths.
Also maybe problem appeared as result of wrong --hosts parameter - I typed ip of my host 172.16... , not localhost 127.0.0.1 as some people advise.
Going just reinstall Vertica this morning with more precise parameterization.
SOLVED
Uninstalled Vertica and installed with new parameters
# /opt/vertica/sbin/install_vertica --hosts 127.0.0.1 -u dbadmin --data-dir /vdb
A lot of preset functions appeared in public.functions (in previous installation folder was empty) and extensions installed with no fails.
My previous installation was wrong
# /opt/vertica/sbin/install_vertica --hosts 172.16.1.39