Arch Linux

sweetthdevil

Member

Registered: 2009-10-20

Posts: 432

SQLite database digikam kphotoalbum

Hello,

After installing a home server I moved my collection of picture to my server mounted via cifs.

Digikam is complaining that I do not have the right to the database. After searching and trying to sort the access I have up and deleted all config files from digikam and all .db that were saved in the photo folder.

Now digikam is still complaining that I don't have right on the database, and so is kphotoalbum that I installed to replace digikam as I gave up.

I can only start both digikam and kphotoalbum without complaints about the database with the server unmounted.

Surely SQLite is keeping a config file that point to it?

Any help would be appreciated.
Thanks

Trilby

Inspector Parrot

Registered: 2011-11-29

Posts: 30,506

Website

Re: SQLite database digikam kphotoalbum

... my server mounted via cifs.

How and where is it mounted?  What are the actualy commands used and error messages produced?

---

"UNIX is simple and coherent" - Dennis Ritchie; "GNU's Not Unix" - Richard Stallman

sweetthdevil

Member

Registered: 2009-10-20

Posts: 432

Re: SQLite database digikam kphotoalbum

Hi Trilby,

Server is mounted in /mnt/share

See debug from digikam

Type "apropos word" to search for commands related to "word"...
Reading symbols from digikam...
(No debugging symbols found in digikam)
(gdb) catch throw
Catchpoint 1 (throw)
(gdb) run
Starting program: /usr/bin/digikam 
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/usr/lib/libthread_db.so.1".
[New Thread 0x7fffdbbb7640 (LWP 4065)]
[New Thread 0x7fffd9ecd640 (LWP 4066)]
[New Thread 0x7fffd96cc640 (LWP 4067)]
[New Thread 0x7fffd8ecb640 (LWP 4068)]
[New Thread 0x7fffcbfff640 (LWP 4069)]
[New Thread 0x7fffca6f9640 (LWP 4070)]
QCommandLineParser: already having an option named "h"
QCommandLineParser: already having an option named "help-all"
QCommandLineParser: already having an option named "v"
[New Thread 0x7fffc94e8640 (LWP 4071)]
[New Thread 0x7fffc8ce7640 (LWP 4072)]
[New Thread 0x7fffb3fff640 (LWP 4073)]
[Thread 0x7fffb3fff640 (LWP 4073) exited]
digikam.dbengine: Detected locked database file. There is an active transaction. Waited but giving up now.
digikam.coredb: Core database: cannot process schema initialization
[New Thread 0x7fffb3fff640 (LWP 4075)]
[New Thread 0x7fffb3709640 (LWP 4076)]
[New Thread 0x7fffb2f08640 (LWP 4077)]
[New Thread 0x7fffb2707640 (LWP 4078)]
[Thread 0x7fffb3709640 (LWP 4076) exited]
[Thread 0x7fffb3fff640 (LWP 4075) exited]
[Thread 0x7fffb2707640 (LWP 4078) exited]
[Thread 0x7fffb2f08640 (LWP 4077) exited]

Thread 9 "digikam" received signal SIG32, Real-time event 32.
[Switching to Thread 0x7fffc8ce7640 (LWP 4072)]
0x00007ffff51f9bf3 in pselect () from /usr/lib/libc.so.6
(gdb) quit
A debugging session is active.

        Inferior 1 [process 4061] will be killed.

Kphotoalbum doesn't give any info via the terminal but the following message appears.

There was an error while executing the SQL backend command. The error is likely due to a broken database file.
To fix this problem run Maintenance->Recreate EXIF Search database.

For debugging: the command that was attempted to be executed was:
create table if not exists settings (keyword TEXT PRIMARY KEY, value TEXT) without rowid
The error message obtained was:
database is locked Unable to fetch row

There was an error while executing the SQL backend command. The error is likely due to a broken database file.
To fix this problem run Maintenance->Recreate EXIF Search database.

For debugging: the command that was attempted to be executed was:
create table if not exists exif (filename string PRIMARY KEY, Exif_Photo_FocalLength float, Exif_Photo_ExposureTime float, Exif_Photo_ApertureValue float, Exif_Photo_FNumber float, Exif_Photo_Flash int, Exif_Photo_Contrast int, Exif_Photo_Sharpness int, Exif_Photo_Saturation int, Exif_Image_Orientation int, Exif_Photo_MeteringMode int, Exif_Photo_ISOSpeedRatings int, Exif_Photo_ExposureProgram int, Exif_Image_Make string, Exif_Image_Model string, Exif_GPSInfo_GPSVersionID int, Exif_GPSInfo_GPSAltitude float, Exif_GPSInfo_GPSAltitudeRef int, Exif_GPSInfo_GPSMeasureMode string, Exif_GPSInfo_GPSDOP float, Exif_GPSInfo_GPSImgDirection float, Exif_GPSInfo_GPSLatitude float, Exif_GPSInfo_GPSLatitudeRef string, Exif_GPSInfo_GPSLongitude float, Exif_GPSInfo_GPSLongitudeRef string, Exif_GPSInfo_GPSTimeStamp float, Exif_Photo_LensModel string )
The error message obtained was:
database is locked Unable to fetch row

tucuxi

Member

From: Switzerland

Registered: 2020-03-08

Posts: 291

Re: SQLite database digikam kphotoalbum

What are the mount parameters?

sweetthdevil

Member

Registered: 2009-10-20

Posts: 432

Re: SQLite database digikam kphotoalbum

Hi,

mounted parameters as followed:

//192.168.1.90/arch_home_server /mnt/share cifs username=sweetth,password=******,rw,user,noauto,nounix,iocharset=utf8,file_mode=0777,dir_mode=0777 0 0

Thank you

tucuxi

Member

From: Switzerland

Registered: 2020-03-08

Posts: 291

Re: SQLite database digikam kphotoalbum

That looks reasonable. Have you tried what the error message suggests, i.e. recreate the EXIF Search database?