Good (not so recent) news about sqlite and locking problem

[Fabien-5]

Hi,

I may be better in the future, look here :

http://alastairs-place.net/2006/07/sqlite_and_mac/

"SQLite is quite a popular library, particularly on Mac OS X where it's
actually used to implement some system features.

Unfortunately, some of the filesystems on OS X (AFP, for instance) don't
implement advisory locking via the POSIX function fcntl(), which leads
SQLite to report that the "database is locked" whenever you try to use it.

Now, SQLite is included with Mac OS X, and Apple have been kind enough
to solve this problem..."


and :
http://www.sqlite.org/changes.html#version_3_3_8

"Added OS-X locking patches (beta - disabled by default)"




It would be great if somebody who has the problem can try the latest
version of sqlite with new locking system enabled...

Note: I recently, for the 1st time, faced this problem with a NFS share.
I found a workaround by mounting the nfs share with "nolock" option.
Don't ask me how it could be better like that, but at least, it worked
for me : I was able to start digiKam and browse all albums without
problem (but didn't try to modify anything as it was read-only access)...


--
Fabien

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

[Gilles Caulier-4]

Fabien,

new sqlite release 3.4.0 is out. I would to have a report about digiKam with this major version... especially with an huge DB and the new data limit than sqlite can manipulate (look this post in French here : http://linuxfr.org/2007/06/26/22661.html)

Gilles

2007/6/13, Fabien <[hidden email]>:

Hi,

I may be better in the future, look here :

http://alastairs-place.net/2006/07/sqlite_and_mac/

"SQLite is quite a popular library, particularly on Mac OS X where it's
actually used to implement some system features.

Unfortunately, some of the filesystems on OS X (AFP, for instance) don't
implement advisory locking via the POSIX function fcntl(), which leads
SQLite to report that the "database is locked" whenever you try to use it.

Now, SQLite is included with Mac OS X, and Apple have been kind enough
to solve this problem..."


and :
http://www.sqlite.org/changes.html#version_3_3_8

"Added OS-X locking patches (beta - disabled by default)"




It would be great if somebody who has the problem can try the latest
version of sqlite with new locking system enabled...

Note: I recently, for the 1st time, faced this problem with a NFS share.
I found a workaround by mounting the nfs share with "nolock" option.
Don't ask me how it could be better like that, but at least, it worked
for me : I was able to start digiKam and browse all albums without
problem (but didn't try to modify anything as it was read-only access)...


--
Fabien

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

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

[Fabien-5]

Hi,

Gilles Caulier wrote:
> new sqlite release 3.4.0 is out. I would to have a report about digiKam
> with this major version... especially with an huge DB and the new data
> limit than sqlite can manipulate (look this post in French here :
> http://linuxfr.org/2007/06/26/22661.html)

I just had a look at the default values :
http://www.sqlite.org/limits.html

They are so high that it shouldn't be a problem, even for millions of
photos !

--
Fabien

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

[Gerhard Kulzer]

Am Friday 29 June 2007 schrieb Fabien:

> Hi,
>
> Gilles Caulier wrote:
> > new sqlite release 3.4.0 is out. I would to have a report about digiKam
> > with this major version... especially with an huge DB and the new data
> > limit than sqlite can manipulate (look this post in French here :
> > http://linuxfr.org/2007/06/26/22661.html)
>
> I just had a look at the default values :
> http://www.sqlite.org/limits.html
>
> They are so high that it shouldn't be a problem, even for millions of
> photos !
>
> --
> Fabien
>
> _______________________________________________
> Digikam-devel mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-devel

I agree. I have now 44K photos, most of them having keyworda and comments, and
the DB is 4MB.

Gerhard

--
Hakuna matata
http://www.gerhard.fr

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