crashes when using foreign database

Andreas Schleth <schleth_es-S0/[email protected]> Tue, 25 May 2021 14:54:32 +0200
Newsgroups gmane.comp.kde.kimdaba
Message-ID <[email protected]>
This is a multi-part message in MIME format.
--------------8D1FE1145695342FDCD40BFC
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi,

since a few iterations of the current git master I expericence crashes
when some files in the .thumbnails (or .videothumbnails) folders have
the wrong owner or strange permissions.

This mix of owners happens quite often here, as we share our KPA
databases via NFS. So if someone imports some new images into the family
album, the new thumbnails (and images) will belong to her.

The images have rw-r--r-- ownership by default (?), so they are readable
by all (we share the same group). I have manually set the .-folders to
rwxrwxr-x, so that anybody in the users group can write.

It seems to me that KPA tries to recreate all thumbnails if the
ownership of some of these files do not match the current owner. Then it
will invariably hit some files with the orignal rw-r--r-- settings and
crash.

a) Why does KPA start rebuilding the thumbnails in first place? The
rebuild starts each time somebody else accesses the DB. It should just
take the thumbnails that are present and live with them.

b) Could we not define somewhere in the settings, how we want the
permissions to be? Right now the permissions seem to be set by some
system dependent magic.

c) I know, that the thumbnail-size is set in the .config/kphotoalbumrc -
probably differently for each user.


Alas, I did some more testing (all on a DB not owned by me) permission
changes done as root, KPA used as myself:

1. set all permissions in .thumbnails to rw-rw-r--

2. open the foreign DB.

3. ./thumbnails/thumbnailindex gets recreated by me. (why?)

4. close the DB

6. change owner back to the original: beate:users

7. change permissions to rw-r--r--:

wshome5:/home/beate/Handy-Bilder # ll .thumbnails/
insgesamt 41650
-rw-r--r-- 1 beate users 33556331 25. Mai 11:13 thumb-0
-rw-r--r-- 1 beate users=C2=A0 9156333 12. Okt 2020=C2=A0 thumb-1
-rw-r--r-- 1 beate users=C2=A0=C2=A0 310330 25. Mai 11:14 thumbnailindex

 =C2=A0=C2=A0=C2=A0 (I was having a break inbetween)

8. open the DB again as myself and do some minor adjustments (rotate a
few images): The thumbnails vanish (as the files are not writable by me)

9. close the DB again and look at the folder:

wshome5:/home/beate/Handy-Bilder # ll .thumbnails/
insgesamt 41650
-rw-r--r-- 1 beate users 33556331 25. Mai 11:13 thumb-0
-rw-r--r-- 1 beate users=C2=A0 9156333 12. Okt 2020=C2=A0 thumb-1
-rw-rw-r-- 1 as=C2=A0=C2=A0=C2=A0 users=C2=A0=C2=A0 310060 25. Mai 14:24 t=
humbnailindex
wshome5:/home/beate/Handy-Bilder #

10. This is most unexpected: the thumbnailindex get new permissions and
new owner (me) - but I did not have write permissions on this file (only
on the folder).


I know, all this sounds a bit garbled. It is not meant to be a "real"
bug message, even if a crashreport is attached, but more to express my
general pain with the thumbnails in KPA.

I have seen some discussions about improving handling of thumbnails in
the past. Maybe one could take into account these quirks and try to
handle things differently. However, I have no solution.


My user story is:

- have a db shared between multiple users in the same group.

- the db may reside on a remote file system

- users use various PCs to access the db

- the same PC is shared by multiple users

- all users add to and edit (tag images) the db from the same or from
different PCs

- the users might have different preferences for their thumbnail size

- the same user might have different preferences on different machines,
as they have different screen sizes

- in my current setup, it takes >1h to recreate the thumbnails for 40k
images (so I don't want to do this often).


Best regards, Andreas


--------------8D1FE1145695342FDCD40BFC
Content-Type: text/plain; charset=UTF-8;
 name="kphotoalbum-20210525-104113.kcrash.txt"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="kphotoalbum-20210525-104113.kcrash.txt"

QXBwbGljYXRpb246IGtwaG90b2FsYnVtICh2NS43LjAtMjYzLWdhNzg1NTNlMSkKClF0IFZl
cnNpb246IDUuMTIuNwpGcmFtZXdvcmtzIFZlcnNpb246IDUuNzEuMApPcGVyYXRpbmcgU3lz
dGVtOiBMaW51eCA1LjMuMTgtbHAxNTIuNzUtcHJlZW1wdCB4ODZfNjQKV2luZG93aW5nIHN5
c3RlbTogWDExCkRpc3RyaWJ1dGlvbjogb3BlblNVU0UgTGVhcCAxNS4yCgotLSBJbmZvcm1h
dGlvbiBhYm91dCB0aGUgY3Jhc2g6CjxFcmtsw6RyZW4gU2llIGJpdHRlIGdhbnogZ2VuYXUs
IHdhcyBTaWUgbWFjaHRlbiwgYWxzIGRhcyBQcm9ncmFtbSBhYnN0w7xyenRlLj4KClRoZSBj
cmFzaCBjYW4gYmUgcmVwcm9kdWNlZCBldmVyeSB0aW1lLgoKLS0gQmFja3RyYWNlOgpBcHBs
aWNhdGlvbjogS1Bob3RvQWxidW0gKGtwaG90b2FsYnVtKSwgc2lnbmFsOiBBYm9ydGVkCltL
Q3Jhc2ggSGFuZGxlcl0KIzQgIDB4MDAwMDdmY2JjN2QwZTQyMCBpbiByYWlzZSAoKSBmcm9t
IC9saWI2NC9saWJjLnNvLjYKIzUgIDB4MDAwMDdmY2JjN2QwZmEwMSBpbiBhYm9ydCAoKSBm
cm9tIC9saWI2NC9saWJjLnNvLjYKIzYgIDB4MDAwMDdmY2JjOGE2NTdmYiBpbiBRTWVzc2Fn
ZUxvZ2dlcjo6ZmF0YWwoY2hhciBjb25zdCosIC4uLikgY29uc3QgKCkgZnJvbSAvdXNyL2xp
YjY0L2xpYlF0NUNvcmUuc28uNQojNyAgMHgwMDAwN2ZjYmM4YTY0ZmYxIGluIHF0X2Fzc2Vy
dChjaGFyIGNvbnN0KiwgY2hhciBjb25zdCosIGludCkgKCkgZnJvbSAvdXNyL2xpYjY0L2xp
YlF0NUNvcmUuc28uNQojOCAgMHgwMDAwMDAwMDAwNjM5ZTAyIGluIFV0aWxpdGllczo6c2F2
ZUltYWdlIChmaWxlTmFtZT0uLi4sIGltYWdlPS4uLiwgZm9ybWF0PTB4NjZkYmY0ICJKUEVH
IikgYXQgL2hvbWUvdXNyL3NyYy9rcGhvdG9hbGJ1bS1naXQva3Bob3RvYWxidW0vVXRpbGl0
aWVzL0ltYWdlVXRpbC5jcHA6MjMKIzkgIDB4MDAwMDAwMDAwMDYyMmU4ZSBpbiBCYWNrZ3Jv
dW5kSm9iczo6SGFuZGxlVmlkZW9UaHVtYm5haWxSZXF1ZXN0Sm9iOjpzYXZlRnVsbFNjYWxl
RnJhbWUgKGZpbGVOYW1lPS4uLiwgaW1hZ2U9Li4uKSBhdCAvaG9tZS91c3Ivc3JjL2twaG90
b2FsYnVtLWdpdC9rcGhvdG9hbGJ1bS9CYWNrZ3JvdW5kSm9icy9IYW5kbGVWaWRlb1RodW1i
bmFpbFJlcXVlc3RKb2IuY3BwOjYzCiMxMCAweDAwMDAwMDAwMDA2MjJkYzkgaW4gQmFja2dy
b3VuZEpvYnM6OkhhbmRsZVZpZGVvVGh1bWJuYWlsUmVxdWVzdEpvYjo6ZnJhbWVMb2FkZWQg
KHRoaXM9MHgzMjFmODAwLCBpbWFnZT08aW5jb21wbGV0ZSB0eXBlPikgYXQgL2hvbWUvdXNy
L3NyYy9rcGhvdG9hbGJ1bS1naXQva3Bob3RvYWxidW0vQmFja2dyb3VuZEpvYnMvSGFuZGxl
VmlkZW9UaHVtYm5haWxSZXF1ZXN0Sm9iLmNwcDo1NgojMTEgMHgwMDAwMDAwMDAwNjIyYzM4
IGluIEJhY2tncm91bmRKb2JzOjpIYW5kbGVWaWRlb1RodW1ibmFpbFJlcXVlc3RKb2I6OmV4
ZWN1dGUgKHRoaXM9MHgzMjFmODAwKSBhdCAvaG9tZS91c3Ivc3JjL2twaG90b2FsYnVtLWdp
dC9rcGhvdG9hbGJ1bS9CYWNrZ3JvdW5kSm9icy9IYW5kbGVWaWRlb1RodW1ibmFpbFJlcXVl
c3RKb2IuY3BwOjQ3CiMxMiAweDAwMDAwMDAwMDA2MWI4ZjcgaW4gQmFja2dyb3VuZFRhc2tN
YW5hZ2VyOjpKb2JJbnRlcmZhY2U6OnN0YXJ0ICh0aGlzPTB4MzIxZjgwMCkgYXQgL2hvbWUv
dXNyL3NyYy9rcGhvdG9hbGJ1bS1naXQva3Bob3RvYWxidW0vQmFja2dyb3VuZFRhc2tNYW5h
Z2VyL0pvYkludGVyZmFjZS5jcHA6MzUKIzEzIDB4MDAwMDAwMDAwMDYxYmYwZCBpbiBCYWNr
Z3JvdW5kVGFza01hbmFnZXI6OkpvYk1hbmFnZXI6OmV4ZWN1dGUgKHRoaXM9MHgyYTQ5MGQw
KSBhdCAvaG9tZS91c3Ivc3JjL2twaG90b2FsYnVtLWdpdC9rcGhvdG9hbGJ1bS9CYWNrZ3Jv
dW5kVGFza01hbmFnZXIvSm9iTWFuYWdlci5jcHA6NjEKIzE0IDB4MDAwMDAwMDAwMDYxYmY2
OCBpbiBCYWNrZ3JvdW5kVGFza01hbmFnZXI6OkpvYk1hbmFnZXI6OmFkZEpvYiAodGhpcz0w
eDJhNDkwZDAsIGpvYj0weDMyMWY4MDApIGF0IC9ob21lL3Vzci9zcmMva3Bob3RvYWxidW0t
Z2l0L2twaG90b2FsYnVtL0JhY2tncm91bmRUYXNrTWFuYWdlci9Kb2JNYW5hZ2VyLmNwcDo2
OAojMTUgMHgwMDAwMDAwMDAwNTdjYzdkIGluIEltYWdlTWFuYWdlcjo6QXN5bmNMb2FkZXI6
OmxvYWRWaWRlbyAodGhpcz0weDJiNWQ1NjAsIHJlcXVlc3Q9MHgzMGRlZjgwKSBhdCAvaG9t
ZS91c3Ivc3JjL2twaG90b2FsYnVtLWdpdC9rcGhvdG9hbGJ1bS9JbWFnZU1hbmFnZXIvQXN5
bmNMb2FkZXIuY3BwOjEwOQojMTYgMHgwMDAwMDAwMDAwNTdjYjQ0IGluIEltYWdlTWFuYWdl
cjo6QXN5bmNMb2FkZXI6OmxvYWQgKHRoaXM9MHgyYjVkNTYwLCByZXF1ZXN0PTB4MzBkZWY4
MCkgYXQgL2hvbWUvdXNyL3NyYy9rcGhvdG9hbGJ1bS1naXQva3Bob3RvYWxidW0vSW1hZ2VN
YW5hZ2VyL0FzeW5jTG9hZGVyLmNwcDo4NgojMTcgMHgwMDAwMDAwMDAwNTFlOWY5IGluIFZp
ZXdlcjo6SW1hZ2VEaXNwbGF5OjpyZXF1ZXN0SW1hZ2UgKHRoaXM9MHgyYmM5Y2QwLCBpbmZv
PS4uLiwgcHJpb3JpdHk9ZmFsc2UpIGF0IC9ob21lL3Vzci9zcmMva3Bob3RvYWxidW0tZ2l0
L2twaG90b2FsYnVtL1ZpZXdlci9JbWFnZURpc3BsYXkuY3BwOjczNwojMTggMHgwMDAwMDAw
MDAwNTFkODgyIGluIFZpZXdlcjo6SW1hZ2VEaXNwbGF5Ojp1cGRhdGVQcmVsb2FkICh0aGlz
PTB4MmJjOWNkMCkgYXQgL2hvbWUvdXNyL3NyYy9rcGhvdG9hbGJ1bS1naXQva3Bob3RvYWxi
dW0vVmlld2VyL0ltYWdlRGlzcGxheS5jcHA6NjAzCiMxOSAweDAwMDAwMDAwMDA1MWQ0MzQg
aW4gVmlld2VyOjpJbWFnZURpc3BsYXk6OnBpeG1hcExvYWRlZCAodGhpcz0weDJiYzljZDAs
IHJlcXVlc3Q9MHgzMGRlZjIwLCBpbWFnZT0uLi4pIGF0IC9ob21lL3Vzci9zcmMva3Bob3Rv
YWxidW0tZ2l0L2twaG90b2FsYnVtL1ZpZXdlci9JbWFnZURpc3BsYXkuY3BwOjU2NQojMjAg
MHgwMDAwMDAwMDAwNTdkNWVkIGluIEltYWdlTWFuYWdlcjo6QXN5bmNMb2FkZXI6OmN1c3Rv
bUV2ZW50ICh0aGlzPTB4MmI1ZDU2MCwgZXY9MHg3ZmNiNjgwMDRlNDApIGF0IC9ob21lL3Vz
ci9zcmMva3Bob3RvYWxidW0tZ2l0L2twaG90b2FsYnVtL0ltYWdlTWFuYWdlci9Bc3luY0xv
YWRlci5jcHA6MjMwCiMyMSAweDAwMDA3ZmNiYzhjOTQ5OWIgaW4gUU9iamVjdDo6ZXZlbnQo
UUV2ZW50KikgKCkgZnJvbSAvdXNyL2xpYjY0L2xpYlF0NUNvcmUuc28uNQojMjIgMHgwMDAw
N2ZjYmM5YWU5ZjJjIGluIFFBcHBsaWNhdGlvblByaXZhdGU6Om5vdGlmeV9oZWxwZXIoUU9i
amVjdCosIFFFdmVudCopICgpIGZyb20gL3Vzci9saWI2NC9saWJRdDVXaWRnZXRzLnNvLjUK
IzIzIDB4MDAwMDdmY2JjOWFmMTU0MCBpbiBRQXBwbGljYXRpb246Om5vdGlmeShRT2JqZWN0
KiwgUUV2ZW50KikgKCkgZnJvbSAvdXNyL2xpYjY0L2xpYlF0NVdpZGdldHMuc28uNQojMjQg
MHgwMDAwN2ZjYmM4YzY0MzI4IGluIFFDb3JlQXBwbGljYXRpb246Om5vdGlmeUludGVybmFs
MihRT2JqZWN0KiwgUUV2ZW50KikgKCkgZnJvbSAvdXNyL2xpYjY0L2xpYlF0NUNvcmUuc28u
NQojMjUgMHgwMDAwN2ZjYmM4YzY2ZWU3IGluIFFDb3JlQXBwbGljYXRpb25Qcml2YXRlOjpz
ZW5kUG9zdGVkRXZlbnRzKFFPYmplY3QqLCBpbnQsIFFUaHJlYWREYXRhKikgKCkgZnJvbSAv
dXNyL2xpYjY0L2xpYlF0NUNvcmUuc28uNQojMjYgMHgwMDAwN2ZjYmM4Y2MxZDkzIGluID8/
ICgpIGZyb20gL3Vzci9saWI2NC9saWJRdDVDb3JlLnNvLjUKIzI3IDB4MDAwMDdmY2JiZDQ0
NjYyNCBpbiBnX21haW5fY29udGV4dF9kaXNwYXRjaCAoKSBmcm9tIC91c3IvbGliNjQvbGli
Z2xpYi0yLjAuc28uMAojMjggMHgwMDAwN2ZjYmJkNDQ2OWMwIGluID8/ICgpIGZyb20gL3Vz
ci9saWI2NC9saWJnbGliLTIuMC5zby4wCiMyOSAweDAwMDA3ZmNiYmQ0NDZhNGMgaW4gZ19t
YWluX2NvbnRleHRfaXRlcmF0aW9uICgpIGZyb20gL3Vzci9saWI2NC9saWJnbGliLTIuMC5z
by4wCiMzMCAweDAwMDA3ZmNiYzhjYzEzYWYgaW4gUUV2ZW50RGlzcGF0Y2hlckdsaWI6OnBy
b2Nlc3NFdmVudHMoUUZsYWdzPFFFdmVudExvb3A6OlByb2Nlc3NFdmVudHNGbGFnPikgKCkg
ZnJvbSAvdXNyL2xpYjY0L2xpYlF0NUNvcmUuc28uNQojMzEgMHgwMDAwN2ZjYmM4YzYyNTdh
IGluIFFFdmVudExvb3A6OmV4ZWMoUUZsYWdzPFFFdmVudExvb3A6OlByb2Nlc3NFdmVudHNG
bGFnPikgKCkgZnJvbSAvdXNyL2xpYjY0L2xpYlF0NUNvcmUuc28uNQojMzIgMHgwMDAwN2Zj
YmM4YzZiNzgwIGluIFFDb3JlQXBwbGljYXRpb246OmV4ZWMoKSAoKSBmcm9tIC91c3IvbGli
NjQvbGliUXQ1Q29yZS5zby41CiMzMyAweDAwMDAwMDAwMDA0OGY3NWEgaW4gbWFpbiAoYXJn
Yz0zLCBhcmd2PTB4N2ZmZGVjNGU0ZDk4KSBhdCAvaG9tZS91c3Ivc3JjL2twaG90b2FsYnVt
LWdpdC9rcGhvdG9hbGJ1bS9tYWluLmNwcDoxNjIKW0luZmVyaW9yIDEgKHByb2Nlc3MgMjQx
MjQpIGRldGFjaGVkXQo=
--------------8D1FE1145695342FDCD40BFC
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
KPhotoAlbum mailing list
[email protected]
https://mail.kdab.com/mailman/listinfo/kphotoalbum

--------------8D1FE1145695342FDCD40BFC--