Vertica strings_packge( and group_concat) Upgrade

Forum|Forum|10 years ago
February 21, 2016
6 replies
9 views

yardenbar
Participating Frequently

Hi,

I've Upgraded our Vertica cluster from 6.1.3 to latest 7.2.1-0. The database was originally copied with a vbr.py copy-cluster command from our previous hosting(Vertica version 6.1.3) to AWS Vertica cluster(Vertica version 7.2.1).

For an unknown reason, I've getting the below error:
ERROR 6999: The library [GroupConcatLib] for the function [group_concat(varchar)] was compiled with an incompatible SDK Version [v6.1.0-0]
HINT: Recompile the library with the SDK version [7.2.1] and then recreate the library and functions

I've cloned Vertica-Extension-Packages and ran:

cd strings-package

make install

Got the below output:
==============================================
vsql -f ddl/install.sql
Password:
version
------------------------------------
Vertica Analytic Database v7.2.1-0
(1 row)

CREATE LIBRARY
CREATE FUNCTION
CREATE FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE FUNCTION
CREATE TRANSFORM FUNCTION
vsql:ddl/install.sql:16: ROLLBACK 3472: Function with same name and number of parameters already exists: group_concat
==============================================

Tried also to run 'make uninstall' followed by 'make install' but it didn't help.

Thanks in advance,

Yarden

SruthiA
Participating Frequently
Forum|Forum|10 years ago
February 21, 2016

HI,

Please try by runing make command before installing strings package using install.sql

Sruthi

yardenbar
Author
Participating Frequently
Forum|Forum|10 years ago
February 22, 2016

Hi,

Got the same error:

vsql:ddl/install.sql:16: ROLLBACK 3472: Function with same name and number of parameters already exists: group_concat

yardenbar
Author
Participating Frequently
Forum|Forum|10 years ago
February 22, 2016

I've dropped the manually install GroupConcat library and successfully installed the strings_package.

Queries runs normally now

Thank you!

AnitaM77
Participating Frequently
Forum|Forum|7 years ago
May 1, 2019

Hello,
Running into issue like this -
make: Entering directory /opt/vertica/packages/Vertica-Extension-Packages-master/strings_package' g++ -g -D HAVE_LONG_LONG_INT_64 -c -I ../include -Wall -Wno-unused-value -fPIC -I /opt/vertica/sdk/include -I /opt/vertica/packages/Vertica-Extension-Packages-master/strings_package/src/third-party/include -O3 -DNDEBUG /opt/vertica/sdk/include/Vertica.cpp -o build/Vertica.o In file included from /opt/vertica/sdk/include/Vertica.h:75:0, from /opt/vertica/sdk/include/Vertica.cpp:38: /opt/vertica/sdk/include/VerticaUDx.h: In member function ‘void Vertica::UDXObject::cancelUDX(Vertica::ServerInterface&)’: /opt/vertica/sdk/include/VerticaUDx.h:2305:57: error: operand type ‘bool*’ is incompatible with argument 1 of ‘__sync_fetch_and_or’ if (!__sync_fetch_and_or(&(this->canceled), true)) { ^ make: *** [build/Vertica.o] Error 1 make: Leaving directory/opt/vertica/packages/Vertica-Extension-Packages-master/strings_package'

We have upgraded to 9.2 and just installing the extension packages, running into this error.

When executing group_concat, the error is -
The library [StringsLib] for the function [group_concat(varchar)] was compiled with an incompatible SDK Version [8.1.1].

Any pointers please? Thanks!

ymenchik
New Participant
Forum|Forum|7 years ago
July 22, 2019

We are facing the below error after upgrading to 9.2.1-3:
[Code: 3399, SQL State: VP001] [Vertica]VJDBC ROLLBACK: Failure in UDx RPC call InvokeGetLibraryInfo(): Error calling setupExecContext() in User Defined Object [] at [/data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_1-x_grader/build/vertica/OSS/UDxFence/vertica-udx-C++.cpp:274], error code: 0, message: Error happened in dlopen(): [/outbrain/vertica/home/udx/Vertica-Extension-Packages/strings_package/lib/StringsLib.so: cannot open shared object file: No such file or directory]
@AnitaM77 - were you able to solve this?