Bug 375346

I am already seeing that some tags coming back properly e.g. /Activities/ snowboarding but some of them showing up in the root not in the group e.g. /snowboarding instead of /Activities/ snowboarding

I never seen this dysfunction before (can you imagine)...

Which kind of database type do you use ?

Gilles Caulier

MySQL MariaDB downloaded using the link digiKam provides

So A mysql server, not Mysql internal. Right ?

Can you try with a fresh database using sqlite instead, to see if problem is reproducible ?

Gilles Caulier

(In reply to caulier.gilles from comment #4)
> So A mysql server, not Mysql internal. Right ?
> 
> Can you try with a fresh database using sqlite instead, to see if problem is
> reproducible ?
> 
> Gilles Caulier

Everything seems to work fine after switching to sqlite. I will keep you posted if it pops up again though.

new 5.6.0 pre-release as bundle is available here :

https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM

Please check if this problem still reproducible with these versions.

Thanks in advance

Gilles Caulier

(In reply to caulier.gilles from comment #6)
> new 5.6.0 pre-release as bundle is available here :
> 
> https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM
> 
> Please check if this problem still reproducible with these versions.
> 
> Thanks in advance
> 
> Gilles Caulier

It never happened again since I switched back to SQLite. You probably were correct, it was a mySQL related issue.

digiKam 5.6.0 is now released and available as bundle for Linux, MacOS and Windows.

https://www.digikam.org/news/2017-06-21-5.6.0-release-announcement/

Can you check if problem still exists with this version ?

Thanks in advance

Gilles Caulier

New digiKam 5.7.0 are built with current implementation as pre-release bundles:

https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM

Problem still reproducible ?

(In reply to caulier.gilles from comment #9)
> New digiKam 5.7.0 are built with current implementation as pre-release
> bundles:
> 
> https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM
> 
> Problem still reproducible ?

Not sure I want to check this. I switched back to sqlite and never seen the issue happen again

I've hit this problem yesterday, after database migration from SQLite to MySQL external.
The migration went fine, but after changing tags to some images and moving tags from one parent to another I saw Digikam doing something strange (tags in tags manager were not updated correctly). Closed and restarted Digikam, all tags disappeared.

Probably related to bug 383326? There's also bug 383563 which seems a duplicate of this one.

I'm switched back to SQLite, will retry as soon 5.7 will be available in Fedora repositories.

Git commit 74ea34d9fa0247a91c341ee99e6f001caa8020c3 by Maik Qualmann.
Committed on 10/11/2017 at 18:35.
Pushed by mqualmann into branch 'master'.

fix updating lft/rgt columns in the Tags table with MySQL
Related: bug 386606
FIXED-IN: 5.8.0

M  +0    -11   app/dragdrop/tagdragdrop.cpp
M  +26   -10   data/database/dbconfig.xml.cmake.in
M  +10   -12   libs/database/coredb/coredb.cpp
M  +0    -7    libs/database/coredb/coredb.h

https://commits.kde.org/digikam/74ea34d9fa0247a91c341ee99e6f001caa8020c3

This bug occurred to me in digikam-5.8.0-20171119094605-x86-64.appimage

I removed an unused Tag tree from the Tag Manager and digikam crashed.  After re-opening digikam some other unrelated Tag trees were completely missing from the tags list.

SQLite or MySQL?

Maik

(In reply to Maik Qualmann from comment #14)
> SQLite or MySQL?
> 
> Maik

external MySQL 5.7

Git commit 5bd6f2fddfe1ab585a67cb3c54a81b4d6c079693 by Maik Qualmann.
Committed on 20/11/2017 at 19:20.
Pushed by mqualmann into branch 'master'.

fix deleting tag or tag tree for MySQL

M  +5    -6    data/database/dbconfig.xml.cmake.in

https://commits.kde.org/digikam/5bd6f2fddfe1ab585a67cb3c54a81b4d6c079693

I inspected the Tags table before and after the crash and the cause of the loss of tags may be related to corrupt lft/rgt fields (related Bug #383326)

Hi, I posted an issue 2 months ago and them missed Igor's request that I'll post here. So I'm posting now in case it would help (as it seems from the comments that the issue is not yet fixed).

--

After upgrading to 5.7 the Tags/People trees are empty.
(*) Since I haven't used the app in a while, I can't tell if this is a
direct result of the upgrade or not.

I rolled back to 5.6 and the behavior persisted so I re-installed 5.7.

I already lost all tagging once in v5.6 and had to re-tag everything. This
time I first took a look at the database and noticed that all the data is
there, well organized in the various tables.

So I dug deeper into the website and found how to get a dump of the trace
messages (DbgView.exe as I'm running on Windows), and then found the
following suspicious lines:

[18488] digikam.general: Failed to find parent tag for tag
"_Digikam_Internal_Tags_"  with pid  -1
[18488] digikam.general: Failed to find parent tag for tag  "People"  with
pid  -1

Took a look at the tags table, and assuming pid = parent id and assuming
only _Digikam_root_tag_ = 0, I modified the above error tags' pid to 0
(_Digikam_root_tag_).

This fixed my issue and tags got back to normal.

Oops.. sorry, I meant to write "Andrey's request".

Please test with digital 5.8.0 pre release app image bundle instead native package
Gilles caulier

5.8.0 bundles are here
https://files.kde.org/digikam/

This issue is definitely fixed in digiKam-5.8.0. Another thing is a possibly broken tag table. With digiKam-5.8.0 an export to SQLite and re-import to MySQL is possible to fix the table again. I close this bug again.

Maik