[Digikam-devel] [Bug 233222] Thumbnails displayed are from incorrect images

bugreports at familie-becker.eu bugreports at familie-becker.eu
Tue May 18 19:06:13 BST 2010


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





--- Comment #18 from  <bugreports familie-becker eu>  2010-05-18 20:06:08 ---
Some updates:

Thumbnail has changed since yesterday, although I've got no idea how or why.
The new thumb comes from a pic with correct information, contrary to my
"general regard 2" from post #16.

SQL:
select * from Images where name="B";
24661|704|20100304-113715.jpg|1|1|2010-04-11T23:49:42|0|

select * from Images where name="C"; (some other broken pic)
24665|704|20100304-115802.jpg|1|1|2010-04-11T23:49:43|0|

select * from Images where name="A"; (where the thumb comes from this time)
24651|704|20100304-110423.jpg|1|1|2010-05-17T22:22:08|548506|8561f30172a715a01944648ba6c101b3

select * from Images where name="X"; (general regard 4 from #16, correct thumb,
wrong information)
24649|704|20100304-105855.jpg|1|1|2010-04-11T23:49:38|8192|3442640930948d35e69223cd4ed15e4a

select * from ImageInformation where imageid=24661; (B)
24661|-1|2010-03-04T11:37:15|2010-03-04T11:37:15|1|0|0|JPG|0|0

select * from ImageMetadata WHERE imageid=24661;
24661|Canon|Canon DIGITAL IXUS 70|5.8 - 17.4
mm|4.9|17.4||0.0166666666666667||0|200|24|0||5||


So, obviously, the file size is 0 for the broken pics, and no "unique" hash
exists. For picture X there's a wrong entry in the DB regarding file size.

Perhaps some kind of racing condition? I did not download these pics with
digikam, but just copied them into my album directory and started up digikam.
When downloading with Digikam, i presume the program will process all new pics
sequentially, as copying over usb is (comparatively) slow. Perhaps its sth.
else when digikam starts up and finds a bunch of new subdirectories with
pictures, parallel processing, problems with database access?

select * from Images where fileSize=0;
24119||20090911-165411.JPG|3|1|2010-04-11T23:47:11|0|
24143||20090922-181612.JPG|3|1|2010-04-11T23:47:27|0|
24169||20090922-191348.JPG|3|1|2010-04-11T23:47:37|0|
24200||20090923-182640.JPG|3|1|2010-04-11T23:47:47|0|
24236||20090928-121616.JPG|3|1|2010-04-11T23:47:59|0|
24240||20090928-121918.JPG|3|1|2010-04-11T23:48:00|0|
24243||20090928-140727.JPG|3|1|2010-04-11T23:48:01|0|
24267||20090928-195526.JPG|3|1|2010-04-11T23:48:10|0|
24268||20090928-195531.JPG|3|1|2010-04-11T23:48:10|0|
24276||20091003-201834.JPG|3|1|2010-04-11T23:48:16|0|
24277||20091003-201842.JPG|3|1|2010-04-11T23:48:16|0|
24500||20100410-202025.JPG|3|1|2010-04-11T23:49:55|0|
24512|688|20091025-140101.jpg|1|1|2010-04-11T23:48:35|0|
24518|688|20091025-141745.jpg|1|1|2010-04-11T23:48:39|0|
24522|688|20091025-142518.jpg|1|1|2010-04-11T23:48:42|0|
24523|688|20091025-142529.jpg|1|1|2010-04-11T23:48:43|0|
24525|688|20091025-143020.jpg|1|1|2010-04-11T23:48:44|0|
24526|688|20091025-143218.jpg|1|1|2010-04-11T23:48:45|0|
24528|688|20091025-143948.jpg|1|1|2010-04-11T23:48:46|0|
24529|688|20091025-144738.jpg|1|1|2010-04-11T23:48:47|0|
24535|688|20091025-150629.jpg|1|1|2010-04-11T23:48:51|0|
24537|688|20091025-150706.jpg|1|1|2010-04-11T23:48:52|0|
24540|688|20091025-150740.jpg|1|1|2010-04-11T23:48:54|0|
24541|688|20091025-151116.jpg|1|1|2010-04-11T23:48:55|0|
24543|688|20091025-151914.jpg|1|1|2010-04-11T23:48:56|0|
24558|691|20091110-205447.jpg|1|1|2010-04-11T23:49:06|0|
24559|691|20091110-205554.jpg|1|1|2010-04-11T23:49:07|0|
24561|691|20091110-205747.jpg|1|1|2010-04-11T23:49:08|0|
24562|691|20091110-205821.jpg|1|1|2010-04-11T23:49:09|0|
24577|692|20091120-200141.jpg|1|1|2010-04-11T23:49:14|0|
24624|698|20091229-133409.jpg|1|1|2010-04-11T23:49:29|0|
24661|704|20100304-113715.jpg|1|1|2010-04-11T23:49:42|0|
24665|704|20100304-115802.jpg|1|1|2010-04-11T23:49:43|0|
24685|704|20100304-153125.jpg|1|1|2010-04-11T23:49:49|0|
24687|704|20100304-165143.jpg|1|1|2010-04-11T23:49:50|0|


select * from Images where fileSize > 0 and fileSize < 9000;
[deleted some pics with correct entries from here]
24117||20090911-165217.JPG|3|1|2010-04-11T23:47:10|8192|ff73e503e5887c4f600027d7a319913a
24120||20090911-165759.JPG|3|1|2010-04-11T23:47:12|8192|11a69b1d6e9e7c08f19b1d61d1a952e6
24146||20090922-182909.JPG|3|1|2010-04-11T23:47:29|8192|cba61275a9623f9ca52bf4cdd4a5c922
24161||20090922-191153.JPG|3|1|2010-04-11T23:47:34|8192|14ab02155ffc5a0753a57775a635d7e0
24164||20090922-191212.JPG|3|1|2010-04-11T23:47:35|8192|26275c250a9fa50db538ee2842ae460c
24179||20090923-092642.JPG|3|1|2010-04-11T23:47:40|8192|c9f8439bfa63da8077aa9848285e69d6
24226||20090928-111127.JPG|3|1|2010-04-11T23:47:55|8192|5c8e456340d83a4e689c420c04ac227c
24230||20090928-113638.JPG|3|1|2010-04-11T23:47:57|8192|9948dae3452562adca1fc6fbbf672225
24233||20090928-121542.JPG|3|1|2010-04-11T23:47:58|8192|9e4a05418ecb92ae3204832f94d578df
24257||20090928-163009.JPG|3|1|2010-04-11T23:48:06|8192|83005354bec8996c52f6eea27264d010
24282||20091021-205151.JPG|3|1|2010-04-11T23:48:19|8192|3baea9d45b3863f94f016044aaec61b1
24283||20091021-205200.JPG|3|1|2010-04-11T23:48:20|8192|fb7cf043754d9b99f0f8edad088686d8
24285||20091021-205233.JPG|3|1|2010-04-11T23:48:21|8192|5f9c385443e9890ac864fab3ce0d38c4
24286||20091021-205240.JPG|3|1|2010-04-11T23:48:22|8192|e28b2f8d0c990e533d6137fab8c3a79e
24288||20091021-205254.JPG|3|1|2010-04-11T23:48:23|8192|358afc84f7ddf34887643ac2d2f2d971
24289||20091021-205410.JPG|3|1|2010-04-11T23:48:24|8192|3ffb1a48082586401bb7f25ebe2758a8
24291||20091021-210739.JPG|3|1|2010-04-11T23:48:25|8192|d86eeefb5e8e5819532a527e7bbe85c8
24292||20091021-210756.JPG|3|1|2010-04-11T23:48:26|8192|2d2024c406d4bb4226e97fa64b3bc1b9
24294||20091021-211059.JPG|3|1|2010-04-11T23:48:27|8192|157b55b4ce4f00def01458d0aa642598
24295||20091021-211206.JPG|3|1|2010-04-11T23:48:28|8192|c54a66b25bdedf9473a8a5c76d9e2fda
24297||20091021-211626.JPG|3|1|2010-04-11T23:48:29|8192|e207486ed8a6028e1eed746362130594
24298||20091021-211633.JPG|3|1|2010-04-11T23:48:30|8192|507c5b2408644cbdb3cc10dd810dcb5c
24300||20091021-211752.JPG|3|1|2010-04-11T23:48:31|8192|d48e5cb1c20f0bdcb4c2dfa6674fb8e5
24301||20091021-211800.JPG|3|1|2010-04-11T23:48:32|8192|3b2add3b512df1aa81a900e9f0159cf4
24486||20100410-140444.JPG|3|1|2010-04-11T23:49:51|8192|9fd3feae01c6c1010b23982e995426d3
24505||20100410-213546.JPG|3|1|2010-04-11T23:49:57|8192|014e4bc26324aae6d16ed4caf81dd736
24509|688|20091025-135348.jpg|1|1|2010-04-11T23:48:33|8192|427bf61ce4831534b746638bcb61ffc4
24510|688|20091025-140046.jpg|1|1|2010-04-11T23:48:34|8192|106a4d5b2755288861349cfba97dd922
24513|688|20091025-140121.jpg|1|1|2010-04-11T23:48:36|8192|960f7b459af6b1bd5bf1231ec6c82c8a
24516|688|20091025-141023.jpg|1|1|2010-04-11T23:48:38|8192|6c82b5c1ce9abf8fc8996f7ea62a8b39
24519|688|20091025-141839.jpg|1|1|2010-04-11T23:48:40|8192|5bd92437de2d3a0d82b420ec1e19035b
24520|688|20091025-141844.jpg|1|1|2010-04-11T23:48:41|8192|f81e0e0d4237216b8d9179f2671675c7
24531|688|20091025-145555.jpg|1|1|2010-04-11T23:48:48|8192|db30a57b9f686ca66a99df0daf6b1ed6
24532|688|20091025-150356.jpg|1|1|2010-04-11T23:48:49|8192|bf4c010b63b18c7f554fa22b3cd8ec9f
24533|688|20091025-150406.jpg|1|1|2010-04-11T23:48:50|8192|dfbe107451ca37b6d45970e29d398e96
24538|688|20091025-150716.jpg|1|1|2010-04-11T23:48:53|8192|2f87e5f1b2fc7913e77c145fc7917638
24545|688|20091025-151927.jpg|1|1|2010-04-11T23:48:57|8192|fccc99e92e588b8a83bd6eb358f185af
24546|688|20091025-151932.jpg|1|1|2010-04-11T23:48:58|8192|2c1d770230df10c03703b8a30b3a9dd2
24552|690|20091031-141332.jpg|1|1|2010-04-11T23:49:02|8192|aba28a504a27f304b80997fb602f3502
24553|690|20091031-141337.jpg|1|1|2010-04-11T23:49:03|8192|7c46cc3d870da85310240fad59bebf22
24594|694|20091128-234019.jpg|1|1|2010-04-11T23:49:19|8192|96eb3a89f245434edd340b6186b72dba
24617|696|20091220-153227.jpg|1|1|2010-04-11T23:49:27|8192|6262cff4650f075f40db8afef5867045
24620|696|20091220-153309.jpg|1|1|2010-04-11T23:49:28|8192|8208937fae66876f7471f672aecd8932
24649|704|20100304-105855.jpg|1|1|2010-04-11T23:49:38|8192|3442640930948d35e69223cd4ed15e4a
24659|704|20100304-112916.jpg|1|1|2010-04-11T23:49:41|8192|7567fb0379a04f45d7235bd6b0adb32d

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Digikam-devel mailing list