do you have some data to test? 2013/9/1 Roberto Spadim <robe...@spadim.com.br>: > well.. provide create tables like: > SHOW CREATE TABLE dbmail_mimeparts; > SHOW CREATE TABLE dbmail_partlists; > SHOW CREATE TABLE dbmail_physmessage; > > > > 2013/9/1 Reindl Harald <h.rei...@thelounge.net> >> >> 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. >> > > > > -- > Roberto Spadim > SPAEmpresarial
-- Roberto Spadim SPAEmpresarial _______________________________________________ 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
