Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.6.3
-
Linux x86_64
Description
Since commit 295f3e4cfb4a8f132f, mariadb crashes (and has severe performance issues) when scanning the DigiKam database. The initial scan (with ~5000 pics) used to take <1 second with MariaDB 10.5, now it takes 10 seconds to reach 10% and then crashes
(gdb) bt
|
#0 net_field_length (packet=packet@entry=0x7fffffffd1c8) at /usr/src/debug/server/libmariadb/libmariadb/mariadb_lib.c:296
|
#1 0x00007fff6749d6dc in ps_fetch_string (r_param=0x55555b44b988, field=<optimized out>, row=0x7fffffffd1c8)
|
at /usr/src/debug/server/libmariadb/libmariadb/ma_stmt_codec.c:1195
|
#2 0x00007fff67497ca7 in mthd_stmt_fetch_to_bind (stmt=0x55555b3d0a90, row=<optimized out>)
|
at /usr/src/debug/server/libmariadb/libmariadb/mariadb_stmt.c:423
|
#3 0x00007fff674997b7 in mysql_stmt_fetch (stmt=0x55555b3d0a90) at /usr/src/debug/server/libmariadb/libmariadb/mariadb_stmt.c:1463
|
#4 0x00007fff840192ed in () at /usr/lib/qt/plugins/sqldrivers/libqsqlmysql.so
|
#5 0x00007ffff70c1819 in Digikam::BdEngineBackend::readToList(Digikam::DbEngineSqlQuery&) () at /usr/lib/libdigikamcore.so.7.3.0
|
#6 0x00007ffff70c1942 in Digikam::BdEngineBackend::handleQueryResult(Digikam::DbEngineSqlQuery&, QList<QVariant>*, QVariant*) ()
|
at /usr/lib/libdigikamcore.so.7.3.0
|
#7 0x00007ffff70c305b in Digikam::BdEngineBackend::execSql(QString const&, QVariant const&, QList<QVariant>*, QVariant*) ()
|
at /usr/lib/libdigikamcore.so.7.3.0
|
#8 0x00007ffff756f835 in Digikam::CoreDB::getItemPosition(long long, QFlags<Digikam::DatabaseFields::ItemPositionsField>) const ()
|
at /usr/lib/libdigikamdatabase.so.7.3.0
|
#9 0x00007ffff75e7312 in () at /usr/lib/libdigikamdatabase.so.7.3.0
|
#10 0x00007ffff75e7a3c in Digikam::ItemPosition::ItemPosition(long long) () at /usr/lib/libdigikamdatabase.so.7.3.0
|
#11 0x00007ffff75d011c in Digikam::ItemInfo::imagePosition() const () at /usr/lib/libdigikamdatabase.so.7.3.0
|
#12 0x00007ffff75d0432 in Digikam::ItemInfo::hasCoordinates() const () at /usr/lib/libdigikamdatabase.so.7.3.0
|
#13 0x00007ffff7d48e2c in () at /usr/lib/libdigikamgui.so.7.3.0
|
#14 0x00007ffff55774ff in QObject::event(QEvent*) () at /usr/lib/libQt5Core.so.5
|
#15 0x00007ffff601ed62 in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/libQt5Widgets.so.5
|
#16 0x00007ffff554a3aa in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/libQt5Core.so.5
|
#17 0x00007ffff554d4a9 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () at /usr/lib/libQt5Core.so.5
|
#18 0x00007ffff55a39a4 in () at /usr/lib/libQt5Core.so.5
|
#19 0x00007fffe449210c in g_main_context_dispatch () at /usr/lib/libglib-2.0.so.0
|
--Type <RET> for more, q to quit, c to continue without paging--
|
#20 0x00007fffe44e5b99 in () at /usr/lib/libglib-2.0.so.0
|
#21 0x00007fffe448f871 in g_main_context_iteration () at /usr/lib/libglib-2.0.so.0
|
#22 0x00007ffff55a2fd6 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/libQt5Core.so.5
|
#23 0x00007ffff5548d1c in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/libQt5Core.so.5
|
#24 0x00007ffff7a3afea in Digikam::ScanController::completeCollectionScanCore(bool, bool) () at /usr/lib/libdigikamgui.so.7.3.0
|
#25 0x00007ffff7bcc4e9 in Digikam::NewItemsFinder::slotStart() () at /usr/lib/libdigikamgui.so.7.3.0
|
#26 0x00007ffff55774ff in QObject::event(QEvent*) () at /usr/lib/libQt5Core.so.5
|
#27 0x00007ffff601ed62 in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/libQt5Widgets.so.5
|
#28 0x00007ffff554a3aa in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/libQt5Core.so.5
|
#29 0x00007ffff554d4a9 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () at /usr/lib/libQt5Core.so.5
|
#30 0x00007ffff55a39a4 in () at /usr/lib/libQt5Core.so.5
|
#31 0x00007fffe449210c in g_main_context_dispatch () at /usr/lib/libglib-2.0.so.0
|
#32 0x00007fffe44e5b99 in () at /usr/lib/libglib-2.0.so.0
|
#33 0x00007fffe448f871 in g_main_context_iteration () at /usr/lib/libglib-2.0.so.0
|
#34 0x00007ffff55a2fd6 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/libQt5Core.so.5
|
#35 0x00007ffff5548d1c in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/libQt5Core.so.5
|
#36 0x00007ffff623325e in QDialog::exec() () at /usr/lib/libQt5Widgets.so.5
|
#37 0x00007ffff70498e3 in Digikam::FilesDownloader::startDownload() () at /usr/lib/libdigikamcore.so.7.3.0
|
#38 0x000055555555a71b in ()
|
#39 0x00007ffff4eb9b25 in __libc_start_main () at /usr/lib/libc.so.6
|
#40 0x000055555555bece in _start ()
|
Downstream report: https://bugs.kde.org/show_bug.cgi?id=440296
Attachments
Issue Links
- is caused by
-
MDEV-19237 Skip sending metadata when possible for binary protocol
- Closed
- links to