[digiKam-users] Scanning 200,000 photos. Digikam, mysql and NAS

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

[digiKam-users] Scanning 200,000 photos. Digikam, mysql and NAS

Manuel Fernández
I'm trying to manage a photo file of 200,000 photos with digikam. I have the
data in mysql working correctly (1.6TB). Once put into operation is quick to
locate photos, search by tags, etc. Great.

The photos are on a NAS unit connected in a network.

Problem: Digikam every so often deletes everything and scans again. It is a
process that takes 24 hours or more and during that process you can not work
and 0 photos appear. Is there any way to avoid it? Why digikam delete the
photos? (I have looked at the program option concerning check at startup,
It's off.)
I have verified that the records in mysql have not been deleted. They are
there.

Possibly the one that uses digikam with few photos does not have importance,
even it is noticed. But in my case, scanning 200,000 photos on a network is
hard.

Thanks!!!

(Sorry, Google translate)



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html
Reply | Threaded
Open this post in threaded view
|

Re: Scanning 200, 000 photos. Digikam, mysql and NAS

Gilles Caulier-4


2018-03-05 12:26 GMT+01:00 Manuel Fernández <[hidden email]>:
I'm trying to manage a photo file of 200,000 photos with digikam. I have the
data in mysql working correctly (1.6TB). Once put into operation is quick to
locate photos, search by tags, etc. Great.

The photos are on a NAS unit connected in a network.

Problem: Digikam every so often deletes everything and scans again. It is a
process that takes 24 hours or more and during that process you can not work
and 0 photos appear. Is there any way to avoid it? Why digikam delete the
photos? (I have looked at the program option concerning check at startup,
It's off.)

delete the photo from DB you want mean ?
 
I have verified that the records in mysql have not been deleted. They are
there.

Possibly the one that uses digikam with few photos does not have importance,
even it is noticed. But in my case, scanning 200,000 photos on a network is
hard.

How is mounted the collection through the network ?
Which DK version do you use ?
It's Mysql or MariaDB in background ?


Gilles Caulier
Reply | Threaded
Open this post in threaded view
|

Re: Scanning 200, 000 photos. Digikam, mysql and NAS

woenx
In reply to this post by Manuel Fernández
Manuel, I had a similar problem. My collection just disappeared if there was
a network disconnection, but only in the windows version of digikam. Is this
your case?

I wrote this message some time ago describing the problem:

http://digikam.1695700.n4.nabble.com/All-albums-are-removed-if-there-is-a-network-disconnection-td4704993.html
<http://digikam.1695700.n4.nabble.com/All-albums-are-removed-if-there-is-a-network-disconnection-td4704993.html>  

And submitted this bug report:
https://bugs.kde.org/show_bug.cgi?id=377849
<https://bugs.kde.org/show_bug.cgi?id=377849>  

The only workaround by now, is frequently backing up your digikam database,
so if it "empties" again, you can just recover it faster.



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html
Reply | Threaded
Open this post in threaded view
|

Re: Scanning 200, 000 photos. Digikam, mysql and NAS

PackElend
Hallo,

there is an additional bug report:
https://bugs.kde.org/show_bug.cgi?id=389680



On 05.03.2018 13:07, woenx wrote:

> Manuel, I had a similar problem. My collection just disappeared if there was
> a network disconnection, but only in the windows version of digikam. Is this
> your case?
>
> I wrote this message some time ago describing the problem:
>
> http://digikam.1695700.n4.nabble.com/All-albums-are-removed-if-there-is-a-network-disconnection-td4704993.html
> <http://digikam.1695700.n4.nabble.com/All-albums-are-removed-if-there-is-a-network-disconnection-td4704993.html>
>
> And submitted this bug report:
> https://bugs.kde.org/show_bug.cgi?id=377849
> <https://bugs.kde.org/show_bug.cgi?id=377849>
>
> The only workaround by now, is frequently backing up your digikam database,
> so if it "empties" again, you can just recover it faster.
>
>
>
> --
> Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

Reply | Threaded
Open this post in threaded view
|

Re: Scanning 200, 000 photos. Digikam, mysql and NAS

Manuel Fernández
In reply to this post by woenx



woenx wrote
> Manuel, I had a similar problem. My collection just disappeared if there
> was
> a network disconnection, but only in the windows version of digikam. Is
> this
> your case?

Yes, This is my case    


woenx wrote
> The only workaround by now, is frequently backing up your digikam
> database,
> so if it "empties" again, you can just recover it faster.

Yes, I do that too :)  










--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html
Reply | Threaded
Open this post in threaded view
|

Re: Scanning 200, 000 photos. Digikam, mysql and NAS

PackElend
woenx wrote
>> The only workaround by now, is frequently backing up your digikam
>> database,
>> so if it "empties" again, you can just recover it faster.
> Yes, I do that too :)
good that you solved it but it isn't an ideal solution.
Let's hope that digikam comes with an dialogue to relocate missing files
before deleting them from the database



On 05.03.2018 13:35, Manuel Fernández wrote:

>
>
> woenx wrote
>> Manuel, I had a similar problem. My collection just disappeared if there
>> was
>> a network disconnection, but only in the windows version of digikam. Is
>> this
>> your case?
> Yes, This is my case
>
>
> woenx wrote
>> The only workaround by now, is frequently backing up your digikam
>> database,
>> so if it "empties" again, you can just recover it faster.
> Yes, I do that too :)
>
>
>
>
>
>
>
>
>
>
> --
> Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

Reply | Threaded
Open this post in threaded view
|

Re: Scanning 200, 000 photos. Digikam, mysql and NAS

woenx
PackElend wrote
> woenx wrote
>>> The only workaround by now, is frequently backing up your digikam
>>> database,
>>> so if it "empties" again, you can just recover it faster.
>> Yes, I do that too :)
> good that you solved it but it isn't an ideal solution.
> Let's hope that digikam comes with an dialogue to relocate missing files
> before deleting them from the database

Well, another option that was suggested in the bug report was to create a
linux virtual machine and run digikam within that virtual machine, but I
think that's overkill...



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html
Reply | Threaded
Open this post in threaded view
|

Re: Scanning 200, 000 photos. Digikam, mysql and NAS

PackElend
it is :)

On 05.03.2018 13:57, woenx wrote:

> PackElend wrote
>> woenx wrote
>>>> The only workaround by now, is frequently backing up your digikam
>>>> database,
>>>> so if it "empties" again, you can just recover it faster.
>>> Yes, I do that too :)
>> good that you solved it but it isn't an ideal solution.
>> Let's hope that digikam comes with an dialogue to relocate missing files
>> before deleting them from the database
> Well, another option that was suggested in the bug report was to create a
> linux virtual machine and run digikam within that virtual machine, but I
> think that's overkill...
>
>
>
> --
> Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html