Bug 112848 - digiKam fails on startup with large pictures folder.
Summary: digiKam fails on startup with large pictures folder.
Status: RESOLVED INTENTIONAL
Alias: None
Product: digikam
Classification: Applications
Component: Database-Scan (show other bugs)
Version: unspecified
Platform: Gentoo Packages Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-09-18 22:20 UTC by Nir Dremer
Modified: 2023-04-08 21:09 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 8.0.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nir Dremer 2005-09-18 22:20:49 UTC
Version:           0.8.0 beta2 (using KDE KDE 3.4.2)
Installed from:    Gentoo Packages
Compiler:          gcc version 3.4.4 (Gentoo 3.4.4-r1, ssp-3.4.4-1.0, pie-8.7.8) 
OS:                Linux

When loading digikam with a big pictures folder digikam gives the following output (debug):

digikam: ScanLib: Finding non-existing Albums: 9 ms
digikam: ScanLib: Finding items not in the database or disk: 143456 ms
digikam: ScanLib: Updating items without date: 4 ms
digikam: WARNING: sqlite_step error: database is full on query: REPLACE into Settings VALUES ('Scanned','2005-09-18T23:14:23');
digikam: WARNING: sqlite_step error: database is full on query: SELECT T.id, T.pid, T.name, A.url, I.name, T.iconkde
 FROM Tags AS T LEFT OUTER JOIN Images AS I ON I.id=T.icon
   LEFT OUTER JOIN Albums AS A ON A.id=I.dirid;
digikam: WARNING: sqlite_step error: database is full on query: SELECT id, name, url FROM Searches;
digikam: ImagePlugin_Core plugin loaded
digikam: ImagePluginLoader: Loaded plugin ImagePlugin_Core

and shows the application with empty albums tab.

my pictures folder contains 6041 pictures and the total size is 9.5 giga.
Comment 1 Tom Albers 2005-09-18 22:50:00 UTC
database is full? Seems like a problem with harddisk space?
Comment 2 Nir Dremer 2005-09-18 23:35:25 UTC
happens only when pictures folder is on NFS, when local folder works good.
Comment 3 Tom Albers 2005-09-18 23:42:42 UTC
See other bugreports about it. you could place the database on another place.
Comment 4 Nir Dremer 2005-09-19 00:30:33 UTC
why not fixing it to support nfs?

i dont think it's a big bug and maybe a simple solutions like:
1. writing db file in chunks instead of once (assuming this is how it is being done).
2. giving the ability to configure the location of the db file so it alone can be saved on local storage?

any chance to address this issue?
Comment 5 Renchi Raju 2005-09-19 04:12:22 UTC
the db writing part is handled by sqlite. for nfs based album library paths, have a look at --enable-nfs-hack flag for configure (./configure --help)