[Bug 282907] New: No items are displayed when I enable 'Include Album Sub-Tree' in a folder containing one image and many folders

[e-mail robert.m.davies]

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





--- Comment #20 from Rob D <Robert M Davies blueyonder co uk>  2011-11-21 16:30:32 ---
@Giles: I'm not disputing that the crash in the backtrace above is in OpenCV.
But I'm reporting that images do not show up, which happens regardless of
whether it crashes or not.
The crash is a separate issue, and not the main point of this bug report.
Unless/until proved otherwise, I'm going to suggest that this is an unrelated
issue - the issue discussed in this thread has been happening for months.
OpenCV only crashed within the last week.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[e-mail robert.m.davies]

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





--- Comment #21 from Rob D <Robert M Davies blueyonder co uk>  2011-11-29 23:48:20 ---
Created an attachment (id=66205)
 --> (http://bugs.kde.org/attachment.cgi?id=66205)
Terminal output from video 1 (29/11/11)

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[e-mail robert.m.davies]

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





--- Comment #22 from Rob D <Robert M Davies blueyonder co uk>  2011-11-29 23:49:23 ---
Created an attachment (id=66206)
 --> (http://bugs.kde.org/attachment.cgi?id=66206)
backtrace from Video 1 (29/11/11)

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[e-mail robert.m.davies]

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





--- Comment #23 from Rob D <Robert M Davies blueyonder co uk>  2011-11-29 23:49:53 ---
Please see the video I have uploaded at http://youtu.be/mHvleOhJyHg, showing
the fault.
Attached are the output and backtrace generated in the process.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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





--- Comment #24 from Marcel Wiesweg <marcel wiesweg gmx de>  2011-11-30 16:29:34 ---
Thanks for your help. So you have three collections, 1 and 3 works with
recursive-listing, 2 does never. All child albums of collection 2 work. It
seems there is one picture in the topmost folder of collection 2.
What is displayed in the lower left corner when collection 2 fails to list?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[e-mail robert.m.davies]

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





--- Comment #25 from Rob D <Robert M Davies blueyonder co uk>  2012-01-30 03:37:03 ---
Created an attachment (id=68324)
 --> (http://bugs.kde.org/attachment.cgi?id=68324)
Perl script to make enough folders to demonstrate bug.

First and only argument = target folder in which to create 1000 subfolders.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[e-mail robert.m.davies]

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





--- Comment #26 from Rob D <Robert M Davies blueyonder co uk>  2012-01-30 03:37:55 ---
Update!!

Sorry it's taken me so long to get around to looking into this, but I finally
have the exact problem:

An album will not display if the total number of folders/subfolders below it
(and including itself) is >= 1000.

This is reproducible every time for me.
Others should be able to reproduce it by creating a folder with 1000 subfolders
(attached script may help, comments on the script are welcome too! - run with

`./makeLotsOfDirs "/path/to/testingDirectory"`

)

Place any digikam-compatible image file(s) in any subfolder(s), and add the
folder as an album in digikam. Select the album root and turn on 'Include Album
Sub-Tree'.
No images are displayed.
Delete 2 or more subfolders and refresh the digikam view...
The image(s) is/are displayed.
Try adding more subfolders again, refresh the digikam view...
No images are displayed once the total number of folders/subfolders in the
album is >= 1000.

Now, why this should happen (and why 1000, not 1024), I don't know. Anyone more
familiar with the workings of digikam care to take a guess?

Here's hoping this helps on the way to fixing it!

Rob

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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





--- Comment #27 from Marcel Wiesweg <marcel wiesweg gmx de>  2012-02-19 18:38:18 ---
Thanks for your work. A bug is so easy to fix once you can reproduce...

http://www.sqlite.org/limits.html
"To prevent excessive memory allocations, the maximum value of a host parameter
number is SQLITE_MAX_VARIABLE_NUMBER, which defaults to 999."

As you may guess, we give each album as a host parameter.
Apparently, SQLite imposes us this limit, at least here MySQL would allow more:
http://stackoverflow.com/questions/6581573/what-are-the-max-number-of-allowable-parameters-per-database-provider-type

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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


Marcel Wiesweg <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |FIXED




--- Comment #28 from Marcel Wiesweg <marcel wiesweg gmx de>  2012-02-19 21:29:30 ---
Git commit e359e0c2c3886b7c90165f2eb4b6e4fafb9a7536 by Marcel Wiesweg.
Committed on 19/02/2012 at 22:26.
Pushed by mwiesweg into branch 'master'.

When listing albums recursively, we may exceed the maximum number of bound
parameters.
Split the query in this case

M  +2    -1    NEWS
M  +17   -5    libs/database/imagelister.cpp

http://commits.kde.org/digikam/e359e0c2c3886b7c90165f2eb4b6e4fafb9a7536

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[e-mail robert.m.davies]

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

--- Comment #29 from Rob D <[hidden email]> ---
Just wanted to confirm the fix works with my collection, which previously
didn't display.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |2.6.0

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|AlbumsView                  |AlbumsView-Tree

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