- discuss - lists.mariadb.org

[Maria-discuss] New Question: unable to upgrade from MariaDB 5.5 to MariaDB 10.0 using YUM
by AskMonty KB 01 Apr '14

01 Apr '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- I created a file mariadb.repo and put in info for mariadb 10.0, when I run the command yum -y update or yum -y upgrade mariadb-server mariadb-client, Loaded plugins: langpacks, refresh-packagekit Resolving Dependencies --> Running transaction check ---> Package MariaDB-server.x86_64 0:10.0.10-1.fc20 will be obsoleting ---> Package mariadb-server.x86_64 1:5.5.36-1.fc20 will be obsoleted --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: MariaDB-server x86_64 10.0.10-1.fc20 mariadb 49 M replacing mariadb-server.x86_64 1:5.5.36-1.fc20 Transaction Summary ================================================================================ Install 1 Package Total download size: 49 M Downloading packages: MariaDB-10.0.10-fedora20-x86_64-server.rpm | 49 MB 00:00:10 Running transaction check Running transaction test Transaction test succeeded Running transaction sed: invalid option -- '1' Usage: sed [OPTION]... {script-only-if-no-other-script} [input-file]... -n, --quiet, --silent suppress automatic printing of pattern space -e script, --expression=script add the script to the commands to be executed -f script-file, --file=script-file add the contents of script-file to the commands to be executed --follow-symlinks follow symlinks when processing in place -i[SUFFIX], --in-place[=SUFFIX] edit files in place (makes backup if SUFFIX supplied) -c, --copy use copy instead of rename when shuffling files in -i mode -b, --binary does nothing; for compatibility with WIN32/CYGWIN/MSDOS/EMX ( open files in binary mode (CR+LFs are not treated specially)) -l N, --line-length=N specify the desired line-wrap length for the `l' command --posix disable all GNU extensions. -r, --regexp-extended use extended regular expressions in the script. -s, --separate consider files as separate rather than as a single continuous long stream. -u, --unbuffered load minimal amounts of data from the input files and flush the output buffers more often -z, --null-data separate lines by NUL characters --help display this help and exit --version output version information and exit If no -e, --expression, -f, or --file option is given, then the first non-option argument is taken as the sed script to interpret. All remaining arguments are names of input files; if no input files are specified, then the standard input is read. GNU sed home page: <http://www.gnu.org/software/sed/>. General help using GNU software: <http://www.gnu.org/gethelp/>. ****************************************************************** A MySQL or MariaDB server package () is installed. The current MariaDB server package is provided by a different vendor (package is not installed) than Monty Program AB. Some files may be installed to different locations, including log files and the service startup script in /etc/init.d/. Upgrading directly from MySQL <unrecognized version package is not installed> to MariaDB 10.0 may not be safe in all cases. A manual dump and restore using mysqldump is recommended. It is important to review the MariaDB manual's Upgrading section for version-specific incompatibilities. A manual upgrade is required. - Ensure that you have a complete, working backup of your data and my.cnf files - Shut down the MySQL server cleanly - Remove the existing MySQL packages. Usually this command will list the packages you should remove: rpm -qa | grep -i '^mysql-' You may choose to use 'rpm --nodeps -ev <package-name>' to remove the package which contains the mysqlclient shared library. The library will be reinstalled by the MariaDB-shared package. - Install the new MariaDB packages supplied by Monty Program AB - Ensure that the MariaDB server is started - Run the 'mysql_upgrade' program This is a brief description of the upgrade process. Important details can be found in the MariaDB manual, in the Upgrading section. ****************************************************************** error: %pre(MariaDB-server-10.0.10-1.fc20.x86_64) scriptlet failed, exit status 1 Error in PREIN scriptlet in rpm package MariaDB-server-10.0.10-1.fc20.x86_64 Verifying : MariaDB-server-10.0.10-1.fc20.x86_64 1/2 1:mariadb-server-5.5.36-1.fc20.x86_64 was supposed to be removed but is not! Verifying : 1:mariadb-server-5.5.36-1.fc20.x86_64 2/2 Failed: MariaDB-server.x86_64 0:10.0.10-1.fc20 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-upgrade-from-mariadb-55-to-mariadb-100-u…

1 0

[Maria-discuss] New Question: crash recovery
by AskMonty KB 01 Apr '14

01 Apr '14

Hello, A new question has been asked in "Backing Up and Restoring" by joemurray: -------------------------------- An XtraDB database running in MariaDB - no cluster, no replication - has been crashing about 15 x per day for 3 days and we suspect it may be corrupt. We don't see any reason in the log files for the crashes. We have taken a mysqldump and restored into a new db and run mysqlcheck on the new db and not fond any errors, but I suspect that the dumping and restoring has hidden them. After testing a staging site with this new database we are planning to repeat the process of dumping and restoring into a new db and then making it live. I intend to run mysqlcheck on the production database once it is no longer in production. Any other suggestions from DBAs to this developer? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/crash-recovery/

1 0

[Maria-discuss] MariaDB 10.0.10 now available
by Daniel Bartholomew 31 Mar '14

31 Mar '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.10. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.10 - Release Notes: https://mariadb.com/kb/en/mariadb-10010-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10010-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.10 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB & MySQL community event, 3 Apr 2014 - - - - - - - - - - - The MariaDB Foundation is holding a community event to complement the Percona Live conference and expo in Santa Clara, CA. The event is free. Visit the Community Events page on mariadb.org for full details, including the speaker schedule and to register. - https://mariadb.org/en/community-events/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - 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/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL 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

3 2

[Maria-discuss] New Question: MariaDB wire protocol
by AskMonty KB 31 Mar '14

31 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by steveteale: -------------------------------- Where is the wire protocol described please. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-wire-protocol/

1 0

[Maria-discuss] bugs in the testsuite
by Reindl Harald 31 Mar '14

31 Mar '14

hi, i see the errors below for a longer time and thought i should mention them - in case of running the test-suite completly alone i would not expect that /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_row_utf32 'row' [ fail ] Test ended at 2014-03-05 19:57:46 CURRENT_TEST: rpl.rpl_row_utf32 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_row_utf32.test at line 2: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with 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_row_utf32-row/' to '/usr/share/mysql-test/var/log/rpl.rpl_row_utf32-row/' rpl.rpl_row_view01 'row' [ skipped ] Not ROW format rpl.rpl_row_wide_table 'row' [ skipped ] Not ROW format rpl.rpl_tmp_table_and_DDL 'row' [ fail ] Test ended at 2014-03-05 19:57:50 CURRENT_TEST: rpl.rpl_tmp_table_and_DDL 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_tmp_table_and_DDL.test at line 8: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with 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_tmp_table_and_DDL-row/' to '/usr/share/mysql-test/var/log/rpl.rpl_tmp_table_and_DDL-row/' rpl.semisync_memleak_4066 'row' [ skipped ] Need semisync plugins rpl.rpl_stm_sql_mode 'stmt' [ fail ] Test ended at 2014-03-05 19:58:31 CURRENT_TEST: rpl.rpl_stm_sql_mode 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_stm_sql_mode.test at line 2: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with 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_stm_sql_mode-stmt/' to '/usr/share/mysql-test/var/log/rpl.rpl_stm_sql_mode-stmt/'

2 1

[Maria-discuss] New Question: Multi Master Replication
by AskMonty KB 27 Mar '14

27 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by eddow: -------------------------------- Greetings, I am attempting to set up Multi Master Replication. So far, I have been able to set up multiple masters and data is replicated to one slave. This works great. What I am having a problem with is if I add a new master. When I add the master the data in the slave table is truncated and only the data from the new master is replicated. I loose all my old data in the slave. Example: Master 1300: +----------------+ | name | +----------------+ t1300 Master 13: +----------------+ | name | +----------------+ t13 +----------------+ Slave: +----------------+ | name | +----------------+ t1300 t13 +----------------+ On the slave I do this: change master 't68' to master_host='10.79.84.149', master_user='replication_user', master_port=3306; start slave t1300; select * from name; Slave: +----------------+ | name | +----------------+ t68 +----------------+ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multi-master-replication/

2 1

[Maria-discuss] Does ADD/DROP INDEX update the InnoDB buffer pool?
by Markus "Shorty" Uckelmann 25 Mar '14

25 Mar '14

Hi all, When adding or dropping a primary and/or secondary index is the InnoDB buffer pool updated too? Is the pool changed in place or will the LRU algo just evict to make room? In the second case buffers of other tables on the server might be affected too and the server would run with a more or less cold buffer pool. We have to fiddle with indices on production servers, which by itself is a precarious matter. So I tried to find out how ADD/DROP INDEX operations affect the memory/buffer pool of our servers. Since I wasn't able (or too stupid) to find something about this topic it would be great if someone could help me out and point me in the right direction. BTW: Version is MariaDB 5.5 Cheers, Shorty

2 1

[Maria-discuss] New Question: can't get mariadb to start in Slackware
by AskMonty KB 25 Mar '14

25 Mar '14

Hello, A new question has been asked in "MariaDB community" by boomhower182: -------------------------------- After my fresh install it was starting just fine and the only thing I changed was my apache config files to get php to work and then I did some updates and it was still working, then all of a sudden it stopped working. this is what my .err file states.. 140324 16:49:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140324 16:49:05 InnoDB: The InnoDB memory heap is disabled 140324 16:49:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140324 16:49:05 InnoDB: Compressed tables use zlib 1.2.8 140324 16:49:05 InnoDB: Using Linux native AIO 140324 16:49:05 InnoDB: Initializing buffer pool, size = 128.0M 140324 16:49:05 InnoDB: Completed initialization of buffer pool 140324 16:49:05 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140324 16:49:05 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140324 16:49:05 InnoDB: Waiting for the background threads to start 140324 16:49:06 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 1597945 140324 16:49:06 [Note] Plugin 'FEEDBACK' is disabled. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 140324 16:49:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-get-mariadb-to-start-in-slackware/

2 1

[Maria-discuss] subscribe please
by James Qian Wang 21 Mar '14

21 Mar '14

-- James Qian Wang Mobile: 44 7986 099 233

2 1

[Maria-discuss] New Question: ETL tool for MariaDB
by AskMonty KB 21 Mar '14

21 Mar '14

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by Sunil: -------------------------------- Hello, Please let me know the ETL tools that we can integrate with MAriaDB. Thanks Sunil -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/etl-tool-for-mariadb/

1 0