[digiKam-users] --> DK Loosing Database (part of it)

[Alex Antão]

Hi, 

  This is not the first time.

  I don't know why, neither I can force reproduce.

  DK sometimes looses all my library from database.  Yesterday, It was recognizing the faces from my library, it was very slow and I closed it (nicely).

  When I opened again, all Library structure was empty, it started to find all photos again.

   Information like Tags and people are shown (the people includes the number of photos with each people), but no photos os even the structure (albums) are on the library.

    I have a MacBook Pro, and my library is located on a NAS. Even if the connection is lost sometime, I don't think DK should clean all DB and start from zero. It is configured as a network device, so DK should be aware that the Library can sometime be unavailable. My library is huge and it will take a long long time to scan all again... this is very frustrating. 

     Is there a way to recover it ?

Regards...

[Gilles Caulier-4]

Hi,

If you use a SQLite database file _must_ be located on the local hard
drive, not on the NAS. You need to use Mysql or Mariadb server
instead, to host a remote database.

This is a sqlite technical restriction, not digiKam. It's well
explained in the database setup configuration panel.

Best

Gilles Caulier

Le mar. 7 juil. 2020 à 10:05, Alex Antão <[hidden email]> a écrit :

>
> Hi,
>
>   This is not the first time.
>   I don't know why, neither I can force reproduce.
>
>   DK sometimes looses all my library from database.  Yesterday, It was recognizing the faces from my library, it was very slow and I closed it (nicely).
>   When I opened again, all Library structure was empty, it started to find all photos again.
>
>    Information like Tags and people are shown (the people includes the number of photos with each people), but no photos os even the structure (albums) are on the library.
>
>     I have a MacBook Pro, and my library is located on a NAS. Even if the connection is lost sometime, I don't think DK should clean all DB and start from zero. It is configured as a network device, so DK should be aware that the Library can sometime be unavailable. My library is huge and it will take a long long time to scan all again... this is very frustrating.
>
>      Is there a way to recover it ?
>
> Regards...
>

[Alex Antão]

Yes, it is on local, I would never try to store the database on a remote location.

Only my library, the photos themselves, is on the NAS drive. 

---- Ativado Ter, 07 jul 2020 11:40:32 -0300 Gilles Caulier <[hidden email]> escreveu ----

Hi,

If you use a SQLite database file _must_ be located on the local hard
drive, not on the NAS. You need to use Mysql or Mariadb server
instead, to host a remote database.

This is a sqlite technical restriction, not digiKam. It's well
explained in the database setup configuration panel.

Best

Gilles Caulier

Le mar. 7 juil. 2020 à 10:05, Alex Antão <[hidden email]> a écrit :

>
> Hi,
>
> This is not the first time.
> I don't know why, neither I can force reproduce.
>
> DK sometimes looses all my library from database. Yesterday, It was recognizing the faces from my library, it was very slow and I closed it (nicely).
> When I opened again, all Library structure was empty, it started to find all photos again.
>
> Information like Tags and people are shown (the people includes the number of photos with each people), but no photos os even the structure (albums) are on the library.
>
> I have a MacBook Pro, and my library is located on a NAS. Even if the connection is lost sometime, I don't think DK should clean all DB and start from zero. It is configured as a network device, so DK should be aware that the Library can sometime be unavailable. My library is huge and it will take a long long time to scan all again... this is very frustrating.
>
> Is there a way to recover it ?
>
> Regards...
>

[Alex Antão]

Today It happened again.

I had my DK opened and it was scanning my library for new items. I had to turn off my house lights and my wifi and also my NAS was down for some time.

When It came back, DK simply got rid of all items already scanned and started all over. 

All over again. 

 I almost never got all my library completely scanned nor all faces recognised in DK.

Regards

---- Ativado Ter, 07 jul 2020 18:09:04 -0300 Alex Antão <[hidden email]> escreveu ----

Yes, it is on local, I would never try to store the database on a remote location.

Only my library, the photos themselves, is on the NAS drive. 

---- Ativado Ter, 07 jul 2020 11:40:32 -0300 Gilles Caulier <[hidden email]> escreveu ----

Hi,

If you use a SQLite database file _must_ be located on the local hard
drive, not on the NAS. You need to use Mysql or Mariadb server
instead, to host a remote database.

This is a sqlite technical restriction, not digiKam. It's well
explained in the database setup configuration panel.

Best

Gilles Caulier

Le mar. 7 juil. 2020 à 10:05, Alex Antão <[hidden email]> a écrit :

>
> Hi,
>
> This is not the first time.
> I don't know why, neither I can force reproduce.
>
> DK sometimes looses all my library from database. Yesterday, It was recognizing the faces from my library, it was very slow and I closed it (nicely).
> When I opened again, all Library structure was empty, it started to find all photos again.
>
> Information like Tags and people are shown (the people includes the number of photos with each people), but no photos os even the structure (albums) are on the library.
>
> I have a MacBook Pro, and my library is located on a NAS. Even if the connection is lost sometime, I don't think DK should clean all DB and start from zero. It is configured as a network device, so DK should be aware that the Library can sometime be unavailable. My library is huge and it will take a long long time to scan all again... this is very frustrating.
>
> Is there a way to recover it ?
>
> Regards...
>