Bug 273063

Summary:	Crash when importing a csv table
Product:	[Applications] KEXI	Reporter:	robert leleu <robert.jean.leleu>
Component:	Migration/Import/Export	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED FIXED
Severity:	crash	CC:	robert.jean.leleu
Priority:	NOR
Version First Reported In:	2.3.3 (KOffice 2.3.3)
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:	2.4 (Calligra 2.4)
Sentry Crash Report:
Attachments:	the file of the bug report another csv file a silly view of the file to import

Description robert leleu 2011-05-11 19:12:56 UTC

Application: kexi (2.3.3 (KOffice 2.3.3))
KDE Platform Version: 4.6.2 (4.6.2)
Qt Version: 4.7.2
Operating System: Linux 2.6.38-8-generic-pae i686
Distribution: Ubuntu 11.04

-- Information about the crash:
- What I was doing when the application crashed:
Importing a csv table with names in first line and 1772 lines

Kexi didn't recognized the names, imported some, and crashed.
There was an advice tellint that the file had more than 100 lines

-- Backtrace:
Application: Kexi (kexi), signal: Segmentation fault
[Current thread is 1 (Thread 0xb2d50720 (LWP 16893))]

Thread 3 (Thread 0xb287cb70 (LWP 16895)):
#0  0xb7766424 in __kernel_vsyscall ()
#1  0xb6922f76 in poll () from /lib/i386-linux-gnu/libc.so.6
#2  0xb57d884b in g_poll () from /lib/i386-linux-gnu/libglib-2.0.so.0
#3  0xb57c81af in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#4  0xb57c892b in g_main_loop_run () from /lib/i386-linux-gnu/libglib-2.0.so.0
#5  0xb29b5304 in ?? () from /usr/lib/i386-linux-gnu/libgio-2.0.so.0
#6  0xb57f12df in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#7  0xb587ae99 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#8  0xb693173e in clone () from /lib/i386-linux-gnu/libc.so.6

Thread 2 (Thread 0xaa8d8b70 (LWP 16897)):
#0  0xb7766424 in __kernel_vsyscall ()
#1  0xb6922f76 in poll () from /lib/i386-linux-gnu/libc.so.6
#2  0xb57d884b in g_poll () from /lib/i386-linux-gnu/libglib-2.0.so.0
#3  0xb57c81af in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#4  0xb57c8524 in g_main_context_iteration () from /lib/i386-linux-gnu/libglib-2.0.so.0
#5  0xb6b44577 in QEventDispatcherGlib::processEvents (this=0x8d48660, flags=...) at kernel/qeventdispatcher_glib.cpp:424
#6  0xb6b16289 in QEventLoop::processEvents (this=0xaa8d8280, flags=...) at kernel/qeventloop.cpp:149
#7  0xb6b16522 in QEventLoop::exec (this=0xaa8d8280, flags=...) at kernel/qeventloop.cpp:201
#8  0xb6a202a0 in QThread::exec (this=0x8d434c8) at thread/qthread.cpp:492
#9  0xb6af7fdb in QInotifyFileSystemWatcherEngine::run (this=0x8d434c8) at io/qfilesystemwatcher_inotify.cpp:248
#10 0xb6a22da2 in QThreadPrivate::start (arg=0x8d434c8) at thread/qthread_unix.cpp:320
#11 0xb587ae99 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#12 0xb693173e in clone () from /lib/i386-linux-gnu/libc.so.6

Thread 1 (Thread 0xb2d50720 (LWP 16893)):
[KCrash Handler]
#7  KexiDB::Field::type (this=0x30) at ../../../kexi/kexidb/field.cpp:138
#8  0xb67e3551 in valueToSQL (this=0x8d594a8, fields=..., values=...) at ../../../kexi/kexidb/driver.h:236
#9  KexiDB::Connection::insertRecord (this=0x8d594a8, fields=..., values=...) at ../../../kexi/kexidb/connection.cpp:1166
#10 0xa9f48ff2 in KexiDB::MySqlPreparedStatement::execute (this=0x8fe11a8) at ../../../../../kexi/kexidb/drivers/mySQL/mysqlpreparedstatement.cpp:288
#11 0xa8a42343 in KexiCSVImportDialog::saveRow (this=0x8fbee60, inGUI=false) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1264
#12 0xa8a4594d in KexiCSVImportDialog::loadRows (this=0x8fbee60, field=..., row=@0xbfaba0e4, column=@0xbfaba0e0, maxColumn=@0xbfaba0dc, inGUI=false) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:888
#13 0xa8a4ba6b in KexiCSVImportDialog::accept (this=0x8fbee60) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1602
#14 0xb5d4c13b in KDialog::slotButtonClicked (this=0x8fbee60, button=4) at ../../kdeui/dialogs/kdialog.cpp:884
#15 0xb5d4c5bc in KDialog::qt_metacall (this=0x8fbee60, _c=QMetaObject::InvokeMetaMethod, _id=33, _a=0xbfaba3b8) at ./kdialog.moc:190
#16 0xa8a49eba in KexiCSVImportDialog::qt_metacall (this=0x8fbee60, _c=QMetaObject::InvokeMetaMethod, _id=69, _a=0xbfaba3b8) at ./kexicsvimportdialog.moc:89
#17 0xb6b1d6ba in QMetaObject::metacall (object=0x8fbee60, cl=QMetaObject::InvokeMetaMethod, idx=69, argv=0xbfaba3b8) at kernel/qmetaobject.cpp:237
#18 0xb6b2d4ff in QMetaObject::activate (sender=0x8f6b3a4, m=0xb6c510f8, local_signal_index=0, argv=0xbfaba3b8) at kernel/qobject.cpp:3287
#19 0xb6b31413 in QSignalMapper::mapped (this=0x8f6b3a4, _t1=4) at .moc/release-shared/moc_qsignalmapper.cpp:101
#20 0xb6b3155f in QSignalMapper::map (this=0x8f6b3a4, sender=0x8f91628) at kernel/qsignalmapper.cpp:266
#21 0xb6b3171e in QSignalMapper::map (this=0x8f6b3a4) at kernel/qsignalmapper.cpp:257
#22 0xb6b31c0b in QSignalMapper::qt_metacall (this=0x8f6b3a4, _c=QMetaObject::InvokeMetaMethod, _id=4, _a=0xbfaba548) at .moc/release-shared/moc_qsignalmapper.cpp:87
#23 0xb6b1d6ba in QMetaObject::metacall (object=0x8f6b3a4, cl=QMetaObject::InvokeMetaMethod, idx=8, argv=0xbfaba548) at kernel/qmetaobject.cpp:237
#24 0xb6b2d4ff in QMetaObject::activate (sender=0x8f91628, m=0xb76c6884, local_signal_index=2, argv=0xbfaba548) at kernel/qobject.cpp:3287
#25 0xb746bd39 in QAbstractButton::clicked (this=0x8f91628, _t1=false) at .moc/release-shared/moc_qabstractbutton.cpp:206
#26 0xb7183896 in QAbstractButtonPrivate::emitClicked (this=0x8fb10a8) at widgets/qabstractbutton.cpp:546
#27 0xb7185104 in QAbstractButtonPrivate::click (this=0x8fb10a8) at widgets/qabstractbutton.cpp:539
#28 0xb71853be in QAbstractButton::mouseReleaseEvent (this=0x8f91628, e=0xbfabaca4) at widgets/qabstractbutton.cpp:1121
#29 0xb6ddb13a in QWidget::event (this=0x8f91628, event=0xbfabaca4) at kernel/qwidget.cpp:8259
#30 0xb718440e in QAbstractButton::event (this=0x8f91628, e=0xbfabaca4) at widgets/qabstractbutton.cpp:1080
#31 0xb72221c2 in QPushButton::event (this=0x8f91628, e=0xbfabaca4) at widgets/qpushbutton.cpp:683
#32 0xb6d82d24 in QApplicationPrivate::notify_helper (this=0x8799960, receiver=0x8f91628, e=0xbfabaca4) at kernel/qapplication.cpp:4462
#33 0xb6d88201 in QApplication::notify (this=0x8793f68, receiver=0x8f91628, e=0xbfabaca4) at kernel/qapplication.cpp:4023
#34 0xb5dfc3ca in KApplication::notify (this=0x8793f68, receiver=0x8f91628, event=0xbfabaca4) at ../../kdeui/kernel/kapplication.cpp:311
#35 0xb6b170bb in QCoreApplication::notifyInternal (this=0x8793f68, receiver=0x8f91628, event=0xbfabaca4) at kernel/qcoreapplication.cpp:731
#36 0xb6d83c3b in sendSpontaneousEvent (receiver=0x8f91628, event=0xbfabaca4, alienWidget=0x8f91628, nativeWidget=0x8f63450, buttonDown=0xb76cfc60, lastMouseReceiver=..., spontaneous=true) at ../../include/QtCore/../../src/corelib/kernel/qcoreapplication.h:218
#37 QApplicationPrivate::sendMouseEvent (receiver=0x8f91628, event=0xbfabaca4, alienWidget=0x8f91628, nativeWidget=0x8f63450, buttonDown=0xb76cfc60, lastMouseReceiver=..., spontaneous=true) at kernel/qapplication.cpp:3120
#38 0xb6e0d2bc in QETWidget::translateMouseEvent (this=0x8f63450, event=0xbfabb1cc) at kernel/qapplication_x11.cpp:4556
#39 0xb6e0b746 in QApplication::x11ProcessEvent (this=0x8793f68, event=0xbfabb1cc) at kernel/qapplication_x11.cpp:3678
#40 0xb6e36b84 in x11EventSourceDispatch (s=0x879d2a8, callback=0, user_data=0x0) at kernel/qguieventdispatcher_glib.cpp:146
#41 0xb57c7aa8 in g_main_context_dispatch () from /lib/i386-linux-gnu/libglib-2.0.so.0
#42 0xb57c8270 in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#43 0xb57c8524 in g_main_context_iteration () from /lib/i386-linux-gnu/libglib-2.0.so.0
#44 0xb6b4453c in QEventDispatcherGlib::processEvents (this=0x8759f68, flags=...) at kernel/qeventdispatcher_glib.cpp:422
#45 0xb6e36775 in QGuiEventDispatcherGlib::processEvents (this=0x8759f68, flags=...) at kernel/qguieventdispatcher_glib.cpp:204
#46 0xb6b16289 in QEventLoop::processEvents (this=0xbfabb4a0, flags=...) at kernel/qeventloop.cpp:149
#47 0xb6b16522 in QEventLoop::exec (this=0xbfabb4a0, flags=...) at kernel/qeventloop.cpp:201
#48 0xb72a0003 in QDialog::exec (this=0x8fbee60) at dialogs/qdialog.cpp:552
#49 0xb77048d1 in KexiMainWindow::slotProjectImportDataTable (this=0x8de0fa0) at ../../../kexi/main/KexiMainWindow.cpp:4914
#50 0xb771291c in KexiMainWindow::qt_metacall (this=0x8de0fa0, _c=QMetaObject::InvokeMetaMethod, _id=64, _a=0xbfabb6b8) at ./KexiMainWindow.moc:478
#51 0xb6b1d6ba in QMetaObject::metacall (object=0x8de0fa0, cl=QMetaObject::InvokeMetaMethod, idx=91, argv=0xbfabb6b8) at kernel/qmetaobject.cpp:237
#52 0xb6b2d4ff in QMetaObject::activate (sender=0x8de16f8, m=0xb76b33f8, local_signal_index=1, argv=0xbfabb6b8) at kernel/qobject.cpp:3287
#53 0xb6d7b8d9 in QAction::triggered (this=0x8de16f8, _t1=false) at .moc/release-shared/moc_qaction.cpp:263
#54 0xb6d7bb38 in QAction::activate (this=0x8de16f8, event=QAction::Trigger) at kernel/qaction.cpp:1257
#55 0xb7256252 in trigger (this=0x8d67000) at ../../include/QtGui/../../src/gui/kernel/qaction.h:218
#56 QToolButton::nextCheckState (this=0x8d67000) at widgets/qtoolbutton.cpp:1147
#57 0xb71850c3 in QAbstractButtonPrivate::click (this=0x8e88e08) at widgets/qabstractbutton.cpp:528
#58 0xb71853be in QAbstractButton::mouseReleaseEvent (this=0x8d67000, e=0xbfabbe44) at widgets/qabstractbutton.cpp:1121
#59 0xb725633c in QToolButton::mouseReleaseEvent (this=0x8d67000, e=0xbfabbe44) at widgets/qtoolbutton.cpp:721
#60 0xb6ddb13a in QWidget::event (this=0x8d67000, event=0xbfabbe44) at kernel/qwidget.cpp:8259
#61 0xb718440e in QAbstractButton::event (this=0x8d67000, e=0xbfabbe44) at widgets/qabstractbutton.cpp:1080
#62 0xb7257a6a in QToolButton::event (this=0x8d67000, event=0xbfabbe44) at widgets/qtoolbutton.cpp:1163
#63 0xb6d82d24 in QApplicationPrivate::notify_helper (this=0x8799960, receiver=0x8d67000, e=0xbfabbe44) at kernel/qapplication.cpp:4462
#64 0xb6d88201 in QApplication::notify (this=0x8793f68, receiver=0x8d67000, e=0xbfabbe44) at kernel/qapplication.cpp:4023
#65 0xb5dfc3ca in KApplication::notify (this=0x8793f68, receiver=0x8d67000, event=0xbfabbe44) at ../../kdeui/kernel/kapplication.cpp:311
#66 0xb6b170bb in QCoreApplication::notifyInternal (this=0x8793f68, receiver=0x8d67000, event=0xbfabbe44) at kernel/qcoreapplication.cpp:731
#67 0xb6d83c3b in sendSpontaneousEvent (receiver=0x8d67000, event=0xbfabbe44, alienWidget=0x8d67000, nativeWidget=0x8d3ce88, buttonDown=0xb76cfc60, lastMouseReceiver=..., spontaneous=true) at ../../include/QtCore/../../src/corelib/kernel/qcoreapplication.h:218
#68 QApplicationPrivate::sendMouseEvent (receiver=0x8d67000, event=0xbfabbe44, alienWidget=0x8d67000, nativeWidget=0x8d3ce88, buttonDown=0xb76cfc60, lastMouseReceiver=..., spontaneous=true) at kernel/qapplication.cpp:3120
#69 0xb6e0d2bc in QETWidget::translateMouseEvent (this=0x8d3ce88, event=0xbfabc36c) at kernel/qapplication_x11.cpp:4556
#70 0xb6e0b746 in QApplication::x11ProcessEvent (this=0x8793f68, event=0xbfabc36c) at kernel/qapplication_x11.cpp:3678
#71 0xb6e36b84 in x11EventSourceDispatch (s=0x879d2a8, callback=0, user_data=0x0) at kernel/qguieventdispatcher_glib.cpp:146
#72 0xb57c7aa8 in g_main_context_dispatch () from /lib/i386-linux-gnu/libglib-2.0.so.0
#73 0xb57c8270 in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#74 0xb57c8524 in g_main_context_iteration () from /lib/i386-linux-gnu/libglib-2.0.so.0
#75 0xb6b4453c in QEventDispatcherGlib::processEvents (this=0x8759f68, flags=...) at kernel/qeventdispatcher_glib.cpp:422
#76 0xb6e36775 in QGuiEventDispatcherGlib::processEvents (this=0x8759f68, flags=...) at kernel/qguieventdispatcher_glib.cpp:204
#77 0xb6b16289 in QEventLoop::processEvents (this=0xbfabc634, flags=...) at kernel/qeventloop.cpp:149
#78 0xb6b16522 in QEventLoop::exec (this=0xbfabc634, flags=...) at kernel/qeventloop.cpp:201
#79 0xb6b1aecc in QCoreApplication::exec () at kernel/qcoreapplication.cpp:1008
#80 0xb6d808e7 in QApplication::exec () at kernel/qapplication.cpp:3736
#81 0x080486c4 in main (argc=1, argv=0xbfabc754) at ../../kexi/main.cpp:34

Reported using DrKonqi

Comment 1 Jarosław Staniek 2011-05-11 20:28:43 UTC

What are the contents of the file? Sample file could be best or please tell how to create such a file (e.g. is one column enough?).

Comment 2 robert leleu 2011-05-11 20:37:52 UTC

Here is the file. It opens nice as csv in LibreOffice calc

I have a lot of other file to test. I test them during the next days



Je la 11/05/2011 20:28-------- Origina mesaĝo-------- Jarosław Staniek  
skribis (esperanto estas la unua internacia lingvo):
> https://bugs.kde.org/show_bug.cgi?id=273063
>
>
>
>
>
> --- Comment #1 from Jarosław Staniek<staniek kde org>   2011-05-11 20:28:43 ---
> What are the contents of the file? Sample file could be best or please tell how
> to create such a file (e.g. is one column enough?).
>

Comment 3 Jarosław Staniek 2011-05-11 20:41:05 UTC

Please use the 'Add an attachment' link below.

Comment 4 robert leleu 2011-05-11 21:09:02 UTC

Created attachment 59915 [details]
the file of the bug report

the file of the bug report

Comment 5 robert leleu 2011-05-11 21:10:59 UTC

Created attachment 59917 [details]
another csv file

and I next attach how it is seen in the import windows

Comment 6 robert leleu 2011-05-11 21:14:24 UTC

Created attachment 59919 [details]
a silly view of the file to import

so it seems that the problem is not related to the size of the file

Comment 7 robert leleu 2011-05-11 21:21:18 UTC

the last attached file, with the silly view, indeed doesn't crash, but gives an error and doesn't import

so perhaps should I file another bug?

Comment 8 Jarosław Staniek 2011-05-11 21:32:52 UTC

It's the same set of issues, so I guess one fix can fix them all.

Thanks a lot for the files.

Comment 9 Jarosław Staniek 2012-04-24 19:20:42 UTC

Dear Robert, thsi bug is related to https://bugs.kde.org/show_bug.cgi?id=279980 and https://bugs.kde.org/show_bug.cgi?id=254068; both fixed on 2012-03-07. I am sorry for this awful delay, and please keep doing quality reports :)