Recompiling the fjsonparser

Hi All,

 

I'm trying to load some json data with the fjsonparser but I've received the following error:

 

ERROR 6999: The library [FlexTableLib] for the function [fjsonparser()] was compiled with an incompatible SDK Version [v7.1.2-4]
HINT: Recompile the library with the SDK version [7.2.1] and then recreate the library and functions

 

I am running Vertica 7.2.1, but I have absolutely no idea where the source for fjsonparser might be, or how to recompile it.  Any pointers would be greatly appreciated!

 

Thanks!

Comments

  • Hi!

     

    1. Post full version of your Vertica instance(with minor fixes).

    Hint: select version();

    daniel=> select version();
    version
    ------------------------------------
    Vertica Analytic Database v7.2.1-1
    (1 row)

     

    2. Post your OS distribution + version.

    For example:

    (~)$ cat << EOF | python
    import platform as os
    print '*' * 20
    print os.linux_distribution()
    print os.uname()
    EOF
    ********************
    ('Ubuntu', '14.04', 'trusty')
    ('Linux', 'synapse', '3.13.0-74-generic', '#118-Ubuntu SMP Thu Dec 17 22:52:10 UTC 2015', 'x86_64', 'x86_64')

     

    3. Post content of dir: /opt/vertica/packages/flextable/lib

    For example:

     

    (~)$ ls -1l  /opt/vertica/packages/flextable/lib
    total 11768
    lrwxrwxrwx 1 root root 29 Dec 16 02:30 libvertica_flextable.so -> libvertica_flextable.so.7.2.1
    -rw-r--r-- 1 root root 12048320 Dec 16 01:48 libvertica_flextable.so.7.2.1

     

    3. Post md5sum of /opt/vertica/packages/flextable/lib/libvertica_flextable.so

    For example:

     

    (/opt/vertica/packages/flextable/lib)$ md5sum ./libvertica_flextable.so
    05e6c13e03cdaae66aac0c78b9dfe431 ./libvertica_flextable.so

     

    4. Post output of file.

    For example:

    (/opt/vertica/packages/flextable/lib)$ file ./libvertica_flextable.so.7.2.1 
    ./libvertica_flextable.so.7.2.1: ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked, BuildID[sha1]=72738bb8a579ebb2f7afa9cf7eec2011f23a1877, not stripped

     

    PS

    >> but I have absolutely no idea where the source for fjsonparser might be

    It's not open source, actuaally you can't recompile by yourself.

     

    Disclimer: Im not a Vertica employee.

  • Hi,

     

      You appear to have experienced an upgrade issue that we're currently investigating.  You actually have the right version of Flex in /opt/vertica/packages, it just needs to get installed:

     

      /opt/vertica/bin/admintools -T install_package -P default -d <database> -p <password>

     

      Note: do not uninstall flex - there is no need to uninstall/install.  Just install over the top of the existing old flex package.

     

      Please let me know if this works.

     

    -Ben

Leave a Comment

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