[Digikam-users] migration database error

[Pompon]

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 <pompon2 at gmail.com>:
>
> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20061019/c33cf190/attachment.html>