Wrong version of libboost_system.so

[David Gleba]

I have a columnstore version 1.0.11 (I think) running on ubuntu.

I upgraded ubuntu from 16.04 to 18.04 to 20.04.

Now I get this error:

mcsadmin shutdownsystem y

/usr/local/mariadb/columnstore/bin/mcsadmin: error while loading shared libraries: libboost_system.so.1.58.0: cannot open shared object file: No such file or directory

This is on the system:

albe@pmdsdata6:~$ locate libboost_system
[some lines removed]

/usr/lib/x86_64-linux-gnu/libboost_system.so
/usr/lib/x86_64-linux-gnu/libboost_system.so.1.71.0

ls:

-rw-r--r-- 1 root root  1396 Apr  1  2020  libboost_system.a
lrwxrwxrwx 1 root root    25 Apr  1  2020  libboost_system.so -> libboost_system.so.1.71.0
-rw-r--r-- 1 root root 13960 Apr  1  2020  libboost_system.so.1.71.0

Since I can't shut down the columnstore, I can't upgrade it.

I tried to symlink 1.58.0 to 1.71.0, but that didn't resolve it.

Any idea how I can fix this?

[drrtuy]

Hi,

If you close Columnstore from any workload stopping MariaDB(to be sure there are no changes in the cluster when you shut it down) and backup data in /usr/local/mariadb/columnstore/lib/data1/systemFiles you are able to shut down MCS manually.

But I don't think this will solve your problem b/c 1.0.11 depends on the old boost library. If you want to go on with MCS 1.0.11 you can compile boost manually or try to update 1.0.11 to the latest MariaDB 10.9 with the columnstore available. IIRC U20 should support MDB 10.9.

There are lots of difference b/w 1.0.11 and MDB 10.9 with MCS engine but they are binary compatible so you can update. I strongly suggest you to try it in a test environment before doing the upgrade in production.

Regards,

Roman

пятница, 24 июня 2022 г. в 22:27:19 UTC+3, dgl...@gmail.com: