October 2017 - discuss - lists.mariadb.org

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 18 Nov '24

18 Nov '24

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

2 1

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] Charsets and collations
by Peter Laursen 20 Apr '18

20 Apr '18

Does anybody know if there are any plans to bring collations added in MySQL 8 - refer http://mysqlserverteam.com/new-collations-in-mysql-8-0-0/ - to MariaDB and are there any plans to change the default charset to a unicode-based one? -- Peter -- Webyog

2 2

[Maria-discuss] Building 10.2 from source issues
by Guillaume Lefranc 02 Nov '17

02 Nov '17

Hi, I am trying to build 10.2 from sources while disabling some plugins (building with all plugins works without issues). e.g. $ cmake . -DPLUGIN_MROONGA=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_SPHINX=NO -DPLUGIN_ROCKSDB=NO $ make This fails with the following errors: [ 98%] Building CXX object extra/mariabackup/CMakeFiles/mariabackup.dir/changed_page_bitmap.cc.o In file included from /home/tanj/mariadb-10.2/storage/innobase/include/univ.i:83:0, from /home/tanj/mariadb-10.2/storage/innobase/include/ut0rbt.h:29, from /home/tanj/mariadb-10.2/extra/mariabackup/changed_page_bitmap.h:28, from /home/tanj/mariadb-10.2/extra/mariabackup/changed_page_bitmap.cc:25: /home/tanj/mariadb-10.2/extra/mariabackup/common.h: In function ‘size_t xb_read_full(File, uchar*, size_t)’: /home/tanj/mariadb-10.2/extra/mariabackup/common.h:162:45: error: ‘MY_WME’ was not declared in this scope tbytes = my_read(fd, buf, len - tlen, MYF(MY_WME)); ^ /home/tanj/mariadb-10.2/include/my_global.h:1025:24: note: in definition of macro ‘MYF’ #define MYF(v) (myf) (v) ^ In file included from /home/tanj/mariadb-10.2/extra/mariabackup/changed_page_bitmap.cc:27:0: /home/tanj/mariadb-10.2/extra/mariabackup/common.h:162:12: error: ‘my_read’ was not declared in this scope tbytes = my_read(fd, buf, len - tlen, MYF(MY_WME)); ^~~~~~~ /home/tanj/mariadb-10.2/extra/mariabackup/common.h:162:12: note: suggested alternative: ‘my_sha1’ tbytes = my_read(fd, buf, len - tlen, MYF(MY_WME)); ^~~~~~~ my_sha1 /home/tanj/mariadb-10.2/extra/mariabackup/common.h:163:32: error: ‘MY_FILE_ERROR’ was not declared in this scope if (tbytes == 0 || tbytes == MY_FILE_ERROR) { ^~~~~~~~~~~~~ /home/tanj/mariadb-10.2/extra/mariabackup/common.h:163:32: note: suggested alternative: ‘DB_IO_ERROR’ if (tbytes == 0 || tbytes == MY_FILE_ERROR) { ^~~~~~~~~~~~~ DB_IO_ERROR make[2]: *** [extra/mariabackup/CMakeFiles/mariabackup.dir/build.make:111: extra/mariabackup/CMakeFiles/mariabackup.dir/changed_page_bitmap.cc.o] Error 1 make[2]: *** Waiting for unfinished jobs.... make[1]: *** [CMakeFiles/Makefile2:4270: extra/mariabackup/CMakeFiles/mariabackup.dir/all] Error 2 make[1]: *** Waiting for unfinished jobs.... [ 98%] Built target mysqld [ 98%] Built target explain_filename-t make: *** [Makefile:163: all] Error 2 $ gcc -v Using built-in specs. COLLECT_GCC=gcc COLLECT_LTO_WRAPPER=/usr/lib/gcc/x86_64-pc-linux-gnu/7.2.0/lto-wrapper Target: x86_64-pc-linux-gnu Configured with: /build/gcc-multilib/src/gcc/configure --prefix=/usr --libdir=/usr/lib --libexecdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=https://bugs.archlinux.org/ --enable-languages=c,c++,ada,fortran,go,lto,objc,obj-c++ --enable-shared --enable-threads=posix --enable-libmpx --with-system-zlib --with-isl --enable-__cxa_atexit --disable-libunwind-exceptions --enable-clocale=gnu --disable-libstdcxx-pch --disable-libssp --enable-gnu-unique-object --enable-linker-build-id --enable-lto --enable-plugin --enable-install-libiberty --with-linker-hash-style=gnu --enable-gnu-indirect-function --enable-multilib --disable-werror --enable-checking=release --enable-default-pie --enable-default-ssp Thread model: posix gcc version 7.2.0 (GCC) Please advise. Thanks

2 5

[Maria-discuss] MariaDB 10.2 'show engine innodb status' format change for Pending AIO
by Jonathan Nicol 31 Oct '17

31 Oct '17

Hi, Starting with 10.2, in 'show engine innodb status', the format has changed for pending reads/writes... The old (pre-5.5) format looked like: Pending normal aio reads: 0, aio writes: 0, In 5.5 it switched to: Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , (where each value in the brackets corresponds to a read or write thread) Now in 10.2 it looks like: Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , I was never clear on what the values outsides the brackets in 5.5-10.1 represented... assumed it was a total of all threads. We were previously monitoring this value, should we move forward monitoring a sum of all threads? It seems a little odd to remove a useful metric from the status output. thanks Jon

1 0

Re: [Maria-discuss] upgrading from 10.1 -> 10.2 with galera cluster
by Jeff Dyke 31 Oct '17

31 Oct '17

Thanks for the tip, that will be helpful for sure. I'm about to set it up on three aws instances and see what happens. Perhaps i can contribute my learnings to the ticket you opened. Best, Jeff On Tue, Oct 31, 2017 at 2:20 PM, Chris Calender <chris.calender(a)mariadb.com> wrote: > Hi Jeff, > > Be sure you have upgraded Xtrabackup to 2.4, or if one of the 10.2 needs > to SST, it will fail with an "No valid checkpoint found" error (as > Xtrabackup 2.3 is not 100% compatible with MariaDB 10.2): > > https://jira.mariadb.org/browse/MDEV-13657 > > Also, I did file a documentation request about this topic last light, if > interested (though you might have this implemented before the page is > added): > > https://jira.mariadb.org/browse/MDEV-14226 > > Hope this helps. > > Best wishes, > Chris > > > > On 10/31/2017 10:09 AM, Jeff Dyke wrote: > >> I have a 10.1 install of galera cluster running in master master mode, i >> would like to upgrade to 10.2.9, and have seen the instructions here[1] >> about "regular" updates, but i'd like to keep the cluster online while i >> upgrade. Is there any difference or things to look out for to keep data >> consistency. can a 10.2 node replicate to a 10.1 node (my guess would be >> no due to the new fields after mysql_upgrade) Downtime offline is a >> possibility, but i'd like to avoid it, as would anyone. >> >> Any hints/links are greatly appreciated. >> Jeff >> >> [1] https://mariadb.com/kb/en/library/upgrading-from-mariadb- >> 101-to-mariadb-102/ >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> > > -- > Chris Calender, M.S., Technical Support Manager > MariaDB Corporation >

1 0

[Maria-discuss] upgrading from 10.1 -> 10.2 with galera cluster
by Jeff Dyke 31 Oct '17

31 Oct '17

I have a 10.1 install of galera cluster running in master master mode, i would like to upgrade to 10.2.9, and have seen the instructions here[1] about "regular" updates, but i'd like to keep the cluster online while i upgrade. Is there any difference or things to look out for to keep data consistency. can a 10.2 node replicate to a 10.1 node (my guess would be no due to the new fields after mysql_upgrade) Downtime offline is a possibility, but i'd like to avoid it, as would anyone. Any hints/links are greatly appreciated. Jeff [1] https://mariadb.com/kb/en/library/upgrading-from-mariadb-101-to-mariadb-102/

1 0

[Maria-discuss] Aria_pack error
by Kenneth Penza 27 Oct '17

27 Oct '17

Good afternoon, I am currently working on MariaDB version 10.1.26-MariaDB-1~yakkety running on Ubuntu 16.10 and have encountered an error whilst using aria_pack. The process used to generate the tables is as follows: 1) create table SQL script 2) shutdown MariaDB (systemctl shutdown mariadb.service) 3 )Disable indexes to speedup loading $ aria_chk --keys-used=0 -rq /var/lib/mysql/mygo/term - recovering (with keycache) Aria-table '/var/lib/mysql/mygo/term' Data records: 0 Table: /var/lib/mysql/mygo/term doesn't have an auto increment key State updated 4) startup MariaDB (systemctl start mariadb.service) 5) load data $ mysqlimport -u penzk001 --password=penzk100 -L mygo term.txt mygo.term: Records: 46032 Deleted: 0 Skipped: 0 Warnings: 0 6) shutdown mariadb (systemctl shutdown mariadb.service) 7) Check table $ aria_chk /var/lib/mysql/mygo/term Checking Aria file: /var/lib/mysql/mygo/term Data records: 46032 Deleted blocks: 0 - check file-size - check key delete-chain - check index reference - check record links State update 8) Compress table $ aria_pack /var/lib/mysql/mygo/term Compressing /var/lib/mysql/mygo/term.MAD: (46032 records) - Calculating statistics - Compressing file Segmentation fault (core dumped) When I run steps 1, 5 and 8 I get the following error message: $ aria_pack /var/lib/mysql/mygo/term /var/lib/mysql/mygo/term gave error 132 on open Am I doing something wrong? Any pointers what I can check? Thanks

1 0

[Maria-discuss] Aria_pack error
by Kenneth Penza 27 Oct '17

27 Oct '17

Good afternoon, I am currently working on MariaDB version 10.1.26-MariaDB-1~yakkety running on Ubuntu 16.10 and have encountered an error whilst using aria_pack. The process used to generate the tables is as follows: 1) create table SQL script 2) shutdown MariaDB (systemctl shutdown mariadb.service) 3 )Disable indexes to speedup loading $ aria_chk --keys-used=0 -rq /var/lib/mysql/mygo/term - recovering (with keycache) Aria-table '/var/lib/mysql/mygo/term' Data records: 0 Table: /var/lib/mysql/mygo/term doesn't have an auto increment key State updated 4) startup MariaDB (systemctl start mariadb.service) 5) load data $ mysqlimport -u penzk001 --password=penzk100 -L mygo term.txt mygo.term: Records: 46032 Deleted: 0 Skipped: 0 Warnings: 0 6) shutdown mariadb (systemctl shutdown mariadb.service) 7) Check table $ aria_chk /var/lib/mysql/mygo/term Checking Aria file: /var/lib/mysql/mygo/term Data records: 46032 Deleted blocks: 0 - check file-size - check key delete-chain - check index reference - check record links State update 8) Compress table $ aria_pack /var/lib/mysql/mygo/term Compressing /var/lib/mysql/mygo/term.MAD: (46032 records) - Calculating statistics - Compressing file Segmentation fault (core dumped) When I run steps 1, 5 and 8 I get the following error message: $ aria_pack /var/lib/mysql/mygo/term /var/lib/mysql/mygo/term gave error 132 on open Am I doing something wrong? Any pointers what I can check? Thanks Kenneth

1 0

[Maria-discuss] maria won't start after giving up on mysql 5.7
by Richard Whitney 24 Oct '17

24 Oct '17

Hello, I have been trying for a week to get mysql 5.7 setup on raspbian and have thrown in the towel. I have now installed (tried to install) mariadb 10.1 and it seems to hang on install and then won't start Let me try one more time ....... sudo apt autoremove Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be REMOVED: default-mysql-server 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded. 3 not fully installed or removed. After this operation, 9,216 B disk space will be freed. Do you want to continue? [Y/n] (Reading database ... 126235 files and directories currently installed.) Removing default-mysql-server (1.0.2) ... Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ... Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. invoke-rc.d: initscript mysql, action "start" failed. ● mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2017-10-24 13:25:21 MST; 60ms ago Process: 5576 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 5487 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 5482 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 5479 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 5576 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Oct 24 13:25:16 qa.com systemd[1]: Starting MariaDB database server... Oct 24 13:25:18 qa.com mysqld[5576]: 2017-10-24 13:25:18 1996230656 [Note] /usr/sbin/mysqld (mysqld 10.1.…576 ... Oct 24 13:25:21 qa.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Oct 24 13:25:21 qa.com systemd[1]: Failed to start MariaDB database server. Oct 24 13:25:21 qa.com systemd[1]: mariadb.service: Unit entered failed state. Oct 24 13:25:21 qa.com systemd[1]: mariadb.service: Failed with result 'exit-code'. Hint: Some lines were ellipsized, use -l to show in full. dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.1 (>= 10.1.23-9+deb9u1); however: Package mariadb-server-10.1 is not configured yet. dpkg: error processing package mariadb-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mariadb-server-10.1 mariadb-server E: Sub-process /usr/bin/dpkg returned an error code (1) any ideas? Thank you! -- Richard Whitney phpMyDEV, LLC phpmydev.com 602-334-7771 May there always be tread and air in your tires and oatmeal and butter in your bowl - Author Unknown

1 0