Bug #90906 mysql compile error

• Submitted: 17 May 2018 9:02
• Modified: 16 Nov 2018 13:49
• Reporter: ben sun
• Status: Won't fix
• Category: MySQL Server: Compiling
• Severity: S2 (Serious)
• Version: 8.0.11
• OS: CentOS (6.5)
• CPU Architecture: Any (Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz)

[17 May 2018 9:02] ben sun

Description:
mysql-boost-8.0.11.tar.gz md5 is right.
Linux localhost 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
gcc (GCC) 4.8.2   cmake version 3.11.1
mkdir bld;cd bld
cmake  .. -DCMAKE_INSTALL_PREFIX=/data -DMYSQL_DATADIR=/data -DMYSQL_UNIX_ADDR=/data/mysql.sock -DINSTALL_LIBDIR=/data/lib/mysql -DSYSCONFDIR=/etc -DENABLED_LOCAL_INFILE=ON -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1  -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BOOST=../boost/boost_1_66_0/ -DWITH_UNIT_TESTS=OFF
make -j4
[100%] Linking CXX static library ../archive_output_directory/libsql_main.a
[100%] Built target sql_main
Scanning dependencies of target mysqld
[100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o
[100%] Linking CXX executable ../runtime_output_directory/mysqld
../archive_output_directory/libtemptable.a(handler.cc.o): In function `temptable::Handler::delete_table(char const*, dd::Table 
/data/soft/mysql-8.0.11/sql/table.h:3288: undefined reference to `_ZTHN9temptable6tablesE'
/data/soft/mysql-8.0.11/sql/table.h:3288: undefined reference to `_ZTHN9temptable6tablesE'
/data/soft/mysql-8.0.11/sql/table.h:3288: undefined reference to `_ZTHN9temptable6tablesE'
../archive_output_directory/libtemptable.a(handler.cc.o): In function `temptable::Handler::open(char const*, int, unsigned int,
/data/soft/mysql-8.0.11/sql/table.h:3288: undefined reference to `_ZTHN9temptable6tablesE'
/data/soft/mysql-8.0.11/sql/table.h:3288: undefined reference to `_ZTHN9temptable6tablesE'
../archive_output_directory/libtemptable.a(handler.cc.o):/data/soft/mysql-8.0.11/sql/table.h:3288: more undefined references to
collect2: 错误：ld 返回 1
make[2]: *** [runtime_output_directory/mysqld] 错误 1
make[1]: *** [sql/CMakeFiles/mysqld.dir/all] 错误 2
make: *** [all] 错误 2
[root@localhost bld]# pwd

How to repeat:
make again,

[18 May 2018 7:51] Terje Røsten

Hi!

This is duplicate of #90734 :
 https://bugs.mysql.com/bug.php?id=90734

[18 May 2018 7:52] MySQL Verification Team

Hello ben sun,

Thank you for the report!
Observed this on CentOS6.9 and with gcc 4.8.2.

Thanks,
Umesh

[18 May 2018 7:53] MySQL Verification Team

# No issues observed on OL7 with provided cmake and gcc 4.8.3

[umshastr@hod03]/export/umesh/server/source/bugs/src_build/90898/90906/mysql-8.0.11/bld: cmake --version
cmake version 2.8.12.2
[umshastr@hod03]/export/umesh/server/source/bugs/src_build/90898/90906/mysql-8.0.11/bld: gcc --version
gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9)
Copyright (C) 2013 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

[18 May 2018 7:54] MySQL Verification Team

Build details

Attachment: 90906_CentOS6.build (application/octet-stream, text), 257.95 KiB.

[18 May 2018 7:56] Terje Røsten

Note:

 for compiling MySQL 8.0 on el6 and el7, it's recommended to install
 Devtoolset 7.

 For CentOS, please read:
    https://lists.centos.org/pipermail/centos-announce/2017-November/022641.html

[16 Nov 2018 13:49] Dyre Tjeldvoll

Posted by developer:
 
Need to use the approved compilers and/or compiler versions.