Bug 465977 - ASSERT failure in Uils::exec: "Query failed:UNIQUE constraint failed: ResourceInfo.targettedResource
Summary: ASSERT failure in Uils::exec: "Query failed:UNIQUE constraint failed: Resourc...
Status: REPORTED
Alias: None
Product: plasmashell
Classification: Plasma
Component: Activities in general (show other bugs)
Version: 5.27.0
Platform: Arch Linux Linux
: NOR normal
Target Milestone: 1.0
Assignee: Ivan Čukić
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-18 03:09 UTC by Dāvis
Modified: 2024-12-17 21:42 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Dāvis 2023-02-18 03:09:12 UTC 
SUMMARY

Hit this assert

```
org.kde.kactivities.resources: "INSERT INTO ResourceInfo(   targettedResource, title, autoTitle, mimetype, autoMimetype) VALUES (  :targettedResource, '' , 1 , '' , 1 )"
org.kde.kactivities.resources: QSqlError("1555", "Nevarēja saņemt rindu", "UNIQUE constraint failed: ResourceInfo.targettedResource")
ASSERT failure in Uils::exec: "Query failed:UNIQUE constraint failed: ResourceInfo.targettedResource Nevarēja saņemt rindu", file /mnt/KDE/kactivitymanagerd/src/service/plugins/sqlite/Utils.h, line 54
```

```
#2  0x00007f3a39a51ea8 in __GI_raise (sig=6) at ../sysdeps/posix/raise.c:26
#3  0x00007f3a3b7d876e in KCrash::defaultCrashHandler (sig=6) at /usr/src/debug/kcrash-git/kcrash/src/kcrash.cpp:597
#4  <signal handler called>
#5  __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at pthread_kill.c:44
#6  0x00007f3a39aa0953 in __pthread_kill_internal (signo=6, threadid=<optimized out>) at pthread_kill.c:78
#7  0x00007f3a39a51ea8 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#8  0x00007f3a39a3b53d in __GI_abort () at abort.c:79
#9  0x00007f3a3a0a41c7 in qAbort () at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/global/qglobal.cpp:3369
#10 0x00007f3a3a0a449a in qt_message_fatal (message=<synthetic pointer>..., context=...) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/global/qlogging.cpp:1916
#11 QMessageLogger::fatal (this=this@entry=0x7fff18533f58, msg=msg@entry=0x7f3a3a3bad58 "ASSERT failure in %s: \"%s\", file %s, line %d") at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/global/qlogging.cpp:850
#12 0x00007f3a3a0a4559 in qt_assert_x (where=where@entry=0x7f3a26d52fca "Uils::exec", what=<optimized out>, file=file@entry=0x7f3a26d52a90 "/mnt/Dati/Git/KDE/kactivitymanagerd/src/service/plugins/sqlite/Utils.h", line=line@entry=54) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/global/qglobal.cpp:3284
#13 0x00007f3a26d2b80e in Utils::exec (eh=<optimized out>, query=..., database=...) at /mnt/Dati/Git/KDE/kactivitymanagerd/src/service/plugins/sqlite/Utils.h:54
#14 0x00007f3a26d355d2 in Utils::exec<char [19], QString> (database=..., value=..., variable=..., query=..., eh=Utils::FailOnError) at /mnt/Dati/Git/KDE/kactivitymanagerd/src/service/plugins/sqlite/Utils.h:69
#15 StatsPlugin::insertResourceInfo (this=this@entry=0x561a80cec220, uri=...) at /mnt/Dati/Git/KDE/kactivitymanagerd/src/service/plugins/sqlite/StatsPlugin.cpp:239
#16 0x00007f3a26d359df in StatsPlugin::saveResourceMimetype (this=0x561a80cec220, uri=..., mimetype=..., autoMimetype=<optimized out>) at /mnt/Dati/Git/KDE/kactivitymanagerd/src/service/plugins/sqlite/StatsPlugin.cpp:271
#17 0x00007f3a3a16bd00 in QObject::event (this=0x561a80cec220, e=0x561a80d00410) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/kernel/qobject.cpp:1378
#18 0x00007f3a3b1759bc in QApplicationPrivate::notify_helper (this=<optimized out>, receiver=0x561a80cec220, e=0x561a80d00410) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/widgets/kernel/qapplication.cpp:3315
#19 0x00007f3a3a12a258 in QCoreApplication::notifyInternal2 (receiver=0x561a80cec220, event=0x561a80d00410) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/kernel/qcoreapplication.cpp:1026
#20 0x00007f3a3a12a42b in QCoreApplicationPrivate::sendPostedEvents (receiver=0x0, event_type=0, data=0x561a80bb63a0) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/kernel/qcoreapplication.cpp:1804
#21 0x00007f3a3a34f348 in postEventSourceDispatch (s=0x561a80bb7820) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/kernel/qeventdispatcher_glib.cpp:243
#22 0x00007f3a3984782b in g_main_dispatch (context=0x7f3a30005040) at ../glib/glib/gmain.c:3454
#23 g_main_context_dispatch (context=0x7f3a30005040) at ../glib/glib/gmain.c:4172
#24 0x00007f3a3989ecc9 in g_main_context_iterate.constprop.0 (context=0x7f3a30005040, block=1, dispatch=1, self=<optimized out>) at ../glib/glib/gmain.c:4248
#25 0x00007f3a398460e2 in g_main_context_iteration (context=0x7f3a30005040, may_block=1) at ../glib/glib/gmain.c:4313
#26 0x00007f3a3a34d382 in QEventDispatcherGlib::processEvents (this=0x561a80c111c0, flags=...) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/kernel/qeventdispatcher_glib.cpp:393
#27 0x00007f3a3a135604 in QEventLoop::exec (this=0x7fff18534630, flags=...) at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/global/qflags.h:34
#28 0x00007f3a3a12ce7b in QCoreApplication::exec () at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/corelib/global/qflags.h:74
#29 0x00007f3a3a9954b2 in QGuiApplication::exec () at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/gui/kernel/qguiapplication.cpp:1859
#30 0x00007f3a3b1676da in QApplication::exec () at /usr/src/debug/qt6-base/qtbase-everywhere-src-6.4.2/src/widgets/kernel/qapplication.cpp:2595
#31 0x0000561a802f102b in main (argc=<optimized out>, argv=<optimized out>) at /mnt/KDE/kactivitymanagerd/src/service/Application.cpp:277
```

Maybe this is expected to happen and assert can be just removed?

SOFTWARE/OS VERSIONS
KDE Frameworks Version: 6.0
Qt Version: 6.4.2

ADDITIONAL INFORMATION