maria-discuss team mailing list archive

[Sergei Petrunia <psergey@xxxxxxxxxxxx>]

Hello,

On Wed, Apr 03, 2013 at 12:15:53PM +0200, Reindl Harald wrote:
> 
> Am 03.04.2013 11:09, schrieb Sergej Pupykin:
> > At Tue, 02 Apr 2013 19:47:15 +0400,
> > Sergej Pupykin <ml@xxxxxxxxxxxx> wrote:
> >> Not sure if it caused by migration to mariadb, but problem appeared
> >> near same time.
> > 
> > Downgrading back from mariadb 5.5.30 to mysql 5.5.30 solves the
> > problem. It looks like mariadb has ordering problems or it is not
> > drop-in replacement of mysql
> 
> i am CC'ing this to the MariaDB list..........
> 
> but "however when I run it from command line it works well" speaks
> against it - this is highly interesting since more and more
> distributions are switching to MariaDB including Fedora and i am
> at preparing the switch too with no problems until now
> _____________________________
> 
> zamri <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:
> 
> 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 = 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.

If something isn't working in MariaDB, we would like to fix it.  I am not aware
of any intended changes that would cause MariaDB to handle ORDER BY differently
than MySQL does.

Could you please tell, what exactly is wrong with the results you're getting? 
Is it the right data, but in the wrong order, or the data itself is also wrong?

You mention
> however when I run it from command line it works well.

How is it run not from commandline? (sorry if this question is trivial, but
I'm not familiar with the dbmail codebase). 

What version of dbmail are you using? Is your table definition for table
dbmail_partlists the same as in dbmail-3.0.2, file sql/mysql/create_tables.mysql ?

Getting to know the above could help us to resolve the problem.

BR
 Sergei
-- 
Sergei Petrunia, Software Developer
Monty Program AB, http://askmonty.org
Blog: http://s.petrunia.net/blog