- discuss - lists.mariadb.org

[Maria-discuss] INNODB not loading
by Roberto Spadim 11 Dec '15

11 Dec '15

hi guys, i was using my database and it crashed, after restart innodb (Xtradb) don't start the log shows this: 151210 21:44:38 [Note] InnoDB: Using mutexes to ref count buffer pool pages 151210 21:44:38 [Note] InnoDB: The InnoDB memory heap is disabled 151210 21:44:38 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 151210 21:44:38 [Note] InnoDB: Memory barrier is not used 151210 21:44:38 [Note] InnoDB: Compressed tables use zlib 1.2.3 151210 21:44:38 [Note] InnoDB: Using CPU crc32 instructions 151210 21:44:38 [Note] InnoDB: Initializing buffer pool, size = 32.0G 151210 21:44:48 [Note] InnoDB: Completed initialization of buffer pool 151210 21:44:54 [Note] InnoDB: Highest supported file format is Barracuda. 151210 21:44:54 [Note] InnoDB: The log sequence numbers 8739254920 and 8739254920 in ibdata files do not match the log sequence number 98318151020 in the ib_logfiles! 151210 21:44:54 [Note] InnoDB: Database was not shutdown normally! 151210 21:44:54 [Note] InnoDB: Starting crash recovery. 151210 21:44:54 [Note] InnoDB: Reading tablespace information from the .ibd files... 151210 21:44:54 [Note] InnoDB: Restoring possible half-written data pages 151210 21:44:54 [Note] InnoDB: from the doublewrite buffer... 151210 21:44:57 [Note] InnoDB: 128 rollback segment(s) are active. 151210 21:44:57 [Note] InnoDB: Waiting for purge to start 151210 21:44:57 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 98318151020 151210 21:44:57 [Note] Plugin 'FEEDBACK' is disabled. 151210 21:44:57 [Note] Server socket created on IP: '::'. 151210 21:44:57 [Note] Event Scheduler: Loaded 0 events 2015-12-10 21:44:57 7fbfd435a700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 151210 21:44:57 [Note] /opt/mariadb/bin//mysqld: ready for connections. Version: '10.0.21-MariaDB-log' socket: '/tmp/mysql.BH.sock' port: 3307 MariaDB Server any idea what could be done to start recovery from innodb? -- Roberto Spadim

3 4

[Maria-discuss] MariaDB 5.5.47 and updated connectors now available
by Daniel Bartholomew 10 Dec '15

10 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.47, MariaDB Connector/C 2.2.2, and MariaDB Connector/J 1.3.3. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.47 - Release Notes: https://mariadb.com/kb/en/mdb-5547-rn - Changelog: https://mariadb.com/kb/en/mdb-5547-cl - Downloads: https://downloads.mariadb.org/mariadb/5.5.47 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 Connector/C 2.2.2 - Release Notes: https://mariadb.com/kb/en/mcc-222-rn - Changelog: https://mariadb.com/kb/en/mcc-222-cl - Downloads: https://downloads.mariadb.org/connector-c/2.2.2/ About MariaDB Connector/C : - https://mariadb.com/kb/en/about-mariadb-connector-c/ MariaDB Connector/J 1.3.3 - Release Notes: https://mariadb.com/kb/en/mcj-133-rn - Changelog: https://mariadb.com/kb/en/mcj-133-cl - Downloads: https://downloads.mariadb.org/connector-java/1.3.3/ About MariaDB Connector/J : - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/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] MariaDB 10.1.8 Stable (GA) now available
by Daniel Bartholomew 10 Dec '15

10 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.8. This is the first Stable (GA) release in the MariaDB 10.1 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.8 - Release Notes: https://mariadb.com/kb/en/mariadb-1018-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1018-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.8 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

6 9

[Maria-discuss] SST xtrabackup-v2 and 10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0')
by Engelmann Florian 08 Dec '15

08 Dec '15

Dear list, this is my 1st time testing Galera Cluster with MariaDB 10.1. With version 10.1.9 I get the following error using xtrabackup-v2 for SST: Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Member 1.0 () requested state transfer from '*any*'. Selected 0.0 ()(SYNCED) as donor. Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0) Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026000176896 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0'' Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: sst_donor_thread signaled with 0 Dec 7 18:32:22 wsc-db01a-test mysqld: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20151207 18:32:22.249) Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming with xbstream Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using socat as streamer Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using /tmp/tmp.l5q4N6ELOD as innobackupex temporary directory Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming GTID file before SST Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} ) Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Sleeping before data transfer for SST Dec 7 18:32:23 wsc-db01a-test mysqld: 2015-12-07 18:32:23 140026880980736 [Note] WSREP: (6b6485fa, 'tcp://0.0.0.0:4567') turning message relay requesting off Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Streaming the backup to joiner at 10.1.234.223 4444 Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Evaluating innobackupex --no-version-check $tmpopts $INNOEXTRA --galera-info --stream=$sfmt $itmpdir 2> >(logger -p daemon.err -t -innobackupex-backup) | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} ) Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: This software is published under Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Get the latest version of Percona XtraBackup, documentation, and help resources: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: http://www.percona.com/xb/ubuntu Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock' as 'sstuser' (using password: NO). Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32 innobackupex: Connected to MySQL server Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: innobackupex: Error: Unsupported server version: '10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0'). Please report a bug at https://bugs.launchpad.net/percona-xtrabackup Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: innobackupex finished with error: 1. Check /var/lib/mysql//innobackup.backup.log Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleanup after exit with status:22 Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleaning up temporary directories Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Failed to read from: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0' Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0': 22 (Invalid argument) Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0' Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Warning] WSREP: 0.0 (): State transfer to 1.0 () failed: -22 (Invalid argument) Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0) Dec 7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Member 0.0 () synced with group. Dec 7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) My 90-galera.cnf looks like: [mysqld] query_cache_size = 0 binlog_format = ROW default_storage_engine = InnoDB innodb_autoinc_lock_mode = 2 innodb_doublewrite = 1 server_id = 100 innodb_flush_log_at_trx_commit = 0 wsrep_on = ON wsrep_provider_options = "gcache.size=512M;pc.recovery=TRUE" wsrep_cluster_address = "gcomm://10.1.234.222,10.1.234.223,10.1.234.224,10.1.234.225" wsrep_cluster_name = dba wsrep_sst_method = "xtrabackup-v2" #wsrep_sst_method = "rsync" wsrep_sst_auth = "sstuser:xxxxxxxxxxxxxxxxxxxxxxx" wsrep_provider = "/usr/lib/galera/libgalera_smm.so" wsrep_slave_threads = 4 wsrep_node_address = 10.1.234.221 wsrep_node_incoming_address = 10.0.234.221 With wsrep_sst_method = "rsync" SST works fine. Did I miss something? All the best, Florian

2 2

[Maria-discuss] New Question: Mysql database concept's information.
by AskMonty KB 08 Dec '15

08 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/mysql-database-concepts-information/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I am studying about the MariaDB and MySql database and need few necessary details about it. I could not find the details while searching in google. I want to know what tools have been used while developing MySql database? Like the editor window output window tools, Parser, etc. Hope to get answer soon. Thanks and regards. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql-database-concepts-information/

1 0

[Maria-discuss] New Question: How to store the string in %s
by AskMonty KB 07 Dec '15

07 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/how-to-store-the-string-in-s/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I am studying source code of MySQL.I noted that in error messages they are using %s,%d here %s is used to store the database name,table name which is chose by user,and %d for error number. I want to know how they store the string in %s.can you help me for that. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-store-the-string-in-s/

1 0

[Maria-discuss] New Question: How to create the line numbers in MySQL query window
by AskMonty KB 07 Dec '15

07 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/how-to-create-the-line-numbers-in-mysql-query-wind… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to create a query window as MySQL query window.for that I am using visual studios .can you say how can they create the line numbers. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-create-the-line-numbers-in-mysql-query-wind…

1 0

[Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster
by Bertrand Caplet 05 Dec '15

05 Dec '15

Hi all, I'm using MariaDB Cluster with 3 servers and I often have split brain because of network. When a network split brain happen, only one node is disconnected. What is for you the best choice for SST or maybe IST method for this configuration ? (N.B.: I already tried rsync method but i'm not really satisfied with it). I have another question, I tried xtrabackup-v2 but it seems this method can't be use for bootstrapping while database is on. Does xtrabackup method can do this ? Regards, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

3 4

[Maria-discuss] New Question: filter QLA
by AskMonty KB 03 Dec '15

03 Dec '15

Hello, A new question has been asked in "MaxScale Filters" by chris_jack_g. Please answer it at http://mariadb.com/kb/en/filter-qla/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to show in the query log the user in which the session originated? Here is my filter config, pretty straight forward: [qla] type=filter module=qlafilter options=/tmp/QueryLog -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/filter-qla/

1 0

[Maria-discuss] New Question: (Another) Install problem on Mac OSX 10.10.2
by AskMonty KB 03 Dec '15

03 Dec '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/another-install-problem-on-mac-osx-10102/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- In am using 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 ... ... ~/Downloads/mariadb-10.1.9$ make ... ... ... Scanning dependencies of target install_tdb_h [ 71%] Generating db.h [ 71%] Built target install_tdb_h Scanning dependencies of target util_static [ 71%] Building CXX object storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/context.cc.o In file included from /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/util/context.cc:94: In file included from /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/util/context.h:96: /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/buildheader/db.h:323:1: error: empty struct has size 0 in C, size 1 in C++ [-Werror,-Wextern-c-compat] struct __toku_db_lsn { ^ 1 error generated. make[2]: *** [storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/context.cc.o] Error 1 make[1]: *** [storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/all] Error 2 make: *** [all] Error 2 ~/Downloads/mariadb-10.1.9$ }}} -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/another-install-problem-on-mac-osx-10102/

1 0