Recompiling the fjsonparser

sjyu

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!

sKwa

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.

Ben_Vandiver

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