- discuss - lists.mariadb.org

[Maria-discuss] New Question: Why does libmariadb require libssl.so.1.0.0(OPENSSL_1.0.0)?
by AskMonty KB 09 Oct '15

09 Oct '15

Hello, A new question has been asked in "MariaDB Community" by johnnyoj. Please answer it at http://mariadb.com/kb/en/why-does-libmariadb-require-libsslso100openssl_100/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I’m currently using MariaDB C Connector 2.2 and it has a dependency on OpenSSL 1.0.0 (libssl.so.1.0.0 with version definition OPENSSL_1.0.0). [root@server5088-vm07 2.2.0]# ldd reporter ./reporter: /root/2.2.0-redhat/./libssl.so.1.0.0: version `OPENSSL_1.0.0' not found (required by /root/2.2.0-redhat/./libmariadb.so.2) libmariadb.so.2 => /root/2.2.0-redhat/./libmariadb.so.2 (0x0019e000) libssl.so.1.0.0 => /root/2.2.0-redhat/./libssl.so.1.0.0 (0x0021c000) [stuff del] Why? All OpenSSL 1.0.x releases are binary compatible (https://www.openssl.org/docs/faq.html#MISC8) In addition my RH release ships with OpenSSL 1.0.1 and there should be no reason I need to maintain 2 versions of OpenSSL. Any guidance would be appreciated. [root@server5088-vm07 2.2.0-redhat]# objdump -p libssl.so.1.0.0 | grep OPENSSL_ 3 0x00 0x066a2b21 OPENSSL_1.0.1 4 0x00 0x02b21533 OPENSSL_1.0.1_EC 0x02b21533 0x00 08 OPENSSL_1.0.1_EC [root@server5088-vm07 2.2.0-redhat]# ls -al total 1756 drwxr-xr-x. 2 root root 4096 Oct 9 10:10 . dr-xr-x---. 12 root root 4096 Oct 9 10:04 .. -r-x------. 1 root root 1281934 Oct 9 10:05 libmariadb.so.2 lrwxrwxrwx. 1 root root 25 Oct 9 10:10 libssl.so.1.0.0 -> /usr/lib/libssl.so.1.0.1e -r-x------. 1 root root 507756 Oct 9 10:05 reporter -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/why-does-libmariadb-require-libsslso100openssl_100/

1 0

[Maria-discuss] Can someone explain odd InnoDB locking behavior
by Yuri Karaban 09 Oct '15

09 Oct '15

Hi I'm trying to understand why InnoDB locks two next-key intervals higher than needed. If you try to run conn-a.sql from one connection, and then run conn-b.sql from other connection, conn-b.sql would be locked. I have a feeling that it locks two next-key intervals: (5 to 7 and 7 to positive infinity). Because I can insert values higher than 7 in conn-b only if condition is WHERE n <= 4 (or lower than 4). TokuDB locks just one next-key interval (with WHERE n <= 7, TokuDB locks from -infinity to +infinity, but with condition WHERE n <= 6, it locks from -infinity to 6). Please help me to understand why ever both engines need to lock gap after the upper end of range scan. And why InnoDB needs to lock even two next-key gaps. I tried this on MariaDB 10.0.21 ----------------------[conn-a.sql]-------------------------------- DROP TABLES IF EXISTS innosel, innoin; CREATE TABLE innosel (n INT UNSIGNED PRIMARY KEY) ENGINE InnoDB; CREATE TABLE innoin (n INT UNSIGNED PRIMARY KEY) ENGINE InnoDB; INSERT INTO innosel values (1), (3), (5), (7); SET tx_isolation = 'REPEATABLE-READ'; START TRANSACTION; INSERT IGNORE INTO innoin (n) SELECT n FROM innosel WHERE n <= 5; SELECT SLEEP(100); ROLLBACK; ----------------------[conn-a.sql]-------------------------------- ----------------------[conn-b.sql]-------------------------------- START TRANSACTION; INSERT INTO innosel VALUES (9); ROLLBACK; ----------------------[conn-b.sql]-------------------------------- -- Nemo iudex in causa sua.

2 2

[Maria-discuss] New Question: Problems with user access to db
by AskMonty KB 08 Oct '15

08 Oct '15

Hello, A new question has been asked in "Downloads" by mathman54. Please answer it at http://mariadb.com/kb/en/problems-with-user-access-to-db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have MariaDB 10.1 installed. I am trying to get some software installed but am running into problems. I have created a database and user for that database, but when I run the software it cannot connect to the database. The user I created was on the database sam I used the command MySQL -u sam -p'sam's password' sam's database I get access denied for user 'sam'@'localhost' I used the command "grant all privileges on newdb.* to sam@localhost;" I also did a "grant usage on *.* to sam@localhost identified by 'sams password'; Is there something I am doing wrong? Is there something I am missing? Your help is appreciated. Thank you, Mark -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problems-with-user-access-to-db/

1 0

[Maria-discuss] New Question: Need help modifing the mysqld_multi script
by AskMonty KB 08 Oct '15

08 Oct '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/need-help-modifing-the-mysqld_multi-script/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I running a multi instance mariadb cluster with 3 nodes. The nodes are all SUSE (SLES) 12. I have copied the mysqld_multi script form /usr/bin to /etc/init.d to enable the startup and shutdown of all the databases when the system starts and stops. Problem I'm having is that if I use mysqld_mult stop/start (to stop/start them all) only one or two will actually stop/start the rest just won't work. But I f I start/stop them one at a time with a few seconds delay between commands it works just fine. So what I'm looking to do is to modify the mysqld_multi script to add a 5 sec delay in between each instances start/stop. Just not where the best place in the script to do this. Any ideas ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/need-help-modifing-the-mysqld_multi-script/

1 0

[Maria-discuss] New Question: Galera Documentation
by AskMonty KB 07 Oct '15

07 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/galera-documentation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can someone point me in the right direction for setting up a MariaDB galera cluster. I see all the MariaDB documentation but I don't see any cluster info ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-documentation/

1 0

[Maria-discuss] MariaDB / Sysbench TPS question
by J. Cassidy 07 Oct '15

07 Oct '15

Hello all, I am running MariaDB 10.1.5 with Sysbench 0.5 (lua) against an IBM Blade (Haswell) using Hitachi 15K SAS Hdd's. Operating system is RHEL 7. Hyperthreading is turned off. System memory is 48GB. Up to now, I have ran extensive Sysbench tests against MariaDB using RAM as the datastore with no appreciable problems. Now I have switched the datastore to normal disk (see above) and am seeing the Sysbench R/W TPS rate take a hit after approximately 3 minutes (180 seconds) into the run (runtime is 600 seconds) and every three minutes thereafter. I am seeing nothing in the MariaDB logs (error and Slow queries), nor in Linux itself, nor is Sysbench telling me anything (I have debug rurned on and verbosity set to 5). Here is an excerpt from one of the R/W Sysbench runs [ 168s] threads: 128, tps: 26262.00, reads: 367679.02, writes: 105188.51, response time: 50.12ms (99%), errors: 0.00, reconnects: 0.00 [ 170s] threads: 128, tps: 25913.49, reads: 362826.86, writes: 103670.96, response time: 49.08ms (99%), errors: 0.00, reconnects: 0.00 [ 172s] threads: 128, tps: 26271.51, reads: 367736.58, writes: 105009.52, response time: 50.34ms (99%), errors: 0.00, reconnects: 0.00 [ 174s] threads: 128, tps: 26059.52, reads: 364822.73, writes: 104187.07, response time: 44.69ms (99%), errors: 0.00, reconnects: 0.00 [ 176s] threads: 128, tps: 26394.00, reads: 369573.99, writes: 105652.50, response time: 52.28ms (99%), errors: 0.00, reconnects: 0.00 [ 178s] threads: 128, tps: 26248.49, reads: 367422.90, writes: 104927.97, response time: 49.85ms (99%), errors: 0.00, reconnects: 0.00 [ 180s] threads: 128, tps: 26549.00, reads: 371726.52, writes: 106166.01, response time: 60.01ms (99%), errors: 0.00, reconnects: 0.00 [ 182s] threads: 128, tps: 21493.92, reads: 301020.88, writes: 86033.18, response time: 47.29ms (99%), errors: 0.00, reconnects: 0.00 [ 184s] threads: 128, tps: 174.00, reads: 2435.96, writes: 706.99, response time: 2245.86ms (99%), errors: 0.00, reconnects: 0.00 [ 186s] threads: 128, tps: 185.50, reads: 2597.00, writes: 760.50, response time: 2334.28ms (99%), errors: 0.00, reconnects: 0.00 [ 188s] threads: 128, tps: 269.00, reads: 3766.00, writes: 1066.50, response time: 2314.11ms (99%), errors: 0.00, reconnects: 0.00 [ 190s] threads: 128, tps: 153.50, reads: 2149.00, writes: 619.50, response time: 2121.06ms (99%), errors: 0.00, reconnects: 0.00 [ 192s] threads: 128, tps: 552.00, reads: 7728.00, writes: 2199.50, response time: 1440.33ms (99%), errors: 0.00, reconnects: 0.00 [ 194s] threads: 128, tps: 615.00, reads: 8610.00, writes: 2450.00, response time: 1414.69ms (99%), errors: 0.00, reconnects: 0.00 [ 196s] threads: 128, tps: 908.00, reads: 12712.00, writes: 3650.00, response time: 950.93ms (99%), errors: 0.00, reconnects: 0.00 [ 198s] threads: 128, tps: 1579.00, reads: 22052.47, writes: 6283.99, response time: 932.61ms (99%), errors: 0.00, reconnects: 0.00 [ 200s] threads: 128, tps: 1562.00, reads: 21921.53, writes: 6257.01, response time: 748.43ms (99%), errors: 0.00, reconnects: 0.00 [ 202s] threads: 128, tps: 4166.00, reads: 58323.95, writes: 16652.49, response time: 445.78ms (99%), errors: 0.00, reconnects: 0.00 [ 204s] threads: 128, tps: 11574.99, reads: 161931.90, writes: 46264.97, response time: 263.77ms (99%), errors: 0.00, reconnects: 0.00 [ 206s] threads: 128, tps: 17420.50, reads: 244004.98, writes: 69714.50, response time: 103.69ms (99%), errors: 0.00, reconnects: 0.00 [ 208s] threads: 128, tps: 19833.49, reads: 277626.90, writes: 79424.97, response time: 93.88ms (99%), errors: 0.00, reconnects: 0.00 [ 210s] threads: 128, tps: 24994.00, reads: 349910.48, writes: 99975.49, response time: 48.12ms (99%), errors: 0.00, reconnects: 0.00 [ 212s] threads: 128, tps: 25129.50, reads: 351825.03, writes: 100549.51, response time: 52.12ms (99%), errors: 0.00, reconnects: 0.00 [ 214s] threads: 128, tps: 24982.99, reads: 349739.36, writes: 99821.46, response time: 47.66ms (99%), errors: 0.00, reconnects: 0.00 My.cnf - [mysqld_safe] user=root password='' [mysqld] open_files_limit = 102400 max_allowed_packet = 768M connect_timeout = 120 # was 60 performance-schema = false net_read_timeout = 720 log-warnings=2 #####files and sockets pid-file=/tmp/mysqld.pid.sysbench log_warnings=2 log-error=/var/log/mariadb/mariadb-error-john.log long_query_time = 1 slow_query_log = 1 slow_query_log_file = /var/log/mariadb/mariadb-slowquery.log log_queries_not_using_indexes = 1 # general-log # general-log-file=/var/log/mariadb/mariadb-general.log # general_log_file=/var/log/mariadb/mariadb-general.log ##### MariaDB temporary tables tmpdir = /mnt/ramdisk #####non innodb options (fixed) max_connections = 8000 # was 4000 back_log = 150 table_open_cache = 4000 # was 8000 key_buffer_size = 16M query_cache_type = 1 # was 0 join_buffer_size = 32K sort_buffer_size = 32K #####use InnoDB plugin #ignore-builtin-innodb #plugin-load=innodb=ha_innodb.so #####fixed innodb options innodb_file_per_table = true innodb_open_files = 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 innodb_log_files_in_group = 2 innodb_buffer_pool_size = 40G innodb_buffer_pool_instances = 32 innodb_adaptive_hash_index_partitions = 32 innodb_thread_concurrency = 0 #####Power8 specific #innodb_spin_wait_delay = 0 #####tuning for SAN storage innodb_adaptive_flushing = 1 innodb_flush_neighbors = 1 innodb_io_capacity = 4000 innodb_io_capacity_max = 6000 innodb_lru_scan_depth = 4096 innodb_purge_threads = 2 innodb_read_io_threads = 8 # was 8 innodb_write_io_threads = 16 ####tuning for RAM disk #innodb_adaptive_flushing = 1 #innodb_flush_neighbors = 0 #innodb_io_capacity = 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 Would anyone be able to enlighten me as to why I am getting this TPS performance hit after approximately three minutes? Any pointers much appreciated. Regards, Aubrey

2 1

[Maria-discuss] New Question: PHP source for UDF in Maria
by AskMonty KB 07 Oct '15

07 Oct '15

Hello, A new question has been asked in "Plugins" by ronijoven. Please answer it at http://mariadb.com/kb/en/php-source-for-udf-in-maria/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to create a UDF in Maria using the PHP method in a class. There are a lot of PHP sites, this is in relation to encrypt data in MariaDB and the encryption algorithm is based on PHP. Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/php-source-for-udf-in-maria/

1 0

[Maria-discuss] Group Concat and Sub Query
by Roberto Spadim 04 Oct '15

04 Oct '15

Hi guys I have a problem and a possible solution, that i think is relative easy to develop (i didn't tested but i think the source is easy to change) i have some queries like: SELECT date, (SELECT value FROM some_table WHERE date=a.date ORDER BY date ASC LIMIT 1) AS first, (SELECT value FROM some_table WHERE date=a.date ORDER BY date DESC LIMIT 1) AS last FROM some_table AS a GROUP BY date i want to "convert" the complex sub query, to a agregate function, and i thinking about group concat: from mysql docs: GROUP_CONCAT([DISTINCT] *expr* [,*expr* ...] [ORDER BY {*unsigned_integer* | *col_name* | *expr*} [ASC | DESC] [,*col_name* ...]] [SEPARATOR *str_val*]) we have ORDER BY if we could include a "LIMIT" clause, i could rewrite this query to: SELECT date, GROUP_CONCAT(value ORDER BY date ASC LIMIT 1) AS first, GROUP_CONCAT(value ORDER BY date DESC LIMIT 1) AS last FROM some_table AS a GROUP BY date i know that i could have stats tables / materialized views (with flexview, i already tested :) ), but i want something more "easy to use" and not "very fast", just a "feature" to solve small problems it's a nice idea? does anyone have this "problem" and solve with other solutions? -- Roberto Spadim

3 11

[Maria-discuss] spider connections
by Federico Razzoli 01 Oct '15

01 Oct '15

Hi all. I'm trying to troubleshoot a weird situation, and I have processes like this: *************************** 3. row *************************** Id: 122884 User: root Host: 127.0.0.1:52222 db: dpp_ela Command: Query Time: 276 State: After opening tables Info: show table status from `dpp_ela` like 'access' Progress: 0.000 The query seems to be issued by SPIDER when "SHOW CREATE TABLE $spider_table" is issued. But why should this require a connection at all? I'd expect that query to show the local table definition. Am I missing something? Regards Federico

1 0

[Maria-discuss] what is adding the -g compile parm?
by Reindl Harald 01 Oct '15

01 Oct '15

"-O3 -g" appears in the cmake output, that likely breaks ld.gold / -flto and so the question: who the explain the build *not* add that useless param for production builds like most oterh software don't without one could also remove the strip-calls in rpm-spec-files!

2 4

[Maria-discuss] Error when migrating from TokuDB 7.5.2 to MariaDB 5.5.44 (works with 5.5.41)
by Fernando Marcelo 01 Oct '15

01 Oct '15

I'm trying to migrate a TokuDB 7.5.2 server to MariaDB 5.5.44. Since I can't stop the production server, I got a snapshot of the running instance. So MariaDB will have to recover. Unfortunately i get an error when TokuDB recovery is running in version 5.5.44. Previously I tried with MariaDB 5.5.41 which worked fine. But since I'm upgrading, I would like to use the latest version. Mon Sep 28 03:53:37 2015 TokuFT recovery bw_begin_checkpoint at 158147092471 timestamp 1443133470008593 (bw_between) Mon Sep 28 03:53:37 2015 TokuFT recovery turning around at begin checkpoint 158147092471 time 181293960 Mon Sep 28 03:53:37 2015 TokuFT recovery starts scanning forward to 158147993496 from 158147092471 left 901025 (fw_between) /home/buildbot/buildbot/build/mariadb-5.5.44/storage/tokudb/ft-index/ft/serialize/ft-serialize.cc:275 deserialize_ft_versioned: Assertion `readsz >= translation_size_on_disk' failed (errno=2) : No such file or directory Backtrace: (Note: toku_do_assert=0x0x7f769b49cf30) /usr/lib64/mysql/plugin/ha_tokudb.so(_Z19db_env_do_backtraceP8_IO_FILE+0x1b)[0x7f769b4996fb] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x80823)[0x7f769b499823] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x8089a)[0x7f769b49989a] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z24deserialize_ft_versionediP4rbufPP2ftj+0xc32)[0x7f769b525622] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z24toku_deserialize_ft_fromi10__toku_lsnPP2ft+0x229)[0x7f769b525949] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z35toku_read_ft_and_store_in_cachefileP9ft_handleP9cachefile10__toku_lsnPP2ft+0x76)[0x7f769b525bb6] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x11e20a)[0x7f769b53720a] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z28toku_ft_handle_open_recoveryP9ft_handlePKciiP10cachetableP7tokutxn7FILENUM10__toku_lsn+0x2d)[0x7f769b53938d] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x1204aa)[0x7f769b5394aa] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z14tokuft_recoverP13__toku_db_envPFvS0_P7tokutxnEPFvS0_P10cachetableEP10tokuloggerPKcSC_PFiP9__toku_dbPK10__toku_dbtSH_EPFiSE_SH_SH_SH_PFvSH_PvESK_EPFiSE_SE_P9DBT_ARRAY SQ_SH_SH_EPFiSE_SE_SQ_SH_SH_Em+0x2538)[0x7f769b5017b8] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x1107b0)[0x7f769b5297b0] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x5195f)[0x7f769b46a95f] /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x6e4018] /usr/sbin/mysqld[0x5b254d] /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x833)[0x5b7573] /usr/sbin/mysqld[0x51c638] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x47f)[0x52119f] /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f769e590af5] /usr/sbin/mysqld[0x518239] Engine status function not available Memory usage: Arena 0: system bytes = 0 in use bytes = 0 Total (incl. mmap): system bytes = 0 in use bytes = 0 max mmap regions = 0 max mmap bytes = 0 150928 3:53:37 [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. Any ideas about how to fix this issue?

2 1

[Maria-discuss] New Question: MariaDB on SGE with environmental modules
by AskMonty KB 28 Sep '15

28 Sep '15

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by netzach. Please answer it at http://mariadb.com/kb/en/mariadb-on-sge-with-environmental-modules/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi The title says it all. How do I setup MariaDB on a computer cluster using SGE and environmental modules with one shared place for the databases? I want the databases to be in /databases which is exported through a local network to the computational nodes. All computers run centos 7. Thank you Jonas Söderberg -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-on-sge-with-environmental-modules/

1 0

[Maria-discuss] MariaDB Crashes due to Stored Procedure
by Joseph Onyilo 27 Sep '15

27 Sep '15

I created two Store procedures to time table scheduling some months back and test it at the time which was fine. The first procedure has a cursor to navigate a list of records and call the second procedure. The Second Procedure has two cursors for different scenarios. Now trying to a final test before moving to production and it crashes my MariaDB Server mid way. Even when I called the Second Procedure individually with static parameters, after three to five calls MariaDB still crashes. The Operating system is Centos 6.6, MariaDB 10.0.21 and error from log displays is as follows |This could be because you hit a bug.It isalso possible that this binary orone ofthe libraries it was linked against iscorrupt,improperly built,ormisconfigured.This error can also be caused bymalfunctioning hardware.Toreport this bug,see http://kb.askmonty.org/en/reporting-bugs We will try our best toscrape up someinfo that will hopefully help diagnose the problem,but since we have already crashed,something isdefinitely wrong andthis may fail.Server version:10.0.21-MariaDB key_buffer_size=134217728read_buffer_size=131072max_used_connections=3max_threads=153thread_count=2It ispossible that mysqld could useup tokey_buffer_size +(read_buffer_size +sort_buffer_size)*max_threads =467003K bytes ofmemory Hope that's ok;ifnot,decrease somevariables inthe equation.Thread pointer:0x0x7fdac266f008 Attempting backtrace.You can usethe followinginformation tofind out wheremysqld died.Ifyou see no messages after this,something went terribly wrong...stack_bottom =0x7fdad74cfd30thread_stack 0x48000/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xb7f84b]/usr/sbin/mysqld(handle_fatal_signal+0x398)[0x72b758]/lib64/libpthread.so.0(+0xf710)[0x7fdad710b710]/usr/sbin/mysqld(_ZN13st_select_lex17mark_as_dependentEP3THDPS_P4Item+0xa0)[0x5c8410]/usr/sbin/mysqld[0x73c544]/usr/sbin/mysqld(_ZN10Item_field15fix_outer_fieldEP3THDPP5FieldPP4Item+0x62f)[0x74c78f]/usr/sbin/mysqld(_ZN10Item_field10fix_fieldsEP3THDPP4Item+0x432)[0x74ce72]/usr/sbin/mysqld(_Z12setup_fieldsP3THDPP4ItemR4ListIS1_E17enum_mark_columnsPS5_b+0x163)[0x594a03]/usr/sbin/mysqld[0x6168f3]/usr/sbin/mysqld(_ZN18st_select_lex_unit7prepareEP3THDP13select_resultm+0x39c)[0x6648ac]/usr/sbin/mysqld(_Z21mysql_derived_prepareP3THDP3LEXP10TABLE_LIST+0x206)[0x5b4bc6]/usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x193)[0x5b5bd3]/usr/sbin/mysqld(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x5ca857]/usr/sbin/mysqld(_ZN10TABLE_LIST14handle_derivedEP3LEXj+0x4f)[0x679f2f]/usr/sbin/mysqld(_Z28mysql_handle_list_of_derivedP3LEXP10TABLE_LISTj+0x3f)[0x5b5d4f]/usr/sbin/mysqld(_Z20mysql_prepare_insertP3THDP10TABLE_LISTP5TABLER4ListI4ItemEPS7_S8_S8_15enum_duplicatesPPS6_bbb+0xb8)[0x5c09a8]/usr/sbin/mysqld(_Z27mysql_insert_select_prepareP3THD+0x72)[0x5c0e62]/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x556f)[0x5d94bf]/usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1e)[0x81d26e]/usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x8b)[0x82285b]/usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x155)[0x822d45]/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x6c9)[0x820529]/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5f6)[0x821796]/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x31f9)[0x5d7149]/usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1e)[0x81d26e]/usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x8b)[0x82285b]/usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x155)[0x822d45]/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x6c9)[0x820529]/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5f6)[0x821796]/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x31f9)[0x5d7149]/usr/sbin/mysqld[0x5da9d7]/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1d0d)[0x5dce4d]/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x453)[0x69a2d3]/usr/sbin/mysqld(handle_one_connection+0x42)[0x69a3a2]/lib64/libpthread.so.0(+0x79d1)[0x7fdad71039d1]/lib64/libc.so.6(clone+0x6d)[0x7fdad581d8fd]Trying toget somevariables.Somepointers may be invalid andcause the dumptoabort.Query (0x7fdaa8818548):isan invalid pointer Connection ID (thread ID):3Status:NOT_KILLED Optimizer switch:index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=onThe manual page at http://dev.mysql.com/doc/mysql/en/crashing.html containsinformation that should help you find out what iscausing the crash.| I also did a test on MariaDB 10.0.17 on windows still no luck.

1 1

[Maria-discuss] select using date_sub produces unwanted milliseconds in results
by Dan Ragle 26 Sep '15

26 Sep '15

We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's going on in the following scenario. In brief, we're getting milliseconds displayed in a particular date_sub calculation (and possibly other selects with date arithmetic, trying to figure out how to track them down is part of the goal of this post) where we aren't expecting them. MariaDB [testdb]> show variables like '%version%'; +-------------------------+---------------------+ | Variable_name | Value | +-------------------------+---------------------+ | innodb_version | 5.5.43-MariaDB-37.2 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.5.44-MariaDB-log | | version_comment | MariaDB Server | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+---------------------+ 7 rows in set (0.00 sec) MariaDB [testdb]> show create table test \G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `datetime` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) MariaDB [testdb]> select datetime from test; Field 1: `datetime` Catalog: `def` Database: `velocitynorep` Table: `test` Org_table: `test` Type: DATETIME Collation: binary (63) Length: 19 Max_length: 19 Decimals: 0 Flags: NOT_NULL BINARY NO_DEFAULT_VALUE +---------------------+ | datetime | +---------------------+ | 2015-09-18 09:23:21 | +---------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select date_sub(datetime,interval 1 second) from test; Field 1: `date_sub(datetime,interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: DATETIME Collation: binary (63) Length: 19 Max_length: 19 Decimals: 0 Flags: BINARY +--------------------------------------+ | date_sub(datetime,interval 1 second) | +--------------------------------------+ | 2015-09-18 09:23:20 | +--------------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select substr(datetime,1,13) from test; Field 1: `substr(datetime,1,13)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 39 Max_length: 13 Decimals: 31 Flags: NOT_NULL +-----------------------+ | substr(datetime,1,13) | +-----------------------+ | 2015-09-18 09 | +-----------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select concat(substr(datetime,1,13),':00:00') -> from test; Field 1: `concat(substr(datetime,1,13),':00:00')` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 57 Max_length: 19 Decimals: 31 Flags: NOT_NULL +----------------------------------------+ | concat(substr(datetime,1,13),':00:00') | +----------------------------------------+ | 2015-09-18 09:00:00 | +----------------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select concat('2015-09-18 09',':00:00'); Field 1: `concat('2015-09-18 09',':00:00')` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 57 Max_length: 19 Decimals: 31 Flags: NOT_NULL +----------------------------------+ | concat('2015-09-18 09',':00:00') | +----------------------------------+ | 2015-09-18 09:00:00 | +----------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select date_sub(concat('2015-09-18 09',':00:00'), -> interval 1 second); Field 1: `date_sub(concat('2015-09-18 09',':00:00'), interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: STRING Collation: binary (63) Length: 19 Max_length: 19 Decimals: 0 Flags: BINARY +---------------------------------------------------------------+ | date_sub(concat('2015-09-18 09',':00:00'), interval 1 second) | +---------------------------------------------------------------+ | 2015-09-18 08:59:59 | +---------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select -> date_sub(concat(substr(datetime,1,13),':00:00'), -> interval 1 second) from test; Field 1: `date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: STRING Collation: binary (63) Length: 26 Max_length: 26 Decimals: 6 Flags: BINARY +---------------------------------------------------------------------+ | date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second) | +---------------------------------------------------------------------+ | 2015-09-18 08:59:59.000000 | +---------------------------------------------------------------------+ 1 row in set (0.00 sec) The last one is the one that has me stumped. 1.) Why does it include milliseconds in the output? According to this page: https://mariadb.com/kb/en/mariadb/microseconds-in-mariadb/ where no precision is specified the result should not display milliseconds, which is what happens in all the other examples above except this one. 2.) The statement on a 5.1 MySQL server (5.1.73-log, also 64 bit Linux) produces this: mysql> select date_sub(concat(substr(datetime,1,13),':00:00'), -> interval 1 second) from test; Field 1: `date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: STRING Collation: binary (63) Length: 29 Max_length: 19 Decimals: 31 Flags: BINARY +---------------------------------------------------------------------+ | date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second) | +---------------------------------------------------------------------+ | 2015-09-18 08:59:59 | +---------------------------------------------------------------------+ 1 row in set (0.00 sec) Is there some global variable I can set to revert to the 5.1 behavior? I realize I can CAST the result to a datetime to make sure I don't get the fractional seconds, but as I mentioned we're converting our system over to 5.5 and there's boatloads of code that I would have to scan through to try and find these differences. 3.) If there is no way to revert to the 5.1 behavior, can someone help me to understand the exact reason why the milliseconds get displayed on the final select in MariaDB 5.5? I'll need to look for any similar types of results and other than the exact reduction above I'm not sure what statements I would need to identify and test. Thanks for any assistance! Dan Ragle

3 7

[Maria-discuss] doubt about merge table (10000+) with same structure
by Roberto Spadim 23 Sep '15

23 Sep '15

Hi again guys :) i'm with a new problem i have MANY (10000+) tables with same struct, and i want to execute a select from "some" (100+) tables i was thinking about creating a view with all tables, something like: CREATE VIEW view_name AS SELECT * FROM table1 WHERE primary_key=<a value only at table1> UNION ALL SELECT * FROM table2 WHERE primary_key=<a value only at table2> UNION ALL SELECT * FROM table3 WHERE primary_key=<a value only at table3> UNION ALL SELECT * FROM table4 WHERE primary_key=<a value only at table4> UNION ALL ... SELECT * FROM tablen WHERE primary_key=<a value only at tablen> but i don't know if mysql optimizer will do a good job when i execute something like: SELECT * FROM view_name WHERE primary_key=<a value only located at table1> and just execute the query at table1 instead of alllllllll 10000+ tables i'm considering restruture database to a spider engine or any other method if i don't have other option any idea is well come -- Roberto Spadim

3 4

[Maria-discuss] WHY re TMM files never removed in 10.0.x
by Reindl Harald 20 Sep '15

20 Sep '15

i was flooded once again with mcron-mails "ERROR 144 (HY000) at line 1: Table './asterisk/cdr' is marked as crashed and last (automatic?) repair failed" well, because mariadb creates such temp files and don't remove them which makes myisam-recover-options = "FORCE" useless -rw-rw---- 1 mysql mysql 0 2015-08-21 13:47 cdr.TMM MariaDB [asterisk]> optimize table cdr; +--------------+----------+----------+------------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+------------------------------------------------------------------------+ | asterisk.cdr | optimize | error | Can't create new tempfile: '/Volumes/dune/mysql_data/asterisk/cdr.TMM' | | asterisk.cdr | optimize | status | Operation failed | +--------------+----------+----------+------------------------------------------------------------------------+

2 5

[Maria-discuss] Cross compile issue
by Johnson Cheng 18 Sep '15

18 Sep '15

Hi, I have problem to do cross compile on mariadb-10.0.21. Where can I find the relative document? Best Regards, Johnson

2 17

[Maria-discuss] New Question: Which is the best solution to re-sync data if one of my mariadb servers was offline for few days?
by AskMonty KB 18 Sep '15

18 Sep '15

Hello, A new question has been asked in "MariaDB Community" by long_beo_g. Please answer it at http://mariadb.com/kb/en/which-is-the-best-solution-to-re-sync-data-if-one-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi all, In our system, we built only two Mariadb Galera servers. We use keepalived module to load balancing IP address . But we found out one of two servers offline for few days. When I start the offline server (server A), the online one (server B) take a long time to replicate to server A, run out of the server's resources. Could Mariadb masters tell me how to deal with this issue ? How could I sync online data to offline one, and make two servers run well online ? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/which-is-the-best-solution-to-re-sync-data-if-one-…

1 0

[Maria-discuss] ODBC.NET DOWNLOAD
by Bruce Carlson 17 Sep '15

17 Sep '15

Hi, I'm trying to download the latest stable version of the MariaDB .net ODBC install MSI but every time I try I get directed to a log in page where I can't get any further unless I create some sort of personal information divulgence account. I have never had to do this before with any open source software. Where can I go to download the MSI without having to create an account that I have no intentions of ever doing. I have been using MySQL ever since the early days of version 3 something and have been using MariaDB ever since inception after the split with MySQL. I'm a dedicated and heavy user and supporter of MariaDB and have been for decades. If I am no longer able to download updates etc. without having to create some sort of GOOGLE account then I will not use MariaDB, I will find an alternative. Please advise. Bruce Carlson

3 3

Re: [Maria-discuss] ODBC.NET DOWNLOAD
by Bruce Carlson 17 Sep '15

17 Sep '15

Hi Jan, Appreciate your comments however the issue is not the availability of the source or my ability to compile my own binaries from the source and I would even be glad to pay a fee for the convenience of downloading a pre built MSI when installing on windows machines and I am reasonably happy with the occasional donations to open source I've been able to extract from my clients. (Although, I admit, we could all possibly do more in the area of digging up donations and raising funds is a constant issue for all open source organisations). My complaint is I object to being SPECIFICALLY targeted by advertising. The only benefit derived from insisting on this type of "account" is to directly target advertising. THERE IS NO OTHER BENEFIT. I do not object to advertising. When I'm browsing MariaDB I expect to get advertising from MariaDB and maybe some affiliates. And MariaDB has some excellent affiliates. I'm on the mailing lists and forums of several open source communities. They constantly send me advertising matter. I contribute. I donate. I do OBJECT to DIRECT TARGETING. Here is just one example of how this works :- Every time I use a web browser to search for any subject, the search engine will target me with advertising from those businesses that have specified my credentials with the search provider thereby denying me access to alternatives. And that is a very real concern and in my opinion is totally contrary to the principles of open source. It's at least contrary to my principles. Now you may think this is trivial and I'm over reacting but I want to be the person in charge of what information I'm fed. No matter how trivial that sounds to you. In the end, if the only way I can get hold of the binaries is to download the source and build my own, I will or find an alternative product. On a completely separate note, Whilst I disagree with you on the subject of direct targeting I completely agree with your attitude to renewables. And I feel just as strongly about both subjects. Regards, Bruce Carlson -----Original Message----- From: Jan Steinman [mailto:Jan@EcoReality.org] Sent: Thursday, 17 September 2015 12:26 PM To: Bruce Carlson Cc: Rasmus Johansson; Maria Discuss (maria-discuss(a)lists.launchpad.net) Subject: Re: [Maria-discuss] ODBC.NET DOWNLOAD On 2015-09-16, at 18:13, Bruce Carlson wrote: > the openness of open SOURCE [emphasis mine] Do you think you may be over-reacting just a bit? My understanding -- correct me if I'm wrong -- is that the SOURCE is freely downloadable, and that the extra content you vociferously object to is only presented if you choose to download a BINARY. Compiling, maintaining, and debugging binaries is NOT part of the "open source" agreement! Rather, it is a service for which one might expect to be compensated. If you want to compile and maintain and debug the SOURCE and provide binaries without advertising, YOU CAN! NO ONE IS STOPPING YOU! Again, my apology if I'm misunderstanding something, but I used Homebrew to download and compile the SOURCE for MariaDB, and I don't recall seeing ANY advertising of any sort. :::: We are like tenant farmers chopping down the fence around our house for fuel when we should be using nature's inexhaustible sources of energy - sun, wind and tide. I'd put my money on the sun and solar energy. What a source of power! I hope we don't have to wait until oil and coal run out before we tackle that. -- Thomas Alva Edison :::: Jan Steinman, EcoReality Co-op ::::

1 0

[Maria-discuss] New Question: Galera mysqld_multi - possible bug
by AskMonty KB 16 Sep '15

16 Sep '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/galera-mysqld_multi-possible-bug/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Not sure where to post this but I've come across this on a SLES 12 system. Running Galera 25.3.9-1 / MariaDB 10.1.6-1. Using the Mysqld_multi init.d script to start and stop multiple mysql instances through service or systemd commands I have found that the starting works just fine but stopping them doesn't. It will stop all the instances but the last one. Just for clarification cmd is : service mysqld_multi stop or systemctl stop mysqld_multi. I tried this with 2 and 3 mysql instances. With 2 instances, #1 would stop but #2 wouldn't. With 3 instances #1 & #2 would stop and #3 wouldn't. I have verified that the mysqladmin command works to shut the DB down with the multi_admin account I use. Now running mysqld_multi directly works just fine. Whether it's one specific instance or all of them. That is running the script directly /etc/init.d/mysqd_multi or the actual /usr/bin/mysqld_multi command directly. Both work as expected. I honestly don't know if this is a script problem or a systemd problem. I do know that in SLES 12, SUSE rewrote the mysql init.d script to include mysqld_multi if multiple instances were discovered in the my.cnf file. And this work great using systemd. Anyway there it is, if anyone has come across this on other systems it might be worth noting. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-mysqld_multi-possible-bug/

1 0

[Maria-discuss] New Question: Connecting Issue
by AskMonty KB 13 Sep '15

13 Sep '15

Hello, A new question has been asked in "Development" by isyed. Please answer it at http://mariadb.com/kb/en/connecting-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello. I've just downloaded and started using the C/C++ connector library (v.2.1.0), libmariadb.dll. I had simply dropped it in as a direct replacement for the MySQL C connector library (v.6.1.6 x64), libmysql.dll. While it works as expected, there is an unduly long lapse during mysql_real_connect(), lasting for about fifteen seconds, before the connection is established. With libmysql.dll, the connection is almost immediate. Might there be any additional setting that I may have missed to prevent this lapse? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connecting-issue/

1 0

[Maria-discuss] mycli
by Otto Kekäläinen 11 Sep '15

11 Sep '15

Hello! Have you seen this before http://mycli.net/ ? Has anybody used it, do you have an opinion if it is of good quality or not? This kind of autocomplete definitely helps newbies in remembering the correct SQL terms and I think the idea is great. - Otto

2 1

[Maria-discuss] New Question: Hybrid replication - issue
by AskMonty KB 11 Sep '15

11 Sep '15

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by truptimali. Please answer it at http://mariadb.com/kb/en/hybrid-replication-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have been trying to implement a Hybrid replication. There is Async replication configured between two galera clusters. To begin with I have been trying this out on two datacenters dc1 and dc2. dc1 has two node galera cluster -- node1_dc1 , node2_dc1 dc2 has one node - just one primary galera node . node1_dc2 I have configured async replication between node1_dc1 and node1_dc2. But I am facing strange problem here. I could see replication happening nicely on all the three nodes involved. But When i tried to restart node2_dc1 ,(the secondary node from dc1's galera cluster) - i am not able to login to this node's mysql with root user. Or any user for that matter. Upon investigation using skip grant, found that the mysql.user table is emptied. (You can refer to the attached logs of node2_dc1 where I have highlighted removal messages in log). My doubts/concerns - 1) I am not sure what could have triggered this mysql table's removal in first place. 2) Inspite of this - I could get this node join the cluster. (Atleast as per the wsrep_cluster_size attribute on primary node) sharing my configurations on all the three nodes - 1) node1_dc1 (Primary Node) galera_cnf : [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=london_galera_cluster wsrep_cluster_address=gcomm:// wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX" wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.XXX.YYY" wsrep_node_name="192.168.XXX.YYY" ************************************ wan.cnf: [mysqld] server-id=101 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 2) node2_dc1 (Secondary node): galera.cnf: [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=london_galera_cluster wsrep_cluster_address=gcomm://192.168.XXX.YYY,192.168.YYY.ZZ wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX" wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.YYY.ZZ" wsrep_node_name="192.168.YYY.ZZ" wan.cnf: [mysqld] server-id=102 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 Node1_dc2 - Single node on datacenter-2 : galera.cnf: [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=calif_galera_cluster wsrep_cluster_address=gcomm:// wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.ZZZ.XXX" wsrep_node_name="192.168.ZZZ.XXX" wan_repl.cnf: [mysqld] server-id=201 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 ~ Note unique server-ids and common gtid-domain-id. Attaching logs of both the nodes in galera cluster in datacenter 1. lines to look for in node2.txt - file *********** Sep 10 21:06:21 localhost mysqld: 150910 21:06:21 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) Sep 10 21:06:21 localhost mysqld: 150910 21:06:21 [Note] WSREP: Requesting state transfer: success, donor: 0 Sep 10 21:06:22 localhost mysqld: WSREP_SST: [INFO] Proceeding with SST (20150910 21:06:22.394) Sep 10 21:06:22 localhost mysqld: WSREP_SST: [INFO] Cleaning the existing datadir (20150910 21:06:22.400) Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql_upgrade_info?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/multi-master.info?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql/procs_priv.MYI?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql/user.MYI?~@~Y ***************** Sep 10 21:25:51 localhost /etc/mysql/debian-start[16787]: Triggering myisam-recover for all MyISAM tables Sep 10 21:25:53 localhost mysqld: 150910 21:25:53 [Note] WSREP: (81dce617, 'tcp://0.0.0.0:4567') turning message relay requesting off Sep 10 21:32:01 localhost mysqld: 150910 21:32:01 [ERROR] Slave SQL: Error 'Can't find any matching row in the user table' on query. Default database: 'mysql'. Query: 'SET PASSWORD FOR 'root'@'localhost'='*FD9D25929BE2AE3A18896D5D93AB9A7DD78D22E4'', Internal MariaDB error code: 1133 Sep 10 21:32:01 localhost mysqld: 150910 21:32:01 [Warning] WSREP: RBR event 1 Query apply warning: 1, 19504 ****************** -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/hybrid-replication-issue/

1 0

[Maria-discuss] New Question: MariaDB Galera bootstrap
by AskMonty KB 10 Sep '15

10 Sep '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/mariadb-galera-bootstrap/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Are there any references for a MariaDB Galera setup on a systemd system (SUSE 12). Having trouble getting the bootstrap to work. I can get the db to run but it won't connect to the galera provider. Not only that but i have to run /etc/init.d/mysql start --wsrep-new-cluster to get the script to accept the parameter. If I use service or systemctl they both return invalid parameter or option. Another thing is when I do run /etc/init.d/mysql it will start but systemctl status mysql won't know about it. Thnaks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-bootstrap/

1 0

[Maria-discuss] MariaDB 10.1.7 RC now available
by Daniel Bartholomew 09 Sep '15

09 Sep '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.7. This is the first Release Candidate (RC) release in the MariaDB 10.1 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.7 - Release Notes: https://mariadb.com/kb/en/mariadb-1017-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1017-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.7 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 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/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - 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] MySQL 5.7 JSON
by Tom Worster 03 Sep '15

03 Sep '15

Are MySQL 5.7 JSON features <http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html#mysqld-5-7-8 -json> likely to end up in MariaDB anytime? If so, would it be 10.2? Tom

2 1

[Maria-discuss] New Question: Table replication with xtra column on slave
by AskMonty KB 01 Sep '15

01 Sep '15

Hello, A new question has been asked in "MariaDB Community" by rahularman. Please answer it at http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have one table DailyMetrics on Interim server like below. Mater DB->Secondary DB--> Interim DB Master DB: Table DailyMetrics ( a char,b char Secondary DB: Table DailyMetrics ( a char,b char Interim DB: Table DailyMetrics ( a char,b char, InsertTime timestamp default current_timestamp) Replication is working fine but added column InsertTime on interim DB is storing 000.000.00 00-00-00 value. It is not storing current system timestamp. When I issue separate insert statement on slave side, it is storing system time but nor with replication. Can anyone suggest me how to achieve system timestamp on slave side. Other details as follows: MySQl DB: MariaDB 5.5.23 Replication Type: Row based. Platform: Linux -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/

1 0

[Maria-discuss] New Question: Login Question
by AskMonty KB 31 Aug '15

31 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/login-question/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to log into a remote MairaDB and keep getting Host [IP] is not allowed to connect to this mariadb server. {client side} tried both mysql -p --port=3307 -h [hostname] mysql -p --port=3307 -h [hostname.domain.xxx] {server side} mysql login accounts tried user/root @ %.domain.xxx user/root @ hostname% Both client and server are in DNS and resolvable. What or how does mariadb determine when to use an IP vs hostname with connection security ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/login-question/

1 0

[Maria-discuss] Double linked list
by Roberto Spadim 28 Aug '15

28 Aug '15

hi guys, i'm with some doibts... I'm trying to replicate a double linked list, my information is: 1) insert at position xxx (and move others to next position) 2) update position yyyy 3) change position zzz with www 4) delete position xxxx to vvvv 5) return all positions 6) return positions with value > zzz My doubt is... I have only one writer and many many readers, writer can't be blocked for more than 1-3 seconds Some times i need to read history (functions 1 to 6) and recreate the linked list at a point in time List is something like: Position - json structure (arraylist in c#) like 0-[0,1,2,4,5] 1-[2.3,4,8,0] It update very fast, minimal update interval is 0.001second (max of 1000updates per second) for each list I will have 100-2000 lists --- Doubts : 1) Whats the best method to create the current double linked list? (The list positioned at last operatiom) A memory table? A row level lock table? A cache solution (memcached) with only one key-value and value with the full list? 2) considering a table: 2.1)what the best method to change position? Update set position=if() where position in (xxx, yyy) In this case what should be the primary key? If i use positionas primary key in this update i cam have non unique values... 2.2) ehat to do with delete/inserts? Insert+update positions? Delete+update positions? 3) any idea if oqgraph could solve this or if there's a storage engine solving this problem? Thanks guys :) -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] random non-zero exit status 1
by Reindl Harald 26 Aug '15

26 Aug '15

on machines mysqld mysqld regulary for backup reasons i observe over months now *randomly* starting mysqld fails because exit-code 1 leading in systemd stop the service and start it again while the is no single indication on the mysqld error-log anybody else? ________________________________________________________________________________ Aug 26 01:45:02 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:03 buildserver systemd: Stopped MariaDB Database. Aug 26 01:45:10 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:10 buildserver mysqld: 150826 1:45:10 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31936 ... Aug 26 01:45:10 buildserver systemd: mysqld.service: control process exited, code=exited status=1 Aug 26 01:45:12 buildserver systemd: Failed to start MariaDB Database. Aug 26 01:45:12 buildserver systemd: Unit mysqld.service entered failed state. Aug 26 01:45:12 buildserver systemd: mysqld.service failed. Aug 26 01:45:13 buildserver systemd: mysqld.service holdoff time over, scheduling restart. Aug 26 01:45:14 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:14 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:14 buildserver mysqld: 150826 1:45:14 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31988 ... Aug 26 01:45:14 buildserver systemd: Started MariaDB Database. ________________________________________________________________________________ 150826 1:45:02 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:02 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:02 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:02 [Note] InnoDB: Starting shutdown... 150826 1:45:03 [Note] InnoDB: Shutdown completed; log sequence number 17271831 150826 1:45:03 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:10 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:10 [Note] InnoDB: Memory barrier is not used 150826 1:45:10 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:10 [Note] InnoDB: Using Linux native AIO 150826 1:45:10 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:10 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:10 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:10 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:10 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:10 [Note] InnoDB: Waiting for purge to start 150826 1:45:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271831 150826 1:45:10 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:10 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:10 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:10 [Note] Event Scheduler: Loaded 0 events 150826 1:45:10 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge 150826 1:45:10 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:10 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:10 [Note] InnoDB: Starting shutdown... 150826 1:45:12 [Note] InnoDB: Shutdown completed; log sequence number 17271841 150826 1:45:12 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:14 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:14 [Note] InnoDB: Memory barrier is not used 150826 1:45:14 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:14 [Note] InnoDB: Using Linux native AIO 150826 1:45:14 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:14 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:14 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:14 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:14 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:14 [Note] InnoDB: Waiting for purge to start 150826 1:45:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271841 150826 1:45:14 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:14 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:14 [Note] Event Scheduler: Loaded 0 events 150826 1:45:14 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge

1 0

[Maria-discuss] New Question: MariaDB 10.1 system variables
by AskMonty KB 26 Aug '15

26 Aug '15

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by diptijoshi. Please answer it at http://mariadb.com/kb/en/mariadb-101-system-variables/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- What is the difference between MariaDB 10.1 and MySQL 5.6 system variables ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-101-system-variables/

1 0

[Maria-discuss] New Question: SET Variable statement
by AskMonty KB 24 Aug '15

24 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/set-variable-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to write a SQL script that creates a database and a few other things. I'm having trouble with a user defined variable statement. SET @dbname = CAST(trees AS VARCHAR(10)); comes directly from https://mariadb.com/kb/en/mariadb/user-defined-variables/ And I keep getting --> Error: 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 'VARCHAR(10))' at line 1 Running MariaDB 10.0.20 on SLES 12, I have no idea what the problem is ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/set-variable-statement/

1 0

[Maria-discuss] New Question: Visual Studio - MariaDB - Entity Framework 6+
by AskMonty KB 23 Aug '15

23 Aug '15

Hello, A new question has been asked in "MariaDB FAQ" by vaclav. Please answer it at http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Dear Specialists, We can use at the moment "Visual Studio ADO.NET Driver for MySQL" (https://www.mysql.com/products/connector/) and also there was lots of work done with Visual Studio Integration for MySQL. (http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio.html) The question is while now it is compatible with MariaDB and I can use MariaDB instead of MySQL, how long if at all there will be a point when this won't become anymore compatible. Is this connection compatibility related with a core or some layer in MariaDB which doesn't change and so it should be working in the future. The reason I am asking is to decide with the strategy. I am testing MariaDB with Entity Framework and the driver/connection mentioned above and it is working but what if you deviate from the connectivity at certain point? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/

1 0

[Maria-discuss] problem with optimizer
by Roberto Spadim 21 Aug '15

21 Aug '15

Hi guys I'm running two queries: first: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 it use primary key and key_len =16 but including a new = element [AND oe_tipo='oe' ]: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 AND oe_tipo='oe' it use primary key but key_len=4 (near to a full table scan) what's wrong? -- Roberto Spadim

1 2

[Maria-discuss] New Question: Multiple DB instances - in multiple cnf files
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to breakup the [mysqldx] [mysqld1] .. [mysqld2] .. and so on into multiple cnf. files (like one each) and include them using the !includedir statement ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/

1 0

[Maria-discuss] New Question: PDF or search area
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/pdf-or-search-area/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a PDF version of the documentation or a way to search the online documentation ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pdf-or-search-area/

1 0

[Maria-discuss] Mariadb 10.1.6, total cluster recovery - gvwstate.dat
by Max Zulio 19 Aug '15

19 Aug '15

Hi, I am using a Mariadb 10.1.6 three node cluster with wsrep. There is a gvwstate.dat file created in /var/lib/mysql, but in the log file when restarting the nodes I see: [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory). This seems to be the only thing stopping automatic cluster recovery. Where is mariadb looking for the file, or is there a way of configuring the file location? Thanks, M

4 5

[Maria-discuss] New Question: Fitting index not used
by AskMonty KB 19 Aug '15

19 Aug '15

Hello, A new question has been asked in "Query Optimizations" by mandark. Please answer it at http://mariadb.com/kb/en/fitting-index-not-used/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MariaDB version: mysql Ver 15.1 Distrib 10.1.2-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Here is the simplified situation (Query with like 10 joins, so I simplify to the simpliest query still reproducing the problem when working on slow queries): ``` SELECT article.article_id FROM article -- USE INDEX (s_ti_pd) LEFT JOIN member ON member.member_id = article.member_id WHERE article.thema_id = 29 AND article.state = 1 ORDER BY published_date LIMIT 0, 3; ``` - I have an index on `state, thema_id, published_date` which fit particularly well from my point of view (Query run in a few milliseconds using it) - When using `state, thema_id, published_date` index, explain give me: key_len: 8, ref: const,const, rows: 15006, filter: 100.00, Using where - I have another index on `published_date` only (Query run in ~1s using it) - When using `published_date` index, explain give me: key_len: 9, rows: 94, filtered: 100.00, Using where - Table have a few other indexes... - Forcing the usage of the index ran my query in a few milliseconds, without, one second. - Removing the LEFT JOIN makes MariaDB use the good index - Changing the thema_id sometimes change the index used I dont see any factor that may tell the query optimizer to use published_date. In fact I see only one, it's shorter, so faster to read. But the `status, thema_id, published_date` index seems, for me, obviously better, as it starts with two consts, and also can be used for the ORDER BY. What can I do to understand MariaDB on this choice ? I only tried an "analyze table" but engine side, not "table side", for the moment, it changed nothing. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/fitting-index-not-used/

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.21 and 5.5.45 now available
by Daniel Bartholomew 18 Aug '15

18 Aug '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.21 and 5.5.45. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.21 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10021-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10021-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.21 MariaDB Galera Cluster 5.5.45 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5545-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5545-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.45 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/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - 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] New Question: Mariadb match against a view (fulltext search) fails; succeeds in MySql
by AskMonty KB 18 Aug '15

18 Aug '15

Hello, A new question has been asked in "Moving to MariaDB" by henrik_bechmann_g. Please answer it at http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails… as the person asking the question may not be subscribed to the mailing list. -------------------------------- The fulltext search query below fails in mariadb, but succeeds in mysql (mariadb database imported from mysql database using phpmyadmin). If a base table is substituted, the query succeeds in both mariadb and mysql. So apparently mariadb cannot match against views. Is there a solution to this? It's messing up my migration. Using 10.0.21. Thanks. SELECT Title FROM Nodes_View WHERE (MATCH(Title,Caption,Description,Location,Body) AGAINST ('something')) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails…

1 0

[Maria-discuss] New Question: Mariadb match against a view (fulltext search) fails; succeeds in MySql
by AskMonty KB 18 Aug '15

18 Aug '15

Hello, A new question has been asked in "Moving to MariaDB" by henrik_bechmann_g. Please answer it at http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails… as the person asking the question may not be subscribed to the mailing list. -------------------------------- The fulltext search query below fails in mariadb, but succeeds in mysql (mariadb database imported from mysql database using phpmyadmin). If a base table is substituted, the query succeeds in both mariadb and mysql. So apparently mariadb cannot match against views. Is there a solution to this? It's messing up my migration. Using 10.0.21. Thanks. SELECT Title FROM Nodes_View WHERE (MATCH(Title,Caption,Description,Location,Body) AGAINST ('something')) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails…

1 0

[Maria-discuss] Latest round of Oracle CVE status on MariaDB
by Brian Evans 13 Aug '15

13 Aug '15

The quarterly CVE list from oracle was published[1]. The following CVEs are listed there affecting 5.5, but not listed on the MariaDB security page[2]. CVE-2015-4757 CVE-2015-4752 CVE-2015-4737 CVE-2015-2648 CVE-2015-2643 CVE-2015-2620 CVE-2015-2582 Are they fixed with 5.5.45 and 10.0.21, or any other version? Brian [1] http://www.oracle.com/technetwork/topics/security/cpujul2015-2367936.html#A… [2] https://mariadb.com/kb/en/mariadb/security/

2 1

[Maria-discuss] faling tests
by Reindl Harald 06 Aug '15

06 Aug '15

just built 10.0.21 and thought it can't be wrong to report the faling test below - this is not new and virtually forever - however, maybe woth a look ______________________________________________________________ /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --default-myisam --parallel=1 --max-test-fail=0 --mysqld=--binlog-format=mixed --skip-ndb --force' mysql ______________________________________________________________ rpl.rpl_not_null_innodb 'row,xtradb' [ fail ] Test ended at 2015-08-06 21:30:45 CURRENT_TEST: rpl.rpl_not_null_innodb mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_not_null_innodb.test at line 15: At line 179: query 'SET GLOBAL gtid_slave_pos= ""' failed: 1198: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_not_null_innodb-row,xtradb/' to '/usr/share/mysql-test/var/log/rpl.rpl_not_null_innodb-row,xtradb/'

1 1

[Maria-discuss] New Question: What data type should I use to store XML natively in the database?
by AskMonty KB 06 Aug '15

06 Aug '15

Hello, A new question has been asked in "Data Types" by ksoh15. Please answer it at http://mariadb.com/kb/en/what-data-type-should-i-use-to-store-xml-natively-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I could not find a XML data type. Which data type can I use to store XML natively? I need to be able to parse and run XQuery on XML content. https://mariadb.com/kb/en/mariadb/data-types/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/what-data-type-should-i-use-to-store-xml-natively-…

1 0

[Maria-discuss] MariaDB 10.0.21 and 5.5.45 now available
by Daniel Bartholomew 06 Aug '15

06 Aug '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.21 and 5.5.45. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.21 - Release Notes: https://mariadb.com/kb/en/mariadb-10021-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10021-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.21 - About MariaDB 10.0: https://mariadb.com/kb/en/what-is-mariadb-100 MariaDB 5.5.45 - Release Notes: https://mariadb.com/kb/en/mariadb-5545-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5545-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.45 - About MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55 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/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - 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] Numa linux
by Roberto Spadim 05 Aug '15

05 Aug '15

Hi guys i'm comfiguring linux kernel, there's some valid numa comfig at kernel to check? It's a xeon server with 2 cpu and 10cores each -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

4 3

[Maria-discuss] New Question: How can I Move (migrate) a Replication Server (MariaDB) to a new Hardware and OS.
by AskMonty KB 04 Aug '15

04 Aug '15

Hello, A new question has been asked in "Standard Replication" by wschwauer. Please answer it at http://mariadb.com/kb/en/how-can-i-move-migrate-a-replication-server-mariad… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a server (Master) and 5 clients (slaves). The replication work’s fine. Now I must migrate the Server/Master Database to a new System. How can I move/migrate the old Master DB to the new Hardware? 1: Install MariaDB on new System. 2: Create all Table and so on on ew system. 3: Stop replikation on old Server 4: export all Tabledata from old Server and import to the new server 5: Start Replikation with the new Server IP ??? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-can-i-move-migrate-a-replication-server-mariad…

1 0

[Maria-discuss] MariaDB 10.1.6 beta now available
by Daniel Bartholomew 27 Jul '15

27 Jul '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.6. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.6 - Release Notes: https://mariadb.com/kb/en/mariadb-1016-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1016-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.6 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 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/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - 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] Travis-CI and MariaDB
by Daniel Black 24 Jul '15

24 Jul '15

For those that use or develop open source or commercial projects that use Travis CI MariaDB has been added as a plugin. This installs either 5.5, 10.0 or 10.1 from the latest MariaDB repo against for testing. Documentation isn't up yet however it is planned. ref: https://github.com/travis-ci/travis-build/pull/303 As an example of Syntax (https://github.com/grooverdan/PyMySQL/blob/c05bf7c6d0f3161d91b3e1418ac185b8…) to test against all MariaDB versions as well as the pre-installed MySQL. Quick snippet: matrix: include: - addons: mariadb: 5.5 - addons: mariadb: 10.0 - addons: mariadb: 10.1 So add it to your own project's .travis.yml or send a PR to your favourite github project that can use MariaDB and Travis-ci. As for MariaDB-server in Travis-CI? we'll see if the bug committing fairies decide https://github.com/MariaDB/server/pull/84 is useful. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 3