Startup takes 4 minutes

meku digikam at meku.org
Tue Aug 8 13:28:01 BST 2017 

Today the startup time has returned to normal (less than 15sec) but I don't
think I changed anything.  I did a full database clean & shrink using the
maintenance tool a few days ago but it didn't have any effect on the
startup time then.

Thanks for your help.

On 8 August 2017 at 22:03, Gilles Caulier-4 [via digiKam] <
ml+s1695700n4703590h37 at n4.nabble.com> wrote:

> 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 <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=4703590&i=0>>:
>
> > 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.
> >
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://digikam.1695700.n4.nabble.com/Startup-takes-4-
> minutes-tp4703585p4703590.html
> To unsubscribe from Startup takes 4 minutes, click here
> <http://digikam.1695700.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4703585&code=ZGlnaWthbUBtZWt1Lm9yZ3w0NzAzNTg1fC0xNTgxMzU2NzE2>
> .
> NAML
> <http://digikam.1695700.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://digikam.1695700.n4.nabble.com/Startup-takes-4-minutes-tp4703585p4703593.html
Sent from the digikam-users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170808/0bbde92b/attachment.html>

More information about the Digikam-users mailing list