Bug 422216

Summary: Kexi crashes when creating a new database or importing an MS Access database
Product: [Applications] KEXI Reporter: Antonio García <I027614>
Component: GeneralAssignee: Kexi Bugs <kexi-bugs>
Status: CONFIRMED ---    
Severity: crash CC: adam, inksi, staniek
Priority: NOR    
Version: 3.2.0   
Target Milestone: ---   
Platform: Mageia RPMs   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: signature.asc
volcado
signature.asc
volcado2
signature.asc

Description Antonio García 2020-05-29 09:57:27 UTC
SUMMARY
On Mageia x86_64 Kexi crashes when creating a new database or importing an MS database

STEPS TO REPRODUCE
1. Open Kexi
2. Create a new database or import an MS Access database.
3. Select "database stored in file" and complete options.

OBSERVED RESULT

When importing an MS Access database: 

kexi-3.2
gui updated 4 min. ago, next auto-update in 56 min.
selectedFile: "/home/antonio/Documentos/Bases de datos/Exporta-Kexi/Silbato 2004.mdb"
selectedFile after applyEnteredFileName(): "/home/antonio/Documentos/Bases de datos/Exporta-Kexi/Silbato 2004.mdb"
Project File: "/home/antonio/Documentos/Bases de datos/Exporta-Kexi/Silbato 2004.mdb"
"Tag 'html' is not defined in message {<__kuit_internal_top__>El asistente de importación de bases de datos va a ...}."
File Destination...
Current file name: "/home/antonio/Documentos/Silbato 2004.kexi"
Structure and data selected
File Destination...
Current file name: "/home/antonio/Documentos/Silbato 2004.kexi"
Structure and data selected
File Destination...
Current file name: "/home/antonio/Documentos/Silbato 2004.kexi"
Structure and data selected
"/home/antonio/Documentos/Silbato 2004.kexi"
Performing import...
CONNECTING...
GETTING TABLENAMES...
Reading list of tables...
num_keys 1
key 1 col 1 "Numero_del_campo"
num_keys 1
key 1 col 1 "Localidad"
num_keys 1
key 1 col 1 "ID"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "Numero"
num_keys 1
key 1 col 1 "ID"
num_keys 1
key 1 col 1 "Categoria"
Violación de segmento (`core' generado)

When creating a new database:

kexi-3.2
gui updated 26 min. ago, next auto-update in 34 min.
QUrl("file:///home/antonio/Documentos/Base de datos nueva.kexi")
filters: ("*.kexi|Proyecto basado en archivos de base de datos Kexi (*.kexi)") path: "/home/antonio/Documentos/Base de datos nueva.kexi"
Missing recent focus widget for KexiProjectCreationPage(0x7f78a4009d30) -- this cat lead to usability isses; please call KexiAssistantPage::setRecentFocusWidget() for that page.
Violación de segmento (`core' generado)

EXPECTED RESULT

Creating a new database or importing an MS database.

SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 5.6.14-desktop-2.mga7
(available in About System)
KDE Plasma Version: 5.15
KDE Frameworks Version: 5.57.0
Qt Version: 
5.12.6 (compiled with 5.12.2)

ADDITIONAL INFORMATION
Comment 1 Jarosław Staniek 2020-05-29 10:09:46 UTC
Thanks for the report. Are you able to try creating a new database on an MySQL  or PostgreSQL server please? This can help to narrow down the area.

Also does the opening an existing .kexi file work?
Comment 2 Jarosław Staniek 2020-05-29 10:12:04 UTC
Another question, do you experience these crashes after system's update? KEXI was not updated since 3.2.0 is the most recent one, so we need to know if there's an issue with any package used by KEXI.
Comment 3 Antonio García 2020-05-30 23:15:35 UTC
Created attachment 128939 [details]
signature.asc

Hi,

Opening an existing Kexi database:

kexi-3.2
gui updated 3 min. ago, next auto-update in 57 min.
selectedFile: "/home/antonio/Documentos/Bases de datos/Varias/Silbato
2000.kexi"
selectedFile after applyEnteredFileName():
"/home/antonio/Documentos/Bases de datos/Varias/Silbato 2000.kexi"
Project File:  "/home/antonio/Documentos/Bases de datos/Varias/Silbato
2000.kexi"
Violación de segmento (`core' generado)

El vie, 29-05-2020 a las 10:09 +0000, Jarosław Staniek escribió:
> https://bugs.kde.org/show_bug.cgi?id=422216
> 
> Jarosław Staniek <staniek@kde.org> changed:
> 
>            What    |Removed                     |Added
> -------------------------------------------------------------------
> ---------
>                  CC|                            |staniek@kde.org
> 
> --- Comment #1 from Jarosław Staniek <staniek@kde.org> ---
> Thanks for the report. Are you able to try creating a new database on
> an MySQL 
> or PostgreSQL server please? This can help to narrow down the area.
> 
> Also does the opening an existing .kexi file work?
>
Comment 4 Jarosław Staniek 2020-05-30 23:28:52 UTC
Thanks. Backtrace (stack trace) would be needed for this crash. You may need to find out how to obtain it in Mageia.
Comment 5 Antonio García 2020-05-31 21:10:34 UTC
Created attachment 128960 [details]
volcado

Hi,

I hope the attached file works.

Thanks,

I027614

 

El sáb, 30-05-2020 a las 23:28 +0000, Jarosław Staniek escribió:
> https://bugs.kde.org/show_bug.cgi?id=422216
> 
> --- Comment #4 from Jarosław Staniek <staniek@kde.org> ---
> Thanks. Backtrace (stack trace) would be needed for this crash. You
> may need to
> find out how to obtain it in Mageia.
>
Comment 6 Antonio García 2020-05-31 21:10:34 UTC
Created attachment 128961 [details]
signature.asc
Comment 7 Jarosław Staniek 2020-05-31 21:35:27 UTC
Thanks. The file only shows what are the files accessed. E.g. /home/antonio/Documentos/Silbato.kexi was not found. Not sure it should already exist before the crash though. 

If even opening any .kexi file crashes for you we shall focus on that activity one and not on importing mdb files.
Comment 8 Antonio García 2020-05-31 21:58:32 UTC
Created attachment 128962 [details]
volcado2

Hi,

I don't think it should exist previously, since it is the result of
importing the .mdb file.

For opening .kexi files, the attached file.

Thanks,

I027614

El dom, 31-05-2020 a las 21:35 +0000, Jarosław Staniek escribió:
> https://bugs.kde.org/show_bug.cgi?id=422216
> 
> --- Comment #7 from Jarosław Staniek <staniek@kde.org> ---
> Thanks. The file only shows what are the files accessed. E.g.
> /home/antonio/Documentos/Silbato.kexi was not found. Not sure it
> should already
> exist before the crash though. 
> 
> If even opening any .kexi file crashes for you we shall focus on that
> activity
> one and not on importing mdb files.
>
Comment 9 Antonio García 2020-05-31 21:58:33 UTC
Created attachment 128963 [details]
signature.asc
Comment 10 Jarosław Staniek 2020-06-01 08:45:47 UTC
Thanks. I've not concluded anything special from the strace log.
Debug packages for KEXI / KDb would be needed. I am unsure how and if this is available for the distribution. 

It seems there is a way for Megeia, please follow the loing in this section: https://community.kde.org/Kexi/File_a_bug_or_wish#In_case_of_crashes

So it's best if the crash dialog appears with the stack trace (in a Developer tab like this https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports#Crash.21 ).
Comment 11 Justin Zobel 2022-10-10 11:16:40 UTC
Thank you for reporting this crash in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the crash with a recent software version?

If you can reproduce the issue, please change the status to "CONFIRMED" when replying. Thank you!
Comment 12 Antonio García 2022-10-10 19:48:17 UTC
Still the same problem, sorry

I027614
Comment 13 Jarosław Staniek 2022-10-10 20:01:14 UTC
@Justin 
I wanted to say the 3.2.0 is still the newest so such questions do not move us forward.