[digikam] [Bug 367853] Digikam hangs on 'Reading database' when stumbling across MacOS' Photos Library of a huge size (>20GB)

[Lars Van Casteren via KDE Bugzilla]

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

--- Comment #7 from Lars Van Casteren <larsvancasteren at gmail.com> ---
I got it up & running with some major trickery using MariaDB 10.1.14  (lots of
manual config stuff & creating mysql. innoDB tables etc before DK would
continue) but in the end I get the same result when adding $HOME/Pictures
collection where the Photos library is located. 
The scan hangs at the same 43% in DK frontend using the local MariaDB. Exactly
the same behaviour like SQLite.

MariaDB [(none)]> select count(*) from digikam.albums;
+----------+
| count(*) |
+----------+
|   106600 |
+----------+
1 row in set (0.02 sec)

106600 seemed like a strange round number to me for the amount of subfolder but
it checks out, $find . -type d | wc -l returns 106600 subfolders.

Another test I did was to create a large number of directories in a collection
to see what would happen.
*note: it might take a minute or 3 to create the 110000 subdirs...

$for ((i=1;i<=110000;i++)); do mkdir-p testdir/$i; done

I ran a clean DK instance with SQLite and point to testdir as a collection so
it would scan it and add the albums. 
Same problem applies. It starts scanning but it hangs after a while and doesn't
seem to generate the (huge) tree although it’s just a single tree without
subfolders or images. 

Rgds,
Lars

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