Bug 250164 - Crash when importing sheet from ODF 1.2 spreadseet
Summary: Crash when importing sheet from ODF 1.2 spreadseet
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Migration/Import/Export (other bugs)
Version First Reported In: 2.2.2 (KOffice 2.2.2)
Platform: Ubuntu Linux
: NOR crash
Target Milestone: ---
Assignee: Adam Pigg
URL:
Keywords:
: 256454 (view as bug list)
Depends on:
Blocks:
 
Reported: 2010-09-04 14:10 UTC by DrewJensen
Modified: 2012-08-11 11:57 UTC (History)
3 users (show)

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

Attachments
test file - sheet 1 has simple chart - sheet 2 same data, no chart (14.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-09-25 21:23 UTC, DrewJensen 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description DrewJensen 2010-09-04 14:10:20 UTC 
Application: kexi (2.2.2 (KOffice 2.2.2))
KDE Platform Version: 4.4.2 (KDE 4.4.2)
Qt Version: 4.6.2
Operating System: Linux 2.6.32-24-generic x86_64
Distribution: Ubuntu 10.04.1 LTS

-- Information about the crash:
Just updated Lucid 10.04 with the backport of the latest Kexi - opened existing database (SQL) and went to IMPORT Table - selected a Calc file created w/ OpenOffice (go-oo) 10.04, selected SHEET 1 - Start the import - Crash - I'm running Lucid w/ Gnome 

The crash can be reproduced every time.

 -- Backtrace:
Application: Kexi (kexi), signal: Segmentation fault
[KCrash Handler]
#5  KexiDB::Field::type (this=0x0) at ../../../kexi/kexidb/field.cpp:138
#6  0x00007fbfe2d51831 in KexiDB::Field::typeName (this=0x2643300, idx=<value optimized out>) at ../../../kexi/kexidb/field.h:341
#7  KexiMigration::AlterSchemaWidget::tableClicked (this=0x2643300, idx=<value optimized out>) at ../../../kexi/migration/AlterSchemaWidget.cpp:95
#8  0x00007fbfe2d51c5d in KexiMigration::AlterSchemaWidget::setTableSchema (this=0x2643300, ts=0x27727f0) at ../../../kexi/migration/AlterSchemaWidget.cpp:81
#9  0x00007fbfe2d4cc37 in KexiMigration::ImportTableWizard::arriveAlterTablePage (this=0x25424d0) at ../../../kexi/migration/importtablewizard.cpp:316
#10 0x00007fbfe2d3b8d6 in KexiMigration::ImportTableWizard::qt_metacall (this=0x25424d0, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fffc699ec20)
    at moc_importtablewizard.cpp:73
#11 0x00007fbffed43e3f in QMetaObject::activate (sender=0x25424d0, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#12 0x00007fbffc606798 in KPageDialog::currentPageChanged (this=0x0, _t1=0x263f020, _t2=0x2644550) at ./kpagedialog.moc:88
#13 0x00007fbffc6067e6 in KPageDialog::qt_metacall (this=0x25424d0, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fffc699edd0) at ./kpagedialog.moc:75
#14 0x00007fbffc529c68 in KAssistantDialog::qt_metacall (this=0x0, _c=QMetaObject::ReadProperty, _id=43399504, _a=0x1) at ./kassistantdialog.moc:70
#15 0x00007fbfe2d3b8b0 in KexiMigration::ImportTableWizard::qt_metacall (this=0x0, _c=QMetaObject::ReadProperty, _id=43399504, _a=0x1) at moc_importtablewizard.cpp:68
#16 0x00007fbffed43e3f in QMetaObject::activate (sender=0x2531ca0, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#17 0x00007fbffc60c568 in KPageWidget::currentPageChanged (this=0x0, _t1=0x263f020, _t2=0x2644550) at ./kpagewidget.moc:96
#18 0x00007fbffc60c708 in KPageWidget::qt_metacall (this=0x2531ca0, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fffc699ef10) at ./kpagewidget.moc:84
#19 0x00007fbffed43e3f in QMetaObject::activate (sender=0x2531ca0, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#20 0x00007fbffc607877 in KPageView::currentPageChanged (this=0x0, _t1=<value optimized out>, _t2=<value optimized out>) at ./kpageview.moc:140
#21 0x00007fbffc608497 in KPageViewPrivate::_k_pageSelected (this=0x253fee0, index=..., previous=...) at ../../kdeui/paged/kpageview.cpp:235
#22 0x00007fbffc608fe2 in KPageView::qt_metacall (this=0x2531ca0, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fffc699f0d0) at ./kpageview.moc:100
#23 0x00007fbffc60c6c0 in KPageWidget::qt_metacall (this=0x0, _c=QMetaObject::ReadProperty, _id=43399504, _a=0x1) at ./kpagewidget.moc:76
#24 0x00007fbffed43e3f in QMetaObject::activate (sender=0x2555a40, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#25 0x00007fbfff77c80a in QItemSelectionModel::currentChanged (this=0x0, _t1=<value optimized out>, _t2=<value optimized out>) at .moc/release-shared/moc_qitemselectionmodel.cpp:159
#26 0x00007fbfff77c952 in QItemSelectionModel::setCurrentIndex (this=0x2555a40, index=..., command=<value optimized out>) at itemviews/qitemselectionmodel.cpp:1167
#27 0x00007fbffc607bd6 in KPageView::setCurrentPage (this=<value optimized out>, index=...) at ../../kdeui/paged/kpageview.cpp:365
#28 0x00007fbffc60c7ea in KPageWidget::setCurrentPage (this=0x2531ca0, item=<value optimized out>) at ../../kdeui/paged/kpagewidget.cpp:122
#29 0x00007fbffc528f8f in KAssistantDialog::next (this=0x25424d0) at ../../kdeui/dialogs/kassistantdialog.cpp:121
#30 0x00007fbffc529ce1 in KAssistantDialog::qt_metacall (this=0x25424d0, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=<value optimized out>) at ./kassistantdialog.moc:76
#31 0x00007fbfe2d3b8b0 in KexiMigration::ImportTableWizard::qt_metacall (this=0x0, _c=QMetaObject::ReadProperty, _id=43399504, _a=0x1) at moc_importtablewizard.cpp:68
#32 0x00007fbffed43e3f in QMetaObject::activate (sender=0x25424d0, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#33 0x00007fbffc53d3b8 in KDialog::slotButtonClicked (this=0x25424d0, button=8192) at ../../kdeui/dialogs/kdialog.cpp:875
#34 0x00007fbffc53f329 in KDialog::qt_metacall (this=0x25424d0, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fffc699f6c0) at ./kdialog.moc:190
#35 0x00007fbffc6067c0 in KPageDialog::qt_metacall (this=0x0, _c=QMetaObject::ReadProperty, _id=43399504, _a=0x1) at ./kpagedialog.moc:70
#36 0x00007fbffc529c68 in KAssistantDialog::qt_metacall (this=0x0, _c=QMetaObject::ReadProperty, _id=43399504, _a=0x1) at ./kassistantdialog.moc:70
#37 0x00007fbfe2d3b8b0 in KexiMigration::ImportTableWizard::qt_metacall (this=0x0, _c=QMetaObject::ReadProperty, _id=43399504, _a=0x1) at moc_importtablewizard.cpp:68
#38 0x00007fbffed43e3f in QMetaObject::activate (sender=0x2542848, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#39 0x00007fbffed4915e in QSignalMapper::mapped (this=0x0, _t1=8192) at .moc/release-shared/moc_qsignalmapper.cpp:101
#40 0x00007fbffed4a372 in QSignalMapper::map (this=0x2542848, sender=0x254dcd0) at kernel/qsignalmapper.cpp:266
#41 0x00007fbffed4a5f0 in QSignalMapper::qt_metacall (this=0x2542848, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fffc699f850) at .moc/release-shared/moc_qsignalmapper.cpp:87
#42 0x00007fbffed43e3f in QMetaObject::activate (sender=0x254dcd0, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#43 0x00007fbfff89f5f2 in QAbstractButton::clicked (this=0x0, _t1=false) at .moc/release-shared/moc_qabstractbutton.cpp:206
#44 0x00007fbfff5b986b in QAbstractButtonPrivate::emitClicked (this=0x254dd10) at widgets/qabstractbutton.cpp:546
#45 0x00007fbfff5ba70b in QAbstractButtonPrivate::click (this=0x254dd10) at widgets/qabstractbutton.cpp:539
#46 0x00007fbfff5ba97c in QAbstractButton::mouseReleaseEvent (this=0x254dcd0, e=0x7fffc69a01a0) at widgets/qabstractbutton.cpp:1121
#47 0x00007fbfff25a582 in QWidget::event (this=0x254dcd0, event=0x7fffc69a01a0) at kernel/qwidget.cpp:7998
#48 0x00007fbfff20422c in QApplicationPrivate::notify_helper (this=0x127dd70, receiver=0x254dcd0, e=0x7fffc69a01a0) at kernel/qapplication.cpp:4300
#49 0x00007fbfff20aecb in QApplication::notify (this=0x1279e70, receiver=0x254dcd0, e=0x7fffc69a01a0) at kernel/qapplication.cpp:3865
#50 0x00007fbffc5cd526 in KApplication::notify (this=0x1279e70, receiver=0x254dcd0, event=0x7fffc69a01a0) at ../../kdeui/kernel/kapplication.cpp:302
#51 0x00007fbffed3106c in QCoreApplication::notifyInternal (this=0x1279e70, receiver=0x254dcd0, event=0x7fffc69a01a0) at kernel/qcoreapplication.cpp:704
#52 0x00007fbfff20a0ae in QCoreApplication::sendEvent (receiver=0x254dcd0, event=0x7fffc69a01a0, alienWidget=0x254dcd0, nativeWidget=0x25424d0, buttonDown=<value optimized out>, 
    lastMouseReceiver=<value optimized out>, spontaneous=true) at ../../include/QtCore/../../src/corelib/kernel/qcoreapplication.h:215
#53 QApplicationPrivate::sendMouseEvent (receiver=0x254dcd0, event=0x7fffc69a01a0, alienWidget=0x254dcd0, nativeWidget=0x25424d0, buttonDown=<value optimized out>, 
    lastMouseReceiver=<value optimized out>, spontaneous=true) at kernel/qapplication.cpp:2965
#54 0x00007fbfff289f65 in QETWidget::translateMouseEvent (this=0x25424d0, event=<value optimized out>) at kernel/qapplication_x11.cpp:4368
#55 0x00007fbfff2888ac in QApplication::x11ProcessEvent (this=<value optimized out>, event=0x7fffc69a0ac0) at kernel/qapplication_x11.cpp:3501
#56 0x00007fbfff2b4882 in x11EventSourceDispatch (s=0x1281020, callback=<value optimized out>, user_data=<value optimized out>) at kernel/qguieventdispatcher_glib.cpp:146
#57 0x00007fbffb2db8c2 in g_main_context_dispatch () from /lib/libglib-2.0.so.0
#58 0x00007fbffb2df748 in ?? () from /lib/libglib-2.0.so.0
#59 0x00007fbffb2df8fc in g_main_context_iteration () from /lib/libglib-2.0.so.0
#60 0x00007fbffed5a513 in QEventDispatcherGlib::processEvents (this=0x1257e10, flags=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:412
#61 0x00007fbfff2b446e in QGuiEventDispatcherGlib::processEvents (this=0x0, flags=<value optimized out>) at kernel/qguieventdispatcher_glib.cpp:204
#62 0x00007fbffed2f992 in QEventLoop::processEvents (this=<value optimized out>, flags=) at kernel/qeventloop.cpp:149
#63 0x00007fbffed2fd6c in QEventLoop::exec (this=0x7fffc69a0df0, flags=) at kernel/qeventloop.cpp:201
#64 0x00007fbfff6ce09e in QDialog::exec (this=0x25424d0) at dialogs/qdialog.cpp:546
#65 0x00007fbfffd1263e in KexiMainWindow::slotToolsImportTables (this=<value optimized out>) at ../../../kexi/main/KexiMainWindow.cpp:4714
#66 0x00007fbfffd2998d in KexiMainWindow::qt_metacall (this=0x20fba30, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0x7fffc69a1030) at ./KexiMainWindow.moc:501
#67 0x00007fbffed43e3f in QMetaObject::activate (sender=0x21dad90, m=<value optimized out>, local_signal_index=<value optimized out>, argv=0x1) at kernel/qobject.cpp:3293
#68 0x00007fbfff1fe032 in QAction::triggered (this=0x0, _t1=false) at .moc/release-shared/moc_qaction.cpp:263
#69 0x00007fbfff2000ab in QAction::activate (this=0x21dad90, event=<value optimized out>) at kernel/qaction.cpp:1255
#70 0x00007fbfff5ba6ca in QAbstractButtonPrivate::click (this=0x2362030) at widgets/qabstractbutton.cpp:528
#71 0x00007fbfff5ba97c in QAbstractButton::mouseReleaseEvent (this=0x2341460, e=0x7fffc69a1990) at widgets/qabstractbutton.cpp:1121
#72 0x00007fbfff6868ca in QToolButton::mouseReleaseEvent (this=0x0, e=0x1) at widgets/qtoolbutton.cpp:721
#73 0x00007fbfff25a582 in QWidget::event (this=0x2341460, event=0x7fffc69a1990) at kernel/qwidget.cpp:7998
#74 0x00007fbfff20422c in QApplicationPrivate::notify_helper (this=0x127dd70, receiver=0x2341460, e=0x7fffc69a1990) at kernel/qapplication.cpp:4300
#75 0x00007fbfff20aecb in QApplication::notify (this=0x1279e70, receiver=0x2341460, e=0x7fffc69a1990) at kernel/qapplication.cpp:3865
#76 0x00007fbffc5cd526 in KApplication::notify (this=0x1279e70, receiver=0x2341460, event=0x7fffc69a1990) at ../../kdeui/kernel/kapplication.cpp:302
#77 0x00007fbffed3106c in QCoreApplication::notifyInternal (this=0x1279e70, receiver=0x2341460, event=0x7fffc69a1990) at kernel/qcoreapplication.cpp:704
#78 0x00007fbfff20a0ae in QCoreApplication::sendEvent (receiver=0x2341460, event=0x7fffc69a1990, alienWidget=0x2341460, nativeWidget=0x23405d0, buttonDown=<value optimized out>, 
    lastMouseReceiver=<value optimized out>, spontaneous=true) at ../../include/QtCore/../../src/corelib/kernel/qcoreapplication.h:215
#79 QApplicationPrivate::sendMouseEvent (receiver=0x2341460, event=0x7fffc69a1990, alienWidget=0x2341460, nativeWidget=0x23405d0, buttonDown=<value optimized out>, 
    lastMouseReceiver=<value optimized out>, spontaneous=true) at kernel/qapplication.cpp:2965
#80 0x00007fbfff289f65 in QETWidget::translateMouseEvent (this=0x23405d0, event=<value optimized out>) at kernel/qapplication_x11.cpp:4368
#81 0x00007fbfff2888ac in QApplication::x11ProcessEvent (this=<value optimized out>, event=0x7fffc69a22b0) at kernel/qapplication_x11.cpp:3501
#82 0x00007fbfff2b4882 in x11EventSourceDispatch (s=0x1281020, callback=<value optimized out>, user_data=<value optimized out>) at kernel/qguieventdispatcher_glib.cpp:146
#83 0x00007fbffb2db8c2 in g_main_context_dispatch () from /lib/libglib-2.0.so.0
#84 0x00007fbffb2df748 in ?? () from /lib/libglib-2.0.so.0
#85 0x00007fbffb2df8fc in g_main_context_iteration () from /lib/libglib-2.0.so.0
#86 0x00007fbffed5a513 in QEventDispatcherGlib::processEvents (this=0x1257e10, flags=<value optimized out>) at kernel/qeventdispatcher_glib.cpp:412
#87 0x00007fbfff2b446e in QGuiEventDispatcherGlib::processEvents (this=0x0, flags=<value optimized out>) at kernel/qguieventdispatcher_glib.cpp:204
#88 0x00007fbffed2f992 in QEventLoop::processEvents (this=<value optimized out>, flags=) at kernel/qeventloop.cpp:149
#89 0x00007fbffed2fd6c in QEventLoop::exec (this=0x7fffc69a25e0, flags=) at kernel/qeventloop.cpp:201
#90 0x00007fbffed33aab in QCoreApplication::exec () at kernel/qcoreapplication.cpp:981
#91 0x0000000000400929 in main (argc=<value optimized out>, argv=<value optimized out>) at ../../kexi/main.cpp:34

Reported using DrKonqi
Comment 1 DrewJensen 2010-09-04 14:14:59 UTC 
Just to clarify - the ODS file was actually created using OOo 3.2 but was last udpated using OpenOffice vanilla 3.2.1 version - not that it matters but just to be precise. Thanks
Comment 2 Adam Pigg 2010-09-13 21:44:11 UTC 
Can you attach the file?
Comment 3 Jarosław Staniek 2010-09-25 20:22:12 UTC 
Yes, please provide test file causing the crash. It's not your fault but the backtrace did not help (it sometimes happens).
Comment 4 DrewJensen 2010-09-25 21:23:46 UTC 
Created attachment 51987 [details]
test file - sheet 1 has simple chart - sheet 2 same data, no chart

Here is the file that causes the crash. Selecting Sheet 1 and Sheet 2 will give slightly different results in the import dialog, but both lead to a crash.
Comment 5 Adam Pigg 2010-09-26 09:59:00 UTC 
Sheet1 does crash, but sheet2 imports perfectly.  Is this the case you see?  I'll get the crash fixed.  For reference, kexi expects the data to be layed out as in sheet2, Starting in the first cell.
Comment 6 Adam Pigg 2010-09-26 14:20:56 UTC 
SVN commit 1179897 by piggz:

Dont crash if there are no columns in the source data
There is another bug that occurs when clicking the back button in the wizard.
BUG:250164


 M  +1 -1      AlterSchemaWidget.cpp  
 M  +3 -0      importtablewizard.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1179897
Comment 7 Adam Pigg 2010-09-27 23:20:43 UTC 
SVN commit 1180402 by piggz:

Fix memory leak
Fix crash and memory corruption by not deleting things that shouldnt be deleted
Clear the table list when visiting the page
Ensure an ods document is closed before opening another
CCMAIL:staniek@kde.org
BUG:250164

 M  +2 -5      importtablewizard.cpp  
 M  +3 -1      importtablewizard.h  
 M  +11 -0     kspread/kspreadmigrate.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1180402
Comment 8 Jarosław Staniek 2010-11-09 22:27:28 UTC 
*** Bug 256454 has been marked as a duplicate of this bug. ***