- discuss - lists.mariadb.org

[Maria-discuss] incomplete provide of symlinks with 10.2.7
by Reindl Harald 13 Jul '17

13 Jul '17

Fedora just started to work on MariaDB 10.2 packaging they create compat symlinks for a sane transition and i try to backport that to my F25 builds with change as less as possible on my existing "mariadb.spec" 10.2.7 seems to do the same now (Fedora last night was still on 10.2.6) well, "libmysqlclient.so.18" is missing in your upstream compat links while "libmysqlclient.so" and "libmysqlclient_r.so" gave an error "ln: failed to create symbolic link 'libmysqlclient.so': File exists" within rpmbuild https://koji.fedoraproject.org/koji/buildinfo?buildID=918138 ___________________________________________ pushd %{buildroot}%{_libdir}/mysql/ ln -s libmariadb.so libmysqlclient.so ln -s libmariadb.so libmysqlclient.so.18 ln -s libmariadb.so libmysqlclient_r.so popd ___________________________________________ + pushd /home/builduser/rpmbuild/BUILDROOT/mariadb-10.2.7-3.fc25.20170713.rh.x86_64/usr/lib64/mysql/ ~/rpmbuild/BUILDROOT/mariadb-10.2.7-3.fc25.20170713.rh.x86_64/usr/lib64/mysql ~/rpmbuild/BUILD/mariadb-10.2.7 + ln -s libmariadb.so libmysqlclient.so.18 + popd ~/rpmbuild/BUILD/

2 2

[Maria-discuss] MariaDB 10.2.7 now available
by Daniel Bartholomew 12 Jul '17

12 Jul '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.7. This is a stable (GA) release. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.7 - Release Notes: https://mariadb.com/kb/en/mdb-1027-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1027-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.7 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Galera cluster for databases replication over three servers
by Martin LEUSCH 11 Jul '17

11 Jul '17

Hi, I'm setting up a new mail infrastructure withe 3 servers running Debian Jessie, data can be read or write from these 3 servers at any time. I chosed Galera with with MariaDB 10.2 to share databases between servers for services like AMAVIS, dovecot, ... I had a lot of errors in my logs (almost each time a service access to a DB), for example: Jul 11 07:00:01 mail mysqld[1302]: 2017-07-11 7:00:01 140256990783232 [Warning] Aborted connection 14812 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets) Jul 11 10:15:17 mailfilter mysqld[3714]: 2017-07-11 10:15:17 139644624377600 [Warning] Aborted connection 399 to db: 'amavisd' user: 'amavisd' host: 'localhost' (Got timeout reading communication packets) I wonder if in this case Galera is a good choice for databases replication and if there is a way to avoid this kind of errors. Thanks -- Martin LEUSCH <martin.leusch(a)imrcom.fr>

1 0

[Maria-discuss] TRIGGERing on new users
by Curtis Brown 07 Jul '17

07 Jul '17

I apologize in advance if this is the wrong venue; please point me in a more correct direction if that's the case. I want to perform some extra database functions when a new user is created in our MariaDB installation. What I am learning though is that I can't CREATE TRIGGERs against system tables like the user table in the mysql database. I am using MariaDB v10.1.24 in an Ubuntu 16.04.2 environment Have others run across a similar situation? Are there techniques to work around this? One thought I had was to enable general query log and either monitor the file output or TRIGGER on the general_log table. Are there any better suggestions? Thanks in advance. -- Curtis Brown, unix system administrator For general PC questions, Academic Computing and Networking Services call: 970-491-7276 Colorado State University email: help(a)colostate.edu curtis.brown(a)colostate.edu http://lib.colostate.edu/helpdesk/

2 4

[Maria-discuss] Broken MariaDB client ARGGG!!!
by Jon Foster 06 Jul '17

06 Jul '17

I'm constantly astounded at the extreme cavalier attitude that MySQL/MariaDB has had towards backwards compatibility for the nearly two decades I've worked with it. Its like you hate the developers that use your stuff. What's up with this?!?! I decided I better install the latest updates to my Deb7 64bit MariaDB install. WTF! Now all of my PHP apps are griping about: ---- symbol client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 ... ---- And it was working so well ten minutes ago. 10.2 even did away with the previous gripes from v10.1. :-/ But with the update to 10.2.6+maria~wheezy of the client libraries from your Debian repositories my clients' sites are down. Please fix. I'll find someway to install older functional code again. - Jon -- Sent from my Debian Linux workstation -- http://www.debian.org/intro/about Jon Foster JF Possibilities, Inc. jon(a)jfpossibilities.com 541-410-2760 Making computers work for you!

5 6

[Maria-discuss] How to deal with text pasted from Word?
by David Karr 06 Jul '17

06 Jul '17

I've inherited a small webapp that is using MariaDB for persistence. Some of the forms have textarea fields for extended text to be entered. Someone reported an issue saving a form with some text that they had pasted from an email. The message started with this: ------------------ Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Incorrect string value: '\xC2\x95\x09Onb...' for column 'ssimpact' at row 1 ---------------- I found where "Onb" is in the text, and right before it is a "bullet" character. So, this appeared to be a Unicode conversion issue. I tried pasting the same text after it had been passed to me, and it didn't fail. I'm pretty sure it didn't fail because that process of "passing it around" filtered the text to be all valid characters. The person who reported the problem said that when she just resubmitted it, it didn't fail. That might also point to a "cleansing" process that resulted in the submitted characters being legal. What are some reasonable strategies for getting this to work a little better?

1 1

[Maria-discuss] legacy InnoDB compressed tables using row_format=compressed
by Lukas Lehner 05 Jul '17

05 Jul '17

Hey Quote from https://mariadb.com/kb/en/mariadb/compression/ This approach differs significantly from legacy InnoDB compressed tables using row_format=compressed, where both uncompressed and compressed pages can be in the buffer pool. Any details why this is legacy? Should not be used? With a search engine I found a very old blog posting "InnoDB compression woes" from Percona. row_format=compressed is attractive when you pay your DBaaS per GB (storage based usage). Any insides? Lukas

2 1

[Maria-discuss] Best place to report RocksDB issues?
by jocelyn fournier 05 Jul '17

05 Jul '17

Hi all, Mark, What's the best place to report RocksDB issues? MariaDB/Percona JIRA, https://github.com/facebook/rocksdb/issues , any other places? Thanks! Jocelyn

2 1

[Maria-discuss] MariaDB 10.1.25 now available
by Daniel Bartholomew 04 Jul '17

04 Jul '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.25, MariaDB Connector/J 2.0.3, and MariaDB Connector/J 1.6.2. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.25 - Release Notes: https://mariadb.com/kb/en/mdb-10125-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10125-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.25 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 2.0.3 - Release Notes: https://mariadb.com/kb/en/mcj-203-rn/ - Changelog: https://mariadb.com/kb/en/mcj-203-cl/ - Downloads: https://downloads.mariadb.org/connector-java/2.0.3/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/J 1.6.2 - Release Notes: https://mariadb.com/kb/en/mcj-162-rn/ - Changelog: https://mariadb.com/kb/en/mcj-162-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.6.2/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] [MariaDB 10.2.6] [PHP 7.1.6] error: /usr/bin/ld: cannot find -lmysqlclient | wrong mysql library version or lib not found
by Guillermo Cespedes 04 Jul '17

04 Jul '17

Hi, I am compiling MariaDB 10.2.6 and PHP 7.1.6 I'm trying it on Debian 8.8 32x and x64 on DigitalOcean See the script: https://gist.github.com/dertin/8de14e458dd4f0d3acb5f0deff120951 <https://gist.github.com/dertin/8de14e458dd4f0d3acb5f0deff120951> But I have problems compiling PHP with MariaDB / MySQLi. Should I check something at the Mariadb installation? # grep 'mysql’ config.log $ ./configure --prefix=/usr/local/php7 --enable-huge-code-pages --with-config-file-scan-dir=/usr/local/php7/etc/conf.d --without-pear --enable-bcmath --with-bz2 --enable-calendar --enable-intl --enable-exif --enable-dba --enable-ftp --with-gettext --with-gd --with-jpeg-dir --enable-mbstring --with-mcrypt --with-mhash --enable-mysqlnd --with-mysql-sock=/var/run/mysqld/mysqld.sock --with-mysqli=/usr/local/mysql/bin/mariadb_config --with-pdo-mysql=/usr/local/mysql --with-openssl --enable-pcntl --with-pspell --enable-shmop --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-wddx --with-zlib --enable-zip --with-readline --with-curl --enable-simplexml --enable-xmlreader --enable-xmlwriter --enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data ... configure:52615: result: /var/run/mysqld/mysqld.sock configure:52749: checking for mysql_set_server_option in -lmysqlclient configure:52774: cc -o conftest -I/usr/include -g -O2 -fvisibility=hidden -Wl,-rpath,/usr/local/mysql/lib/ -L/usr/local/mysql/lib/ -L/usr/lib -Wl,-rpath,/usr/local/lib -L/usr/local/lib -Wl,-rpath,/usr/lib/x86_64-linux-gnu -L/usr/lib/x86_64-linux-gnu -lmariadb -ldl -lm -lssl -lcrypto conftest.c -lmysqlclient -lmcrypt -lltdl -lstdc++ -lpng -lz -ljpeg -lcurl -lbz2 -lz -lrt -lm -ldl -lnsl -lxml2 -lz -lm -ldl -lssl -lcrypto -lcurl -lxml2 -lz -lm -ldl -lssl -lcrypto -licui18n -licuuc -licudata -licuio >&5 /usr/bin/ld: cannot find -lmysqlclient | char mysql_set_server_option (); | return mysql_set_server_option (); configure:53081: error: wrong mysql library version or lib not found. Check config.log for more information. ac_cv_lib_mysqlclient___mysql_set_server_option=no Tested with: --with-mysqli=/usr/local/mysql/bin/mysql_config --with-mysqli=/usr/local/mysql/bin/mariadb_config related to: https://lists.launchpad.net/maria-discuss/msg04668.html What do you think? Guillermo Céspedes Full Stack Developer

2 2

[Maria-discuss] I expected the same values for mariadb_config, mysql_config and my_print_defaults --mysqld
by Guillermo Cespedes 04 Jul '17

04 Jul '17

Hi, The values are not correct, they are even different, I expected the same values. See socket and version. # /usr/local/mysql/bin/mariadb_config Copyright 2011-2015 MariaDB Corporation AB Get compiler flags for using the MariaDB Connector/C. Usage: mariadb_config [OPTIONS] --cflags [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/mysql] --include [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/mysql] --libs [-L/usr/local/mysql/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto] --libs_r [-L/usr/local/mysql/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto] --libs_sys [-lpthread -ldl -lm -lssl -lcrypto] --version [10.2.5] --socket [/tmp/mysql.sock] --port [3306] --plugindir [/usr/local/mysql/lib/plugin] --tlsinfo [OpenSSL 1.1.0f] # /usr/local/mysql/bin/mysql_config Usage: /usr/local/mysql/bin/mysql_config [OPTIONS] Options: --cflags [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/.. ] --include [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/..] --libs [-L/usr/local/mysql/lib -lmariadb] --libs_r [-L/usr/local/mysql/lib -lmariadb] --plugindir [/usr/local/mysql/lib/plugin] --socket [/tmp/mysql.sock] --port [0] --version [10.2.6] --libmysqld-libs [-L/usr/local/mysql/lib -lmysqld -lpthread -lz -lm -ldl -lssl -lcrypto -lpcre -lcrypt -llz4 -laio] --variable=VAR VAR is one of: pkgincludedir [/usr/local/mysql/include/mysql] pkglibdir [/usr/local/mysql/lib] plugindir [/usr/local/mysql/lib/plugin] # my_print_defaults --mysqld --port=3306 --socket=/var/run/mysqld/mysqld.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --server-id=1 --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --tmpdir=/tmp --lc-messages-dir=/usr/local/mysql/share --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --myisam-recover=BACKUP --query_cache_limit=1M --query_cache_size=16M --log_error=/var/log/mysql/error.log --expire_logs_days=10 --max_binlog_size=100M Guillermo Céspedes Full Stack Developer

2 2

Re: [Maria-discuss] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so'
by Daniel Black 04 Jul '17

04 Jul '17

On 03/07/17 22:54, Jonathan Gazeley wrote: > On 03/07/17 13:38, Ian Gilfillan wrote: >> On 03/07/2017 14:13, Jonathan Gazeley wrote: >>> >>> 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? >>> >> In which notes did you read about auth_socket being deprecated? > > In /etc/my.cnf.d/mariadb-enterprise.cnf: > > # This is to accommodate upgrades to MariaDB 10.2, which does not include > # the Unix socket plugin built into the server. > loose-plugin-load=auth_socket > > Makes it sound like auth_socket is going away - or at least is opt-in in > 10.2. Its built in to the 10.2 server rather than being a separate shared library like <10.2

1 0

[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

[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

[Maria-discuss] MariaDB new installation on Centos 6
by romeo kalebic 18 Jun '17

18 Jun '17

Hi everyone, I'm new user of MariaDB, and I install it on Centos 6.8 64bit. I install it using yum utility , according instruction on MariaDB site: https://mariadb.com/kb/en/mariadb/yum/. yum install MariaDB-server MariaDB-client finished without any problem. I can use mysql client to connect to databases without any problems. Then I try to compile some of my applications. To find out what library to use and where include files are I use mysql_config and mariadb_config. mysql_config output: [root@xms tests]# mysql_config Usage: /usr/bin/mysql_config [OPTIONS] Options: --cflags [-I/usr/include/mysql ] --include [-I/usr/include/mysql] --libs [-L/usr/lib64 -lmariadb] --libs_r [-L/usr/lib64 -lmariadb] --plugindir [/usr/lib64/mysql/plugin] --socket [/var/lib/mysql/mysql.sock] --port [0] --version [10.2.6] --libmysqld-libs [-L/usr/lib64 -lmysqld -lpthread -lz -lm -lrt -ldl -lssl -lcrypto -lcrypt -laio] --variable=VAR VAR is one of: pkgincludedir [/usr/include/mysql] pkglibdir [/usr/lib64] plugindir [/usr/lib64/mysql/plugin] [root@xms tests]# And mariadb_config returns: [root@xms tests]# mariadb_config Copyright 2011-2015 MariaDB Corporation AB Get compiler flags for using the MariaDB Connector/C. Usage: mariadb_config [OPTIONS] --cflags [-I/usr/include/mysql -I/usr/include/mysql/mysql] --include [-I/usr/include/mysql -I/usr/include/mysql/mysql] --libs [-L/usr/lib64/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto] --libs_r [-L/usr/lib64/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto] --libs_sys [-lpthread -ldl -lm -lssl -lcrypto] --version [10.2.5] --socket [/var/lib/mysql/mysql.sock] --port [3306] --plugindir [/usr/lib64/mysql/plugin] --tlsinfo [OpenSSL 1.0.1e] [root@xms tests]# First question is why these two outputs are different? I wrote Makefile and use -I and -L like this in mysql_config. gcc compiler finish with error that there is no mariadb library. What I have missed? Where is libmariadb located? Best Regards, Romeo <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_cam…> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_cam…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

3 3

[Maria-discuss] Question about mariadb 10.2 "rows" keyword
by Rod Bio 14 Jun '17

14 Jun '17

Hi everyone, Apologies I am not a native english speaker so my english will be weird and database is not my specialty, but I would just like to ask something about mariadb specifically version 10.2 I just recently upgraded to 10.2 from 5.5 and somewhat we had problem displaying our data. Anyway we've traced the issue, after trying to replicate the database, to a specific table. What we found is that when we create a table with a column named "rows" it would return an error. e.g. MariaDB [test]> create table test (rows int); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows int)' at line 1 Only by using `` as in `rows` to create the column would we be able to do it successfully. e.g. MariaDB [test]> create table test (`rows` int); Query OK, 0 rows affected (0.02 sec) I haven't had any other issue but just this specific keyword and we have not successfully seen any documentation regarding this. Thank you everyone in advance. -- Rod

3 2

Re: [Maria-discuss] Deadlocks in R/W phase of Sysbench
by J. Cassidy 10 Jun '17

10 Jun '17

All, as discussed yesterday, here is my setup and configuration. ************************************************************* 16 VCPU 64GB Memory, DB size 12 GB (In RAM), MariaDB 10.1.24* Single Image. No clustering or outside network interaction * SuSE SLES 12 SP2 using a 4.4.49-92 kernel * ************************************************************* ### Sysbench R/W - 64 Threads sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 64 Report intermediate results every 2 second(s) Initializing random number generator from seed (42). Threads started! [ 2s] threads: 64, tps: 51141.62, reads: 717023.15, writes: 204757.48, response time: 4.72ms (99%), errors: 54.00, reconnects: 0.00 [ 4s] threads: 64, tps: 47938.19, reads: 671195.72, writes: 191759.28, response time: 4.65ms (99%), errors: 5.00, reconnects: 0.00 [ 6s] threads: 64, tps: 46908.41, reads: 656790.25, writes: 187640.64, response time: 4.65ms (99%), errors: 2.50, reconnects: 0.00 [ 8s] threads: 64, tps: 45940.12, reads: 643191.64, writes: 183781.47, response time: 4.44ms (99%), errors: 3.00, reconnects: 0.00 [ 10s] threads: 64, tps: 45789.91, reads: 641083.20, writes: 183161.13, response time: 4.77ms (99%), errors: 2.00, reconnects: 0.00 [ 12s] threads: 64, tps: 45408.37, reads: 635825.16, writes: 181672.97, response time: 4.80ms (99%), errors: 1.50, reconnects: 0.00 [ 14s] threads: 64, tps: 44319.93, reads: 620440.07, writes: 177262.74, response time: 4.50ms (99%), errors: 0.50, reconnects: 0.00 [ 16s] threads: 64, tps: 44634.78, reads: 624843.97, writes: 178523.13, response time: 4.71ms (99%), errors: 0.50, reconnects: 0.00 . . . [ 572s] threads: 64, tps: 24980.71, reads: 349707.39, writes: 99924.32, response time: 5.92ms (99%), errors: 0.00, reconnects: 0.00 [ 574s] threads: 64, tps: 25337.03, reads: 354796.98, writes: 101355.13, response time: 6.19ms (99%), errors: 0.00, reconnects: 0.00 [ 576s] threads: 64, tps: 25196.31, reads: 352683.33, writes: 100777.24, response time: 6.49ms (99%), errors: 0.00, reconnects: 0.00 [ 578s] threads: 64, tps: 25235.61, reads: 353317.05, writes: 100941.94, response time: 5.94ms (99%), errors: 0.00, reconnects: 0.00 [ 580s] threads: 64, tps: 25241.11, reads: 353395.59, writes: 100956.96, response time: 6.09ms (99%), errors: 0.00, reconnects: 0.00 [ 582s] threads: 64, tps: 25146.18, reads: 352056.04, writes: 100599.73, response time: 5.96ms (99%), errors: 0.00, reconnects: 0.00 [ 584s] threads: 64, tps: 25242.59, reads: 353362.72, writes: 100978.85, response time: 6.21ms (99%), errors: 0.00, reconnects: 0.00 [ 586s] threads: 64, tps: 25297.02, reads: 354187.80, writes: 101166.58, response time: 5.89ms (99%), errors: 0.00, reconnects: 0.00 [ 588s] threads: 64, tps: 25070.60, reads: 350944.86, writes: 100283.39, response time: 6.33ms (99%), errors: 0.00, reconnects: 0.00 [ 590s] threads: 64, tps: 25115.20, reads: 351666.84, writes: 100466.81, response time: 6.21ms (99%), errors: 0.00, reconnects: 0.00 [ 592s] threads: 64, tps: 25165.11, reads: 352314.52, writes: 100668.94, response time: 5.98ms (99%), errors: 0.00, reconnects: 0.00 [ 594s] threads: 64, tps: 25165.99, reads: 352322.89, writes: 100703.97, response time: 6.30ms (99%), errors: 0.00, reconnects: 0.00 [ 596s] threads: 64, tps: 24854.73, reads: 347945.66, writes: 99370.90, response time: 6.17ms (99%), errors: 0.00, reconnects: 0.00 [ 598s] threads: 64, tps: 24888.16, reads: 348463.80, writes: 99556.16, response time: 6.21ms (99%), errors: 0.00, reconnects: 0.00 [ 600s] threads: 64, tps: 25158.22, reads: 352195.58, writes: 100633.38, response time: 5.94ms (99%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 256244548 write: 73212536 other: 36606172 total: 366063256 transactions: 18302990 (30454.11 per sec.) read/write requests: 329457084 (548179.44 per sec.) other operations: 36606172 (60908.54 per sec.) ignored errors: 192 (0.32 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 601.0023s total number of events: 18302990 total time taken by event execution: 38450.5507s response time: min: 0.42ms avg: 2.10ms max: 62.26ms approx. 99 percentile: 5.62ms Threads fairness: events (avg/stddev): 285984.2188/3788.79 execution time (avg/stddev): 600.7899/0.00 ================================================================================================================= ### Excerpt from MariaDB Error Log (Thousands of similiar messages). . . . 2017-06-08 8:10:44 4395980287248 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4353081699600 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4353087458576 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4360227998992 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4353073515792 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4390705949968 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4360227392784 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4353087458576 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4353073515792 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2017-06-08 8:10:44 4353087458576 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction . . . =================================================================================================================== The configuration below has been tried and tested and works across on different architectures e.g. S390X and S390X. [mysqld_safe] user=root password='' [mysqld] symbolic-links=0 open_files_limit = 65535 # was 102400 max_allowed_packet = 16M # was 768M max-connect-errors = 1000000 connect_timeout = 120 # was 60 performance-schema = false net_read_timeout = 720 log-warnings=2 #####files and sockets # innodb_log_group_home_dir= /data-lun22/logs pid-file=/tmp/mysqld.pid.sysbench port = 3306 # log-error=/var/log/mariadb/mariadb-error-john.log log-error=/var/log/mariadb/mariadb-error-john.log general_log_file=/var/log/mariadb/mariadb-john.log long_query_time = 0 slow_query_log = 0 # slow_query_log_file = /var/log/mariadb/mariadb-slowquery.log # general-log # general_log_file=/var/log/mariadb/mariadb-general.log ##### MariaDB temporary tables # tmpdir in RAM tmpdir = /mnt/tmpdir #####non innodb options (fixed) max_connections = 4000 back_log = 150 table_open_cache = 8000 # was 2048 # was 4000 # was 8000 key_buffer_size = 16M query_cache_type = 0 #was 1 # was 0 join_buffer_size = 32K sort_buffer_size = 32K autocommit = 0 thread-cache-size = 50 table-definition-cache = 1024 table-open-cache = 2048 ####fixed innodb options innodb_file_per_table = true innodb_open_files = 4096 # was 8192 # was 4096 innodb_data_file_path = ibdata1:250M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT_NO_FSYNC innodb_log_buffer_size = 256M innodb_log_file_size = 4G # was 14G # was 4G innodb_log_files_in_group = 2 innodb_buffer_pool_size = 36G #was 8G # was 48G innodb_buffer_pool_instances = 8 # 16 # was 6 # was 32 innodb_adaptive_hash_index_partitions = 32 innodb_thread_concurrency = 0 ####tuning for RAM disk innodb_adaptive_flushing = 1 innodb_flush_neighbors = 0 innodb_io_capacity = 8000 # was 20000 innodb_io_capacity_max = 40000 innodb_lru_scan_depth = 4096 innodb_purge_threads = 2 innodb_read_io_threads = 2 innodb_write_io_threads = 2 <*> Note NMON reports 35% memory usage in the middle of the abovementioned Banchmark ergo the DB is in cache. No paging. ++ Note The R/W TPS rate are "respectable" based on observations from countless other runs ran on other configurations/architecture. The TPS rates would obviously improve if the deadlock situation outlined above was resolved. So there you have it. Any tips / pointers that would enlighten me are much appreciated. Regards, JC Privet Sergey, do not think I have a problem with my config(s). I am not on the machine at the moment. >From memory, with 16 Cores / 32 VCPU, 64 GB memory, buffer pools, logs etc. tailored to this configuration, the TPS rate is 64 threads - R/O 73K R/W 26K 128 threads - R/O 71K R/W 23K. I am putting the DB in RAM of course to obviate I/O issues. I am interested in seeing what is happening with the CPU caches and nest.. NMON tells me that for the R/O runs I have approximately 85% User, 12-14% System and the rest Idle - this stays consistent throughout the run (300 seconds R/O, 600 seconds R/W) which is reasonable. On the R/W runs, NMONs CPU usage display shows that some CPUs are barely firing, or only intermittently and the granularity I had with R/O is gone. This would seem to tie in with what I see in the MariaDB log - headwinds, violent storms and deadlocks. Any further information you require, please let me know. Regards, JC Hi! I just tried this on x86: 40 threads against single table having 10k rows. No deadlocks, "tps: 12372.40, reads: 173219.52, writes: 49490.51". This is with latest snapshot of 10.1 and sysbench 1.0. I believe you shouldn't see deadlocks on such a big data set. Probably something is wrong with your configs? Regards, Sergey On Thu, Jun 08, 2017 at 04:51:31PM +0200, J. Cassidy wrote: > > > Hello Mark, > > appreciate the reply. > > The OLTP table size and > OLTP size give me a DB size of appx 12GB. This is what I want. I have in the > meantime, looked at some older logs and see that whatever amount of threads I > specify (8, 16,32, 64 or 128), the deadlock messages are still surfacing in the > R/W phase > of Sysbench. I even dropped in two different MariaDB release levels > (10.0.19, 10.1.24) to see whether it would make a difference, deadlock still > there. I am using Sysbench 0.5 for these tests. > I am currently using MariaDB > 10.1.24 - built directly on the machine. S390x by the way, but the problem is > also > occuring on an X86-64 box. > > Regards, > > > JC > > > > I run sysbench frequently with MySQL > (not MariaDB yet) and don't recall ever seeing this error. But I use much > larger values for --oltp-table-size. You used 85937 and I use 1M or larger. > Maybe > there is too much data contention with smaller tables, even if a large number of > tables is used (128 in your case). I use a smaller number of tables - between 4 > and 20. On Thu, Jun 8, 2017 at 12:48 AM, J. Cassidy sean(a)jdcassidy.eu> wrote: > Hello all, > > > have used Sysbench extensively to test MariaDB CPU load factors between various > architectures. > > I am noticing massive amounts of "[ERROR] mysqld: > Deadlock found when trying to get lock; try restarting transaction" in the > MariaDB error log during the R/W phase. The Sysbench R/W TPS rates are still > respectable for my purposes, but how do I > correct this condition?? Can I > ignore this / must live with it? > I have tried three different MariaDB > releases (10.0.19, 10.1.12, 10.1.24) to narrow things down, but this message (x > 1000's) is happening across all releases in the Sysbench R/W phase. > > Here is the Sysbench command that drives the workload against MariaDB - > > sysbench --test=lua/oltp.lua --oltp_tables_count=128 --oltp-table-size=85937 > --rand-seed=42 --rand-type=uniform --num-threads=128 --oltp-read-only=off > --report-interval=2 --mysql-socket=/var/lib/mysql/mysql.sock --max-time=201 > --max-requests=0 --mysql-user=root --percentile=99 run > > Would anyone > have a tip / idea /pointer? > > > Regards, > > > JC > > > John Cassidy > > Obere Bühlstrasse 21 > 8700 Küsnacht > (ZH) > Switzerland / Suisse / Schweiz > > > Mobile: +49 152 58961601 (Germany) > Mobile: +352 621 577 149 (Luxembourg) > Mobile: +41 78 769 17 97 (CH) > Landline: +41 44 509 1957 > > http://www.jdcassidy.eu > > "Aut viam inveniam aut > faciam" - Hannibal. > _______________________________________________ > 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 > --Mark Callaghan > mdcallag(a)gmail.com > > John Cassidy > > Obere Bühlstrasse 21 > 8700 > Küsnacht (ZH) > Switzerland / Suisse / Schweiz > > > Mobile: > +49 152 58961601 (Germany) > Mobile: +352 621 577 149 (Luxembourg) > Mobile: > +41 78 769 17 97 (CH) > Landline: +41 44 509 1957 > > http://www.jdcassidy.eu > > "Aut viam inveniam aut faciam" - > Hannibal. > _______________________________________________ > 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 John Cassidy Obere Bühlstrasse 21 8700 Küsnacht (ZH) Switzerland / Suisse / Schweiz Mobile: +49 152 58961601 (Germany) Mobile: +352 621 577 149 (Luxembourg) Mobile: +41 78 769 17 97 (CH) Landline: +41 44 509 1957 http://www.jdcassidy.eu "Aut viam inveniam aut faciam" - Hannibal. John Cassidy Obere Bühlstrasse 21 8700 Küsnacht (ZH) Switzerland / Suisse / Schweiz Mobile: +49 152 58961601 (Germany) Mobile: +352 621 577 149 (Luxembourg) Mobile: +41 78 769 17 97 (CH) Landline: +41 44 509 1957 http://www.jdcassidy.eu "Aut viam inveniam aut faciam" - Hannibal.

4 11

[Maria-discuss] logging original SQL statement along with ROW events
by Justin Swanhart 09 Jun '17

09 Jun '17

Hi, I seem to recall reading that MariaDB can annotate the binary log with the original SQL statement for a given set of ROW changes in the binary log, but I can't seem to find documentation on this on the wiki. Can MariaDB log the original STATEMENT along with the ROW changeset? If so, can you point me to the relevant documentation, or better yet the patch itself that makes this possible? Thanks, --Justin

3 3

[Maria-discuss] Deadlocks in R/W phase of Sysbench
by J. Cassidy 08 Jun '17

08 Jun '17

Hello all, have used Sysbench extensively to test MariaDB CPU load factors between various architectures. I am noticing massive amounts of "[ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction" in the MariaDB error log during the R/W phase. The Sysbench R/W TPS rates are still respectable for my purposes, but how do I correct this condition?? Can I ignore this / must live with it? I have tried three different MariaDB releases (10.0.19, 10.1.12, 10.1.24) to narrow things down, but this message (x 1000's) is happening across all releases in the Sysbench R/W phase. Here is the Sysbench command that drives the workload against MariaDB - sysbench --test=lua/oltp.lua --oltp_tables_count=128 --oltp-table-size=85937 --rand-seed=42 --rand-type=uniform --num-threads=128 --oltp-read-only=off --report-interval=2 --mysql-socket=/var/lib/mysql/mysql.sock --max-time=201 --max-requests=0 --mysql-user=root --percentile=99 run Would anyone have a tip / idea /pointer? Regards, JC John Cassidy Obere Bühlstrasse 21 8700 Küsnacht (ZH) Switzerland / Suisse / Schweiz Mobile: +49 152 58961601 (Germany) Mobile: +352 621 577 149 (Luxembourg) Mobile: +41 78 769 17 97 (CH) Landline: +41 44 509 1957 http://www.jdcassidy.eu "Aut viam inveniam aut faciam" - Hannibal.

3 6

[Maria-discuss] libmariadb.so.3 compatibility
by Michal Schorm 08 Jun '17

08 Jun '17

Hello, I'm currently quite confused about the *libmariadb* library. In MariaDB 10.1.24 there are: " libmysqlclient_r.so -> libmysqlclient.so " " libmysqlclient.so -> libmysqlclient.so.18 " " libmysqlclient.so.18 -> libmysqlclient.so.18.0.0 " " libmysqlclient.so.18.0.0 " In MariaDB 10.2.6 there are: " libmariadb.so -> libmariadb.so.3 " In MariaDB-connector-c v2.3.3 there are: " libmysqlclient.so -> libmariadb.so " " libmysqlclient_r.so -> libmariadb.so " " libmariadb.so -> libmariadb.so.2 " " libmariadb.so.2 " -- 1) is "libmariadb.so.2" compatibile with "libmysqlclient.so.18.0.0"? Both API and ABI? 2) is "libmariadb.so.3" compatibile with "libmysqlclient.so.18.0.0"? Both API and ABI? 3) is "libmariadb.so.2" compatibile with "libmariadb.so.3"? Both API and ABI? Many packages in Fedora depends on "libmysqlclient.so". I would like to pack 10.2 to Fedora, but I can't before all those packages move to the libmariadb library. It would be considerably easier transfer for me, if all those libraries were compatibile, so I could provide symlinks (simmilar as in the connector C), and provide time for all those packages in Fedora to move safely. -- Michal Schorm Associate Software Engineer Core Services - Databases Team Red Hat

2 2

[Maria-discuss] MariaDB Galera Cluster 10.0.31 and Connector/Java 2.0.2 now available
by Daniel Bartholomew 07 Jun '17

07 Jun '17

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.31 and MariaDB Connector/J 2.0.2 and 1.6.1. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.31 - Release Notes: https://mariadb.com/kb/en/mgc-10031-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10031-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.31 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 2.0.2 - Release Notes: https://mariadb.com/kb/en/mcj-202-rn/ - Changelog: https://mariadb.com/kb/en/mcj-202-cl/ - Downloads: https://downloads.mariadb.org/connector-java/2.0.2/ About MariaDB Connector/ODBC: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/J 1.6.1 - Release Notes: https://mariadb.com/kb/en/mcj-161-rn/ - Changelog: https://mariadb.com/kb/en/mcj-161-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.6.1/ About MariaDB Connector/ODBC: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Time Zone help
by Karthick Subramanian 07 Jun '17

07 Jun '17

All, I am facing some strange issue, I believe its due to my ignorant, would appreciate if you can help me out on this: DB Server system OS CentOS. I have loaded the timezone tables in mysql using: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql After loading, I have restrated the DB using systemctl restart mariadb: Then I have tried below in DB: select @@global.time_zone,@@system_time_zone; [image: Inline image 1] SELECT CONVERT_TZ( NOW(), @@global.time_zone , 'UTC' ), UTC_TIMESTAMP; [image: Inline image 3] SELECT CONVERT_TZ( NOW(), @@system_time_zone , 'UTC' ), UTC_TIMESTAMP; [image: Inline image 4] SELECT CONVERT_TZ( NOW(), 'EDT' , 'UTC' ), UTC_TIMESTAMP; [image: Inline image 2] For some reason, If I use named TZ in CONVERT_TZ function for FROM_TZ, its always showing NULL. Can anyone help me out what else i can do so I can pass the abbreviation or named TZ in FROM_TZ. Regards, Karthick

2 2

[Maria-discuss] Failure upon startup due to changes in /var/lib/mysql/databasename/
by Timothy D. Legg 07 Jun '17

07 Jun '17

Hello, Thanks for the prior suggestions, they ended well. I found a behavior that I found a slight bit confounding. While I tested the server, one of the wikis I host was modified by a friend of mine. When I broke MariaDB, it was no longer feasible to start it, (to the degree that it could have taken days of tinkering), With MariaDB verified to be not running, I tarred the directory /var/lib/mysql/mywiki/ into a file mywiki_with_new_data.tar. I reinstalled MariaDB thoroughly to force the creation of a new /var/lib/mysql/ and /etc/mysql/ . I felt it was safe to recover the databases from the backup SQL file I had created on the currently running machine. Everything now works great, but the mywiki database doesn't reflect the changes anymore. So I stop the mysql process and then for the sake of recoverability, I tar up /var/lib/mysql/mywiki into a file called mywiki_without_new_data.tar. I then rm -rf /var/lib/mysql/mywiki and then untar the mywiki_with_new_data.tar in it's place. MariaDB will no longer start. If I again rm -rf /var/lib/mysql/mywiki and then untar mywiki_without_new_data.tar into the location, MariaDB starts without error. This isn't a code blue situation, my friend can recreate the change he made and that is the easiest solution, but others reading this might not have that luxury. I am also quite curious about what went wrong and how to repair the problem. I didn't think this was possible to fail. There is an interesting except from the errors described below. I'm not certain what exactly this means, or how to correct it. Given that MariaDB could have failed uncleanly when the mysql database was imported, recovery may be infeasible. (the wiki connected to MariaDB as root, it's bad, I know) <excerpt /var/lib/mysql/altdorf.err> InnoDB: Error: tablespace id is 235 in the data dictionary InnoDB: but in file ./mywiki/objectcache.ibd it is 254! 2017-06-07 11:45:08 5c7ff420 InnoDB: Assertion failure in thread 1551889440 in file fil0fil.cc line 638 InnoDB: We intentionally generate a memory trap. </excerpt> # service mysql start Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. # systemctl -l status mysql.service * mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Wed 2017-06-07 11:45:40 CEST; 1min 16s ago Process: 1692 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS) Process: 1753 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) Jun 07 11:45:08 altdorf mysql[1753]: /etc/init.d/mysql: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz ... (warning). Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: [61B blob data] Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")' Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: Jun 07 11:45:40 altdorf mysql[1753]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed! Jun 07 11:45:40 altdorf systemd[1]: mysql.service: control process exited, code=exited status=1 Jun 07 11:45:40 altdorf systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. Jun 07 11:45:40 altdorf systemd[1]: Unit mysql.service entered failed state. # journalctl -xn -- Logs begin at Wed 2017-05-24 10:06:00 CEST, end at Wed 2017-06-07 11:45:40 CEST. -- Jun 07 11:45:08 altdorf /etc/init.d/mysql[1764]: WARNING: /etc/mysql/my.cnf cannot be read. See Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: 0 processes alive and '/usr/bin/mysqladmin --de Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: [61B blob data] Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: error: 'Can't connect to local MySQL server thr Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: Check that mysqld is running and that the socke Jun 07 11:45:40 altdorf /etc/init.d/mysql[2152]: Jun 07 11:45:40 altdorf mysql[1753]: Starting MariaDB database server: mysqld . . . . . . . . . Jun 07 11:45:40 altdorf systemd[1]: mysql.service: control process exited, code=exited status=1 Jun 07 11:45:40 altdorf systemd[1]: Failed to start LSB: Start and stop the mysql database serve -- Subject: Unit mysql.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has failed. -- -- The result is failed. Jun 07 11:45:40 altdorf systemd[1]: Unit mysql.service entered failed state. # cat /var/lib/mysql/aldorf.err (excerpts from file with a database name changed to protect user privacy) 170607 11:45:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170607 11:45:08 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB-0+deb8u2) starting as process 1851 ... 170607 11:45:08 [Note] InnoDB: Using mutexes to ref count buffer pool pages 170607 11:45:08 [Note] InnoDB: The InnoDB memory heap is disabled 170607 11:45:08 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 170607 11:45:08 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 170607 11:45:08 [Note] InnoDB: Compressed tables use zlib 1.2.8 170607 11:45:08 [Note] InnoDB: Using Linux native AIO 170607 11:45:08 [Note] InnoDB: Not using CPU crc32 instructions 170607 11:45:08 [Note] InnoDB: Initializing buffer pool, size = 128.0M 170607 11:45:08 [Note] InnoDB: Completed initialization of buffer pool 170607 11:45:08 [Note] InnoDB: Highest supported file format is Barracuda. 170607 11:45:08 [Note] InnoDB: 128 rollback segment(s) are active. 170607 11:45:08 [Note] InnoDB: Waiting for purge to start InnoDB: Error: tablespace id is 235 in the data dictionary InnoDB: but in file ./mywiki/objectcache.ibd it is 254! 2017-06-07 11:45:08 5c7ff420 InnoDB: Assertion failure in thread 1551889440 in file fil0fil.cc line 638 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 170607 11:45:08 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.30-MariaDB-0+deb8u2 key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=0 max_threads=153 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 465934 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48000 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 170607 11:45:08 mysqld_safe mysqld from pid file /var/lib/mysql/altdorf.pid ended

4 3

[Maria-discuss] Error when switching to MariaDB
by Timothy D. Legg 07 Jun '17

07 Jun '17

Hello, First of all, here is what I'm working with: Original machine: MySQL Server 5.7.18-0ubuntu0.16.04.1 Destination machine: MariaDB 10.0.30-MariaDB-0+deb8u2 These two machines have no filesystem or communication with with other. I am moving to MariaDB with about 10 to 15 databases that were created in MySQL and I have had a very odd problem with the destination machine running MariaDB where the applications using these databases were having connection errors with their databases. I looked very carefully at what I had done. I exported the databases from MySQL using: $ mysqldump --all-databases > all.sql and imported the collection on the new machine with $ mysql -u root -p < all.sql When I log in as root, all appears well when I inspect the databases, but all is not well. The applications the use these databases cannot connect. I enter the command line to connect using the SQL user accounts, and guess what, they don't log in with their respective passwords. I can log in on the MySQL server using the same account/password pairs. I think it might be a permissions issue. I log into the MariaDB server as root and flush privileges, just to make sure, and I get a terribly vague error message (with no details dropped off in /var/log/mysql/ either). MariaDB [(none)]> flush privileges; ERROR 1105 (HY000): Unknown error When I reach this point, I perform something akin to these steps: sudo su service stop mysql apt-get purge mariadb-server mariadb-server-10.0 mariabd-comon mariadb-client mariadb-client-10.0 mariadb-client-core-10.0 mariadb-server-core-10.0 rm -rf /etc/mysql rm -rf /var/lib/mysql apt-get install mariadb-server mariadb-client exit and I'm asked for root password, etc and also run mysql_secure_installation with all suggested values. Voila, flush privileges works again on the MariaDB server, at least until I attempt to reinsert the databases. Are these problems somewhat unique? Is there a way to pry additional detail from mariadb, such as launching the server in a debug mode? What scenarios have people seen cause this in the past? Where do I look for detailed symptoms? Timothy D. Legg

2 2

[Maria-discuss] Maxscale: qlafilter
by Atif Ghaffar 06 Jun '17

06 Jun '17

Hi all, I have setup a maxscale instance to proxy to the local mysql server running on a different port. All this is working fine. I have also setup a filter to catch deletes on a single table. I can see the deletes in the filter but only when I restart maxscale service. Is there something that I can set so that the log is flushed immediately to the flle. The filter definition is the following [WaCountriesDomainsDeleteFilter] type=filter module=qlafilter options=ignorecase,extended filebase=/tmp/maxscale.wa_countries_domains.delete match=DELETE.*wa_countries_domains.* log_type=unified append=true kind regards -- Atif Ghaffar

2 2

[Maria-discuss] MyRocks:recommended configuration for DB of several TB ?
by Julien Muchembled 01 Jun '17

01 Jun '17

Hello, We have started to evaluate MyRocks 3 months ago, our DBs were initially empty and now they have reached 500 GB on-disk. We experience severe performance issues, and we have the feelings it could be better. https://github.com/facebook/rocksdb/wiki/RocksDB-Tuning-Guide is interesting, especially the "Universal Compaction" section: « Universal compaction has a size limitation. Please be careful when your DB (or column family) size is over 100GB. » I don't think that write amplification is a bottleneck for our application, so my obvious first question is: What compaction style is used in MariaDB and how to make sure that Level Style Compaction is used ? Also, we haven't set any 'rocksdb_*' option. The default configuration may not be appropriate in our case. For example, rocksdb_block_cache_size (default: 512MB) seems to be one of the most important options, similarly to innodb_buffer_pool_size and tokudb_cache_size, although I have never understood why (see my unanswered question at https://lists.launchpad.net/maria-discuss/msg02683.html ). Although the DB is much bigger than RAM (128 GB), RAM should be big enough to contain the active working set. Julien

2 1

[Maria-discuss] MariaDB 10.1.24 and Connector/C 2.3.3 now available
by Daniel Bartholomew 31 May '17

31 May '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.24 and MariaDB Connector/C 2.3.3. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.24 - Release Notes: https://mariadb.com/kb/en/mdb-10124-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10124-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.24 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/C 2.3.3 - Release Notes: https://mariadb.com/kb/en/mcc-233-rn/ - Changelog: https://mariadb.com/kb/en/mcc-233-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.3.3/ About MariaDB Connector/ODBC: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Ubuntu 16.04, Accidentally installed mariadb-server on top of mysql-server
by rich.greder＠hushmail.com 29 May '17

29 May '17

Hello, Guys, I did a bad one. I only had one server remaining that still had mysql installed and thinking I was logged into my laptop's console, I executed apt-get install mariadb-server. I wasn't on my laptop. I was logged into a virtual hosting server and knocked eight sites offline including my wiki of all my HOWTO documents ironically, describing how to install mariadb-server on various platforms. I didn't notice anything was amiss until I saw a comment that it was uninstalling mysql (which I knew wasn't on my laptop) I was able to log in using my old root password, but all my databases were gone. Is there any hope for recovering the databases as they were earlier today? Rich

2 3

[Maria-discuss] thank you for getting MyRocks into MariaDB 10.2
by MARK CALLAGHAN 26 May '17

26 May '17

I look forward to trying it out. -- Mark Callaghan mdcallag(a)gmail.com

5 8

[Maria-discuss] MariaDB 10.2.6 Delay slave question?
by Ljr Yang 24 May '17

24 May '17

HI, Today, we upgrade a group MariaDB 10.1.22 to MariaDB 10.2.6, after upgade, start delay slave : change master to master_delay=86400 start slave and execute show all slaves status , Seconds_Behind_Master continue grow and Exec_Master_Log_Pos not change, please help confirm what cause lead this ? thanks. Slave_IO_Running: Yes Slave_SQL_Running: Yes * Exec_Master_Log_Pos: 367* Seconds_Behind_Master: 116072 Gtid_IO_Pos: 0-227-72846307321 Parallel_Mode: conservative SQL_Delay: 86400 SQL_Remaining_Delay: 83164 Slave_SQL_Running_State: Waiting until MASTER_DELAY seconds after master executed event after 5 minutes, Slave_IO_Running: Yes Slave_SQL_Running: Yes * Exec_Master_Log_Pos: 367* Seconds_Behind_Master: 116550 Gtid_IO_Pos: 0-227-72846546131 Parallel_Mode: conservative SQL_Delay: 86400 SQL_Remaining_Delay: 82686 Slave_SQL_Running_State: Waiting until MASTER_DELAY seconds after master executed event

1 0

[Maria-discuss] MariaDB 10.2.6 Stable (GA) now available
by Daniel Bartholomew 23 May '17

23 May '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.6 Stable (GA). This is the first stable release in the MariaDB 10.2 series. MariaDB 10.0.31 and MariaDB Connector/ODBC 2.0.15 have also been released. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.6 - Release Notes: https://mariadb.com/kb/en/mdb-1026-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1026-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.6 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB 10.0.31 - Release Notes: https://mariadb.com/kb/en/mdb-10031-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10031-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.31 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/ODBC 2.0.15 - Release Notes: https://mariadb.com/kb/en/mco-2015-rn/ - Changelog: https://mariadb.com/kb/en/mco-2015-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.15/ About MariaDB Connector/ODBC: - https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Connector Net Question
by ksubramanian＠paycommerce.com 17 May '17

17 May '17

All, We have set auto-commit=false at server level. But our .Net developers want to enable this auto-commit as true (default behaviour) that I hesitant to do that. Is there any connector (driver) properties that we can set at connection level for auto-commit. I know in JDBC driver, we have the properties that we can set at driver level when we establish connection to DB. But for connector/Net I am trying to find, couldn’t locate one. I noticed auto-enlist sett to true or false, not sure whether this will mimic the auto-commit functionality in a given connection. Can anyone using .Net and MariaDB combination help me to share your thought on this. Regards, Karthick Sent from Mail for Windows 10

2 3

Re: [Maria-discuss] Connector Net Question
by Federico Razzoli 17 May '17

17 May '17

Note that the auto commit was always enabled by default in MySQL. So, changing this default would probably break most existing applications. Running a multi-statement transaction in autocommit is possible by using START TRANSACTION explicitly. Applications can do this and just don't care about autocommit value, if they want. Cheers, Federico -------------------------------------------- Mer 17/5/17, <ksubramanian(a)paycommerce.com> ha scritto: Oggetto: Re: [Maria-discuss] Connector Net Question A: "Vladislav Vaintroub" <vvaintroub(a)gmail.com>, "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 17 maggio 2017, 16:36 #yiv0052539947 #yiv0052539947 -- _filtered #yiv0052539947 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv0052539947 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv0052539947 #yiv0052539947 p.yiv0052539947MsoNormal, #yiv0052539947 li.yiv0052539947MsoNormal, #yiv0052539947 div.yiv0052539947MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;color:windowtext;} #yiv0052539947 a:link, #yiv0052539947 span.yiv0052539947MsoHyperlink {color:blue;text-decoration:underline;} #yiv0052539947 a:visited, #yiv0052539947 span.yiv0052539947MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;} #yiv0052539947 pre {margin:0cm;margin-bottom:.0001pt;font-size:10.0pt;color:black;} #yiv0052539947 span.yiv0052539947HTMLPreformattedChar {color:black;} #yiv0052539947 .yiv0052539947MsoChpDefault {} _filtered #yiv0052539947 {margin:72.0pt 72.0pt 72.0pt 72.0pt;} #yiv0052539947 div.yiv0052539947WordSection1 {} #yiv0052539947 The reason for disable the auto-commit is to mimic more or less similar to oracle behaviour. Because our existing system was in oracle. Just asking out of curiosity – why we enable auto-commit by default in Maria DB. I felt that it wont give control on how we maintain the transaction. Can anyone provide some reasons for why we need to keep the auto-commit enabled at server level. Sent from Mail for Windows 10 From: Vladislav Vaintroub Sent: 17 May 2017 18:08 To: ksubramanian(a)paycommerce.com; Maria Discuss Subject: Re: [Maria-discuss] Connector Net Question On 17.05.2017 11:26, ksubramanian(a)paycommerce.com wrote:All, We have set auto-commit=false at server level. But our .Net developers want to enable this auto-commit as true (default behaviour) that I hesitant to do that. Is there any connector (driver) properties that we can set at connection level for auto-commit. I know in JDBC driver, we have the properties that we can set at driver level when we establish connection to DB. But for connector/Net I am trying to find, couldn’t locate one. I noticed auto-enlist sett to true or false, not sure whether this will mimic the auto-commit functionality in a given connection. Can anyone using .Net and MariaDB combination help me to share your thought on this. Out of curiosity, what is the reason for you to use the non-default behavior (global auto-commit=false)? As far as I know, you cannot set arbitrary session variable automatically with C/NET, and there is no property for autocommit. Thus this would need to be done in code, just after connecting, e.g command.executeNonQuery("set @@autocommit=1") Regards,Karthick Sent from Mail for Windows 10 _______________________________________________Mailing list: https://launchpad.net/~maria-discussPost to : maria-discuss(a)lists.launchpad.netUnsubscribe : https://launchpad.net/~maria-discussMore help : https://help.launchpad.net/ListHelp _______________________________________________ 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] Cross compile error
by Lucian Cristian 16 May '17

16 May '17

Hi I'm trying to cross compile (any 10.* versions) using musl and uClibc++ for a LEDE/Openwrt system and I have problems with these errors: staging_dir/target-x86_64_musl/usr/include/uClibc++/associative_base:444:8: error: 'void std::__base_associative<Key, ValueType, Compare, Allocator>::swap(std::__base_associative<Key, ValueType, Compare, Allocator>&) [with Key = dict_foreign_t*; ValueType = dict_foreign_t*; Compare = dict_foreign_compare; Allocator = ut_allocator<dict_foreign_t*>]' is protected void __base_associative<Key, ValueType, Compare, Allocator>::swap(__base_associative<Key, ValueType, Compare, Allocator>& m) ^ build_dir/target-x86_64_musl/mariadb-10.2.4/storage/innobase/dict/dict0dict.cc:1996:32: error: within this context table->foreign_set.swap(fk_set); ^ storage/innobase/CMakeFiles/innobase.dir/build.make:542: recipe for target 'storage/innobase/CMakeFiles/innobase.dir/dict/dict0dict.cc.o' failed staging_dir/target-x86_64_musl/usr/include/uClibc++/map: In instantiation of 'std::map<Key, T, Compare, Allocator>::reference std::map<Key, T, Compare, Allocator>::operator[](const key_type&) [with Key = const char*; T = dict_index_t*; Compare = ut_strcmp_functor; Allocator = ut_allocator<std::pair<const char*, dict_index_t*> >; std::map<Key, T, Compare, Allocator>::reference = std::pair<const char*, dict_index_t*>&; std::map<Key, T, Compare, Allocator>::key_type = const char*]': build_dir/target-x86_64_musl/mariadb-10.2.4/storage/innobase/dict/dict0stats.cc:2518:22: required from here staging_dir/target-x86_64_musl/usr/include/uClibc++/map:143:13: error: invalid initialization of reference of type 'std::map<const char*, dict_index_t*, ut_strcmp_functor, ut_allocator<std::pair<const char*, dict_index_t*> > >::reference {aka std::pair<const char*, dict_index_t*>&}' from expression of type 'dict_index_t*' return i->second; ^ storage/innobase/CMakeFiles/innobase.dir/build.make:614: recipe for target 'storage/innobase/CMakeFiles/innobase.dir/dict/dict0stats.cc.o' failed build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp: In constructor 'dena::hstcpsvr::hstcpsvr(const dena::config&)': build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp:92:37: error: invalid initialization of non-const reference of type 'std::auto_ptr<volatile dena::database_i>&' from an rvalue of type 'dena::database_ptr {aka std::auto_ptr<volatile dena::database_i>}' cshared.dbptr = database_i::create(c); ^ In file included from staging_dir/target-x86_64_musl/usr/include/uClibc++/vector:22:0, from build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp:12: staging_dir/target-x86_64_musl/usr/include/uClibc++/memory:137:12: note: initializing argument 1 of 'std::auto_ptr<T>& std::auto_ptr<T>::operator=(std::auto_ptr<T>&) [with T = volatile dena::database_i]' auto_ptr& operator=(auto_ptr& p) throw(){ ^ plugin/handler_socket/CMakeFiles/handlersocket.dir/build.make:134: recipe for target 'plugin/handler_socket/CMakeFiles/handlersocket.dir/handlersocket/hstcpsvr.cpp.o' failed make[5]: *** [plugin/handler_socket/CMakeFiles/handlersocket.dir/handlersocket/hstcpsvr.cpp.o] Error 1 this is the command line (cd /build_dir/target-x86_64_musl/mariadb-10.2.4; CFLAGS="-Os -pipe -fno-caller-saves -fno-plt -fhonour-copts -Wno-error=unused-but-set-variable -Wno-error=unused-result -iremap/build_dir/target-x86_64_musl/mariadb-10.2.4:mariadb-10.2.4 -Wformat -Werror=format-security -fstack-protector -D_FORTIFY_SOURCE=1 -Wl,-z,now -Wl,-z,relro -fpic " CXXFLAGS="-Os -pipe -fno-caller-saves -fno-plt -fhonour-copts -Wno-error=unused-but-set-variable -Wno-error=unused-result -iremap/build_dir/target-x86_64_musl/mariadb-10.2.4:mariadb-10.2.4 -Wformat -Werror=format-security -fstack-protector -D_FORTIFY_SOURCE=1 -Wl,-z,now -Wl,-z,relro -fpic " LDFLAGS="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro " cmake -DCMAKE_SYSTEM_NAME=Linux -DCMAKE_SYSTEM_VERSION=1 -DCMAKE_SYSTEM_PROCESSOR=x86_64 -DCMAKE_BUILD_TYPE=Release -DCMAKE_C_FLAGS_RELEASE="-DNDEBUG" -DCMAKE_CXX_FLAGS_RELEASE="-DNDEBUG" -DCMAKE_C_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc" -DCMAKE_C_COMPILER_ARG1="" -DCMAKE_CXX_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/g++-uc" -DCMAKE_CXX_COMPILER_ARG1="" -DCMAKE_ASM_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc" -DCMAKE_ASM_COMPILER_ARG1="" -DCMAKE_EXE_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro" -DCMAKE_MODULE_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro -Wl,-Bsymbolic-functions" -DCMAKE_SHARED_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro -Wl,-Bsymbolic-functions" -DCMAKE_AR="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-ar" -DCMAKE_NM="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-nm" -DCMAKE_RANLIB="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-ranlib" -DCMAKE_FIND_ROOT_PATH="/staging_dir/target-x86_64_musl/usr;/staging_dir/toolchain-x86_64_gcc-5.4.0_musl" -DCMAKE_FIND_ROOT_PATH_MODE_PROGRAM=BOTH -DCMAKE_FIND_ROOT_PATH_MODE_LIBRARY=ONLY -DCMAKE_FIND_ROOT_PATH_MODE_INCLUDE=ONLY -DCMAKE_STRIP=: -DCMAKE_INSTALL_PREFIX=/usr -DDL_LIBRARY=/staging_dir/target-x86_64_musl -DCMAKE_PREFIX_PATH=/staging_dir/target-x86_64_musl -DCMAKE_SKIP_RPATH=TRUE -DCMAKE_SYSTEM_NAME=Linux -DSTACK_DIRECTION=-1 -DWITH_WSREP=ON -DWITH_INNODB_DISALLOW_WRITES=1 -DCONNECT_WITH_JDBC=OFF -DWITHOUT_TOKUDB=1 -DIMPORT_EXECUTABLES=/build_dir/hostpkg/mariadb-10.2.4/host/import_executables.cmake /build_dir/target-x86_64_musl/mariadb-10.2.4 ) can someone give me an advice ? Regards

2 2

[Maria-discuss] AWS Key Management plugin
by Christopher Hendry 10 May '17

10 May '17

Currently configuring MariaDB for at rest encryption using Amazon key management. A few weeks ago, I setup our primary server with no problems (Centos 7). Recently, working on the same hardware/OS for slaves - when I do a yum install MariaDB-aws-key-management I get: "No package MariaDB-aws-key-management available." I did discover that since the first successful install, the RPM versions have changed from 10.1.22 to 10.1.23 (and have included some config options for 10.2 that need to be commented out). I also believe that originally I had to change plugin-maturity in config = alpha - but that makes no difference now. Anyone know what happened to the plugin? I can copy the original one from my primary server and all works fine - but I don't love that approach. Is aws-key-management plugin still supported? Thanks for any insight. C -- "When you do things right, people won't be sure you've done anything at all."

2 1

Re: [Maria-discuss] MySQL Workbench Fork?
by Federico Razzoli 07 May '17

07 May '17

Well, clicking around, selecting things, switching to keyboards, and so on, can hardly be faster than writing an SQL statement - provided that you learn ALTER TABLE syntax. But, apart from that, I think that we mostly agree on everything except one thing: the meaning of enterprise. In an enterprise environment a DBA needs to automate everything and write scripts. Also, as I wrote before and the author of that post also says, GUI's are not reliable, you never know exactly what they do. That said, I suppose that GUIs can be useful for someone, especially for developers and hobbyists. Cheers, Federico -------------------------------------------- Gio 27/4/17, <info(a)smallbusinessconsultingexperts.com> ha scritto: Oggetto: Re: [Maria-discuss] MySQL Workbench Fork? A: maria-discuss(a)lists.launchpad.net, "Federico Razzoli" <federico_raz(a)yahoo.it> Data: Giovedì 27 Aprile 2017, 20:34 Sure, but don't confuse a post with a fact either. That's great he has an opinion that you share, I am sure I can find many more that say the opposite. What I got from his post is there are some things a gui cannot do, which is of course the case. So? The opposite is true also, if you add the word quickly. That does not make a point as universal true or factual. Should we abandon SNMP and other standards type network consoles (gui) since obviously we can do the same thing without them? You don't see the value is the gui network view? So, workbench feature of showing you a refreshing graphical status of your server isn't useful? It's not complete by any means, but it is useful, just like the connections screen showing running queries. Those are just examples which some will desire to pick on. But I think it's a reasonable view. My point is not guis are (always) better, they each have a place. On Apr 27, 2017, 1:23 PM -0500, Federico Razzoli <federico_raz(a)yahoo.it>, wrote: I've just seen this Quora answer, which lists some good reasons to avoid GUIs. There are others. Again: my point is not "GUI's shouldn't exist", it's just "please don't call them an enterprise software, because they are not". https://www.quora.com/Do-database-administrators-actually-think-that-GUIs-a…

8 8

[Maria-discuss] MySQL Workbench Fork?
by Zach Lym 05 May '17

05 May '17

I convinced my boss to use MariaDB for a new project but it appears that the workbench is incompatible with new features of MariaDB. I've looked at the alternatives listed on the website, but they are all either proprietary or Windows only. I just can't sell my boss on switching to MariaDB without workbench. Free software isn't free, but I think Workbench is a big driver of commercial and enterprise use. It's easy to kvetch from the outside, but I feel as though MariaDB has just lost some ground. Has management considered forking Workbench? Thank you, -Zach Lym

9 12

[Maria-discuss] MariaDB 10.1.23 & 5.5.56 now available
by Daniel Bartholomew 03 May '17

03 May '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.23, MariaDB 5.5.56 and MariaDB Galera Cluster 5.5.56. All are Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.23 - Release Notes: https://mariadb.com/kb/en/mdb-10123-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10123-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.23 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB 5.5.56 - Release Notes: https://mariadb.com/kb/en/mdb-5556-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5556-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.56 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-56/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Galera Cluster 5.5.56 - Release Notes: https://mariadb.com/kb/en/mgc-5556-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5556-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.56 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] lz4 innodb compression
by Reinis Rozitis 28 Apr '17

28 Apr '17

Hello, is lz4 support not compiled in the Mariadb rpm (Opensuse) packages or are there some runtime requirements or you have to rebuild from source? MariaDB> set global innodb_compression_algorithm=lz4; ERROR 1231 (42000): Variable 'innodb_compression_algorithm' can't be set to the value of 'lz4' while MariaDB> set global innodb_compression_algorithm=lzo; Query OK, 0 rows affected (0.00 sec) Server version: 10.2.5-MariaDB-log MariaDB Server / OpenSUSE Leap 42.2 / on system: lz4-1.4.0+svn124-3.3.x86_64 liblz4-1_4-1.4.0+svn124-3.3.x86_64 rr

3 4

[Maria-discuss] howto debug “Slave SQL: Error executing row event” and “Node consistency compromized, aborting…” and “Failed to apply trx: source”
by Lukas Lehner 28 Apr '17

28 Apr '17

Hi https://dba.stackexchange.com/questions/172230/howto-debug-slave-sql-error-… any idea? Lukas

1 0

[Maria-discuss] M|17 MariaDB Conference 2017 videos
by Lukas Lehner 27 Apr '17

27 Apr '17

Hi where can I watch M|17 video recordings? Is this planned? Will it be free or only for customers? Lukas

2 1