This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
https://www.suse.com/support/kb/doc/?id=7022289
1. Edit /etc/ld.so.conf as below. Just add the first lile.
/lib64/noelision
/usr/local/lib64
/usr/local/lib
include /etc/ld.so.conf.d/*.conf
2. Run "ldconfig" command.
3. Run "ldconfig -p | grep noel" command. Result should be as below. It includes "noelision" in target path.
libpthread.so.0 (libc6,x86-64, OS ABI: Linux 3.0.0) => /lib64/noelision/libpthread.so.0
4. Run "ldd /opt/vertica/bin/vertica | grep libpthread" command. Result should be as below. It includes "noelision" in target path again.
libpthread.so.0 => /lib64/noelision/libpthread.so.0 (0x00007fd4c0275000)
5. Try to create database again.
Question
The problem only happens for Vertica 9.1.x version on SLES 12 with SP2-2P4 OS system.
Customer also tried to build the same OS with VirtualBox, and the DB creation can be done successfully.
But with the same OS system, customer can install Vertica 9.0.x package and startup normally.
Customer confirmed that after upgrade Vertica from 9.0 to 9.1 or 9.2, the issue will happen with startup failure.
So that means the issue only happens for Vertica 9.1/9.2 deployed on physical SLES 12 SP2/3/4
Customer also tried to build the same OS with VirtualBox, and the DB creation can be done successfully.
But with the same OS system, customer can install Vertica 9.0.x package and startup normally.
Customer confirmed that after upgrade Vertica from 9.0 to 9.1 or 9.2, the issue will happen with startup failure.
So that means the issue only happens for Vertica 9.1/9.2 deployed on physical SLES 12 SP2/3/4
Answer
1. Edit /etc/ld.so.conf as below. Just add the first lile./lib64/noelision/usr/local/lib64/usr/local/libinclude /etc/ld.so.conf.d/*.conf2. Run "ldconfig" command.3. Run "ldconfig -pgrep noel" command. Result should be as below. It includes "noelision" in target path.libpthread.so.0 (libc6,x86-64, OS ABI: Linux 3.0.0) => /lib64/noelision/libpthread.so.04. Run "ldd /opt/vertica/bin/verticagrep libpthread" command. Result should be as below. It includes "noelision" in target path again.libpthread.so.0 => /lib64/noelision/libpthread.so.0 (0x00007fd4c0275000)5. Try to create database again.