Startup takes 4 minutes

[meku]

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.