Summary: | Crash during MDB import | ||
---|---|---|---|
Product: | [Applications] KEXI | Reporter: | Kevin O'Riordan <k.oriordan> |
Component: | Migration/Import/Export | Assignee: | Jarosław Staniek <staniek> |
Status: | CLOSED WAITINGFORINFO | ||
Severity: | crash | CC: | andresbajotierra, bruno, claus_chr, crns13, filippo.bottega, forums, gabrimonfa, jozefvanhoof, js, k.oriordan, kde, kevin.coonan, krisgesling, pnolan, rasasi78, sd, yo_oke, zwerg8_thorin |
Priority: | NOR | ||
Version: | 2.2.0 (KOffice 2.2.0) | ||
Target Milestone: | --- | ||
Platform: | Unlisted Binaries | ||
OS: | Linux | ||
See Also: | https://bugs.kde.org/show_bug.cgi?id=332315 | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: | |||
Attachments: |
New crash information added by DrKonqi
New crash information added by DrKonqi New crash information added by DrKonqi New crash information added by DrKonqi |
Description
Kevin O'Riordan
2010-06-01 12:59:02 UTC
is it possible that you attach such a file in the bugreport ? Kevin, could you tell me more about your hardware? E.g. is it a 64bit system? Sample database could help. On 32-bit systems importing Nothwind examples from MS Access 2000 and 2003 works properly. May be similar to Bug #244420 Created attachment 50945 [details]
New crash information added by DrKonqi
kexi (2.2.2 (KOffice 2.2.2)) on KDE Platform 4.5.00 (KDE 4.5.0) using Qt 4.7.0
- What I was doing when the application crashed:
Opening Microsoft Access database
System is a 32 bit system. Can attach sample database but it is several megabytes in size.
-- Backtrace (Reduced):
#7 KexiDB::IndexSchema::addField (this=0xa1dc738, field=0x0) at ../../../kexi/kexidb/indexschema.cpp:90
#8 0x02a8e2f8 in KexiMigration::MDBMigrate::getPrimaryKey (this=0xa1b9348, table=0xa1dc650, tableDef=0xa1dc800) at ../../../../../kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:424
#9 0x02a8f954 in KexiMigration::MDBMigrate::drv_readTableSchema (this=0xa1b9348, originalName=..., tableSchema=...) at ../../../../../kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:188
#10 0x0281fa3d in KexiMigration::KexiMigrate::performImport (this=0xa1b9348, result=0xbfa5f2e8) at ../../../kexi/migration/keximigrate.cpp:199
#11 0x0282c0fa in KexiMigration::ImportWizard::import (this=0xa05a3c0) at ../../../kexi/migration/importwizard.cpp:816
[Comment from a bug triager] From bug 261072 (KOffice 2.3 RC 1): - What I was doing when the application crashed: Nothing other then going through the import guide. I chose to import both structure and data and to save as a file. I am running Kexi in a dinstibution installed i a virtual machine in VirtualBox under OpenSUSE 11.3 (the open source version from the official SUSE repositories). Kexi is also installed from the repositories. The .mdb file is from a rather old XP-version of Access . - Backtrace: [KCrash Handler] #7 KexiDB::IndexSchema::addField (this=0x87b13c8, field=0x0) at /usr/src/debug/koffice-2.2.91/kexi/kexidb/indexschema.cpp:90 #8 0xafef0589 in KexiMigration::MDBMigrate::getPrimaryKey (this=0x8798008, table=0x8675330, tableDef=0x87a35c8) at /usr/src/debug/koffice-2.2.91/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:432 #9 0xafef0bc4 in KexiMigration::MDBMigrate::drv_readTableSchema (this=0x8798008, originalName=..., tableSchema=...) at /usr/src/debug/koffice-2.2.91/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:188 #10 0xaff11c62 in KexiMigration::KexiMigrate::performImport (this=0x8798008, result=0xbfe176e4) at /usr/src/debug/koffice-2.2.91/kexi/migration/keximigrate.cpp:199 #11 0xaff1fa3c in KexiMigration::ImportWizard::import (this=0x85d3f58) at /usr/src/debug/koffice-2.2.91/kexi/migration/importwizard.cpp:816 #12 0xaff2028b in KexiMigration::ImportWizard::next (this=0x85d3f58) at /usr/src/debug/koffice-2.2.91/kexi/migration/importwizard.cpp:901 #13 0xb5d8a177 in KAssistantDialog::qt_metacall (this=0x85d3f58, _c=QMetaObject::InvokeMetaMethod, _id=<value optimized out>, _a=0xbfe1798c) at /usr/src/debug/kdelibs-4.5.85/build/kdeui/kassistantdialog.moc:76 #14 0xaff1ec92 in KexiMigration::ImportWizard::qt_metacall (this=0x85d3f58, _c=QMetaObject::InvokeMetaMethod, _id=76, _a=0xbfe1798c) at /usr/src/debug/koffice-2.2.91/build/kexi/migration/importwizard.moc:78 *** Bug 261072 has been marked as a duplicate of this bug. *** [Comment from a bug triager] From bug 262817: I've tried it a number of times now, tried to import it to a file with structure and data, then just with structure. Also tried both storing it to a remote server. Crashes regardless. I don't know what version of Access was used to create the original database. *** Bug 262817 has been marked as a duplicate of this bug. *** Created attachment 57470 [details]
New crash information added by DrKonqi
kexi (2.3.1 (KOffice 2.3.1)) on KDE Platform 4.6.00 (4.6.0) "release 386" using Qt 4.7.1
- What I was doing when the application crashed: Opening a modest (312 KiB) Microsoft Access DB (which I can send if you like) with Kexi. Error occurs whether or not I choose local project or try to import it into MySQL.
Please fix. The Universe is counting on you.
-- Backtrace (Reduced):
#6 KexiDB::IndexSchema::addField (this=0x1c0f680, field=0x0) at /usr/src/debug/koffice-2.3.1/kexi/kexidb/indexschema.cpp:90
#7 0x00007f46fea9799a in KexiMigration::MDBMigrate::getPrimaryKey (this=<value optimized out>, table=0x1bea4b0, tableDef=0x1bea5f0)
at /usr/src/debug/koffice-2.3.1/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:432
#8 0x00007f46fea97f62 in KexiMigration::MDBMigrate::drv_readTableSchema (this=0x1160330, originalName=<value optimized out>, tableSchema=...)
at /usr/src/debug/koffice-2.3.1/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:188
#9 0x00007f4705415be9 in KexiMigration::KexiMigrate::performImport (this=0x1160330, result=0x7fff17fbfcb0) at /usr/src/debug/koffice-2.3.1/kexi/migration/keximigrate.cpp:199
#10 0x00007f4705422433 in KexiMigration::ImportWizard::import (this=0x1a040f0) at /usr/src/debug/koffice-2.3.1/kexi/migration/importwizard.cpp:820
This is what killed it.
Kevin M. Coonan, MD
Bethesda, MD
kevin.coonan {GMail, Skype}
Omnes homines liberi aequique dignitate atque juribus nascuntur. Ratione
conscientiaque praediti sunt et alii erga alios cum fraternitate se gerere
debent.
All human beings are born free and equal in dignity and rights. They are
endowed with reason and conscience and should act towards one another in a
spirit of brotherhood.
Article I. Universal Declaration of Human Rights. 1948-12-10, Paris, France
On Wednesday, February 23, 2011 11:12:42 Kevin Coonan wrote:
> https://bugs.kde.org/show_bug.cgi?id=240343
>
>
>
>
>
> --- Comment #9 from Kevin Coonan <kevin coonan gmail com> 2011-02-23
> 17:12:39 --- Created an attachment (id=57470)
> --> (http://bugs.kde.org/attachment.cgi?id=57470)
> New crash information added by DrKonqi
>
> kexi (2.3.1 (KOffice 2.3.1)) on KDE Platform 4.6.00 (4.6.0) "release 386"
> using Qt 4.7.1
>
> - What I was doing when the application crashed: Opening a modest (312
> KiB) Microsoft Access DB (which I can send if you like) with Kexi. Error
> occurs whether or not I choose local project or try to import it into
> MySQL.
>
> Please fix. The Universe is counting on you.
>
> -- Backtrace (Reduced):
> #6 KexiDB::IndexSchema::addField (this=0x1c0f680, field=0x0) at
> /usr/src/debug/koffice-2.3.1/kexi/kexidb/indexschema.cpp:90
> #7 0x00007f46fea9799a in KexiMigration::MDBMigrate::getPrimaryKey
> (this=<value optimized out>, table=0x1bea4b0, tableDef=0x1bea5f0)
> at
> /usr/src/debug/koffice-2.3.1/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:
> 432 #8 0x00007f46fea97f62 in
> KexiMigration::MDBMigrate::drv_readTableSchema (this=0x1160330,
> originalName=<value optimized out>, tableSchema=...) at
> /usr/src/debug/koffice-2.3.1/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:
> 188 #9 0x00007f4705415be9 in KexiMigration::KexiMigrate::performImport
> (this=0x1160330, result=0x7fff17fbfcb0) at
> /usr/src/debug/koffice-2.3.1/kexi/migration/keximigrate.cpp:199
> #10 0x00007f4705422433 in KexiMigration::ImportWizard::import
> (this=0x1a040f0) at
> /usr/src/debug/koffice-2.3.1/kexi/migration/importwizard.cpp:820
Created attachment 60378 [details]
New crash information added by DrKonqi
kexi (2.4 Alpha 1 (Calligra 2.4 Alpha 1)) on KDE Platform 4.6.3 (4.6.3) using Qt 4.7.2
calligra is compiled from source (git, 2011-05-27)
The crash happened opening an Access 2000 mdb file
-- Backtrace (Reduced):
#6 KexiDB::IndexSchema::addField (this=0x24bee30, field=0x0) at /home/monfardini/devel/calligra/kexi/kexidb/indexschema.cpp:90
#7 0x00007ff222b26087 in KexiMigration::MDBMigrate::getPrimaryKey (this=<value optimized out>, table=0x24b7d00, tableDef=0x24b7e70) at /home/monfardini/devel/calligra/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:432
#8 0x00007ff222b265bd in KexiMigration::MDBMigrate::drv_readTableSchema (this=0x24453b0, originalName=<value optimized out>, tableSchema=...) at /home/monfardini/devel/calligra/kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:188
#9 0x00007ff22bca5932 in KexiMigration::KexiMigrate::performImport (this=0x24453b0, result=0x7fff518a9d20) at /home/monfardini/devel/calligra/kexi/migration/keximigrate.cpp:200
#10 0x00007ff22bcb19a8 in KexiMigration::ImportWizard::import (this=0x1ce3d20) at /home/monfardini/devel/calligra/kexi/migration/importwizard.cpp:820
Thank you for your email. It has been automatically forwarded to my new email address: sd@warpuniversal.co.uk. Please update your address book - thanks! :-) Steve *** Bug 259700 has been marked as a duplicate of this bug. *** *** Bug 156811 has been marked as a duplicate of this bug. *** *** Bug 271886 has been marked as a duplicate of this bug. *** *** Bug 262101 has been marked as a duplicate of this bug. *** *** Bug 280212 has been marked as a duplicate of this bug. *** Good backtrace in #285380. *** Bug 285380 has been marked as a duplicate of this bug. *** Could you please compress your sample crashing database and send via email to staniek@kde.org? You can also remove extra objects from it if you wish, leaving one object that causes the crash. Created attachment 66624 [details]
New crash information added by DrKonqi
kexi (2.3.3 (KOffice 2.3.3)) on KDE Platform 4.6.5 (4.6.5) using Qt 4.7.2
- What I was doing when the application crashed: Importing a MDB- file (Microsoft ACCESS database)
-- Backtrace (Reduced):
#7 0xac6365e2 in mdb_read_indices (table=0x9605540) at ../../../../../kexi/migration/mdb/src/mdbtools/libmdb/index.c:134
#8 0xac63147a in KexiMigration::MDBMigrate::getPrimaryKey (this=0x94601b8, table=0x96053c0, tableDef=0x9605540) at ../../../../../kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:396
#9 0xac631b5f in KexiMigration::MDBMigrate::drv_readTableSchema (this=0x94601b8, originalName=..., tableSchema=...) at ../../../../../kexi/migration/mdb/src/keximdb/mdbmigrate.cpp:188
#10 0xac60efb3 in KexiMigration::KexiMigrate::performImport (this=0x94601b8, result=0xbffac9d4) at ../../../kexi/migration/keximigrate.cpp:199
#11 0xac61c3d2 in KexiMigration::ImportWizard::import (this=0x9460a18) at ../../../kexi/migration/importwizard.cpp:820
On 12/06/2011 10:14 PM, Jarosław Staniek wrote:
> https://bugs.kde.org/show_bug.cgi?id=240343
>
>
> Jarosław Staniek <staniek@kde.org> changed:
>
> What |Removed |Added
> ----------------------------------------------------------------------------
> Status|ASSIGNED |NEEDSINFO
> Resolution| |WAITINGFORINFO
>
>
>
>
> --- Comment #20 from Jarosław Staniek <staniek kde org> 2011-12-06 21:14:00 ---
> Could you please compress your sample crashing database and send via email to
> staniek@kde.org? You can also remove extra objects from it if you wish, leaving
> one object that causes the crash.
>
Jarosław
Find the culprit file attached.
I don't know where it crash, but nothing too much sensible in it.
Two changes to this bug : one informations have been transmitted directly to dev please adjust status. Platform : has I enconter this crash on openSUSE rpm I thing we can enlarge the Platform too OK, I still need sample database that crashes Kexi, crash information is not enough. Update: Tested database sent by Bruno and no problem with import on a 32-bit single core Intel machine... Looks like architecture-dependent bug. Hello, I'm sorry don't reply before. I have just opened a microsoft jet database (mdb) and the result was great. I've saved the mdb file as kexi project and when visualizing data looks like all right. Good job. Congratulations! 2011/12/14 Jarosław Staniek <staniek@kde.org> > https://bugs.kde.org/show_bug.cgi?id=240343 > > > > > > --- Comment #25 from Jarosław Staniek <staniek kde org> 2011-12-14 > 22:49:41 --- > Update: Tested database sent by Bruno and no problem with import on a > 32-bit > single core Intel machine... Looks like architecture-dependent bug. > > -- > Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email > ------- You are receiving this mail because: ------- > You are on the CC list for the bug. > (In reply to comment #26) Caco, I am glad it works for you. Could you let me know if you use 32 or 64-bit machine and what's your Kexi version? My machine is 32-bit. $ uname -a: Linux caco-laptop 3.0.0-15-generic #26-Ubuntu SMP Fri Jan 20 15:59:53 UTC 2012 i686 i686 i386 GNU/Linux Kexi version: Version 2.3.3 (KOffice 2.3.3) Using KDE Development Platform 4.7.4 (4.7.4) 2012/1/29 Jarosław Staniek <staniek@kde.org> > https://bugs.kde.org/show_bug.cgi?id=240343 > > > > > > --- Co mment #27 from Jarosław Staniek <staniek kde org> 2012-01-29 > 22:46:30 --- > (In reply to comment #26) > > Caco, I am glad it works for you. Could you let me know if you use 32 or > 64-bit > machine and what's your Kexi version? > > -- > Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email > ------- You are receiving this mail because: ------- > You are on the CC list for the bug. > *** Bug 299202 has been marked as a duplicate of this bug. *** *** Bug 332315 has been marked as a duplicate of this bug. *** Confirmed, awaiting for sample files. Idea: Can someone test again with Kexi 2.8? It seems that Kexi 2.4 is the newest one tested here. Correct me if I'm wrong, but I'm not seeing any mdb file attached or referenced in this report. I'd be glad to test with latest kexi stable if anyone could provide us with some. Regards, @Raúl: I propose to use the popular Northwind.mdb database. Available with MS Access (if you have it somewhere) but also at various places, just googled for you, it's there: http://www.mcfedries.com/AccessForms/examples.asp. Microsoft.com had it somewhere too. 2.9.11 will get update for the MDB handling. Feel free to use it and test. If there are crashes, feel free to re-open this report. |