[Digikam-devel] [digikam] [Bug 337737] MySQL : Settings and installation windows freeze when valid mariadb/mysql db connection is available

[Christian]

https://bugs.kde.org/show_bug.cgi?id=337737

Christian <buitk14 at A1.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|4.1.0                       |4.2.0

--- Comment #10 from Christian <buitk14 at A1.net> ---
(In reply to Gilles Caulier from comment #9) 
..
> Perhaps the distro switch from MySQL to MariaDB has introduced some side
> effects...
> 
> Gilles Caulier

Yes, I have similar experience with openSuse 11.x + digikam 3.2: there was no
freeze. With openSuse 12.x + digikam 3.5 the freeze started (I did not
recognize the bug that time. thought its just a crash).

With openSuse 12.x mysql was replaced by mariadb. The maria db core is almost
identical with mysql server. There were no issues in my java and php projects. 

Possible reasons:
- It might be related to some specific queries that were optimized for old
mysql tables or system tables.
- Latest maria and mysql packages have different default settings compared to
the ones a couple of years ago, e.g. inno-db tables (no isam), different
tablespaces, worker and memory settings and improved security model.
- mix of old qt4 libs and new mysql libs to access the db - hopefully it is not
something like this

I will invest a little time next week to log what is going on in the db before
the freeze occurs.

Christian

-- 
You are receiving this mail because:
You are the assignee for the bug.