- discuss - lists.mariadb.org

[Maria-discuss] MariaDB Java Client 1.1.0 Released
by Daniel Bartholomew 16 Jan '13

16 Jan '13

The MariaDB Java Client 1.1.0 has been released. You can download it here: https://downloads.mariadb.org/client-java/1.1.0/ This version focused on fixing all known database metadata bugs and ConnnectorJ incompatibilities. Specific fixes include: - Consistent, compatible with ConnectorJ handling of JDBC catalogs vs schemas vs databases - Implementation of several missing methods in DatabaseMetaData - Better handling of statement timeouts - OSGi-specific entries have been added to MANIFEST.MF so it can be used in OSGi environments - Added support for dumpQueriesOnException=true in the JDBC URL - Added support for IPv6 addresses in the connector - Added SSL support - and more... See the Release Notes and Changelog for more information: - https://kb.askmonty.org/en/mariadb-java-client-110-release-notes - https://kb.askmonty.org/en/mariadb-java-client-110-changelog See also the "About the MariaDB Java Client" page: - https://kb.askmonty.org/en/about-the-mariadb-java-client -- 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 Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB installation failed in fedora17, No more mirrors to try!!!
by Haseena L. 14 Jan '13

14 Jan '13

Hi all, Iam trying to install mariadb in fedora17 using the following link : https://kb.askmonty.org/en/installing-mariadb-with-yum/#manually-importi ng-the-mariadb-signing-key It shows an error, there is no mirror for downloading mariadb. Please see the error log : $ sudo yum install MariaDB-server MariaDB-client Loaded plugins: langpacks, presto, refresh-packagekit fedora/metalink | 8.3 kB 00:00 fedora | 4.2 kB 00:00 fedora/primary_db | 12 MB 00:02 fedora/group_gz | 434 kB 00:00 mariadb | 1.9 kB 00:00 mariadb/primary_db | 15 kB 00:00 updates/metalink | 3.7 kB 00:00 updates | 4.7 kB 00:00 updates/primary_db | 5.9 MB 00:44 updates/group_gz | 439 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.i686 0:5.5.28a-1 will be installed --> Processing Dependency: MariaDB-common for package: MariaDB-client-5.5.28a-1.i686 ---> Package MariaDB-server.i686 0:5.5.28a-1 will be obsoleting ---> Package mysql.i686 0:5.5.23-1.fc17 will be obsoleted ---> Package mysql-server.i686 0:5.5.23-1.fc17 will be obsoleted --> Running transaction check ---> Package MariaDB-common.i686 0:5.5.28a-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ======================================================================== ======== Package Arch Version Repository Size ======================================================================== ======== Installing: MariaDB-client i686 5.5.28a-1 mariadb 8.4 M MariaDB-server i686 5.5.28a-1 mariadb 32 M replacing mysql.i686 5.5.23-1.fc17 replacing mysql-server.i686 5.5.23-1.fc17 Installing for dependencies: MariaDB-common i686 5.5.28a-1 mariadb 23 k Transaction Summary ======================================================================== ======== Install 2 Packages (+1 Dependent package) Total size: 41 M Total download size: 41 M Is this ok [y/N]: y Downloading Packages: http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-client.rpm: [Errno 12] Timeout on http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-client.rpm: (28, '') Trying other mirror. http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-server.rpm: [Errno 12] Timeout on http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-server.rpm: (28, '') Trying other mirror. Error Downloading Packages: MariaDB-server-5.5.28a-1.i686: failure: rpms/MariaDB-5.5.28a-fedora17-i686-server.rpm from mariadb: [Errno 256] No more mirrors to try. MariaDB-client-5.5.28a-1.i686: failure: rpms/MariaDB-5.5.28a-fedora17-i686-client.rpm from mariadb: [Errno 256] No more mirrors to try. Please help me... Give me the appropriate mirror for downloading mariadb Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

1 0

[Maria-discuss] Reporting upstream bugs
by Federico Razzoli 10 Jan '13

10 Jan '13

Hi all. I reported a bug in JIRA - I hit it in MariaDB but it was tagged as "upstream". This brings us to the question: is it ok to report upstream bugs in MariaDB's JIRA? There are 2 reasons why I didn't report it to Oracle. Let me explain. 1) MySQL Ab and Sun never had a lot of data about me or the companies where I worked. They only had my email and my full name, plus some optional info, if I remember correctly. But my old account doesn't work anymore, and the new Oracle's sign up page REQUIRES a lot of data - including a physical address and a work phone. I don't want to provide them too much info about me and my company. 2) I tried to sign up with fake data, but after 2 days I didn't receive a confirm email and my account still doesn't work. They are very slow, or something doesn't work fine in their website, or they detected that some data I wrote is fake (but I got no error message). I think that a company which develops open source software should be glad that people reports bugs, and should make the process easier. If the process is hard, I would prefer to report bugs to MariaDB. But, what does MariaDB think about it? Is it ok to report the bugs to you? Federico Razzoli

3 3

[Maria-discuss] ASFORMENTIONED keyword suggestion
by Eric Wood 26 Dec '12

26 Dec '12

Routinely updating records with 20 or more columns can be exhausting work. Many have asked for this for many years and I was hoping a MariaDB developer would take the reins in implementing a shorter ON DUPLICATE KEY UPDATE syntax: INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`); INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE a=1, b=2, c=3; INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY UPDATE ASFORMENTIONED; INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE ASFORMENTIONED; Something like this would certainly make SQL enjoyable again. -Eric Wood

1 0

[Maria-discuss] DrizzleJDBC 1,2
by Marcus Eriksson 06 Dec '12

06 Dec '12

Hi I just released DrizzleJDBC 1.2 DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle It is in maven central: <dependency> <groupId>org.drizzle.jdbc</groupId> <artifactId>drizzle-jdbc</artifactId> <version>1.2</version> </dependency> Changelog; - IPv6 support, enclose the IP in brackets, [::1] ( https://github.com/krummas/DrizzleJDBC/issues/10) - Correct behavior if getInt on larger than MAXINT values ( https://github.com/krummas/DrizzleJDBC/issues/9) - Fix ssl support, was not possible to close connection ( https://github.com/krummas/DrizzleJDBC/issues/8) - Support InputStream in LOAD DATA INFILE ( https://github.com/krummas/DrizzleJDBC/issues/7) - support getting columns using <table>.<column> ( https://github.com/krummas/DrizzleJDBC/issues/6) - use single quotes (https://github.com/krummas/DrizzleJDBC/pull/5) - clean up unicode support (https://github.com/krummas/DrizzleJDBC/pull/4) - Fix NPE bug when timestamp is null, patch by Tim Rickettsl on launchpad - set FOUND ROWS by default (https://github.com/krummas/DrizzleJDBC/issues/2 ) Report bugs/feature requests etc on github; https://github.com/krummas/DrizzleJDBC /Marcus

3 3

[Maria-discuss] partitioning by timestamp field
by Said Ramirez 30 Nov '12

30 Nov '12

Hello, I am trying to setup a range partitioned table using 5.5.27-MariaDB-log MariaDB Server using a timestamp field. According to the documents, I should be able to use unix_timestamp(ts) as my partitioning function ( http://dev.mysql.com/doc/refman/5.5/en/partitioning-range.html ) . I find, however, that it is not possible to use unix_timestamp using mariadb because with mariadb the unix_timestamp function returns an floating point value: mariadb> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000.000000 | +------------------------------+ 1 row in set (0.00 sec) However the MySQL version of unix_timestamp returns an int value: myqsl> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000 | +------------------------------+ 1 row in set (0.06 sec) How have people worked around this issue? What other ways can I partition by a timestamp in MariaDB ? Thanks, -Said

2 1

Re: [Maria-discuss] Contact Form: Ruslan Kutliakhmetov
by Sergei Golubchik 17 Nov '12

17 Nov '12

Hi, Ruslan! First, please use email for questions of this kind. We have a mailing list maria-discuss(a)lists.launchpad.net - it's much easier to follow the discussion there, and many more people will see your question, so you'll have a better chance of getting a fast and helpful reply. On Nov 17, Ruslan Kutliakhmetov wrote: > ------------------------------------------------ > Hi. I installed on the linux debian MarinaDB 10 for linux debian. > I watched that she doesn't installed. Log: > root @ debian :/ home / tran # apt-get install mariadb-server-5.2 mariadb-client-5.2 > Reading package lists ... Done > Building dependency tree > Reading state information ... Done > Some packages could not be installed. Perhaps you are asking the impossible, > or using the unstable distribution that some required > packages have not yet been created or been moved out of Incoming. > The following information may help you: > > The following packages have unmet dependencies: > mariadb-client-5.2: Depends: mariadb-client-core-5.2 (> = 5.2.12-mariadb115 ~ squeeze) but it is not installed > E: Broken packages > ------------------------------------------------ I don't understand what you are trying to do. Are you installing MariaDB 10.0.0 release? If yes, why do you specify "5.2" in the apt-get command line? If you want to install MariaDB 5.2.12 - why do you mention 10.0? May be, you are trying to upgrade or downgrade? Regards, Sergei

1 0

[Maria-discuss] KB Question: Drop-in replacement on Debian
by Daniel Bartholomew 17 Nov '12

17 Nov '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/drop-in-replacement-on-debian/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Is there a way to make MariaDB install over MySQL on a Debian machine? I have my puppet master, which is running Debian/sid. It has puppet-dashboard, which utilizes MySQL 5.5.28. Much to my dismay, I am unable to install MariaDB over it: - - - - - The following packages have unmet dependencies: libmariadbclient18 : Depends: libmysqlclient18 (= 5.5.28-mariadb1~wheezy) but 5.5.28+dfsg-1 is to be installed E: Unable to correct problems, you have held broken packages. - - - - - But if I try to uninstall the parts of MySQL, then apt wishes to uninstall everything, up to and including puppet-dashboard: - - - - - The following packages were automatically installed and are no longer required: dbconfig-common libaio1 libhttpclient-ruby1.8 mysql-server-core-5.5 rake ruby-dbi ruby-deprecated unzip zip Use 'apt-get autoremove' to remove them. The following packages will be REMOVED: libdbd-mysql-perl libdbd-mysql-ruby libmysqlclient18 mysql-client mysql-client-5.5 mysql-server mysql-server-5.5 puppet-dashboard ruby-dbd-mysql ruby-mysql - - - - - This is unacceptable for a live box... Is there something else I can do to make the install less painful? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart 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 Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

3 2

[Maria-discuss] mDB logs off when there are several ssh under same user
by klrumpf 15 Nov '12

15 Nov '12

4 6

[Maria-discuss] KB Question: Aria Max Table Size
by Daniel Bartholomew 14 Nov '12

14 Nov '12

The following question has been posted in the Knowledgebase: https://kb.askmonty.org/en/aria-max-table-size/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Aria looks to be a safer robust replacement to MyISAM for data warehousing. However, I was unable to find any mention of maximum table sizes for tables in various row formats. Upon creating tables and getting information in SequelPro, I saw the following: Aria Dynamic: 4GB Aria Fixed: 20GB Aria Page: 64GB This would seem counterproductive as MyISAM supports 256TB. Is there an official statistic on the maximum amount of data that Aria can handle? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart 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 Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0