Bug 351444

Summary: opening mysql database crash
Product: [Applications] KEXI Reporter: Bill Newton <spiderbill>
Component: Migration/Import/ExportAssignee: Kexi Bugs <kexi-bugs>
Status: RESOLVED WORKSFORME    
Severity: crash CC: adam, inksi, staniek
Priority: NOR Keywords: drkonqi, triaged
Version: 2.9.5   
Target Milestone: ---   
Platform: Fedora RPMs   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: attachment-8028-0.html

Description Bill Newton 2015-08-18 13:59:33 UTC
Application: kexi (2.9.5)
KDE Platform Version: 4.14.9
Qt Version: 4.8.6
Operating System: Linux 4.0.8-200.fc21.x86_64 x86_64
Distribution: "Fedora release 21 (Twenty One)"

-- Information about the crash:
Trying to open a mysql database causes a hard crash. Not sure why, this is the first time I've tried using the app.

The crash can be reproduced every time.

-- Backtrace:
Application: Kexi (kexi), signal: Segmentation fault
Using host libthread_db library "/lib64/libthread_db.so.1".
81	T_PSEUDO (SYSCALL_SYMBOL, SYSCALL_NAME, SYSCALL_NARGS)
[Current thread is 1 (Thread 0x7f095d2398c0 (LWP 21121))]

Thread 2 (Thread 0x7f0912c6f700 (LWP 21220)):
#0  0x00007f0956000c8d in poll () at ../sysdeps/unix/syscall-template.S:81
#1  0x00007f094f928b34 in g_main_context_iterate.isra () at /lib64/libglib-2.0.so.0
#2  0x00007f094f928c4c in g_main_context_iteration () at /lib64/libglib-2.0.so.0
#3  0x00007f095714557e in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=0x7f090c0008c0, flags=...) at kernel/qeventdispatcher_glib.cpp:452
#4  0x00007f0957114d81 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=this@entry=0x7f0912c6ecc0, flags=...) at kernel/qeventloop.cpp:149
#5  0x00007f09571150e5 in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) (this=this@entry=0x7f0912c6ecc0, flags=...) at kernel/qeventloop.cpp:204
#6  0x00007f0957009bb9 in QThread::exec() (this=this@entry=0x1ffb420) at thread/qthread.cpp:538
#7  0x00007f09570f56e3 in QInotifyFileSystemWatcherEngine::run() (this=0x1ffb420) at io/qfilesystemwatcher_inotify.cpp:265
#8  0x00007f095700c41f in QThreadPrivate::start(void*) (arg=0x1ffb420) at thread/qthread_unix.cpp:349
#9  0x00007f0956d7b52a in start_thread (arg=0x7f0912c6f700) at pthread_create.c:310
#10 0x00007f095600c22d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 1 (Thread 0x7f095d2398c0 (LWP 21121)):
[KCrash Handler]
#6  0x00007f0953d5eda4 in KexiMigration::ImportWizard::next() () at /lib64/libkeximigrate.so.14
#7  0x00007f095712ad9c in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) (sender=sender@entry=0x1d89600, m=m@entry=0x7f09594b1120 <KDialog::staticMetaObject>, local_signal_index=local_signal_index@entry=5, argv=argv@entry=0x0) at kernel/qobject.cpp:3567
#8  0x00007f0958fead03 in KDialog::user2Clicked() (this=this@entry=0x1d89600) at /usr/src/debug/kdelibs-4.14.9/x86_64-redhat-linux-gnu/kdeui/kdialog.moc:247
#9  0x00007f0958feb470 in KDialog::slotButtonClicked(int) (this=0x1d89600, button=8192) at /usr/src/debug/kdelibs-4.14.9/kdeui/dialogs/kdialog.cpp:897
#10 0x00007f0958fecf2f in KDialog::qt_static_metacall(QObject*, QMetaObject::Call, int, void**) (_o=<optimized out>, _id=<optimized out>, _a=<optimized out>, _c=<optimized out>) at /usr/src/debug/kdelibs-4.14.9/x86_64-redhat-linux-gnu/kdeui/kdialog.moc:166
#11 0x00007f095712ad9c in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) (sender=sender@entry=0x2287280, m=m@entry=0x7f0957479480 <QSignalMapper::staticMetaObject>, local_signal_index=local_signal_index@entry=0, argv=argv@entry=0x7ffccc614160) at kernel/qobject.cpp:3567
#12 0x00007f095713295e in QSignalMapper::mapped(int) (this=this@entry=0x2287280, _t1=8192) at .moc/release-shared/moc_qsignalmapper.cpp:114
#13 0x00007f0957132ae6 in QSignalMapper::map(QObject*) (this=0x2287280, sender=0x20127d0) at kernel/qsignalmapper.cpp:266
#14 0x00007f095712ad9c in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) (sender=sender@entry=0x20127d0, m=m@entry=0x7f09583af820 <QAbstractButton::staticMetaObject>, local_signal_index=local_signal_index@entry=2, argv=argv@entry=0x7ffccc6142e0) at kernel/qobject.cpp:3567
#15 0x00007f0957f2e1e2 in QAbstractButton::clicked(bool) (this=this@entry=0x20127d0, _t1=false) at .moc/release-shared/moc_qabstractbutton.cpp:219
#16 0x00007f0957c6e4e3 in QAbstractButtonPrivate::emitClicked() (this=this@entry=0x2045b00) at widgets/qabstractbutton.cpp:548
#17 0x00007f0957c6f924 in QAbstractButtonPrivate::click() (this=this@entry=0x2045b00) at widgets/qabstractbutton.cpp:541
#18 0x00007f0957c6fa34 in QAbstractButton::mouseReleaseEvent(QMouseEvent*) (this=0x20127d0, e=0x7ffccc614840) at widgets/qabstractbutton.cpp:1123
#19 0x00007f09578f2118 in QWidget::event(QEvent*) (this=0x20127d0, event=0x7ffccc614840) at kernel/qwidget.cpp:8775
#20 0x00007f095789eefc in QApplicationPrivate::notify_helper(QObject*, QEvent*) (this=0x1578b50, receiver=0x20127d0, e=0x7ffccc614840) at kernel/qapplication.cpp:4565
#21 0x00007f09578a5abf in QApplication::notify(QObject*, QEvent*) (this=this@entry=0x1566680, receiver=receiver@entry=0x20127d0, e=e@entry=0x7ffccc614840) at kernel/qapplication.cpp:4108
#22 0x00007f0959092e0a in KApplication::notify(QObject*, QEvent*) (this=0x1566680, receiver=0x20127d0, event=0x7ffccc614840) at /usr/src/debug/kdelibs-4.14.9/kdeui/kernel/kapplication.cpp:311
#23 0x00007f095711622d in QCoreApplication::notifyInternal(QObject*, QEvent*) (this=0x1566680, receiver=0x20127d0, event=0x7ffccc614840) at kernel/qcoreapplication.cpp:953
#24 0x00007f09578a511f in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) (receiver=receiver@entry=0x20127d0, event=event@entry=0x7ffccc614840, alienWidget=alienWidget@entry=0x20127d0, nativeWidget=nativeWidget@entry=0x2066bf0, buttonDown=buttonDown@entry=0x7f09583c1478 <qt_button_down>, lastMouseReceiver=..., spontaneous=true) at ../../src/corelib/kernel/qcoreapplication.h:231
#25 0x00007f095791b562 in QETWidget::translateMouseEvent(_XEvent const*) (this=this@entry=0x2066bf0, event=event@entry=0x7ffccc614ba0) at kernel/qapplication_x11.cpp:4540
#26 0x00007f0957919f5c in QApplication::x11ProcessEvent(_XEvent*) (this=0x1566680, event=event@entry=0x7ffccc614ba0) at kernel/qapplication_x11.cpp:3663
#27 0x00007f0957941ff4 in x11EventSourceDispatch(GSource*, GSourceFunc, gpointer) (s=0x1580540, callback=0x0, user_data=0x0) at kernel/qguieventdispatcher_glib.cpp:148
#28 0x00007f094f9287fb in g_main_context_dispatch () at /lib64/libglib-2.0.so.0
#29 0x00007f094f928b98 in g_main_context_iterate.isra () at /lib64/libglib-2.0.so.0
#30 0x00007f094f928c4c in g_main_context_iteration () at /lib64/libglib-2.0.so.0
#31 0x00007f095714557e in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=0x15329b0, flags=...) at kernel/qeventdispatcher_glib.cpp:452
#32 0x00007f0957942176 in QGuiEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=<optimized out>, flags=...) at kernel/qguieventdispatcher_glib.cpp:207
#33 0x00007f0957114d81 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=this@entry=0x7ffccc614f90, flags=...) at kernel/qeventloop.cpp:149
#34 0x00007f09571150e5 in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) (this=this@entry=0x7ffccc614f90, flags=...) at kernel/qeventloop.cpp:204
#35 0x00007f0957d7191c in QDialog::exec() (this=0x1d89600) at dialogs/qdialog.cpp:562
#36 0x00007f095c81fb08 in KexiMainWindow::showProjectMigrationWizard(QString const&, QString const&, KexiDB::ConnectionData const*) () at /lib64/libkeximain.so.14
#37 0x00007f095c8205e5 in KexiMainWindow::openProject(KexiProjectData const&) () at /lib64/libkeximain.so.14
#38 0x00007f095c821ed7 in KexiMainWindow::qt_static_metacall(QObject*, QMetaObject::Call, int, void**) [clone .part.155] () at /lib64/libkeximain.so.14
#39 0x00007f095712ad9c in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) (sender=0x201a950, m=<optimized out>, local_signal_index=<optimized out>, argv=0x7ffccc6153f0) at kernel/qobject.cpp:3567
#40 0x00007f095c847637 in KexiOpenProjectAssistant::slotOpenProject(KexiProjectData*) () at /lib64/libkeximain.so.14
#41 0x00007f095c847b2c in KexiOpenProjectAssistant::qt_static_metacall(QObject*, QMetaObject::Call, int, void**) [clone .part.5] () at /lib64/libkeximain.so.14
#42 0x00007f095712ad9c in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) (sender=0x20a98d0, m=<optimized out>, local_signal_index=<optimized out>, argv=0x7ffccc615560) at kernel/qobject.cpp:3567
#43 0x00007f09541d6aef in KexiProjectSelectorWidget::projectExecuted(KexiProjectData*) () at /lib64/libkexiextendedwidgets.so.14
#44 0x00007f095712ad9c in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) (sender=0x1e36d30, m=m@entry=0x7f09583a5300 <QTreeWidget::staticMetaObject>, local_signal_index=local_signal_index@entry=2, argv=argv@entry=0x7ffccc6156a0) at kernel/qobject.cpp:3567
#45 0x00007f0957e3d2f0 in QTreeWidget::itemDoubleClicked(QTreeWidgetItem*, int) (this=<optimized out>, _t1=0x1e24e70, _t2=0) at .moc/release-shared/moc_qtreewidget.cpp:227
#46 0x00007f095712ad9c in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) (sender=0x1e36d30, m=m@entry=0x7f09583a2900 <QAbstractItemView::staticMetaObject>, local_signal_index=local_signal_index@entry=2, argv=argv@entry=0x7ffccc6157d0) at kernel/qobject.cpp:3567
#47 0x00007f0957dc4945 in QAbstractItemView::doubleClicked(QModelIndex const&) (this=<optimized out>, _t1=...) at .moc/release-shared/moc_qabstractitemview.cpp:354
#48 0x00007f0957e0e963 in QTreeView::mouseDoubleClickEvent(QMouseEvent*) (this=0x1e36d30, event=0x7ffccc615f60) at itemviews/qtreeview.cpp:1867
#49 0x00007f09578f2c77 in QWidget::event(QEvent*) (this=this@entry=0x1e36d30, event=event@entry=0x7ffccc615f60) at kernel/qwidget.cpp:8393
#50 0x00007f0957cb249e in QFrame::event(QEvent*) (this=0x1e36d30, e=0x7ffccc615f60) at widgets/qframe.cpp:557
#51 0x00007f0957dce7b3 in QAbstractItemView::viewportEvent(QEvent*) (this=0x1e36d30, event=0x7ffccc615f60) at itemviews/qabstractitemview.cpp:1644
#52 0x00007f0957e10b30 in QTreeView::viewportEvent(QEvent*) (this=0x1e36d30, event=0x7ffccc615f60) at itemviews/qtreeview.cpp:1252
#53 0x00007f0957116396 in QCoreApplicationPrivate::sendThroughObjectEventFilters(QObject*, QEvent*) (this=<optimized out>, receiver=0x2075630, event=0x7ffccc615f60) at kernel/qcoreapplication.cpp:1063
#54 0x00007f095789eedc in QApplicationPrivate::notify_helper(QObject*, QEvent*) (this=0x1578b50, receiver=0x2075630, e=0x7ffccc615f60) at kernel/qapplication.cpp:4561
#55 0x00007f09578a5abf in QApplication::notify(QObject*, QEvent*) (this=this@entry=0x1566680, receiver=receiver@entry=0x2075630, e=e@entry=0x7ffccc615f60) at kernel/qapplication.cpp:4108
#56 0x00007f0959092e0a in KApplication::notify(QObject*, QEvent*) (this=0x1566680, receiver=0x2075630, event=0x7ffccc615f60) at /usr/src/debug/kdelibs-4.14.9/kdeui/kernel/kapplication.cpp:311
#57 0x00007f095711622d in QCoreApplication::notifyInternal(QObject*, QEvent*) (this=0x1566680, receiver=0x2075630, event=0x7ffccc615f60) at kernel/qcoreapplication.cpp:953
#58 0x00007f09578a511f in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) (receiver=receiver@entry=0x2075630, event=event@entry=0x7ffccc615f60, alienWidget=alienWidget@entry=0x2075630, nativeWidget=nativeWidget@entry=0x1dce2d0, buttonDown=buttonDown@entry=0x7f09583c1478 <qt_button_down>, lastMouseReceiver=..., spontaneous=true) at ../../src/corelib/kernel/qcoreapplication.h:231
#59 0x00007f095791b562 in QETWidget::translateMouseEvent(_XEvent const*) (this=this@entry=0x1dce2d0, event=event@entry=0x7ffccc6162c0) at kernel/qapplication_x11.cpp:4540
#60 0x00007f0957919f5c in QApplication::x11ProcessEvent(_XEvent*) (this=0x1566680, event=event@entry=0x7ffccc6162c0) at kernel/qapplication_x11.cpp:3663
#61 0x00007f0957941ff4 in x11EventSourceDispatch(GSource*, GSourceFunc, gpointer) (s=0x1580540, callback=0x0, user_data=0x0) at kernel/qguieventdispatcher_glib.cpp:148
#62 0x00007f094f9287fb in g_main_context_dispatch () at /lib64/libglib-2.0.so.0
#63 0x00007f094f928b98 in g_main_context_iterate.isra () at /lib64/libglib-2.0.so.0
#64 0x00007f094f928c4c in g_main_context_iteration () at /lib64/libglib-2.0.so.0
#65 0x00007f095714555e in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=0x15329b0, flags=...) at kernel/qeventdispatcher_glib.cpp:450
#66 0x00007f0957942176 in QGuiEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=<optimized out>, flags=...) at kernel/qguieventdispatcher_glib.cpp:207
#67 0x00007f0957114d81 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) (this=this@entry=0x7ffccc6166a0, flags=...) at kernel/qeventloop.cpp:149
#68 0x00007f09571150e5 in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) (this=this@entry=0x7ffccc6166a0, flags=...) at kernel/qeventloop.cpp:204
#69 0x00007f095711a7c9 in QCoreApplication::exec() () at kernel/qcoreapplication.cpp:1225
#70 0x0000000000400b51 in main ()

The reporter indicates this bug may be a duplicate of or related to bug 240343.

Possible duplicates by query: bug 332315.

Reported using DrKonqi
Comment 1 Jarosław Staniek 2015-08-24 12:51:47 UTC
@Bill Newton
Thanks for the report. 

From the backtrace it looks like an issue with importing an existing externally-created MySQL database, not opening 'own' one.

Knowing at least a schema of table that causes the bug would be a first step. You can send me it privately as a SQL dump if it's secret or attach below (preferred).

Sometimes specific data is the factor.

Finally, sometimes specific MySQL server configuration is the factor.

See also A4.2 at http://kexi-project.org/wiki/wikiview/index.php@KexiFAQ.html#4._Database_Support_&_Data_Migration
Comment 2 Bill Newton 2015-08-24 21:37:05 UTC
Created attachment 94208 [details]
attachment-8028-0.html

Hi Jarosław,

Thanks for the quick response! Unfortunately, I'm prohibited by a NDA from
sharing the schema. But, I might be able to reproduce it with a different
schema that has some of the same traits.

Cheers,

Bill

On Mon, Aug 24, 2015, 7:51 AM Jarosław Staniek <staniek@kde.org> wrote:

> https://bugs.kde.org/show_bug.cgi?id=351444
>
> Jarosław Staniek <staniek@kde.org> changed:
>
>            What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>              Status|UNCONFIRMED                 |NEEDSINFO
>          Resolution|---                         |WAITINGFORINFO
>                  CC|                            |staniek@kde.org
>
> --- Comment #1 from Jarosław Staniek <staniek@kde.org> ---
> @Bill Newton
> Thanks for the report.
>
> From the backtrace it looks like an issue with importing an existing
> externally-created MySQL database, not opening 'own' one.
>
> Knowing at least a schema of table that causes the bug would be a first
> step.
> You can send me it privately as a SQL dump if it's secret or attach below
> (preferred).
>
> Sometimes specific data is the factor.
>
> Finally, sometimes specific MySQL server configuration is the factor.
>
> See also A4.2 at
>
> http://kexi-project.org/wiki/wikiview/index.php@KexiFAQ.html#4._Database_Support_&_Data_Migration
>
> --
> You are receiving this mail because:
> You reported the bug.
Comment 3 Jarosław Staniek 2015-08-24 22:26:02 UTC
> But, I might be able to reproduce it with a different schema that has some of the same traits.

Thanks Bill,  this would help.
Comment 4 Andrew Crouthamel 2018-09-25 21:40:37 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days, the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information.

For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please set the bug status as REPORTED so that the KDE team knows that the bug is ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 5 Andrew Crouthamel 2018-10-27 02:03:05 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least 30 days. The bug is now closed as RESOLVED > WORKSFORME due to lack of needed information.

For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!