Bug 1003410 - Server cursor is broken with blobs in the select list, ORDER BY does not work
Summary: Server cursor is broken with blobs in the select list, ORDER BY does not work
Alias: None
Product: Fedora
Classification: Fedora
Component: mariadb
Version: 19
Hardware: x86_64
OS: Linux
Target Milestone: ---
Assignee: Honza Horak
QA Contact: Fedora Extras Quality Assurance
Depends On:
TreeView+ depends on / blocked
Reported: 2013-09-01 23:25 UTC by Harald Reindl
Modified: 2013-11-10 07:43 UTC (History)
1 user (show)

Fixed In Version: mariadb-5.5.33a-2.fc20
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2013-11-10 07:43:30 UTC

Attachments (Terms of Use)

Description Harald Reindl 2013-09-01 23:25:58 UTC
-------- Original-Nachricht --------
Betreff: Fwd: [Dbmail] MariaDB and dbmail
Datum: Sun, 01 Sep 2013 23:37:13 +0200
Von: Reindl Harald <h.reindl@thelounge.net>
An: Mailing-List dbmail <dbmail@dbmail.org>,  Mailing-List mariadb <"maria-discuss"@lists.launchpad.net>

please can someone from the MariaDB developers
MariaDB 5.5.32 is running here on test-machines

this is todays feedback of the dbmail core-developer and beause
more and more distributions including Fedora/OpenSuSE and AFAIK
even RHEL7 switch to MariaDB this is a *serious* problem which is
not what a "drop-in replacement" should do and a show-stopper
rollout Fedora 19 at all in the near future

> Anyway, MariaDB doesn't even pass the basic unit-tests
> Looks like this maybe libzdb related. The ordering of the query
> retrieving mime parts is ok on the console, but *not* when looping
> over the result in libzdb.
> MariaDB is *no-go* at this moment. Just what I experienced a year
> ago or so. I'm sorry, but I don't think I'll hold 3.1.4 for that
> not a regression at all.

-------- Original-Nachricht --------
Betreff: Re: [Dbmail] MariaDB and dbmail
Datum: Tue, 02 Apr 2013 19:47:15 +0400
Von: Sergej Pupykin <ml@sergej.pp.ru>
An: DBMail mailinglist <dbmail@dbmail.org>

At Thu, 20 Sep 2012 10:46:52 +0800,
zamri <myzamri@gmail.com> wrote:
> MariaDB is fully compatible with MySQL. Migration is done. So far so good. Phewww!...
> Now I need to do some research on tuning mariadb if needed.

I found that after migration following SQL returns wrong sorted data:

    dbmail_mimeparts p
JOIN dbmail_partlists l ON p.id = l.part_id
JOIN dbmail_physmessage ph ON ph.id = l.physmessage_id
WHERE l.physmessage_id = <ID>
ORDER BY l.part_key,l.part_order ASC;

however when I run it from command line it works well.

Probably it does not fail always because of not all emails damaged.

Not sure if it caused by migration to mariadb, but problem appeared
near same time

Comment 1 Harald Reindl 2013-09-02 13:17:59 UTC

Comment 2 Honza Horak 2013-09-02 14:04:33 UTC
Thanks for getting this visible in Fedora, I'll keep an eye on the upstream bug report.

Comment 3 Harald Reindl 2013-09-06 13:32:37 UTC
looks like upstream has cooked a fix while i am unable to locate it currently for testing - maybe the fedora packager is more firm with the MariaDB upstream sources


Comment 4 Honza Horak 2013-09-10 12:38:55 UTC
Right, the patch is here:

However, I believe the new upstream release is going to be released very soon, so I'd rather wait for mariadb-5.5.33, where this issue will be fixed.

Comment 5 Harald Reindl 2013-09-17 19:49:22 UTC
MariaDB 5.5.33 is out!

this bug is now finally confirmed as fixedwith my dbmail-tests
hopefully it was the only one failing dbmail-requirements

something is changed in the location of docdir-files with 5.5.33
useless to provide my SPEC changes because I#m far form Fedora packaging

however, it builds, it works, it's fine AFAIK


The MariaDB project is pleased to announce the immediate availability
of MariaDB 5.5.33.

This release features the addition of TokuDB as an additional storage
engine option. There are also bug and other fixes. See the Release
Notes and Changelog for details.

MariaDB 5.5.33 Stable (GA)
 - Release Notes: https://mariadb.com/kb/en/mariadb-5533-release-notes
 - Changelog: https://mariadb.com/kb/en/mariadb-5533-changelog
 - Downloads: https://downloads.mariadb.org/mariadb/5.5.33

Comment 6 Harald Reindl 2013-09-18 17:45:10 UTC
BTW if you update Fedora to 5.5.33 be aware it bundles jemalloc
with these two switches you can use the system-library
with only the first one you disable jemalloc at all

 -DLIBJEMALLOC=jemalloc \

after i cried out loud on the mailing-list with 5.5.34 we get
-DWITH_JEMALLOC=system supported, the reason for the outdated
bundeled version has a context to TokuDB, no idea what fedora 
does in that case

our companies builds will use -DWITHOUT_DYNAMIC_PLUGINS=ON
and so TokuDB doe snot matter at all for me

Comment 7 Harald Reindl 2013-09-20 09:10:26 UTC
wait a moment for 5.5.33a :-)

> I've begun the prep for the special 5.5.33a release.
> Draft changelog and release notes are here:
> https://mariadb.com/kb/en/mariadb-5533a-changelog/
> https://mariadb.com/kb/en/mariadb-5533a-release-notes/

cmake -DWITH_JEMALLOC=system

Comment 8 Harald Reindl 2013-09-20 18:27:34 UTC
-------- Original-Nachricht --------
Betreff: [Maria-discuss] MariaDB 5.5.33a Now Available
Datum: Fri, 20 Sep 2013 12:52:42 -0400
Von: Daniel Bartholomew <dbart@mariadb.com>
An: maria-discuss <maria-discuss@lists.launchpad.net>

The MariaDB project is pleased to announce the immediate availability
of MariaDB 5.5.33a.

This is a special bug-fix release to address some packaging and other
bugs present in the recent MariaDB 5.5.33 release. See the release notes
and changelog for details.

- - Links  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

MariaDB 5.5.33a Stable (GA)
 - Release Notes: https://mariadb.com/kb/en/mariadb-5533a-release-notes
 - Changelog: https://mariadb.com/kb/en/mariadb-5533a-changelog
 - Downloads: https://downloads.mariadb.org/mariadb/5.5.33a

Comment 9 Fedora Update System 2013-10-14 18:25:35 UTC
mariadb-5.5.33a-2.fc20 has been submitted as an update for Fedora 20.

Comment 10 Fedora Update System 2013-10-15 06:36:07 UTC
Package mariadb-5.5.33a-2.fc20:
* should fix your issue,
* was pushed to the Fedora 20 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing mariadb-5.5.33a-2.fc20'
as soon as you are able to.
Please go to the following url:
then log in and leave karma (feedback).

Comment 11 Fedora Update System 2013-11-10 07:43:30 UTC
mariadb-5.5.33a-2.fc20 has been pushed to the Fedora 20 stable repository.  If problems still persist, please make note of it in this bug report.

Note You need to log in before you can comment on or make changes to this bug.