- discuss - lists.mariadb.org

[Maria-discuss] how to build MariaDB from source
by Reindl Harald 03 Jul '17

03 Jul '17

i get tired - "-DPLUGIN_INNODB=YES" leads to failures at configure time - each time the same dance when the version changes well, when remove that thinking since xtradb is now dead it will be default enabled leads finally still to a build-failure with not mentioning really where and why - can we please have back "configure && make && make install" with "./configure --help" back for peace of mind _______________________________ [ 53%] Linking CXX static library libmyisammrg.a *why* at all when i say "-DPLUGIN_MYISAMMRG=NO" but remove it does still make no difference _______________________________ cmake . \ -DFEATURE_SET="large" \ -DCMAKE_INSTALL_PREFIX="%{_prefix}" \ -DINSTALL_INCLUDEDIR=include/mysql \ -DINSTALL_LAYOUT=RPM \ -DINSTALL_LIBDIR="%{_lib}/mysql" \ -DINSTALL_MANDIR=share/man \ -DINSTALL_MYSQLSHAREDIR=share/mysql \ -DINSTALL_MYSQLTESTDIR=share/mysql-test \ -DINSTALL_PLUGINDIR="%{_lib}/mysql/plugin" \ -DINSTALL_SBINDIR=libexec \ -DINSTALL_SCRIPTDIR=bin \ -DINSTALL_SQLBENCHDIR= \ -DINSTALL_SUPPORTFILESDIR=share/mysql \ -DMYSQL_DATADIR="%{_sharedstatedir}/mysql" \ -DMYSQL_UNIX_ADDR="%{_sharedstatedir}/mysql/mysql.sock" \ -DENABLED_PROFILING=OFF \ -DENABLE_DEBUG_SYNC=OFF \ -DENABLE_DTRACE=OFF \ -DPLUGIN_ARIA=YES \ -DPLUGIN_CSV=YES \ -DPLUGIN_MYISAM=YES \ -DPLUGIN_ARCHIVE=NO \ -DPLUGIN_BLACKHOLE=NO \ -DPLUGIN_CASSANDRA=NO \ -DPLUGIN_CONNECT=NO \ -DPLUGIN_EXAMPLE=NO \ -DPLUGIN_FEDERATED=NO \ -DPLUGIN_FEDERATEDX=NO \ -DPLUGIN_FEEDBACK=NO \ -DPLUGIN_MROONGA=NO \ -DPLUGIN_MYISAMMRG=NO \ -DPLUGIN_OQGRAPH=NO \ -DPLUGIN_PARTITION=NO \ -DPLUGIN_PERFSCHEMA=NO \ -DPLUGIN_SEMISYNC=NO \ -DPLUGIN_SEQUENCE=NO \ -DPLUGIN_SPHINX=NO \ -DPLUGIN_SPIDER=NO \ -DPLUGIN_TOKUDB=NO \ -DPLUGIN_XTRADB=NO \ -DWITHOUT_DYNAMIC_PLUGINS=ON \ -DWITH_ATOMIC_OPS=smp \ -DWITH_EMBEDDED_SERVER=OFF \ -DWITH_INNODB_DISALLOW_WRITES=OFF \ -DWITH_INNODB_BZIP2=OFF \ -DWITH_INNODB_LZ4=OFF \ -DWITH_INNODB_LZMA=OFF \ -DWITH_INNODB_LZO=OFF \ -DSECURITY_HARDENED=OFF \ -DWITH_LIBWRAP=OFF \ -DWITH_MARIABACKUP=OFF \ -DWITH_PIC=NO \ -DWITH_READLINE=OFF \ -DWITH_SAFEMALLOC=OFF \ -DWITH_SYSTEMD=OFF \ -DWITH_VALGRIND=OFF \ -DWITH_WSREP=OFF \ -DWITH_JEMALLOC=system \ -DWITH_SSL=system \ -DWITH_ZLIB=system \ -DCOMPILATION_COMMENT="thelounge" cd /home/builduser/rpmbuild/BUILD/mariadb-10.2.6/storage/myisam && /usr/bin/cmake -P CMakeFiles/myisam.dir/cmake_clean_target.cmake cd /home/builduser/rpmbuild/BUILD/mariadb-10.2.6/storage/myisam && /usr/bin/cmake -E cmake_link_script CMakeFiles/myisam.dir/link.txt --verbose=1 /usr/bin/ar qc libmyisam.a CMakeFiles/myisam.dir/ft_boolean_search.c.o CMakeFiles/myisam.dir/ft_nlq_search.c.o CMakeFiles/myisam.dir/ft_parser.c.o CMakeFiles/myisam.dir/ft_static.c.o CMakeFiles/myisam.dir/ha_myisam.cc.o CMakeFiles/myisam.dir/ft_myisam.c.o CMakeFiles/myisam.dir/ft_stopwords.c.o CMakeFiles/myisam.dir/ft_update.c.o CMakeFiles/myisam.dir/mi_cache.c.o CMakeFiles/myisam.dir/mi_changed.c.o CMakeFiles/myisam.dir/mi_check.c.o CMakeFiles/myisam.dir/mi_checksum.c.o CMakeFiles/myisam.dir/mi_close.c.o CMakeFiles/myisam.dir/mi_create.c.o CMakeFiles/myisam.dir/mi_dbug.c.o CMakeFiles/myisam.dir/mi_delete.c.o CMakeFiles/myisam.dir/mi_delete_all.c.o CMakeFiles/myisam.dir/mi_delete_table.c.o CMakeFiles/myisam.dir/mi_dynrec.c.o CMakeFiles/myisam.dir/mi_extra.c.o CMakeFiles/myisam.dir/mi_info.c.o CMakeFiles/myisam.dir/mi_key.c.o CMakeFiles/myisam.dir/mi_keycache.c.o CMakeFiles/myisam.dir/mi_locking.c.o CMakeFiles/myisam.dir/mi_log.c.o CMakeFiles/myisam.dir/mi_open.c.o CMakeFiles/myisam.dir/mi_packrec.c.o CMakeFiles/myisam.dir/mi_page.c.o CMakeFiles/myisam.dir/mi_panic.c.o CMakeFiles/myisam.dir/mi_preload.c.o CMakeFiles/myisam.dir/mi_range.c.o CMakeFiles/myisam.dir/mi_rename.c.o CMakeFiles/myisam.dir/mi_rfirst.c.o CMakeFiles/myisam.dir/mi_rlast.c.o CMakeFiles/myisam.dir/mi_rnext.c.o CMakeFiles/myisam.dir/mi_rnext_same.c.o CMakeFiles/myisam.dir/mi_rprev.c.o CMakeFiles/myisam.dir/mi_rrnd.c.o CMakeFiles/myisam.dir/mi_rsame.c.o CMakeFiles/myisam.dir/mi_rsamepos.c.o CMakeFiles/myisam.dir/mi_scan.c.o CMakeFiles/myisam.dir/mi_search.c.o CMakeFiles/myisam.dir/mi_static.c.o CMakeFiles/myisam.dir/mi_statrec.c.o CMakeFiles/myisam.dir/mi_unique.c.o CMakeFiles/myisam.dir/mi_update.c.o CMakeFiles/myisam.dir/mi_write.c.o CMakeFiles/myisam.dir/rt_index.c.o CMakeFiles/myisam.dir/rt_key.c.o CMakeFiles/myisam.dir/rt_mbr.c.o CMakeFiles/myisam.dir/rt_split.c.o CMakeFiles/myisam.dir/sort.c.o CMakeFiles/myisam.dir/sp_key.c.o CMakeFiles/myisam.dir/mi_rkey.c.o /usr/bin/ranlib libmyisam.a make[2]: Leaving directory '/home/builduser/rpmbuild/BUILD/mariadb-10.2.6' [ 52%] Built target myisam make[1]: Leaving directory '/home/builduser/rpmbuild/BUILD/mariadb-10.2.6' Makefile:162: recipe for target 'all' failed make: *** [all] Error 2 Fehler: Fehler-Status beim Beenden von /var/tmp/rpm-tmp.Qwgvnq (%build) Fehler beim Bauen des RPM: Fehler-Status beim Beenden von /var/tmp/rpm-tmp.Qwgvnq (%build)

2 5

[Maria-discuss] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so'
by Jonathan Gazeley 03 Jul '17

03 Jul '17

Hi folks, I did a routine reboot on one of my database nodes and it was unable to start up wsrep afterwards. I'm running MariaDB 10.1.24 with Galera 25.3.20 on CentOS 7.3.1611 (latest). Jul 03 09:53:07 db2.example.com sh[14400]: WSREP: Failed to start mysqld for wsrep recovery: '2017-07-03 9:50:49 139825954236672 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so' (errno: 0, cannot open shared object file: No such file or directory) Jul 03 09:53:07 db2.example.com sh[14400]: 2017-07-03 9:50:49 139825954236672 [ERROR] Couldn't load plugins from 'auth_socket.so'. It fails to find auth_socket.so, but when I check in yum what provides that file, only MariaDB 5.5 from the CentOS repo has it, but not MariaDB 10.1 from the MariaDB repo. I read in the notes that auth_socket is deprecated and going in 10.2. My config file specifies 'loose-plugin-load=auth_socket'. If I just remove this line, will it work? Will it break wsrep? Can someone explain this to me? Right now I am nervous because if the other nodes also can't start up wsrep after rebooting then I will lose my cluster. I'm looking for ways to resolve the problem and get the node back online. I'm happy to upgrade to 10.2 if necessary. Thanks, Jonathan

3 3

[Maria-discuss] R: Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so'
by Federico Razzoli 03 Jul '17

03 Jul '17

It is just a simpler way to do authentication: https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/ Unless you use it intentionally, I don't think it can break anything. I'd just comment the line and then, for consistency, I'd uninstall that plugin in other nodes in case it is installed. Federico -------------------------------------------- Lun 3/7/17, Jonathan Gazeley <Jonathan.Gazeley(a)bristol.ac.uk> ha scritto: Oggetto: [Maria-discuss] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so' A: maria-discuss(a)lists.launchpad.net Data: Lunedì 3 luglio 2017, 14:13 Hi folks, I did a routine reboot on one of my database nodes and it was unable to start up wsrep afterwards. I'm running MariaDB 10.1.24 with Galera 25.3.20 on CentOS 7.3.1611 (latest). Jul 03 09:53:07 db2.example.com sh[14400]: WSREP: Failed to start mysqld for wsrep recovery: '2017-07-03 9:50:49 139825954236672 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so' (errno: 0, cannot open shared object file: No such file or directory) Jul 03 09:53:07 db2.example.com sh[14400]: 2017-07-03 9:50:49 139825954236672 [ERROR] Couldn't load plugins from 'auth_socket.so'. It fails to find auth_socket.so, but when I check in yum what provides that file, only MariaDB 5.5 from the CentOS repo has it, but not MariaDB 10.1 from the MariaDB repo. I read in the notes that auth_socket is deprecated and going in 10.2. My config file specifies 'loose-plugin-load=auth_socket'. If I just remove this line, will it work? Will it break wsrep? Can someone explain this to me? Right now I am nervous because if the other nodes also can't start up wsrep after rebooting then I will lose my cluster. I'm looking for ways to resolve the problem and get the node back online. I'm happy to upgrade to 10.2 if necessary. Thanks, Jonathan _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

1 0

[Maria-discuss] [mysqld] Can't find messagefile '/usr/share/mysql/errmsg.sys'
by Guillermo Cespedes 30 Jun '17

30 Jun '17

Hi, Compilation Instructions: # uname -a Linux framework 3.16.0-4-686-pae #1 SMP Debian 3.16.43-2+deb8u2 (2017-06-26) i686 GNU/Linux # groupadd mysql # useradd -c "MySQL Server" -g mysql -s /bin/false mysql # cmake . -DBUILD_CONFIG=mysql_release \ -DCMAKE_C_FLAGS="-I/usr/local/include -I/usr/include/i386-linux-gnu" \ -DWITH_INNODB_LZ4=ON -DWITH_INNODB_LZMA=OFF -DWITH_INNODB_LZO=OFF \ -DWITH_ZLIB=system -DWITH_SSL=system \ -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_spanish_ci \ -DWITH_DEBUG=0 -DWITH_VALGRIND=0 # make # make install # export PATH=$PATH:/usr/local/mysql/bin # echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile # source /etc/profile # cd /usr/local/mysql # chown -R root . # chown -R mysql data # cp ./support-files/my-medium.cnf /etc/my.cnf # ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --verbose # cp ./support-files/mysql.server /etc/init.d/mysql # chmod +x /etc/init.d/mysql # update-rc.d mysql defaults # service mysql start # ./bin/mysql_secure_installation # ./bin/mysqladmin -u root password Error: # mysqld 2017-06-28 21:37:24 3071039232 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. 2017-06-28 21:37:24 3071039232 [Note] mysqld (mysqld 10.2.6-MariaDB-log) starting as process 2600 ... 2017-06-28 21:37:24 3071039232 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys' 2017-06-28 21:37:24 3071039232 [ERROR] Aborting # ls -l /usr/share/mysql ls: cannot access /usr/share/mysql: No such file or directory How to indicate the correct directory permanently ? /usr/share/mysql to /usr/local/mysql/share # ls /usr/local/mysql/share aclocal german mysql_performance_tables.sql romanian charsets greek mysql_system_tables_data.sql russian czech hungarian mysql_system_tables.sql serbian danish install_spider.sql mysql_test_data_timezone.sql slovak dutch italian mysql_to_mariadb.sql spanish english japanese norwegian swedish errmsg-utf8.txt korean norwegian-ny ukrainian estonian maria_add_gis_sp_bootstrap.sql pkgconfig fill_help_tables.sql maria_add_gis_sp.sql polish french mroonga portuguese Guillermo Céspedes Full Stack Developer

2 5

[Maria-discuss] Parser language
by Roberto Spadim 28 Jun '17

28 Jun '17

Hi guys, sometime ago i asked if we could select what parser we are using, with an example with nosql (handler socket) or sql, without new socket connection Show we consider this as something we will need? Check that new query ideas are next door: http://probcomp.csail.mit.edu/bayesdb/ -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] MariaDB 10.2 innodb page_clean question ?
by Ljr Yang 26 Jun '17

26 Jun '17

Hi, Recently, we upgrade 8 MariaDB slaves from MariaDB 10.1.22 to MariaDB 10.2.6. In error log, it frequent occurrence some innodb Note: ............. 2017-06-26 9:01:03 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6142ms. The settings might not be optimal. (flushed=16 and evicted =0, during the time.) 2017-06-26 9:03:54 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4584ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:05:58 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4728ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:08:49 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5016ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:09:12 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4990ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:11:27 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5387ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:14:43 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6463ms. The settings might not be optimal. (flushed=0 and evicted= 0, during the time.) 2017-06-26 9:16:27 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4031ms. The settings might not be optimal. (flushed=40 and evicted =0, during the time.) ............ Now, It have not affect the normal use, but we could not confirm, it is our config problem or other reasons? Please help confirm, thanks.

1 0

[Maria-discuss] MariaDB and Intel TSX
by Reindl Harald 25 Jun '17

25 Jun '17

does MariaDB make usage of TSX on newer hardware or at least using glibc for the query cache mutex which would implicit benfit form it? just curious because next year we replace our cluster nodes and put them in a EVC mode where TSX instrcutions are supported https://en.wikipedia.org/wiki/Transactional_Synchronization_Extensions https://www.flamingspork.com/blog/2014/06/05/performance-impact-of-mysql-qu… https://lwn.net/Articles/534758/

2 2

[Maria-discuss] Help to compile MariaDB 10.2.6 - Debian 8.8
by Guillermo Céspedes Tabárez 23 Jun '17

23 Jun '17

Hello I need help to add in my script ( https://gist.github.com/dertin/8de14e458dd4f0d3acb5f0deff120951#file-instal… ) the compilation of "MariaDB 10.2.6" from its source code. Must work for Debian 8.8 32bit and 64bit Thank you

4 16

[Maria-discuss] memory allocators and MariaDB
by MARK CALLAGHAN 20 Jun '17

20 Jun '17

Do MariaDB 10.2 binaries use glibc malloc or get built with one of tcmalloc or jemalloc? Sorry for being lazy, as I have yet to install it. -- Mark Callaghan mdcallag(a)gmail.com

3 8

[Maria-discuss] mariadb 10.2.6 make test failures
by Bruce Dubbs 20 Jun '17

20 Jun '17

I am trying to build mariadb from source on a linux system. I used this procedure: mkdir build cd build cmake -DTOKUDB_OK=0 .. make make test The build goes fine, but the output of make test gives: 74% tests passed, 21 tests failed out of 81 Total Test time (real) = 42.80 sec The following tests FAILED: 23 - bulk1 (Failed) 24 - performance (Failed) 25 - basic-t (Failed) 26 - fetch (Failed) 27 - charset (Failed) 28 - logs (Failed) 29 - cursor (Failed) 30 - errors (Failed) 31 - view (Failed) 32 - ps (Failed) 33 - ps_bugs (Failed) 34 - sp (Failed) 35 - result (Failed) 36 - connection (Failed) 37 - misc (Failed) 38 - ps_new (Failed) 39 - sqlite3 (Failed) 40 - thread (Failed) 41 - features-10_2 (Failed) 42 - dyncol (Failed) 43 - async (Failed) Errors while running CTest All the failing tests have messages in the log like: # Couldn't establish connection to server (null). Error (2002): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Bail out! Can't connect to a server. Aborting.... All the above tests appear to be new to version 10.2. I used the asme build procedure for version 10.1.23 and all tests pass, but none of the above tests show up on the earlier version either. What am I missing? If the tests need a server running, shouldn't the tests start the server? -- Bruce

3 4