- discuss - lists.mariadb.org

[Maria-discuss] Oneric DEBs are missing?
by Colin Charles 18 Nov '11

18 Nov '11

Hi! http://mirror.aarnet.edu.au/pub/MariaDB/repo/5.3/ubuntu/dists/ The mirror select tool allows you to choose Oneric as a distribution, but it seems to be missing from all the mirrors This probably needs to be fixed -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

2 1

[Maria-discuss] MariaDB 5.2.7 to 5.2.9 changes new bugs ?
by GEORGE LIU 13 Nov '11

13 Nov '11

First time posting to this list :) I've been using MariaDB since 5.2.4 for everyone of my side projects without issues. But having a problem while playing with Tungsten Replicator based replication. All worked fine with MariaDB 5.2.7 but since upgrading to MariaDB 5.2.9 via rpm on CentOS 6.0 64bit, I have been having problems getting Tungsten Replicator to play nice. Logged a bug report at http://code.google.com/p/tungsten-replicator/issues/detail?id=256 and the Tungsten Replicator folks say it could be possibly a problem with newer MariaDB 5.2.9 release ? Not sure who I should be contacting or whether or not MariaDB folks have already been made aware of this issue ? cheers

2 1

[Maria-discuss] New KB Question: Connecting to a Mariadb database with visual basic express 2010
by Daniel Bartholomew 08 Nov '11

08 Nov '11

A new question has been posted to the AskMonty Knowledgebase: http://kb.askmonty.org/en/connecting-to-a-mariadb-database-with-visual-basi… ----------------------------------------------------------------------- I have tried everything I know how to do -- to connect to an existing mariadb database with visual basic 2010 express. Can anyone give me any ideas on how to get a proper start. I am trying to connect to the localdb server created by heidi, which is a tcp/ip . Microsoft SQL server is installed. ----------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] PlanetMariaDB glitch - resolved
by Arjen Lentz 08 Nov '11

08 Nov '11

Hi all This morning planetmariadb.org would show no feeds and no content. Config and db was all fine, and an agressive clearing of the rss/output cache appears to have resolved the issue. Not sure what caused the problem though, which is annoying. By the way, if you do spot a problem, please shoot me an email - don't just leave a msg on #maria as that can be missed. thanks! Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise & maintenance for MySQL/MariaDB server environments. Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

1 0

[Maria-discuss] New KB Question: CentOS 5.x/6.x mysql-lib conflicts and postfix
by Daniel Bartholomew 01 Nov '11

01 Nov '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/centos-5x6x-mysql-lib-conflicts-and-postfix ======================================================================= On a fresh CentOS 5.x/6.x 32bit or 64bit install, mysql 5.0.xx is installed. To install MariaDB 5.2.x rpms, mysql-lib needs to be removed for MariaDB-server to be installed. But removing mysql-lib via yum remove, removes postfix. If later you need to install postfix via yum it still requires mysql-lib, but installing mysql-lib installs mysql 5.0.x server again. yum install postfix Loaded plugins: fastestmirror, refresh-packagekit Loading mirror speeds from cached hostfile * base: mirror.averse.net * extras: mirror.averse.net * rpmforge: apt.sw.be * updates: mirror.averse.net Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package postfix.x86_64 2:2.6.6-2.1.el6_0 set to be updated --> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-2.1.el6_0.x86_64 --> Finished Dependency Resolution Error: Package: 2:postfix-2.6.6-2.1.el6_0.x86_64 (updates) Requires: mysql-libs You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest Anyway to properly resolve this ? with MariaDB 5.2/5.3.x version of mysql-lib ?? ======================================================================= Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Aria_log file
by Richard Dunn 15 Oct '11

15 Oct '11

How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.

3 4

[Maria-discuss] MariaDB 5.3.2-beta now available
by Daniel Bartholomew 14 Oct '11

14 Oct '11

The MariaDB project would like to announce the availability of MariaDB 5.3.2-beta, the latest addition to our growing lineup of supported software. MariaDB 5.3.2-beta is a bug-fix update to the previous 5.3.1 and 5.3.0 betas. == About MariaDB 5.3 The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 == About MariaDB 5.3.2-beta In the MariaDB 5.3.2-beta there are a couple of changes compared to previous 5.3 releases: === User Feedback plugin MariaDB 5.3.2-beta introduces the User Feedback plugin. This plugin is disabled by default. If enabled, it submits anonymous basic MariaDB usage information. This information will be 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 --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. === Subquery Cache now on by default Starting in MariaDB 5.3.2-beta, the Subquery cache is on by default. In previous versions of MariaDB the cache was off by default. The goal of the subquery cache is to optimize the evaluation of correlated subqueries by storing results together with correlation parameters in a cache and avoiding re-execution of the subquery in cases where the result is already in the cache. See http://kb.askmonty.org/en/subquery-cache for more information. == MariaDB 5.3.2-beta Release Notes, Changelog, Downloads The release notes for MariaDB 5.3.2-beta are available from: http://kb.askmonty.org/en/mariadb-532-release-notes A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-532-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.2/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ The project always strives for quality, and being a beta release, we know that not everything may be perfect. Please take some time to report any issues you may encounter at: https://bugs.launchpad.net/maria Enjoy MariaDB 5.3.2-beta & Happy Testing! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Including MariaDB server and client in my package application???
by wahono sri 06 Oct '11

06 Oct '11

May I include MariaDB files in my software package to make easy for user if they don't know about db server and how to install and configure it to use as db server for my application. I'll prefer my users to choose options of installation package : 1. Acosys Version 4 2. MariaDB Client Library 3. MariaDB Server 4. .... Is it allowed by MariaDB licence? I read MariaDB licence but I am confusing to understand it clearly. Thanks Wahono

4 3

[Maria-discuss] Error install from binary tarballs
by wahono sri 30 Sep '11

30 Sep '11

I use PCLinuxOS and I can't install from RPM or from binary. I got this message from /data/localhost.localhost.err 110930 22:52:06 mysqld_safe Starting mysqld daemon with databases from ./data 110930 22:52:06 [ERROR] mysqld: File '/usr/local/mysql/data/aria_log_control' not found (Errcode: 13) 110930 22:52:06 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/usr/local/mysql/data/aria_log_control' 110930 22:52:06 [ERROR] Plugin 'Aria' init function returned error. 110930 22:52:06 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 110930 22:52:06 [ERROR] Failed to initialize plugins. 110930 22:52:06 [ERROR] Aborting 110930 22:52:06 [Note] ./bin/mysqld: Shutdown complete 110930 22:52:06 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 22:54:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 22:54:34 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 22:54:34 [ERROR] Aborting 110930 22:54:34 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 22:56:00 mysqld_safe Starting mysqld daemon with databases from ./data 110930 22:56:00 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 22:56:00 [ERROR] Aborting 110930 22:56:00 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 23:00:45 mysqld_safe Starting mysqld daemon with databases from ./data 110930 23:00:45 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:00:45 [ERROR] Aborting 110930 23:00:45 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 23:01:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 23:01:01 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:01:01 [ERROR] Aborting 110930 23:01:01 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 23:01:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 23:01:10 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:01:10 [ERROR] Aborting 110930 23:01:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 23:03:41 mysqld_safe Starting mysqld daemon with databases from ./data 110930 23:03:41 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:03:41 [ERROR] Aborting 110930 23:03:41 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended How to fix this error? Thanks

2 1

[Maria-discuss] New KB Question: MariaDB 5.2.x server RPM fails on upgrades - error: scriptlet failed, exit status 1
by Daniel Bartholomew 30 Sep '11

30 Sep '11

A new question has been posted to the Knowledgebase: MariaDB 5.2.x server RPM fails on upgrades - error: scriptlet failed, exit status 1 http://kb.askmonty.org/en/mariadb-52x-server-rpm-fails-on-upgrades-error-sc… --------------------------------------------------------------------- This problem occurs on CentOS 5.5/5.6/6.0 32bit and 64bit from first time I used MariaDB 5.2.3 all the way to 5.2.9 upgrade. It happens 1) via manual RPM upgrade from RPM downloaded at http://downloads.askmonty.org/mariadb/5.2/#file_type=rpm or 2) via ourdelta YUM REPO update http://ourdelta.org/centos (yum update MariaDB*). Problem, MariaDB-server-5.2.x RPM updates fails and needs manually removing previous version MariaDB-server-5.2.x RPM before the new update installs. error error: %pre(MariaDB-server-5.2.9-102.el5.x86_64) scriptlet failed, exit status 1 error: install: %pre scriptlet failed (2), skipping MariaDB-server-5.2.9-102.el5 full details below ... (continued in the KB) --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

2 2