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.rei...@thelounge.net > <mailto:h.rei...@thelounge.net>> 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 <m...@sergej.pp.ru <mailto:m...@sergej.pp.ru>> > An: DBMail mailinglist <dbm...@dbmail.org <mailto:dbm...@dbmail.org>> > > At Thu, 20 Sep 2012 10:46:52 +0800, > zamri <myza...@gmail.com <mailto:myza...@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: > > SELECT > l.part_key, > l.part_depth, > l.part_order, > l.is_header, > DATE_FORMAT(ph.internal_date,GET_FORMAT(DATETIME,'ISO')), > data > FROM > 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.
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
