- discuss - lists.mariadb.org

[Maria-discuss] TokuDB + virtual column
by Roberto Spadim 09 Nov '15

09 Nov '15

Hi guys, there's a plan to include virtual column to tokudb storage? /* Erro SQL (1910): TokuDB storage engine does not support computed columns */ thanks -- Roberto Spadim

3 4

[Maria-discuss] New Question: Install problem on Mac OSX 10.10.2
by AskMonty KB 09 Nov '15

09 Nov '15

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by 7stud. Please answer it at http://mariadb.com/kb/en/install-problem-on-mac-osx-10102/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I would love to switch to MariaDB, but over the last year I've tried installing it twice on different versions of Mac OSX and failed. I don't use Homebrew because generally it causes more problems than installing from source. So, I followed the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install: **MariaDB 10.1.8**\\ on **Mac OSX 10.10.2 **\\ with **Xcode 6.3.2**\\ {{{ $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake). $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:191:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:222:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:423:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:452:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:465:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:552:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:576:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:592:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:617:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:616:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:652:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:651:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:703:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:811:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:864:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:921:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:969:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1007:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1101:3: error: cannot use 'try' with exceptions disabled try { ^ fatal error: too many errors emitted, stopping now [-ferror-limit=] 20 errors generated. make[2]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/dat.cpp.o] Error 1 make[1]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/all] Error 2 make: *** [all] Error 2 }}} -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/install-problem-on-mac-osx-10102/

1 0

[Maria-discuss] New Question: I would love to switch to MariaDB, but over the last year I've tried installing it twice on different versions of Mac OSX and failed.
by AskMonty KB 08 Nov '15

08 Nov '15

Hello, A new question has been asked in "Downloads" by 7stud. Please answer it at http://mariadb.com/kb/en/i-would-love-to-switch-to-mariadb-but-over-the-las… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I don't use Homebrew because it causes more problems than installing from source. So I followed the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install on Mac OSX 10.10.2 with Xcode 6.3.2: $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake). $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:191:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:222:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:423:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:452:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:465:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:552:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:576:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:592:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:617:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:616:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:652:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:651:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:703:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:811:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:864:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:921:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:969:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1007:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1101:3: error: cannot use 'try' with exceptions disabled try { ^ fatal error: too many errors emitted, stopping now [-ferror-limit=] 20 errors generated. make[2]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/dat.cpp.o] Error 1 make[1]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/all] Error 2 make: *** [all] Error 2 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-would-love-to-switch-to-mariadb-but-over-the-las…

1 0

[Maria-discuss] Compiling maxscale
by Justin Swanhart 08 Nov '15

08 Nov '15

Hi, When I try to compile maxscale, the classifier won't compile because it needs server headers. How do I tell it where to find the source. It uses multiple headers in multiple directories so adding the server source via a simple -I to CXXFLAGS doesn't work. Am I missing something? Sent from my iPhone

2 2

[Maria-discuss] Bad file descriptor mariadb 10.1.
by joao＠7lan.net 07 Nov '15

07 Nov '15

Hi List, Sometimes, my mysqld daemon begin to consumes 100% the connection to the server gets unstable and I get flooded in the mysql error log with these messages: Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor it only stops when I restart the daemon, no query is shown in "show full processlist". Maybe some kernel adjustment? Any ideia? Running centos 7 at the lastest version. [root@db1 scripts]# yum -y update Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: ftpmirror.your.org * epel: mirror.nexcess.net * extras: ftpmirror.your.org * updates: mirrors.lga7.us.voxel.net No packages marked for update [root@db1 scripts]# rpm -qa|grep -i MariaDB MariaDB-shared-10.1.8-1.el7.centos.x86_64 MariaDB-client-10.1.8-1.el7.centos.x86_64 MariaDB-common-10.1.8-1.el7.centos.x86_64 MariaDB-server-10.1.8-1.el7.centos.x86_64 Thanks! João Reis.

4 5

[Maria-discuss] New Question: Downgrade MariaDB
by AskMonty KB 04 Nov '15

04 Nov '15

Hello, A new question has been asked in "Upgrading MariaDB" by areno. Please answer it at http://mariadb.com/kb/en/downgrade-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I recently upgraded MariaDB 10.0.21 to 10.1.8. Our program that interacts with it is tossing errors and we found out it's not supported by the program. We were directed from the application dev team to install 10.0.21 back. I cannot find any documentation on how to properly downgrade the DB and move the data to an older version. Any specific process to follow? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/downgrade-mariadb/

1 0

[Maria-discuss] LOAD FILE and BIT datatype
by Roberto Spadim 03 Nov '15

03 Nov '15

hi guys, how could i send bit data to mysql with LOAD FILE? a table example: create table t (i bit not null default 0); LOAD DATA LOCAL INFILE "file.csv" IGNORE INTO TABLE `t` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' (i) the data file is simple: 0 1 0 1 0 1 but i got Warning 1024: Out of range value for column 'i' at row 1 ... to last row any idea? i tried b'0' b'1' '0' '1' 0 1 but no one work, i don't know what happen but it's cast always to 1 (maybe convert from string to binary?)

2 12

[Maria-discuss] New Question: my_config.h is missing from Connector 2.2.0 for Windows
by AskMonty KB 01 Nov '15

01 Nov '15

Hello, A new question has been asked in "MariaDB Community" by sruliganor. Please answer it at http://mariadb.com/kb/en/my_configh-is-missing-from-connector-220-for-windo… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I downloaded and ran mariadb-connector-c-2.2.0-win64.msi. Instead of my_config.h, directory include contains only my_config.h.in. Where is the mssing file? Thanks Sruli -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/my_configh-is-missing-from-connector-220-for-windo…

1 0

[Maria-discuss] New Question: Spider
by AskMonty KB 30 Oct '15

30 Oct '15

Hello, A new question has been asked in "MariaDB Community" by siliconplains44. Please answer it at http://mariadb.com/kb/en/mariadb-community-spider/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, we are looking for scale up options for mariadb. We wanted to try spider out but there was not enough information on this site. Some of the questions I had were what is the maxiumum number of nodes you can have. Does the database balance the shards, etc.? I am looking to see how much storage we can get out of spider. Can anyone out there help us with this request? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-spider/

1 0

[Maria-discuss] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes
by Reindl Harald 29 Oct '15

29 Oct '15

* why does that happen at all instead finish whatever is not finished after get SIGTERM * "try to restart the slave with --slave-exec-mode=IDEMPOTENT" must be a joke when "slave-exec-mode = IDEMPOTENT" is part of my.cnf for years *because* of that failure happening randomly when stop a slave at a wrong moment 151029 9:15:44 [ERROR] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes. If the group consists solely of row-based events, you can try to restart the slave with --slave-exec-mode=IDEMPOTENT, which ignores duplicate key, key not found, and similar errors (see documentation for details). Gtid 0-1-2058483, Internal MariaDB error code: 1593

1 0