Bug #117993 cmake failed MySQL 9.3.0 + Oracle Linux 8.10

• Submitted: 16 Apr 2:12
• Modified: 18 Apr 5:25
• Reporter: Tsubasa Tanaka (OCA)
• Status: Can't repeat
• Category: MySQL Server: Compiling
• Severity: S3 (Non-critical)
• Version: 9.3.0
• OS: Oracle Linux (8.10)
• CPU Architecture: Any

[16 Apr 2:12] Tsubasa Tanaka

Description:
cmake errors when trying to compile MySQL 9.3.0.
See "How to repeat".

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

How to repeat:
$ wget https://dev.mysql.com/get/Downloads/MySQL-9.3/mysql-9.3.0.tar.gz
$ tar xf mysql-9.3.0.tar.gz
$ cd mysql-9.3.0
$ cmake -DCMAKE_INSTALL_PREFIX=/usr/mysql/9.3.0 -DMINIMAL_RELWITHDEBINFO=OFF -DFORCE_INSOURCE_BUILD=1

Suggested fix:
Maybe OL8 have to use gcc-toolset-14 for MySQL 9.3.0.

$ diff CMakeLists.txt{.orig,}
325c325
<         SET(ALTERNATIVE_PATHS "/opt/rh/gcc-toolset-13")
---
>         SET(ALTERNATIVE_PATHS "/opt/rh/gcc-toolset-14")

https://github.com/mysql/mysql-server/blob/mysql-9.3.0/CMakeLists.txt#L324-L325

[16 Apr 2:14] Tsubasa Tanaka

$ vim CMakeLists.txt   ### Fix
$ rm CMakeCache.txt

$ cmake -DCMAKE_INSTALL_PREFIX=/usr/mysql/9.3.0 -DMINIMAL_RELWITHDEBINFO=OFF -DFORCE_INSOURCE_BUILD=1 ### Works well

[16 Apr 7:17] MySQL Verification Team

Hello Tanaka San,

Thank you for the report and feedback.
I quickly followed your steps and tried to verify but not seeing any issues at my end. Am I missing something here? Thank you.

Joining the log shortly.

regards,
Umesh

[16 Apr 7:18] MySQL Verification Team

9.3.0 build on OL 8.10

Attachment: 117993.build (application/octet-stream, text), 32.62 KiB.

[18 Apr 1:49] Tsubasa Tanaka

Hello, Umesh.

I tried to build 9.3.0 again at freshly installed Oracle Linux 8.

```
$ wget https://dev.mysql.com/get/Downloads/MySQL-9.3/mysql-9.3.0.tar.gz
$ tar xf mysql-9.3.0.tar.gz
$ cd mysql-9.3.0/
$ sudo dnf install -y cmake

sudo yum install gcc-toolset-13-gcc gcc-toolset-13-gcc-c++ gcc-toolset-13-binutils gcc-toolset-13-annobin-annocheck gcc-toolset-13-annobin-plugin-gcc
$ sudo dnf install -y --enablerepo=ol8_codeready_builder openssl-devel ncurses-devel libtirpc-devel rpcgen cpp
$ rm CMakeCache.txt
$ cmake -DCMAKE_INSTALL_PREFIX=/usr/mysql/9.3.0 -DMINIMAL_RELWITHDEBINFO=OFF -DFORCE_INSOURCE_BUILD=1
```

And I didn't get error, cmake & make succeeded as same as you explained me.
Therefore, my issue depends on my first environment.

Sorry for bothering you, that's my fault.
Can you change the status to "Not a Bug" or "Can't repeat" ?

[18 Apr 5:25] MySQL Verification Team

Thank you, Tanaka San for re-testing this.
For now I'll mark it as "Can't repeat" but please feel free to re-open if needed. 

Sincerely,
Umesh