MySQL Bugs: #115522: MySQL fails to build on centos 9 stream

Bug #115522	MySQL fails to build on centos 9 stream
Submitted:	5 Jul 2024 9:43	Modified:	5 Jul 2024 10:02
Reporter:	Amol Arote	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Compiling	Severity:	S3 (Non-critical)
Version:	8.0.38	OS:	Any
Assigned to:		CPU Architecture:	x86 (intel xeon)

Description:
CMake Error at configure.cmake:337 (MESSAGE):
  No mysys timer support detected!
Call Stack (most recent call first):
  CMakeLists.txt:1584 (INCLUDE)

-- Configuring incomplete, errors occurred!

How to repeat:
Runs on centos 9 stream with a5.14.0 kernel
Installed all gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils gcc-toolset-12-annobin-annocheck gcc-toolset-12-annobin-plugin-gcc

Hi Mr. Arote,

Thank you for your bug report.

However, let us inform you that this is a forum for the bugs with fully repeatable test cases.

You have not supplied the one.

You can either follow our building instructions from our Reference Manual, or much better, use an official binary form htttps://dev.mysql.com.

Can't repeat.

below steps i followed on centos 9 stream   

yum install zlib

yum install zlib-devel

yum install gcc

yum install gcc-c++

yum install ncurses

yum install ncurses-devel

yum install openssl

yum install openssl-devel

yum install libaio

yum install libaio-devel

yum install m4

yum install bison

yum install perl

yum install git 

yum install glibc-devel 

yum install glibc-headers

yum install cmake3

yum install cyrus-sasl-devel

yum install gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils gcc-toolset-12-annobin-annocheck gcc-toolset-12-annobin-plugin-gcc

yum  --enablerepo=crb install libtirpc-devel

yum install rpcgen

yum install libudev-devel

yum install perl-Data-Dumper

yum install epel-release

cd /opt/	

groupadd mysql

useradd -g mysql mysql

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-boost-8.0.38.tar.gz

tar -zxvf mysql-boost-8.0.38.tar.gz

mkdir /opt/mysql-8.0.38/build

cd mysql-8.0.38/build/

cmake3 ../ -DCMAKE_INSTALL_PREFIX=/opt/mysql    -DMYSQL_DATADIR=/opt/mysql/data -DWITH_BOOST=/opt/mysql-8.0.38/boost/boost_1_77_0/

Hi Mr. ARote,

Sorry, but your cmake command is not according to our recommendations .......

Please use cmake GUI and follow our Reference Manual.

Amol you may be interested in this: https://github.com/sjmudd/mysql-rpm-builder

I've seen several issues with builds on CentOS 9 failing due to some minor differences in the setup of CentOS 9 vs OL9. In theory the 2 OS versions should be the same but the packages provided with the compiler contain some minor differences.

For 8.0.39 (ignore 8.0.38 as it has bugs) you'll see I have a reproducible way to ensure the build process DOES work on this version.  The build failure error messages are not very clear and it took me a long while to figure out these minor differences to make the builds work.

I hope this is of use to you.

Thank you, Mr. Mudd, for your contribution.