July 2017 - discuss - lists.mariadb.org

[Maria-discuss] Duplication of documentation for binlog annotation and a question on replicate_annotate_row_events not being dynamic
by Jean-Francois B. Gagne 03 Jul '17

03 Jul '17

Hi all, This is a documentation organisation question and a technical question on replicate_annotate_row_events not being dynamic. In [1], we can find the documentation for the options binlog-annotate-row-events and replicate-annotate-row-events, and [2] points to [1]. However, there is a duplication of that documentation in [3] and [4], is there a reason for that (there is a risk of those 2 documentation diverging) ? [1]: https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/ [2]: https://mariadb.com/kb/en/mariadb/mysqld-options/ [3]: https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-… [4]: https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-… And the technical question about replicate_annotate_row_events: this variable is not dynamic, is there a reason for that ? I understand that this variable could/should only be modifiable while the slave is stopped, but not being dynamic is not very DBA/SysAdmin/Operator friendly. Many thanks, Jean-François Gagné

3 2

[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