Startup takes 4 minutes

[Gilles Caulier]

Simon is right. Let's the database to be cleaned at least one time.

But look also in Step/Misc/Behavior. There is an option to disable
this check at startup.

Note that DB clean can be started as a maintenance tool.

Gilles Caulier

2017-08-08 13:29 GMT+02:00 Simon Frei <freisim93 at gmail.com>:
> This is likely due to the new database integrity checks. As far as I
> remember parts of it happen on startup. So first advice is to let it run
> once - it may take a (long) while, but it should be only this one time.
> I Cced Mario who worked on this, so he can give more relevant
> information or correct me if necessary.
>
> On 08/08/17 02:32, meku wrote:
>> In v5.6+ the splash screen pauses at "Reading Database..." for almost 4
>> minutes where previously the entire program would load in under a minute.
>> This is using mysql backend and it does not appear to be waiting for
>> database - nothing is reported in the slow query log.
>>
>> The following backtrace is from v5.7 pre-release appbundle:
>>
>> digikam.database: " ( 1 ) "
>> digikam.database: Search query:
>>  "SELECT DISTINCT Images.id, Images.name, Images.album,
>> Albums.albumRoot,        ImageInformation.rating, Images.category,
>> ImageInformation.format, ImageInformation.creationDate,
>> Images.modificationDate, Images.fileSize,        ImageInformation.width,
>> ImageInformation.height,        ImagePositions.latitudeNumber,
>> ImagePositions.longitudeNumber  FROM Images        LEFT JOIN
>> ImageInformation ON Images.id=ImageInformation.imageid        LEFT  JOIN
>> ImageMetadata    ON Images.id=ImageMetadata.imageid        LEFT  JOIN
>> VideoMetadata    ON Images.id=VideoMetadata.imageid        LEFT  JOIN
>> ImagePositions   ON Images.id=ImagePositions.imageid        INNER JOIN
>> Albums           ON Albums.id=Images.album WHERE Images.status=1 AND (  ( 1
>> )  );"
>>  ()
>> digikam.database: Search result: 916804
>> digikam.geoiface: "ROADMAP"
>> ^C
>> Thread 1 "digikam" received signal SIGINT, Interrupt.
>> syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
>> 38      ../sysdeps/unix/sysv/linux/x86_64/syscall.S: No such file or
>> directory.
>> (gdb) bt
>> #0  syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
>> #1  0x00007fffec9aa7c5 in QBasicMutex::lockInternal() () from
>> /tmp/.mount_MPSbUb/usr/lib/libQt5Core.so.5
>> #2  0x00007fffec9aa856 in QMutex::lock() () from
>> /tmp/.mount_MPSbUb/usr/lib/libQt5Core.so.5
>> #3  0x00007fffec0c2332 in Digikam::CoreDbAccess::CoreDbAccess
>> (this=<optimised out>)
>>     at
>> /b/dktemp/digikam-master/core/libs/database/coredb/coredbaccess.cpp:116
>> #4  0x00007ffff7729375 in Digikam::AbstractAlbumTreeView::doLoadState
>> (this=this at entry=0x13c39b0)
>>     at /b/dktemp/digikam-master/core/libs/album/albumtreeview.cpp:773
>> #5  0x00007ffff772a4b9 in
>> Digikam::AbstractCheckableAlbumTreeView::doLoadState (this=0x13c39b0)
>>     at /b/dktemp/digikam-master/core/libs/album/albumtreeview.cpp:1368
>> #6  0x00007ffff685721a in Digikam::StateSavingObject::loadState
>> (this=0x13c39e0)
>>     at
>> /b/dktemp/digikam-master/core/libs/widgets/common/statesavingobject.cpp:184
>> #7  0x00007ffff798c537 in Digikam::GPSSearchView::doLoadState
>> (this=0x13b0940)
>>     at
>> /b/dktemp/digikam-master/core/utilities/geolocation/mapsearches/gpssearchview.cpp:328
>> #8  0x00007ffff685721a in Digikam::StateSavingObject::loadState
>> (this=0x13b0970)
>>     at
>> /b/dktemp/digikam-master/core/libs/widgets/common/statesavingobject.cpp:184
>> #9  0x00007ffff685721a in Digikam::StateSavingObject::loadState
>> (this=0x13b05f0)
>>     at
>> /b/dktemp/digikam-master/core/libs/widgets/common/statesavingobject.cpp:184
>> #10 0x00007ffff75f3047 in Digikam::DigikamView::loadViewState
>> (this=this at entry=0xd6b090)
>>     at /b/dktemp/digikam-master/core/app/views/digikamview.cpp:724
>> #11 0x00007ffff75f343a in Digikam::DigikamView::slotAllAlbumsLoaded
>> (this=0xd6b090)
>>     at /b/dktemp/digikam-master/core/app/views/digikamview.cpp:945
>> #12 0x00007ffff7605ab8 in Digikam::DigikamView::qt_static_metacall
>> (_o=0xd6b090, _c=<optimised out>, _id=<optimised out>,
>>     _a=<optimised out>) at
>> /b/dktemp/digikam-master/build/core/app/moc_digikamview.cpp:712
>> #13 0x00007fffecbb9fd8 in QMetaObject::activate(QObject*, int, int, void**)
>> () from /tmp/.mount_MPSbUb/usr/lib/libQt5Core.so.5
>> #14 0x00007ffff7747146 in Digikam::AlbumManager::startScan (
>>     this=0x7ffff7dd6230
>> <_ZZN7Digikam12_GLOBAL__N_113Q_QGS_creator13innerFunctionEvE6holder>)
>>     at /b/dktemp/digikam-master/core/libs/album/albummanager.cpp:1090
>> #15 0x00007ffff7554d50 in Digikam::DigikamApp::DigikamApp (this=0x78a3a0,
>> __in_chrg=<optimised out>, __vtt_parm=<optimised out>)
>>     at /b/dktemp/digikam-master/core/app/main/digikamapp.cpp:276
>> #16 0x00000000004058c8 in main (argc=1, argv=<optimised out>) at
>> /b/dktemp/digikam-master/core/app/main/main.cpp:236
>> (gdb)
>>
>>
>>
>> --
>> View this message in context: http://digikam.1695700.n4.nabble.com/Startup-takes-4-minutes-tp4703585.html
>> Sent from the digikam-users mailing list archive at Nabble.com.
>