Bug 139340 - Crash when opening Table or Query with graphic Editor
Summary: Crash when opening Table or Query with graphic Editor
Status: RESOLVED DUPLICATE of bug 140951
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-31 14:36 UTC by F langner
Modified: 2021-09-06 19:49 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Latest LO Crash Dump (271.76 KB, application/octet-stream)
2020-12-31 14:40 UTC, F langner
Details
second Crash Dump (173.19 KB, application/octet-stream)
2021-01-02 12:37 UTC, F langner
Details
first of two crash dumps (176.89 KB, application/octet-stream)
2021-01-02 12:38 UTC, F langner
Details
ODB-Database with sanitized Table Rechnng2 (15.25 KB, application/vnd.sun.xml.base)
2021-02-24 20:49 UTC, F langner
Details

Note You need to log in before you can comment on or make changes to this bug.
Description F langner 2020-12-31 14:36:22 UTC
Description:
Each Time EDITING a TABLE or BUILDING / EDITING a QUERY VIEW.
LO Crashes when switching to Designer Screen for Tables or Queries (View), Reports not tested as it relies on Queries.

Trying on internal HSSQDB using small one table DB.
All Fields are Type Text.

https://crashreport.libreoffice.org/stats/crash_details/5c07ee3e-ecf0-49bd-8a1f-f1ffe8f2d164



Steps to Reproduce:
1.Build DB
2.Create Table "Accounting"
3.Fill in some Date
4.Open Query Designer 
5.Crash

Actual Results:
In my case LO Crashes when opening Designer Window

Expected Results:
Open Designer Window


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
Comment 1 F langner 2020-12-31 14:40:42 UTC
Created attachment 168604 [details]
Latest LO Crash Dump
Comment 2 Robert Großkopf 2021-01-01 08:56:38 UTC
Couldn't confirm this behavior for OpenSUSE 15.2 64bit rpm Linux.

Created many queries in the last days with LO 7.0.4.2. No crash happened. So it might be a special Windows bug.
Comment 3 Julien Nabet 2021-01-01 21:41:24 UTC
Could you upgrade to 7.0.4 and give a try at https://wiki.documentfoundation.org/QA/FirstSteps ?
Comment 4 F langner 2021-01-02 12:37:01 UTC
Created attachment 168631 [details]
second Crash Dump

second of latest two Crash Dumps
Comment 5 F langner 2021-01-02 12:38:34 UTC
Created attachment 168632 [details]
first of two crash dumps

Crash Dump after unchecking opencl
Comment 6 Julien Nabet 2021-01-02 12:43:17 UTC
Thank you for your feedback.
I don't know how to use a dump file.
I only know stacktrace but I suppose someone may help here.
=> uncc myself
Comment 7 Xisco Faulí 2021-02-23 09:23:30 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 8 F langner 2021-02-24 20:49:25 UTC
Created attachment 170037 [details]
ODB-Database with sanitized Table Rechnng2

Thank You for replying me.
Please find aside the requested sample file.

regards
Comment 9 Alex Thurgood 2021-02-25 11:00:22 UTC
No repro with 

Version: 7.1.0.3 / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded

1) Loaded test file provided by OP

2) Double-clicked on a table, table opened without crash for editing

3) I can also select Create View... and the SQL window is displayed to create a view as a table, without crashing.

4) In the Query window, I can choose any of the 3 entries (Create Query in Design View, Use Wizard to Create Query, or Create Query in SQL View) and no crash.

Suspect that this a Windows only bug ?
Comment 10 Alex Thurgood 2021-03-12 10:15:59 UTC
@F_Langner : please advise whether you are using, or have activated, any accessibility tools or functions of Windows OS when running LibreOffice ?
Comment 11 Alex Thurgood 2021-03-12 10:19:56 UTC
The crash report link posted by the OP points to calls in the accessibility API when calling the getCellText() function in :

dbaui::OSelectionBrowseBox::GetCellText(long,unsigned short)

at

C:\cygwin64\home\buildslave\source\libo-core\dbaccess\source\ui\querydesign\SelectionBrowseBox.cxx:2106

Perhaps something worth looking at ?
Comment 12 Julien Nabet 2021-09-06 19:49:31 UTC
Sorry I finally found how to reproduce this on Windows with master sources updated some days ago and debug mode.
I've just submitted a patch for tdf#140951

*** This bug has been marked as a duplicate of bug 140951 ***