- discuss - lists.mariadb.org

[Maria-discuss] failed to initialize plugins error
by Patrick Galbraith 10 Sep '11

10 Sep '11

Hi all! Moin moin, Privet! I have the latest 5.3 compiled as well as a client's own storage engine. The compile, link, all went well. I do notice they only compile their engine statically, but see symbols for it in mysqld: ... 000000000081d4f0 T filepro_rkey 000000000081d9f0 T filepro_rnext 000000000081da80 T filepro_rprev 000000000081d350 T filepro_rrange 000000000081db20 T filepro_rrnd 000000000081ddc0 T filepro_scan 000000000081dde0 T filepro_scan_init 0000000000e747c8 B filepro_share_list 0000000000e52ea0 D filepro_storage_engine 000000000081de00 T filepro_update 000000000081e020 T filepro_write 0000000000e74798 b ha_filepro_exts ... So, when I start mysqld, I get the error: "[ERROR] Failed to initialize plugins." If I run this with strace, I don't see it trying to load a particular shared library file, just it logging messages to the log, opening replication log and index. So, not sure what I need to load with "plugin_load". When I configured MariaDB top compile, I used the following (per what the client uses with their successful build of MySQL 5.1.30) ./configure --with-plugins=all --without-plugin-oqgraph --with-charset=utf8 --enable-assembler --enable-profiling --enable-community-features --without-plugin-ndbcluster --prefix=/usr/local/maria I'm guessing that I'm missing something obvious and simple? Thank you in advance for any help! Patrick

3 2

[Maria-discuss] Native SQL-Connector for LibreOffice/OpenOffice
by Daniel Bartholomew 07 Sep '11

07 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/native-sql-connector-for-libreofficeopenoffice --------------------------------------------------------------------- Hello, I have been using OO/LO for years and have used both the Java-Connector but also ODBC under both Debian-Linux and Windows-Vista. When it became available I switched to the Native MySQL-Connector as delivered by MySQL. Oracle now has obviously got rid of that connector. Is there or are there any plany for a native connector to LO/OO in MariaDB? Thanks for your help and regards H. Stoellinger Salzburg --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Is there any java connector for MariaDB than the one from Mysql(mysql-java-5.1.6.jar) ?
by Daniel Bartholomew 01 Sep '11

01 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/is-there-any-java-connector-for-mariadb-than-the-… ---------------------------------------------------------------------- For licensing purposes, we try to remove any link to MySQL connectors, we found for Delphi and .NET, but we did not yet find any for java. Does anyone know a third party components that can be used as java connector for MariaDB ? ---------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] GUI/Workbench for MariaDB Aria?
by Peter Laursen 31 Aug '11

31 Aug '11

'transactional' in Aria will eanable crash recovery for the table. It will not make the table transactional (ie. START TRANSACTION, COMMIT, ROLLBACK etc.) are still ignored. Probably it was originaly intended to have it trasactional over time but I do not think focus is there at the moment. Byt yes .. it is just a checkbox and would be simple to add to any GUI (conditionally if engine = ARIA). But I think that if people want (user-)tables with the Aria engine you would use '1' in most if not all cases (temproary tables created by server internally is another thing). -- Peter On Wed, Aug 31, 2011 at 07:47, Ansgar Becker <ansgar.becker(a)googlemail.com>wrote: > Hi all, > I'm a bit unsure what this option really does, now that Peter said it > doesn't make a table transactional, but I'm sure there is a reason for why > it exists. So I'll see if I can add a checkbox right besides the engine drop > down, which is enabled only if Aria is selected. Also I need to read out > this attribute in existing tables, which needs some adjustment in my CREATE > TABLE parser. > > Ansgar > > Am 30.08.2011 19:31, schrieb Peter Laursen: > > We have the same request for SQLyog: > http://code.google.com/p/sqlyog/issues/detail?id=538 > > Of course a client is never engine-specific. But that is not the same > that a client has GUI fucntionalities to su > > @Vlad you probably know that your company (Monty Program) and mine > (Webyog) are partners (what means customers will gain a rebate to our > products when comming from Monty Program website. Check it out or ask Monty > himself). Not that I would mind that Ansgar adds this to Heidi. But > basically we never found it very important. Even if ARIA is set to > transactioanl = 1 , it is not transactional. it has crash recovery what is > not the same. > > > Peter > Webyog > > On Tue, Aug 30, 2011 at 19:11, Vladislav Vaintroub <wlad(a)montyprogram.com>wrote: > >> I'm forwarding this to Ansgar, as a feature request for HeidiSQL. May be >> tricky to add it as Aria-specific option, currently CREATE TABLE >> options/checkboxes in HeidiSQL seem to be not engine dependent to me. >> >> > -----Original Message----- >> > From: maria-discuss- >> > bounces+wlad=montyprogram.com(a)lists.launchpad.net [mailto:maria- >> > discuss-bounces+wlad=montyprogram.com(a)lists.launchpad.net] On Behalf >> > Of Daniel Bartholomew >> > Sent: Dienstag, 30. August 2011 18:50 >> > To: Maria Discuss >> > Subject: [Maria-discuss] GUI/Workbench for MariaDB Aria? >> > >> > New question on the Knowledgebase: >> > >> > http://kb.askmonty.org/en/guiworkbench-for-mariadb-aria >> > >> > Does anybody know a good GUI/Work bench tool to handle ARIA >> > transactional=1/0 and row_format=PAGE situations? >> > >> > Thanks. >> > >> > -- >> > Daniel Bartholomew >> > MariaDB - http://mariadb.org >> > Monty Program - http://montyprogram.com >> > AskMonty Knowledgebase - http://kb.askmonty.org >> > >> > >> > _______________________________________________ >> > 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 >> >> >> _______________________________________________ >> 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 >> > > >

1 0

[Maria-discuss] Good GUI
by md＠rpzdesign.com 30 Aug '11

30 Aug '11

Hello: I have been using Navicat to administer my Oracle/Sun based MySQL servers for years. (www.navicat.com) Now I am switched over to MariaDB 2.8 using ARIA engine. What do MariaDB users recommend of good GUI front end that allows me to manage ARIA Create Table Transactional=0|1 Row_format=PAGE setting. Most Tools do not support all of the MariaDB settings in the table setup dialogs. Suggestions appreciated... md

3 2

[Maria-discuss] GUI/Workbench for MariaDB Aria?
by Daniel Bartholomew 30 Aug '11

30 Aug '11

New question on the Knowledgebase: http://kb.askmonty.org/en/guiworkbench-for-mariadb-aria Does anybody know a good GUI/Work bench tool to handle ARIA transactional=1/0 and row_format=PAGE situations? Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

3 2

[Maria-discuss] Frequently running Event overlapping itself
by Brian Evans 17 Aug '11

17 Aug '11

I have an issue where a fast triggering event, running every 30 seconds, is occasionally running multiple times without each finishing. This is causing duplicate data as things are marked done one at a time. I am trying to figure a solution such that this event can only run singly, but what is the best way? DISABLE at start and ENABLE at end? Do SESSION variables work between event invocations?

2 2

[Maria-discuss] Installation issues with PHP5
by Daniel Bartholomew 15 Aug '11

15 Aug '11

A few comments were posted yesterday to the following Knowledgebase article: https://kb.askmonty.org/en/installation-issues-with-php5 The poster is getting mysql_connect errors. He's using CentOS 5 64bit, PHP 5.2, and recently upgraded from MySQL 5.0.77 to MariaDB 5.3. If you have any experience in this area, please consider jumping in and replying to the comments. Thanks! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Bug reporting
by planas 06 Aug '11

06 Aug '11

How does one post a bug? install issue with MariaDB-server-5.2 and 5.3 - fatal, crash on install Ubuntu 11.04 see below for terminal reports for both sudo apt-get install mariadb-server-5.2 Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.2 mariadb-client-core-5.2 mariadb-server-core-5.2 mysql-common Suggested packages: mailx mariadb-test The following NEW packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.2 mariadb-client-core-5.2 mariadb-server-5.2 mariadb-server-core-5.2 mysql-common 0 upgraded, 8 newly installed, 0 to remove and 2 not upgraded. Need to get 21.4 MB/21.5 MB of archives. After this operation, 51.2 MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mysql-common all 5.2.7-mariadb101~natty [10.6 kB] Get:2 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main libmariadbclient16 amd64 5.2.7-mariadb101~natty [1,454 kB] Get:3 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main libmysqlclient16 amd64 5.2.7-mariadb101~natty [4,300 B] Get:4 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-client-core-5.2 amd64 5.2.7-mariadb101~natty [93.7 kB] Get:5 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-client-5.2 amd64 5.2.7-mariadb101~natty [1,759 kB] Get:6 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-server-core-5.2 amd64 5.2.7-mariadb101~natty [4,474 kB] Get:7 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-server-5.2 amd64 5.2.7-mariadb101~natty [13.6 MB] Fetched 21.4 MB in 6s (3,166 kB/s) Preconfiguring packages ... Selecting previously deselected package mysql-common. (Reading database ... 458443 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.2.7-mariadb101~natty_all.deb) ... Selecting previously deselected package libmariadbclient16. Unpacking libmariadbclient16 (from .../libmariadbclient16_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libmysqlclient16. Unpacking libmysqlclient16 (from .../libmysqlclient16_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_amd64.deb) ... Selecting previously deselected package mariadb-client-core-5.2. Unpacking mariadb-client-core-5.2 (from .../mariadb-client-core-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-client-5.2. Unpacking mariadb-client-5.2 (from .../mariadb-client-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-server-core-5.2. Unpacking mariadb-server-core-5.2 (from .../mariadb-server-core-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for menu ... Setting up mysql-common (5.2.7-mariadb101~natty) ... Selecting previously deselected package mariadb-server-5.2. (Reading database ... 458622 files and directories currently installed.) Unpacking mariadb-server-5.2 (from .../mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for ureadahead ... Setting up libmysqlclient16 (5.2.7-mariadb101~natty) ... Setting up libmariadbclient16 (5.2.7-mariadb101~natty) ... Setting up libdbd-mysql-perl (4.016-1) ... Setting up mariadb-client-core-5.2 (5.2.7-mariadb101~natty) ... Setting up mariadb-client-5.2 (5.2.7-mariadb101~natty) ... Setting up mariadb-server-core-5.2 (5.2.7-mariadb101~natty) ... Setting up mariadb-server-5.2 (5.2.7-mariadb101~natty) ... ' * Stopping MariaDB database server mysqld [ OK ] 110805 19:21:20 [Note] Plugin 'PBXT' is disabled. 110805 19:21:20 [Note] Plugin 'InnoDB' is disabled. * Starting MariaDB database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mariadb-server-5.2 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin ... ldconfig deferred processing now taking place Processing triggers for menu ... Errors were encountered while processing: mariadb-server-5.2 E: Sub-process /usr/bin/dpkg returned an error code (1) sudo apt-get install mariadb-server-5.3 Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.3 mariadb-client-core-5.3 mariadb-server-core-5.3 mysql-common Suggested packages: mailx mariadb-test The following NEW packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.3 mariadb-client-core-5.3 mariadb-server-5.3 mariadb-server-core-5.3 mysql-common 0 upgraded, 8 newly installed, 0 to remove and 2 not upgraded. Need to get 22.8 MB of archives. After this operation, 56.5 MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mysql-common all 5.3.0-mariadb101~natty [10.7 kB] Get:2 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main libmariadbclient16 amd64 5.3.0-mariadb101~natty [1,517 kB] Get:3 http://us.archive.ubuntu.com/ubuntu/ natty/main libdbd-mysql-perl amd64 4.016-1 [140 kB] Get:4 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main libmysqlclient16 amd64 5.3.0-mariadb101~natty [4,356 B] Get:5 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-client-core-5.3 amd64 5.3.0-mariadb101~natty [94.1 kB] Get:6 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-client-5.3 amd64 5.3.0-mariadb101~natty [1,760 kB] Get:7 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-server-core-5.3 amd64 5.3.0-mariadb101~natty [4,719 kB] Get:8 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-server-5.3 amd64 5.3.0-mariadb101~natty [14.5 MB] Fetched 22.8 MB in 6s (3,556 kB/s) Preconfiguring packages ... Selecting previously deselected package mysql-common. (Reading database ... 458566 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.3.0-mariadb101~natty_all.deb) ... Selecting previously deselected package libmariadbclient16. Unpacking libmariadbclient16 (from .../libmariadbclient16_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libmysqlclient16. Unpacking libmysqlclient16 (from .../libmysqlclient16_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_amd64.deb) ... Selecting previously deselected package mariadb-client-core-5.3. Unpacking mariadb-client-core-5.3 (from .../mariadb-client-core-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-client-5.3. Unpacking mariadb-client-5.3 (from .../mariadb-client-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-server-core-5.3. Unpacking mariadb-server-core-5.3 (from .../mariadb-server-core-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for menu ... Setting up mysql-common (5.3.0-mariadb101~natty) ... Selecting previously deselected package mariadb-server-5.3. (Reading database ... 458747 files and directories currently installed.) Unpacking mariadb-server-5.3 (from .../mariadb-server-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for ureadahead ... Setting up libmysqlclient16 (5.3.0-mariadb101~natty) ... Setting up libmariadbclient16 (5.3.0-mariadb101~natty) ... Setting up libdbd-mysql-perl (4.016-1) ... Setting up mariadb-client-core-5.3 (5.3.0-mariadb101~natty) ... Setting up mariadb-client-5.3 (5.3.0-mariadb101~natty) ... Setting up mariadb-server-core-5.3 (5.3.0-mariadb101~natty) ... Setting up mariadb-server-5.3 (5.3.0-mariadb101~natty) ... * Stopping MariaDB database server mysqld [ OK ] 110805 19:01:37 [Note] Plugin 'PBXT' is disabled. 110805 19:01:37 [Note] Plugin 'InnoDB' is disabled. * Starting MariaDB database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mariadb-server-5.3 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin ... ldconfig deferred processing now taking place Processing triggers for menu ... Errors were encountered while processing: mariadb-server-5.3 E: Sub-process /usr/bin/dpkg returned an error code (1) I have spent days trying to fully resolve this. One should be able uninstall and reinstall a package as needed without tracking down bugs in the installer or uninstaller scripts. Logs have been blank or just repeat the above information. -- Jay Lozier jslozier(a)gmail.com

2 1

[Maria-discuss] Cannot install Mariadb-server-5.2
by planas 04 Aug '11

04 Aug '11

Hi I have been struggling to get mariadb to work. My problems have been either the server is very erratic, usually will not start it. After trying a complete reinstall I can not install the mariadb-server-5.2 package either from the repository or from a deb. I am using Ubuntu/Pinguy 11.04. The installation results from apt-get or aptitude are sudo aptitude install mariadb-server-5.2 The following NEW packages will be installed: mariadb-server-5.2 0 packages upgraded, 1 newly installed, 0 to remove and 21 not upgraded. Need to get 13.6 MB of archives. After unpacking 30.8 MB will be used. Get:1 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-server-5.2 amd64 5.2.7-mariadb101~natty [13.6 MB] Fetched 13.6 MB in 4s (2,733 kB/s) Preconfiguring packages ... (Reading database ... 427308 files and directories currently installed.) Unpacking mariadb-server-5.2 (from .../mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Aborting downgrade from (at least) 5.3 to 5.2. If are sure you want to downgrade to 5.2, remove the file /var/lib/mysql/debian-*.flag and try installing again. dpkg: error processing /var/cache/apt/archives/mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb (--unpack): subprocess new pre-installation script returned error exit status 1 Errors were encountered while processing: /var/cache/apt/archives/mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1) A package failed to install. Trying to recover: I tried MySQL 5.1.7 from the Ubuntu repository and got the same results. Searching various forums/online information has not turned up an answer including MySQL and Ubuntu. -- Jay Lozier jslozier(a)gmail.com

2 1