maria-discuss team mailing list archive
Mailing list archive
Re: Fwd: [Dbmail] MariaDB and dbmail
Mailing-List mariadb <"maria-discuss"@lists.launchpad.net>, Mailing-List dbmail <dbmail@xxxxxxxxxx>
Reindl Harald <h.reindl@xxxxxxxxxxxxx>
Mon, 02 Sep 2013 01:02:33 +0200
the lounge interactive design
Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130805 Thunderbird/17.0.8
if it would be that easy
i am only a guy try to help dbmail and not that good in data details and how
to reproduce a valid test set, al i can say is that it wasted a lot
of hours to figure out why the machines of the dbmail-developer are
beahve differently in case of nsetd mime-messages and that it is
caused by MariaDB afetr that i searched my archive for the mail below
AFAIK i even tried to bring MariaDB/DBMail community together months ago
*please* some MariaDB developers could you connect to dbmail/libzdb
to sort out this problem because from the original post below and the feedback
of dbmail-developer the query is correct with the terminal client
so something goes wrong in combination with libzdb
IMHO this *must not* happen if MariaDB claims to be a drop-in-replacemnet
Am 02.09.2013 00:44, schrieb Roberto Spadim:
> Could you send some data to test?
> Em 01/09/2013 18:37, "Reindl Harald" <h.reindl@xxxxxxxxxxxxx <mailto:h.reindl@xxxxxxxxxxxxx>> escreveu:
> 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@xxxxxxxxxxxx <mailto:ml@xxxxxxxxxxxx>>
> An: DBMail mailinglist <dbmail@xxxxxxxxxx <mailto:dbmail@xxxxxxxxxx>>
> At Thu, 20 Sep 2012 10:46:52 +0800,
> zamri <myzamri@xxxxxxxxx <mailto:myzamri@xxxxxxxxx>> 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 <http://p.id> = l.part_id
> JOIN dbmail_physmessage ph ON ph.id <http://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.
Description: OpenPGP digital signature