Vertica strings_packge( and group_concat) Upgrade

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

Comments

  • SruthiASruthiA Employee, Registered User, VerticaExpert

    HI,

     

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

     

     

    Sruthi

  • yardenbaryardenbar Registered User

    Hi,

    Got the same error:

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

     

     

  • yardenbaryardenbar Registered User

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

     

    Queries runs normally now :)

     

    Thank you!

  • AnitaM77AnitaM77 Registered User

    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!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file