migration database error

[Jean-Michel Bonnefond]

Hi team,

This is certainly a dummy question but, I have an NFS repository where
my photos are stocked accessed by 2 computers with digikam. Today,
after some weeks without using digikam and a little problem over nfs
on my server, the 2 digikam won't launch saying (message translated
from french) : "Error; impossible to migrate from old database to new
database format". And the digikam doesn't launch.

If I launch it in a term, I obtain those messages :
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: SELECT name
FROM sqlite_master WHERE type='table' ORDER BY name;
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: SELECT value
FROM Settings WHERE keyword='Locale';
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: REPLACE into
Settings VALUES ('Locale','UTF-8');
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: SELECT name
FROM sqlite_master WHERE type='table' ORDER BY name;
digikam: WARNING: Failed to open new Album Database


So where should I find this database (where on the client is it
defined), and how should I remove the lock?

Thanks,
Jean-Michel.
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Hubert Figuiere-3]

Pompon wrote:
> So where should I find this database (where on the client is it
> defined), and how should I remove the lock?

It it the file digikam3.db that is at the top level of the "library"
directory in which digiKam look for picture (that appear to be on your
NFS mounted filesystem)

Use the command line tool "sqlite3" to open it.


Hub
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Jean-Michel Bonnefond]

Hi,

Just to answer myself and give the solution :

The problem came with sqlite which doesn't support concurent access over an nfs export (documented in sqlite). Notice that even deleting the database doesn't change the problem. So my solution to continue using the same gallery directory over multiple computer was to export the gallery subdirectory of my nfs export with samba... wich seems to work.

Thanks all.

2006/10/10, Pompon <[hidden email]>:

Hi team,

This is certainly a dummy question but, I have an NFS repository where
my photos are stocked accessed by 2 computers with digikam. Today,
after some weeks without using digikam and a little problem over nfs
on my server, the 2 digikam won't launch saying (message translated
from french) : "Error; impossible to migrate from old database to new
database format". And the digikam doesn't launch.

If I launch it in a term, I obtain those messages :
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: SELECT name
FROM sqlite_master WHERE type='table' ORDER BY name;
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: SELECT value
FROM Settings WHERE keyword='Locale';
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: REPLACE into
Settings VALUES ('Locale','UTF-8');
digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*,
bool)] sqlite_compile error: database is locked on query: SELECT name
FROM sqlite_master WHERE type='table' ORDER BY name;
digikam: WARNING: Failed to open new Album Database


So where should I find this database (where on the client is it
defined), and how should I remove the lock?

Thanks,
Jean-Michel.

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users