Compile error with 8.0.26-16

I use to complie Percona wih config below and it work until

[root@localhost percona-server-8.0.26-16]# mysql -V
mysql  Ver 8.0.25-15 for Linux on x86_64 (Source distribution)

With newest version 26-16, it is impossible because it missing alot of lib while i’m very sure i have all of these thing, otherwise my current 25-25 cannot compile or even works.

[root@localhost percona-server-8.0.26-16]# cmake -Wno-dev -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=Release -DFORCE_INSOURCE_BUILD=ON -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci -DINSTALL_INCLUDEDIR=/usr/include -DINSTALL_LAYOUT=STANDALONE -DINSTALL_LIBDIR=/usr/lib64/mysql -DINSTALL_PKGCONFIGDIR=/usr/lib64/pkgconfig -DMYSQLX_TCP_PORT=33060 -DMYSQLX_UNIX_ADDR=/tmp/mysqlx.sock -DMYSQL_DATADIR=/var/data/mysql -DMYSQL_MAINTAINER_MODE=OFF -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DSYSTEMD_PID_DIR=/var/data/mysql -DSYSTEMD_SERVICE_NAME=mysqld -DTMPDIR=/tmp -DWITH_BOOST=/soft/boost_1_73_0 -DWITH_CURL=system -DWITH_EDITLINE=bundled -DWITH_ICU=bundled -DWITH_INNODB_MEMCACHED=ON -DWITH_LIBEVENT=bundled -DWITH_LZ4=bundled -DWITH_NUMA=ON -DWITH_PROTOBUF=bundled -DWITH_RAPIDJSON=bundled -DWITH_SSL=/usr -DWITH_SYSTEMD=ON -DWITH_ZLIB=system -DWITH_ZSTD=bundled -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_TOKUDB=1 -DWITH_ROCKSDB=1
CMake Warning:
  No source or binary directory provided.  Both will be assumed to be the
  same as the current working directory, but note that this warning will
  become a fatal error in future CMake releases.


-- Running cmake version 3.22.0
-- Found Git: /usr/bin/git (found version "2.27.0")
-- This is .el8. as found from 'rpm -qf /'
-- Looking for a devtoolset compiler
-- Using /opt/rh/gcc-toolset-10/root/usr/bin/gcc
-- Using /opt/rh/gcc-toolset-10/root/usr/bin/g++
-- CMAKE_MODULE_PATH is /soft/percona-server-8.0.26-16/cmake
-- MySQL 8.0.26-16
-- The C compiler identification is GNU 10.3.1
-- The CXX compiler identification is GNU 10.3.1
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working C compiler: /opt/rh/gcc-toolset-10/root/usr/bin/gcc - skipped
-- Detecting C compile features
-- Detecting C compile features - done
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Check for working CXX compiler: /opt/rh/gcc-toolset-10/root/usr/bin/g++ - skipped
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Source directory /soft/percona-server-8.0.26-16
-- Binary directory /soft/percona-server-8.0.26-16
CMake Warning at CMakeLists.txt:459 (MESSAGE):
  This is an in-source build


-- CMAKE_GENERATOR: Unix Makefiles
-- Looking for SHM_HUGETLB
-- Looking for SHM_HUGETLB - found
-- Looking for sys/types.h
-- Looking for sys/types.h - found
-- Looking for stdint.h
-- Looking for stdint.h - found
-- Looking for stddef.h
-- Looking for stddef.h - found
-- Check size of void *
-- Check size of void * - done
-- SIZEOF_VOIDP 8
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD - Failed
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD - Failed
-- Packaging as: percona-server-8.0.26-16-Linux-x86_64
-- Performing Test C_LD_LLD_RESULT
-- Performing Test C_LD_LLD_RESULT - Failed
-- Performing Test CXX_LD_LLD_RESULT
-- Performing Test CXX_LD_LLD_RESULT - Failed
-- Performing Test C_LD_GOLD_RESULT
-- Performing Test C_LD_GOLD_RESULT - Failed
-- Performing Test CXX_LD_GOLD_RESULT
-- Performing Test CXX_LD_GOLD_RESULT - Failed
-- Local boost dir /soft/boost_1_73_0
-- Found /soft/boost_1_73_0/boost/version.hpp
-- BOOST_VERSION_NUMBER is #define BOOST_VERSION 107300
-- BOOST_INCLUDE_DIR /soft/boost_1_73_0
-- Enabling installation of systemd support files...
-- Checking for module 'systemd'
--   Found systemd, version 239
-- SYSTEMD_SERVICES_DIR /usr/lib/systemd/system
-- SYSTEMD_TMPFILES_DIR /usr/lib/tmpfiles.d
-- SYSTEMD_SERVICE_NAME mysqld
-- SYSTEMD_PID_DIR /var/data/mysql
-- Looking for pthread.h
-- Looking for pthread.h - not found
-- Could NOT find Threads (missing: Threads_FOUND)
-- Looking for floor
-- Looking for floor - not found
-- Looking for floor in m
-- Looking for floor in m - not found
-- Looking for log
-- Looking for log - not found
-- Looking for log in m
-- Looking for log in m - not found
-- Looking for gethostbyname_r
-- Looking for gethostbyname_r - not found
-- Looking for gethostbyname_r in nsl_r
-- Looking for gethostbyname_r in nsl_r - not found
-- Looking for gethostbyname_r in nsl
-- Looking for gethostbyname_r in nsl - not found
-- Looking for bind
-- Looking for bind - not found
-- Looking for bind in bind
-- Looking for bind in bind - not found
-- Looking for bind in socket
-- Looking for bind in socket - not found
-- Looking for setsockopt
-- Looking for setsockopt - not found
-- Looking for setsockopt in socket
-- Looking for setsockopt in socket - not found
-- Looking for dlopen
-- Looking for dlopen - not found
-- Looking for dlopen in dl
-- Looking for dlopen in dl - not found
-- Looking for dlsym
-- Looking for dlsym - not found
-- Looking for dlsym in dl
-- Looking for dlsym in dl - not found
-- Looking for sched_yield
-- Looking for sched_yield - not found
-- Looking for sched_yield in rt
-- Looking for sched_yield in rt - not found
-- Looking for clock_gettime
-- Looking for clock_gettime - not found
-- Looking for clock_gettime in rt
-- Looking for clock_gettime in rt - not found
-- Looking for timer_create
-- Looking for timer_create - not found
-- Looking for timer_create in rt
-- Looking for timer_create in rt - not found
-- Looking for backtrace
-- Looking for backtrace - not found
-- Looking for backtrace in execinfo
-- Looking for backtrace in execinfo - not found
-- Looking for include file alloca.h
-- Looking for include file alloca.h - not found
-- Looking for include file arpa/inet.h
-- Looking for include file arpa/inet.h - not found
-- Looking for include file dlfcn.h
-- Looking for include file dlfcn.h - not found
-- Looking for include file endian.h
-- Looking for include file endian.h - not found
-- Looking for include file execinfo.h
-- Looking for include file execinfo.h - not found
-- Looking for include file fpu_control.h
-- Looking for include file fpu_control.h - not found
-- Looking for include file grp.h
-- Looking for include file grp.h - not found
-- Looking for include file langinfo.h
-- Looking for include file langinfo.h - not found
-- Looking for include file malloc.h
-- Looking for include file malloc.h - not found
-- Looking for include file netinet/in.h
-- Looking for include file netinet/in.h - not found
-- Looking for include file poll.h
-- Looking for include file poll.h - not found
-- Looking for include file pwd.h
-- Looking for include file pwd.h - not found
-- Looking for include file strings.h
-- Looking for include file strings.h - not found
-- Looking for include file sys/ioctl.h
-- Looking for include file sys/ioctl.h - not found
-- Looking for include file sys/mman.h
-- Looking for include file sys/mman.h - not found
-- Looking for include file sys/prctl.h
-- Looking for include file sys/prctl.h - not found
-- Looking for include file sys/resource.h
-- Looking for include file sys/resource.h - not found
-- Looking for include file sys/select.h
-- Looking for include file sys/select.h - not found
-- Looking for include file sys/socket.h
-- Looking for include file sys/socket.h - not found
-- Looking for include files curses.h, term.h
-- Looking for include files curses.h, term.h - not found
-- Looking for include file termios.h
-- Looking for include file termios.h - not found
-- Looking for include file termio.h
-- Looking for include file termio.h - not found
-- Looking for include file unistd.h
-- Looking for include file unistd.h - not found
-- Looking for include file sys/wait.h
-- Looking for include file sys/wait.h - not found
-- Looking for include file sys/param.h
-- Looking for include file sys/param.h - not found
-- Looking for include file fnmatch.h
-- Looking for include file fnmatch.h - not found
-- Looking for include file sys/un.h
-- Looking for include file sys/un.h - not found
-- Looking for include files sys/types.h, sasl/sasl.h
-- Looking for include files sys/types.h, sasl/sasl.h - not found
-- Looking for _aligned_malloc
-- Looking for _aligned_malloc - not found
-- Looking for backtrace
-- Looking for backtrace - not found
-- Looking for index
-- Looking for index - not found
-- Looking for chown
-- Looking for chown - not found
-- Looking for cuserid
-- Looking for cuserid - not found
-- Looking for directio
-- Looking for directio - not found
-- Looking for ftruncate
-- Looking for ftruncate - not found
-- Looking for fchmod
-- Looking for fchmod - not found
-- Looking for fcntl
-- Looking for fcntl - not found
-- Looking for fdatasync
-- Looking for fdatasync - not found
-- Looking for fdatasync
-- Looking for fdatasync - not found
-- Looking for fedisableexcept
-- Looking for fedisableexcept - not found
-- Looking for fsync
-- Looking for fsync - not found
-- Looking for gethrtime
-- Looking for gethrtime - not found
-- Looking for getpass
-- Looking for getpass - not found
-- Looking for getpassphrase
-- Looking for getpassphrase - not found
-- Looking for getpwnam
-- Looking for getpwnam - not found
-- Looking for getpwuid
-- Looking for getpwuid - not found
-- Looking for getrusage
-- Looking for getrusage - not found
-- Looking for initgroups
-- Looking for initgroups - not found
-- Looking for issetugid
-- Looking for issetugid - not found
-- Looking for getuid
-- Looking for getuid - not found
-- Looking for geteuid
-- Looking for geteuid - not found
-- Looking for getgid
-- Looking for getgid - not found
-- Looking for getegid
-- Looking for getegid - not found
-- Looking for madvise
-- Looking for madvise - not found
-- Looking for malloc_info
-- Looking for malloc_info - not found
-- Looking for mlock
-- Looking for mlock - not found
-- Looking for mlockall
-- Looking for mlockall - not found
-- Looking for mmap64
-- Looking for mmap64 - not found
-- Looking for poll
-- Looking for poll - not found
-- Looking for posix_fallocate
-- Looking for posix_fallocate - not found
-- Looking for posix_memalign
-- Looking for posix_memalign - not found
-- Looking for pthread_condattr_setclock
-- Looking for pthread_condattr_setclock - not found
-- Looking for pthread_getaffinity_np
-- Looking for pthread_getaffinity_np - not found
-- Looking for pthread_sigmask
-- Looking for pthread_sigmask - not found
-- Looking for sleep
-- Looking for sleep - not found
-- Looking for stpcpy
-- Looking for stpcpy - not found
-- Looking for stpncpy
-- Looking for stpncpy - not found
-- Looking for strlcpy
-- Looking for strlcpy - not found
-- Looking for strndup
-- Looking for strndup - not found
-- Looking for strlcat
-- Looking for strlcat - not found
-- Looking for strptime
-- Looking for strptime - not found
-- Looking for strsignal
-- Looking for strsignal - not found
-- Looking for tell
-- Looking for tell - not found
-- Looking for vasprintf
-- Looking for vasprintf - not found
-- Looking for memalign
-- Looking for memalign - not found
-- Looking for nl_langinfo
-- Looking for nl_langinfo - not found
-- Looking for ntohll
-- Looking for ntohll - not found
-- Looking for memset_s
-- Looking for memset_s - not found
-- Looking for epoll_create
-- Looking for epoll_create - not found
-- Looking for include file sys/time.h
-- Looking for include file sys/time.h - not found
-- Looking for include file sys/times.h
-- Looking for include file sys/times.h - not found
-- Looking for times
-- Looking for times - not found
-- Looking for gettimeofday
-- Looking for gettimeofday - not found
-- Looking for lrand48
-- Looking for lrand48 - not found
-- Looking for TIOCGWINSZ
-- Looking for TIOCGWINSZ - not found
-- Looking for FIONREAD
-- Looking for FIONREAD - not found
-- Looking for FIONREAD
-- Looking for FIONREAD - not found
-- Looking for MADV_DONTDUMP
-- Looking for MADV_DONTDUMP - not found
-- Performing Test HAVE_O_TMPFILE
-- Performing Test HAVE_O_TMPFILE - Failed
-- Looking for timer_create
-- Looking for timer_create - not found
-- Looking for timer_settime
-- Looking for timer_settime - not found
-- Looking for kqueue
-- Looking for kqueue - not found
-- Performing Test HAVE_SETNS
-- Performing Test HAVE_SETNS - Failed
-- Looking for EVFILT_TIMER
-- Looking for EVFILT_TIMER - not found
CMake Error at configure.cmake:335 (MESSAGE):
  No mysys timer support detected!
Call Stack (most recent call first):
  CMakeLists.txt:1341 (INCLUDE)

Is that something change that i should know? I tried to search “what’s new” but i didnt see anything change with compile command .

Rocket Linux 8.5

1 Like

Hi @abh
This is a known issue.
You should have gcc-toolset-10-annobin package installed.
Also you could use our build script to build all binaries.
Here is the blogpost which should help you with the script usage How to Build Percona Server for MySQL From Sources - Percona Database Performance Blog

2 Likes

Thank @Evgeniy_Patlan for update.

I use to build by my own script about and to be honest, never try the script provide by Percona because im not sure if the script allow me to change the folder location as i way i need or not.

1 Like