Spider for MySQL

  1. Bug #780347
  2. Activity log

Activity log for bug #780347

Date Who What changed Old value New value Message
2011-05-10 07:25:28 Ashish Disawal bug added bug
2011-05-10 07:26:13 Ashish Disawal description tar -zxvf mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0.tgz cd mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0 #### List configure options $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON -L ##### CMake $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON . $ make Linking CXX static library libsql.a [ 99%] Built target sql Scanning dependencies of target mysqld [100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o Linking CXX executable mysqld ../storage/spider/libspider.a(spd_param.cc.o):(.data+0xd60): multiple definition of `mysql_sysvar_bgs_mode' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x180): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x1660): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_interval' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2a0): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x16a0): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_rows' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2e0): first defined here collect2: ld returned 1 exit status make[2]: *** [sql/mysqld] Error 1 make[1]: *** [sql/CMakeFiles/mysqld.dir/all] Error 2 make: *** [all] Error 2 ##### After I did $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=OFF . $ make clean $ make All went fine without any errors. $ tar -zxvf mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0.tgz $ cd mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0 #### List configure options $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON -L ##### CMake $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON . $ make Linking CXX static library libsql.a [ 99%] Built target sql Scanning dependencies of target mysqld [100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o Linking CXX executable mysqld ../storage/spider/libspider.a(spd_param.cc.o):(.data+0xd60): multiple definition of `mysql_sysvar_bgs_mode' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x180): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x1660): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_interval' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2a0): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x16a0): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_rows' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2e0): first defined here collect2: ld returned 1 exit status make[2]: *** [sql/mysqld] Error 1 make[1]: *** [sql/CMakeFiles/mysqld.dir/all] Error 2 make: *** [all] Error 2 ##### After I did $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=OFF . $ make clean $ make All went fine without any errors.
2011-05-10 08:30:28 Ashish Disawal description $ tar -zxvf mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0.tgz $ cd mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0 #### List configure options $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON -L ##### CMake $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON . $ make Linking CXX static library libsql.a [ 99%] Built target sql Scanning dependencies of target mysqld [100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o Linking CXX executable mysqld ../storage/spider/libspider.a(spd_param.cc.o):(.data+0xd60): multiple definition of `mysql_sysvar_bgs_mode' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x180): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x1660): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_interval' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2a0): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x16a0): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_rows' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2e0): first defined here collect2: ld returned 1 exit status make[2]: *** [sql/mysqld] Error 1 make[1]: *** [sql/CMakeFiles/mysqld.dir/all] Error 2 make: *** [all] Error 2 ##### After I did $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=OFF . $ make clean $ make All went fine without any errors. $ tar -zxvf mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0.tgz $ cd mysql-5.5.8-spider-2.24-vp-0.13-hs-1.0 #### List configure options $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON -L ##### CMake $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=ON . $ make Linking CXX static library libsql.a [ 99%] Built target sql Scanning dependencies of target mysqld [100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o Linking CXX executable mysqld ../storage/spider/libspider.a(spd_param.cc.o):(.data+0xd60): multiple definition of `mysql_sysvar_bgs_mode' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x180): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x1660): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_interval' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2a0): first defined here ../storage/spider/libspider.a(spd_param.cc.o):(.data+0x16a0): multiple definition of `mysql_sysvar_udf_ct_bulk_insert_rows' ../storage/vp/libvp.a(vp_param.cc.o):(.data+0x2e0): first defined here collect2: ld returned 1 exit status make[2]: *** [sql/mysqld] Error 1 make[1]: *** [sql/CMakeFiles/mysqld.dir/all] Error 2 make: *** [all] Error 2 ##### After I did $ cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-5.5.8 -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON -DWITH_FEDERATED_STORAGE_ENGINE:BOOL=ON -DWITH_SPIDER_STORAGE_ENGINE:BOOL=ON -DWITH_VP_STORAGE_ENGINE:BOOL=OFF . $ make clean $ make ##### I got a lot of warnings and when I started mysql got the following warning: 110510 13:22:50 [Warning] Couldn't load plugin named 'spider' with soname 'ha_spider.so'.
2011-10-19 14:44:49 Kentoku SHIBA spiderformysql: status New Fix Committed
2011-10-19 14:44:55 Kentoku SHIBA spiderformysql: importance Undecided Low
2011-10-19 14:44:58 Kentoku SHIBA spiderformysql: assignee Kentoku SHIBA (kentokushiba)
2012-02-08 17:14:50 Kentoku SHIBA spiderformysql: status Fix Committed Fix Released