Create DB failure on 9.1 or 9.2 with SUSE 12 SP2-SP4

  • KM03528016
  • 20-Sep-2019
  • 20-Sep-2019

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

Answer

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.