Bug 287931

Summary: Kexi Crash During CSV import
Product: [Applications] KEXI Reporter: Terry Mills <darksparc>
Component: Migration/Import/ExportAssignee: Jarosław Staniek <staniek>
Status: CLOSED DUPLICATE    
Severity: crash CC: adam
Priority: NOR    
Version: 2.3.3 (KOffice 2.3.3)   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Terry Mills 2011-11-30 18:10:21 UTC 
Application: kexi (2.3.3 (KOffice 2.3.3))
KDE Platform Version: 4.7.2 (4.7.2)
Qt Version: 4.7.4
Operating System: Linux 3.0.0-13-generic i686
Distribution: Ubuntu 11.10

-- Information about the crash:
- What I was doing when the application crashed:

I was importing a small table.csv file exported from an Access File, this csv was created from MDB
gmdb2 0.6pre1

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

Thread 3 (Thread 0xb5379b70 (LWP 17568)):
#0  0x0084fd10 in clock_gettime () from /lib/i386-linux-gnu/librt.so.1
#1  0x003887d5 in do_gettime (frac=0xb5379010, sec=0xb5379008) at tools/qelapsedtimer_unix.cpp:123
#2  qt_gettime () at tools/qelapsedtimer_unix.cpp:140
#3  0x0045b4b6 in QTimerInfoList::updateCurrentTime (this=0x9f58834) at kernel/qeventdispatcher_unix.cpp:339
#4  0x0045b80a in QTimerInfoList::timerWait (this=0x9f58834, tm=...) at kernel/qeventdispatcher_unix.cpp:442
#5  0x0045a053 in timerSourcePrepareHelper (src=<optimized out>, timeout=0xb537911c) at kernel/qeventdispatcher_glib.cpp:136
#6  0x0045a0ed in timerSourcePrepare (source=0x9f58800, timeout=<optimized out>) at kernel/qeventdispatcher_glib.cpp:169
#7  0x0316988c in g_main_context_prepare () from /lib/i386-linux-gnu/libglib-2.0.so.0
#8  0x0316a637 in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#9  0x0316ac2a in g_main_context_iteration () from /lib/i386-linux-gnu/libglib-2.0.so.0
#10 0x0045ab37 in QEventDispatcherGlib::processEvents (this=0x9f56f18, flags=...) at kernel/qeventdispatcher_glib.cpp:424
#11 0x0042b1dd in QEventLoop::processEvents (this=0xb53792a0, flags=...) at kernel/qeventloop.cpp:149
#12 0x0042b421 in QEventLoop::exec (this=0xb53792a0, flags=...) at kernel/qeventloop.cpp:201
#13 0x0032e90b in QThread::exec (this=0x9f4ac90) at thread/qthread.cpp:498
#14 0x0040be2d in QInotifyFileSystemWatcherEngine::run (this=0x9f4ac90) at io/qfilesystemwatcher_inotify.cpp:248
#15 0x003317b3 in QThreadPrivate::start (arg=0x9f4ac90) at thread/qthread_unix.cpp:331
#16 0x0025bd31 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#17 0x009370ce in clone () from /lib/i386-linux-gnu/libc.so.6
Backtrace stopped: Not enough registers or memory available to unwind further

Thread 2 (Thread 0xb3929b70 (LWP 17580)):
#0  0x0025dda8 in pthread_mutex_lock () from /lib/i386-linux-gnu/libpthread.so.0
#1  0x00944f14 in pthread_mutex_lock () from /lib/i386-linux-gnu/libc.so.6
#2  0x0316a839 in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#3  0x0316ac2a in g_main_context_iteration () from /lib/i386-linux-gnu/libglib-2.0.so.0
#4  0x0045ab37 in QEventDispatcherGlib::processEvents (this=0x9a73280, flags=...) at kernel/qeventdispatcher_glib.cpp:424
#5  0x0042b1dd in QEventLoop::processEvents (this=0xb39292a0, flags=...) at kernel/qeventloop.cpp:149
#6  0x0042b421 in QEventLoop::exec (this=0xb39292a0, flags=...) at kernel/qeventloop.cpp:201
#7  0x0032e90b in QThread::exec (this=0x9f765d0) at thread/qthread.cpp:498
#8  0x0040be2d in QInotifyFileSystemWatcherEngine::run (this=0x9f765d0) at io/qfilesystemwatcher_inotify.cpp:248
#9  0x003317b3 in QThreadPrivate::start (arg=0x9f765d0) at thread/qthread_unix.cpp:331
#10 0x0025bd31 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#11 0x009370ce in clone () from /lib/i386-linux-gnu/libc.so.6
Backtrace stopped: Not enough registers or memory available to unwind further

Thread 1 (Thread 0xb77ce720 (LWP 17567)):
[KCrash Handler]
#7  isNull (d=0x11) at kernel/qguivariant.cpp:292
#8  0x0044e261 in QVariant::isNull (this=0x11) at kernel/qvariant.cpp:2909
#9  0x0299e347 in KexiDB::SQLitePreparedStatement::execute (this=0xa7f0e58) at ../../../../../kexi/kexidb/drivers/sqlite/sqlitepreparedstatement.cpp:86
#10 0x030eb344 in saveRow (this=0xa58c7e8, inGUI=<optimized out>) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1264
#11 KexiCSVImportDialog::saveRow (this=0xa58c7e8, inGUI=false) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1257
#12 0x030ee544 in KexiCSVImportDialog::loadRows (this=0xa58c7e8, field=..., row=@0xbfdc317c, column=@0xbfdc3180, maxColumn=@0xbfdc3184, inGUI=false) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:888
#13 0x030f510f in KexiCSVImportDialog::accept (this=0xa58c7e8) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1602
#14 0x024f8113 in KDialog::slotButtonClicked (this=0xa58c7e8, button=4) at ../../kdeui/dialogs/kdialog.cpp:885
#15 0x024f8603 in KDialog::qt_metacall (this=0xa58c7e8, _c=QMetaObject::InvokeMetaMethod, _id=33, _a=0xbfdc3398) at ./kdialog.moc:190
#16 0x030f3452 in KexiCSVImportDialog::qt_metacall (this=0xa58c7e8, _c=QMetaObject::InvokeMetaMethod, _id=69, _a=0xbfdc3398) at ./kexicsvimportdialog.moc:89
#17 0x00432b7d in metacall (argv=0xbfdc3398, idx=69, cl=QMetaObject::InvokeMetaMethod, object=0xa58c7e8) at kernel/qmetaobject.cpp:237
#18 QMetaObject::metacall (object=0xa58c7e8, cl=QMetaObject::InvokeMetaMethod, idx=69, argv=0xbfdc3398) at kernel/qmetaobject.cpp:232
#19 0x00441a6a in QMetaObject::activate (sender=0xa535d44, m=0x5621b8, local_signal_index=0, argv=0xbfdc3398) at kernel/qobject.cpp:3278
#20 0x00447b15 in QSignalMapper::mapped (this=0xa535d44, _t1=4) at .moc/release-shared/moc_qsignalmapper.cpp:101
#21 0x00447c62 in QSignalMapper::map (this=0xa535d44, sender=0xa2fb170) at kernel/qsignalmapper.cpp:266
#22 0x00447e1e in QSignalMapper::map (this=0xa535d44) at kernel/qsignalmapper.cpp:257
#23 0x00447f50 in QSignalMapper::qt_metacall (this=0xa535d44, _c=QMetaObject::InvokeMetaMethod, _id=4, _a=0xbfdc3528) at .moc/release-shared/moc_qsignalmapper.cpp:87
#24 0x00432b7d in metacall (argv=0xbfdc3528, idx=8, cl=QMetaObject::InvokeMetaMethod, object=0xa535d44) at kernel/qmetaobject.cpp:237
#25 QMetaObject::metacall (object=0xa535d44, cl=QMetaObject::InvokeMetaMethod, idx=8, argv=0xbfdc3528) at kernel/qmetaobject.cpp:232
#26 0x00441a6a in QMetaObject::activate (sender=0xa2fb170, m=0x16c5a28, local_signal_index=2, argv=0xbfdc3528) at kernel/qobject.cpp:3278
#27 0x0147ee1d in QAbstractButton::clicked (this=0xa2fb170, _t1=false) at .moc/release-shared/moc_qabstractbutton.cpp:206
#28 0x0117d58d in QAbstractButtonPrivate::emitClicked (this=0xa594aa8) at widgets/qabstractbutton.cpp:546
#29 0x0117ebfb in QAbstractButtonPrivate::click (this=0xa594aa8) at widgets/qabstractbutton.cpp:539
#30 0x0117eeb6 in QAbstractButton::mouseReleaseEvent (this=0xa2fb170, e=0xbfdc3adc) at widgets/qabstractbutton.cpp:1121
#31 0x00dc3f98 in QWidget::event (this=0xa2fb170, event=0xbfdc3adc) at kernel/qwidget.cpp:8295
#32 0x0117e159 in QAbstractButton::event (this=0xa2fb170, e=0xbfdc3adc) at widgets/qabstractbutton.cpp:1080
#33 0x01220798 in QPushButton::event (this=0xa2fb170, e=0xbfdc3adc) at widgets/qpushbutton.cpp:683
#34 0x00d69d54 in notify_helper (e=0xbfdc3adc, receiver=0xa2fb170, this=0x9966458) at kernel/qapplication.cpp:4486
#35 QApplicationPrivate::notify_helper (this=0x9966458, receiver=0xa2fb170, e=0xbfdc3adc) at kernel/qapplication.cpp:4458
#36 0x00d6fdbb in QApplication::notify (this=0x9966458, receiver=0xa2fb170, e=0xbfdc3adc) at kernel/qapplication.cpp:4047
#37 0x025b4681 in KApplication::notify (this=0x9960370, receiver=0xa2fb170, event=0xbfdc3adc) at ../../kdeui/kernel/kapplication.cpp:311
#38 0x0042c19e in QCoreApplication::notifyInternal (this=0x9960370, receiver=0xa2fb170, event=0xbfdc3adc) at kernel/qcoreapplication.cpp:787
#39 0x00d6ad15 in sendEvent (event=<optimized out>, receiver=<optimized out>) at ../../include/QtCore/../../src/corelib/kernel/qcoreapplication.h:215
#40 QApplicationPrivate::sendMouseEvent (receiver=0xa2fb170, event=0xbfdc3adc, alienWidget=0xa2fb170, nativeWidget=0xa552ab0, buttonDown=0x16d4eb4, lastMouseReceiver=..., spontaneous=true) at kernel/qapplication.cpp:3146
#41 0x00df72c4 in QETWidget::translateMouseEvent (this=0xa552ab0, event=0xbfdc3f5c) at kernel/qapplication_x11.cpp:4568
#42 0x00df5e4d in QApplication::x11ProcessEvent (this=0x9960370, event=0xbfdc3f5c) at kernel/qapplication_x11.cpp:3690
#43 0x00e2224c in x11EventSourceDispatch (s=0x9969240, callback=0, user_data=0x0) at kernel/qguieventdispatcher_glib.cpp:146
#44 0x0316a25f in g_main_context_dispatch () from /lib/i386-linux-gnu/libglib-2.0.so.0
#45 0x0316a990 in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#46 0x0316ac2a in g_main_context_iteration () from /lib/i386-linux-gnu/libglib-2.0.so.0
#47 0x0045aada in QEventDispatcherGlib::processEvents (this=0x99414e0, flags=...) at kernel/qeventdispatcher_glib.cpp:422
#48 0x00e21e3a in QGuiEventDispatcherGlib::processEvents (this=0x99414e0, flags=...) at kernel/qguieventdispatcher_glib.cpp:204
#49 0x0042b1dd in QEventLoop::processEvents (this=0xbfdc4260, flags=...) at kernel/qeventloop.cpp:149
#50 0x0042b421 in QEventLoop::exec (this=0xbfdc4260, flags=...) at kernel/qeventloop.cpp:201
#51 0x012a17c9 in QDialog::exec (this=0xa58c7e8) at dialogs/qdialog.cpp:552
#52 0x00142c1b in KexiMainWindow::slotProjectImportDataTable (this=0xa2c40f0) at ../../../kexi/main/KexiMainWindow.cpp:4914
#53 0x0014ed6d in KexiMainWindow::qt_metacall (this=0xa2c40f0, _c=QMetaObject::InvokeMetaMethod, _id=64, _a=0xbfdc4478) at ./KexiMainWindow.moc:478
#54 0x00432b7d in metacall (argv=0xbfdc4478, idx=91, cl=QMetaObject::InvokeMetaMethod, object=0xa2c40f0) at kernel/qmetaobject.cpp:237
#55 QMetaObject::metacall (object=0xa2c40f0, cl=QMetaObject::InvokeMetaMethod, idx=91, argv=0xbfdc4478) at kernel/qmetaobject.cpp:232
#56 0x00441a6a in QMetaObject::activate (sender=0xa2b8668, m=0x16b2458, local_signal_index=1, argv=0xbfdc4478) at kernel/qobject.cpp:3278
#57 0x00d6283d in QAction::triggered (this=0xa2b8668, _t1=false) at .moc/release-shared/moc_qaction.cpp:263
#58 0x00d62adb in QAction::activate (this=0xa2b8668, event=QAction::Trigger) at kernel/qaction.cpp:1257
#59 0x01256170 in trigger (this=<optimized out>) at ../../include/QtGui/../../src/gui/kernel/qaction.h:218
#60 QToolButton::nextCheckState (this=0xa2d7bc0) at widgets/qtoolbutton.cpp:1147
#61 0x0117ebb7 in QAbstractButtonPrivate::click (this=0xa2e2000) at widgets/qabstractbutton.cpp:528
#62 0x0117eeb6 in QAbstractButton::mouseReleaseEvent (this=0xa2d7bc0, e=0xbfdc4a5c) at widgets/qabstractbutton.cpp:1121
#63 0x0125620d in QToolButton::mouseReleaseEvent (this=0xa2d7bc0, e=0xbfdc4a5c) at widgets/qtoolbutton.cpp:721
#64 0x00dc3f98 in QWidget::event (this=0xa2d7bc0, event=0xbfdc4a5c) at kernel/qwidget.cpp:8295
#65 0x0117e159 in QAbstractButton::event (this=0xa2d7bc0, e=0xbfdc4a5c) at widgets/qabstractbutton.cpp:1080
#66 0x0125794c in QToolButton::event (this=0xa2d7bc0, event=0xbfdc4a5c) at widgets/qtoolbutton.cpp:1163
#67 0x00d69d54 in notify_helper (e=0xbfdc4a5c, receiver=0xa2d7bc0, this=0x9966458) at kernel/qapplication.cpp:4486
#68 QApplicationPrivate::notify_helper (this=0x9966458, receiver=0xa2d7bc0, e=0xbfdc4a5c) at kernel/qapplication.cpp:4458
#69 0x00d6fdbb in QApplication::notify (this=0x9966458, receiver=0xa2d7bc0, e=0xbfdc4a5c) at kernel/qapplication.cpp:4047
#70 0x025b4681 in KApplication::notify (this=0x9960370, receiver=0xa2d7bc0, event=0xbfdc4a5c) at ../../kdeui/kernel/kapplication.cpp:311
#71 0x0042c19e in QCoreApplication::notifyInternal (this=0x9960370, receiver=0xa2d7bc0, event=0xbfdc4a5c) at kernel/qcoreapplication.cpp:787
#72 0x00d6ad15 in sendEvent (event=<optimized out>, receiver=<optimized out>) at ../../include/QtCore/../../src/corelib/kernel/qcoreapplication.h:215
#73 QApplicationPrivate::sendMouseEvent (receiver=0xa2d7bc0, event=0xbfdc4a5c, alienWidget=0xa2d7bc0, nativeWidget=0xa2c8b98, buttonDown=0x16d4eb4, lastMouseReceiver=..., spontaneous=true) at kernel/qapplication.cpp:3146
#74 0x00df72c4 in QETWidget::translateMouseEvent (this=0xa2c8b98, event=0xbfdc4edc) at kernel/qapplication_x11.cpp:4568
#75 0x00df5e4d in QApplication::x11ProcessEvent (this=0x9960370, event=0xbfdc4edc) at kernel/qapplication_x11.cpp:3690
#76 0x00e2224c in x11EventSourceDispatch (s=0x9969240, callback=0, user_data=0x0) at kernel/qguieventdispatcher_glib.cpp:146
#77 0x0316a25f in g_main_context_dispatch () from /lib/i386-linux-gnu/libglib-2.0.so.0
#78 0x0316a990 in ?? () from /lib/i386-linux-gnu/libglib-2.0.so.0
#79 0x0316ac2a in g_main_context_iteration () from /lib/i386-linux-gnu/libglib-2.0.so.0
#80 0x0045aada in QEventDispatcherGlib::processEvents (this=0x99414e0, flags=...) at kernel/qeventdispatcher_glib.cpp:422
#81 0x00e21e3a in QGuiEventDispatcherGlib::processEvents (this=0x99414e0, flags=...) at kernel/qguieventdispatcher_glib.cpp:204
#82 0x0042b1dd in QEventLoop::processEvents (this=0xbfdc51e4, flags=...) at kernel/qeventloop.cpp:149
#83 0x0042b421 in QEventLoop::exec (this=0xbfdc51e4, flags=...) at kernel/qeventloop.cpp:201
#84 0x0043019d in QCoreApplication::exec () at kernel/qcoreapplication.cpp:1064
#85 0x00d678f4 in QApplication::exec () at kernel/qapplication.cpp:3760
#86 0x08048624 in main (argc=1, argv=0xbfdc52e4) at ../../kexi/main.cpp:34

Possible duplicates by query: bug 283104, bug 279980.

Reported using DrKonqi
Comment 1 Jarosław Staniek 2011-11-30 18:41:11 UTC 
Could you please provide a small sample CSV file that causes a crash?

*** This bug has been marked as a duplicate of bug 279980 ***
Comment 2 Adam Pigg 2011-11-30 19:52:26 UTC 
If the data in question isnt private, could you attach it to the list or send it to me to debug with? adam@piggz.co.uk
Comment 3 Terry Mills 2011-12-03 16:27:06 UTC 
I will be glad to send you information. I am building a new machine, but as soon as I am done I will get you some info.
The data is private to the point that we can not publish it in any way.


   Terry W. Mills     
 
Web Page                                                                    Blog
http://sites.google.com/site/hobbygaragesite/Home  http://hobbygarage.blogspot.com/






---- On Wed, 30 Nov 2011 19:52:26 +0000 Adam Pigg &lt;adam@piggz.co.uk&gt; wrote ---- 


https://bugs.kde.org/show_bug.cgi?id=287931 
 
 
Adam Pigg &lt;adam@piggz.co.uk&gt; changed: 
 
 What |Removed |Added 
---------------------------------------------------------------------------- 
 CC| |adam@piggz.co.uk 
 
 
 
 
--- Comment #2 from Adam Pigg &lt;adam piggz co uk&gt; 2011-11-30 19:52:26 --- 
If the data in question isnt private, could you attach it to the list or send 
it to me to debug with? adam@piggz.co.uk
Comment 4 Terry Mills 2011-12-05 15:59:02 UTC 
   Terry W. Mills    
Here are a couple of the files. I would send you the actual data base but it is to large. 

It looks like while importing the table data the software is not reading the first line correctly.
But if I open it in as a spread sheet it looks ok.
I have imported just the tables no problem but I can not import the data.
Thanks







 
---- On Sat, 03 Dec 2011 22:57:12 +0000 Jarosław Staniek &lt;staniek@kde.org&gt; wrote ---- 


https://bugs.kde.org/show_bug.cgi?id=287931 
 
 
Jarosław Staniek &lt;staniek@kde.org&gt; changed: 
 
 What |Removed |Added 
---------------------------------------------------------------------------- 
 Summary|Kexi Crash Durring CSV |Kexi Crash During CSV 
 |import |import
Comment 5 Jarosław Staniek 2011-12-06 20:55:19 UTC 
The files should compress very well or you could remove all rows but 100 first rows or so and then send to me or Adam.
Comment 6 Terry Mills 2011-12-06 21:05:01 UTC 
I will see what I can do.

   Terry W. Mills     







---- On Tue, 06 Dec 2011 20:55:19 +0000 Jarosław Staniek &lt;staniek@kde.org&gt; wrote ---- 


https://bugs.kde.org/show_bug.cgi?id=287931 
 
 
 
 
 
--- Comment #5 from Jarosław Staniek &lt;staniek kde org&gt; 2011-12-06 20:55:19 --- 
The files should compress very well or you could remove all rows but 100 first 
rows or so and then send to me or Adam.