GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Compilation Blows up

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Compilation Blows up

    I cannot compile the application on RHEl 6.1 fully updated.
    I started with
    cmake . -DBUILD_CONFIG=mysql_release -DCMAKE_INSTALL_PREFIX=/usr/mysql

    and did "make"
    These are the errors:

    Scanning dependencies of target mysql_client_test_embedded
    [100%] Building C object libmysqld/examples/CMakeFiles/mysql_client_test_embedded.dir /__/__/tests/mysql_client_test.c.o
    Linking CXX executable mysql_client_test_embedded
    ../libmysqld.a(lib_sql.cc.o): In function `clean_up':
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1509: undefined reference to `query_response_time_free()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1511: undefined reference to `free_global_user_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1512: undefined reference to `free_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1513: undefined reference to `free_global_thread_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1514: undefined reference to `free_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1515: undefined reference to `free_global_index_stats()'
    ../libmysqld.a(lib_sql.cc.o): In function `init_server_components':
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4061: undefined reference to `query_response_time_init()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4064: undefined reference to `init_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4065: undefined reference to `init_global_index_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4203: undefined reference to `init_global_user_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4204: undefined reference to `init_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4205: undefined reference to `init_global_thread_stats()'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_reset(THD*, char*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:30 14: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_fetch(THD*, char*, unsigned int)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:28 88: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_execute(THD*, char*, unsigned int)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:27 13: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_prepare(THD*, char const*, unsigned int)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:22 73: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_parse.cc.o): In function `log_slow_statement(THD*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:1531 : undefined reference to `query_response_time_collect(unsigned long long)'
    ../libmysqld.a(sql_parse.cc.o): In function `mysql_parse(THD*, char*, unsigned int, Parser_state*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:5807 : undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_show.cc.o).data.rel+0x598): undefined reference to `query_response_time_fill(THD*, TABLE_LIST*, Item*)'
    ../libmysqld.a(sql_reload.cc.o): In function `reload_acl_and_cache(THD*, unsigned long, TABLE_LIST*, int*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:315 : undefined reference to `free_global_index_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:316 : undefined reference to `init_global_index_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:308 : undefined reference to `free_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:309 : undefined reference to `init_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:300 : undefined reference to `query_response_time_flush()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:334 : undefined reference to `free_global_thread_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:335 : undefined reference to `init_global_thread_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:329 : undefined reference to `free_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:330 : undefined reference to `init_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:324 : undefined reference to `free_global_user_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:325 : undefined reference to `init_global_user_stats()'
    ../libmysqld.a(ha_innodb.cc.o): In function `innobase_commit_low':
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    ../libmysqld.a(ha_innodb.cc.o): In function `innobase_init':
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to `init_strvar_from_file(char*, int, st_io_cache*, char const*)'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to `init_intvar_from_file(int*, st_io_cache*, int)'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to `init_strvar_from_file(char*, int, st_io_cache*, char const*)'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to `init_intvar_from_file(int*, st_io_cache*, int)'
    ../libmysqld.a(ha_innodb.cc.o): In function `innobase_commit_low':
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    ../libmysqld.a(ha_innodb.cc.o):/usr/src/Percona-Server-5.5.1 6-rel22.0/storage/innobase/handler/ha_innodb.cc:3103: more undefined references to `active_mi' follow
    collect2: ld returned 1 exit status
    make[2]: *** [libmysqld/examples/mysql_client_test_embedded] Error 1
    make[1]: *** [libmysqld/examples/CMakeFiles/mysql_client_test_embedded.di r/all] Error 2
    make: *** [all] Error 2Scanning dependencies of target mysql_client_test_embedded
    [100%] Building C object libmysqld/examples/CMakeFiles/mysql_client_test_embedded.dir /__/__/tests/mysql_client_test.c.o
    Linking CXX executable mysql_client_test_embedded
    ../libmysqld.a(lib_sql.cc.o): In function `clean_up':
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1509: undefined reference to `query_response_time_free()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1511: undefined reference to `free_global_user_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1512: undefined reference to `free_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1513: undefined reference to `free_global_thread_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1514: undefined reference to `free_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1515: undefined reference to `free_global_index_stats()'
    ../libmysqld.a(lib_sql.cc.o): In function `init_server_components':
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4061: undefined reference to `query_response_time_init()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4064: undefined reference to `init_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4065: undefined reference to `init_global_index_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4203: undefined reference to `init_global_user_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4204: undefined reference to `init_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4205: undefined reference to `init_global_thread_stats()'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_reset(THD*, char*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:30 14: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_fetch(THD*, char*, unsigned int)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:28 88: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_execute(THD*, char*, unsigned int)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:27 13: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_prepare.cc.o): In function `mysqld_stmt_prepare(THD*, char const*, unsigned int)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:22 73: undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_parse.cc.o): In function `log_slow_statement(THD*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:1531 : undefined reference to `query_response_time_collect(unsigned long long)'
    ../libmysqld.a(sql_parse.cc.o): In function `mysql_parse(THD*, char*, unsigned int, Parser_state*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:5807 : undefined reference to `update_global_user_stats(THD*, bool, long)'
    ../libmysqld.a(sql_show.cc.o).data.rel+0x598): undefined reference to `query_response_time_fill(THD*, TABLE_LIST*, Item*)'
    ../libmysqld.a(sql_reload.cc.o): In function `reload_acl_and_cache(THD*, unsigned long, TABLE_LIST*, int*)':
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:315 : undefined reference to `free_global_index_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:316 : undefined reference to `init_global_index_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:308 : undefined reference to `free_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:309 : undefined reference to `init_global_table_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:300 : undefined reference to `query_response_time_flush()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:334 : undefined reference to `free_global_thread_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:335 : undefined reference to `init_global_thread_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:329 : undefined reference to `free_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:330 : undefined reference to `init_global_client_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:324 : undefined reference to `free_global_user_stats()'
    /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:325 : undefined reference to `init_global_user_stats()'
    ../libmysqld.a(ha_innodb.cc.o): In function `innobase_commit_low':
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    ../libmysqld.a(ha_innodb.cc.o): In function `innobase_init':
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to `init_strvar_from_file(char*, int, st_io_cache*, char const*)'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to `init_intvar_from_file(int*, st_io_cache*, int)'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to `init_strvar_from_file(char*, int, st_io_cache*, char const*)'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to `init_intvar_from_file(int*, st_io_cache*, int)'
    ../libmysqld.a(ha_innodb.cc.o): In function `innobase_commit_low':
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to `active_mi'
    ../libmysqld.a(ha_innodb.cc.o):/usr/src/Percona-Server-5.5.1 6-rel22.0/storage/innobase/handler/ha_innodb.cc:3103: more undefined references to `active_mi' follow
    collect2: ld returned 1 exit status
    make[2]: *** [libmysqld/examples/mysql_client_test_embedded] Error 1
    make[1]: *** [libmysqld/examples/CMakeFiles/mysql_client_test_embedded.di r/all] Error 2
    make: *** [all] Error 2

  • #2
    Hello, can you find the build-binary.sh script in your copy of the tree? That script should fetch all dependencies before running make.

    Also, have you tried to install the binary instead?:

    http://www.percona.com/doc/percona-server/5.5/installation/y um_repo.html

    Comment


    • #3
      I downloaded the binaries using yum, and it installed, but It is still using my old my.cnf. How do I get an ideal, maxed out my.cnf for a box with 127 GB, dedicated to mysql? The business issue is this: I have a table with 340 Million records, 3 columns, 2 Bigint and 1 varchar(4). I need to load the table in RAM for the predictable response for a query based on the primary key (first Bigint) must be 1/4 of a second. Can I achieve this with Percona?

      Comment


      • #4
        There is something wrong with the software. I inserted 274 million rows in an innodb table. I stopped and tried to shut down the mysql server. It took 15 mins stopping and it failed like this:

        Shutting down MySQL (Percona Server)........................................... .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... ....... ERROR!

        Comment


        • #5
          I need some help compiling from sources. There is no file build-binary.sh and I need to install the server to a particular location, not the default location. Unless that can be done with the binary version. Any way, the sources should compile no matter what, in RHEL 6.1.

          Comment


          • #6
            The source code compiles if you have all prerequisites installed on your RHEL 6.1.
            But I recommend against compiling your own if you are not sure about it.

            Use the general Linux Binary instead.
            It is a simple .tar.gz which you can unpack at the location of your choosing.
            But since you want to place it in a custom location you will need to fix things like ownership of directories and init startup/shutdown scripts etc.

            And if you want to place the data directory in some other place than in a sub-directory to the installation folder then you will have to modify the my.cnf file accordingly.

            As for the settings for your box something like:

            innodb_buffer_pool_size = 100G


            Will bring you a long way since according to my very rough calculations your table shouldn't be more than about 15-20G.


            And if you have a lot of writes then you can consider something like:
            innodb_log_buffer = 8M
            innodb_log_file_size = 128M

            And depending on if you have a BBU RAID controller or are willing to loose some data in case of a OS crash then you can trade robustness for speed:
            innodb_flush_log_at_trx_commit = 2

            Comment

            Working...
            X