maria-discuss team mailing list archive

["Reindl Harald (mobile)" <h.reindl@xxxxxxxxxxxxx>]

As said in my initial post 5.5.32 and if you read the whole post you see also that this exists very long 

*please* read my whole initial post - I *can not* send test data because it is *not* reproduceable in a terminal so how should I as ordinary user verify that whatever I send is qualified to prove the problem - so please do not insist that I should provide the test data because with the queries from my initial post and some lines code using libzdb this should be easy to verify - as php developer I can not provide it 

mail's with multiple mime parts are broken and reconstructed in the wrong order and so destroyed - so install dbmail and send such test mail's - you not "maybe" have a order by problem you *have* have one which wasted a lot of hours to debug a mailserver because a software claiming to be a drop-in replacement is broken - and I would not be that angry if I had not tried to bring MariaDB upstream to the problem a other user reported months ago and nobody cared 


-------- Ursprüngliche Nachricht --------
Von: Roberto Spadim <roberto@xxxxxxxxxxxxx>
Gesendet: Mon Sep 02 06:28:48 MESZ 2013
An: Reindl Harald <h.reindl@xxxxxxxxxxxxx>
CC: Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>, Mailing-List dbmail <dbmail@xxxxxxxxxx>
Betreff: Re: [Maria-discuss] Fwd: [Dbmail] MariaDB and dbmail

please send the mariadb version too

2013/9/2 Roberto Spadim <roberto@xxxxxxxxxxxxx>:
> please Reindl provide some data to test,
> i found some information, we can add a bug at jira (bug tracker) of
> mariadb and solve this problem... (if it exists...)
>
> here one report from archlinux guys similar to your report, maybe we
> (mariadb) have a problem with order by (?)
> https://mailman.archlinux.org/pipermail/arch-general/2013-April/033282.html
>
> here the create tables:
> --------------------------------------------------------
> CREATE TABLE IF NOT EXISTS `dbmail_mimeparts` (
>   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
>   `hash` char(128) NOT NULL,
>   `data` longblob NOT NULL,
>   `size` bigint(20) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`id`),
>   KEY `hash` (`hash`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
> ---
> CREATE TABLE IF NOT EXISTS `dbmail_partlists` (
>   `physmessage_id` bigint(20) unsigned NOT NULL DEFAULT '0',
>   `is_header` tinyint(1) NOT NULL DEFAULT '0',
>   `part_key` smallint(6) NOT NULL DEFAULT '0',
>   `part_depth` smallint(6) NOT NULL DEFAULT '0',
>   `part_order` smallint(6) NOT NULL DEFAULT '0',
>   `part_id` bigint(20) unsigned NOT NULL DEFAULT '0',
>   UNIQUE KEY `message_parts`
> (`physmessage_id`,`part_key`,`part_depth`,`part_order`),
>   KEY `physmessage_id` (`physmessage_id`),
>   KEY `part_id` (`part_id`),
>   CONSTRAINT `dbmail_partlists_ibfk_1` FOREIGN KEY (`physmessage_id`)
> REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE
> CASCADE,
>   CONSTRAINT `dbmail_partlists_ibfk_2` FOREIGN KEY (`part_id`)
> REFERENCES `dbmail_mimeparts` (`id`) ON DELETE CASCADE ON UPDATE
> CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
> ---
> CREATE TABLE IF NOT EXISTS `dbmail_physmessage` (
>   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
>   `messagesize` bigint(20) unsigned NOT NULL DEFAULT '0',
>   `rfcsize` bigint(20) unsigned NOT NULL DEFAULT '0',
>   `internal_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
>   PRIMARY KEY (`id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
> ---





--

Reindl Harald (mobile)
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / CISO / Software-Development
+43 (676) 40 221 40
http://www.thelounge.net