mysql 5.5 fails to build.

[Martin Wilke]

Hi,

I facing since a while on all my servers that mysql 5.5.20 fails to build. Have anyone of you seen something like that,

/usr/include/sys/timeb.h:42:2: warning: #warning "this file includes <sys/timeb.h> which is deprecated"
[ 96%] Building CXX object sql/CMakeFiles/sql.dir/datadict.cc.o
[ 96%] Building CXX object sql/CMakeFiles/sql.dir/sql_reload.cc.o
[ 96%] Building CXX object sql/CMakeFiles/sql.dir/sql_truncate.cc.o
In file included from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/include/my_global.h:351,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/mysqld.h:19,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/handler.h:29,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/datadict.h:18,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/datadict.cc:16:
/usr/include/sys/timeb.h:42:2: warning: #warning "this file includes <sys/timeb.h> which is deprecated"
In file included from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/include/my_global.h:351,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/debug_sync.h:29,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/sql_truncate.cc:16:
/usr/include/sys/timeb.h:42:2: warning: #warning "this file includes <sys/timeb.h> which is deprecated"
In file included from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/include/my_global.h:351,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/mysqld.h:19,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/sql_reload.cc:18:
/usr/include/sys/timeb.h:42:2: warning: #warning "this file includes <sys/timeb.h> which is deprecated"
[ 96%] Building CXX object sql/CMakeFiles/sql.dir/sql_yacc.cc.o
[ 96%] Building CXX object sql/CMakeFiles/sql.dir/sql_builtin.cc.o
In file included from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/include/my_global.h:351,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/unireg.h:20,
                 from /export/home/pb2/build/sb_0-4575772-1324064860.06/mysql-5.5.20-release-basket-export_GPL-2891819/sql/sql_yacc.yy:41:
/usr/include/sys/timeb.h:42:2: warning: #warning "this file includes <sys/timeb.h> which is deprecated"
[ 96%] Building C object sql/CMakeFiles/sql.dir/__/mysys/my_libwrap.c.o
In file included from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/include/my_global.h:351,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/mysys/my_libwrap.c:21:
/usr/include/sys/timeb.h:42:2: warning: #warning "this file includes <sys/timeb.h> which is deprecated"
[ 96%] Building CXX object sql/CMakeFiles/sql.dir/sql_lex.cc.o
In file included from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/include/my_global.h:351,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/unireg.h:20,
                 from /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/sql/sql_lex.cc:21:
/usr/include/sys/timeb.h:42:2: warning: #warning "this file includes <sys/timeb.h> which is deprecated"
Linking CXX static library libsql_embedded.a
[ 96%] Built target sql_embedded
[ 96%] Generating mysqlserver_depends.c
Scanning dependencies of target mysqlserver
[ 97%] Building C object libmysqld/CMakeFiles/mysqlserver.dir/mysqlserver_depends.c.o
Linking C static library libmysqld.a
ar: warning: creating /var/ports/usr/ports/databases/mysql55-server/work/mysql-5.5.20/libmysqld/libmysqld.a
[ 97%] Built target mysqlserver
Linking CXX static library libsql.a
[ 97%] Built target sql
Scanning dependencies of target mysqld
[ 97%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o
Linking CXX executable mysqld
../storage/innobase/libinnobase.a(row0merge.c.o): In function `row_merge_write':
row0merge.c:(.text+0x571): undefined reference to `posix_fadvise'
../storage/innobase/libinnobase.a(row0merge.c.o): In function `row_merge_read':
row0merge.c:(.text+0x968): undefined reference to `posix_fadvise'
../storage/innobase/libinnobase.a(row0merge.c.o): In function `row_merge_build_indexes':
row0merge.c:(.text+0x1f08): undefined reference to `posix_fadvise'
*** Error code 1
1 error
*** Error code 2
1 error
*** Error code 2
1 error
*** Error code 1

Stop in /usr/ports/databases/mysql55-server.
*** Error code 1

In the tinderbox builds fine.


Some infos about the system  

FreeBSD 9.0-STABLE #1 r229835: Mon Jan  9 04:11:49 CET 2012, 
Filesystem is ZFS, and all mysql servers running in a jail.

Any idea?

- Martin







+-----------------oOO--(_)--OOo-------------------------+
With best Regards,
       Martin Wilke (miwi_(at)_FreeBSD.org)

Mess with the Best, Die like the Rest