Bug 123778 - Frequent crashes in sal3.dll when EDITING forms.
Summary: Frequent crashes in sal3.dll when EDITING forms.
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Forms Crash
  Show dependency treegraph
 
Reported: 2019-03-01 06:40 UTC by Alexander Steinhöfer
Modified: 2022-05-02 11:57 UTC (History)
7 users (show)

See Also:
Crash report or crash signature: ["sal3.dll"]
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander Steinhöfer 2019-03-01 06:40:18 UTC
This bug was filed from the crash reporting server and is br-79ecb678-c319-4134-8df7-dc0c2fe8db0d.
=========================================

I am using LibreOffice Base with a MySQL-Backend.

Especially when trying to view/use a Form, LibreOffice crashes very often with this report.

Using:
- MySQL 5.7.23 connected over WAN
- mysql-connector-java-8.0.15.jar

Steps to reproduce:

1. Design Database with SQL Backend
2. Create Form for one table
3. Open Form (not in Design Mode)
4. Likely observer random crash.

I'd really like to help to get this resolved, but I am not sure which information might be relevant to add.

If you need any further info, or more crash reports (I can provide plenty), I'll gladly add them to this bug report. I also have a Visual Studio debugger and gdb (MingW) at hands, if that might help any further.

Thanks for your help!
Comment 1 ribotb 2019-03-06 15:47:21 UTC
Using the same connector (mysql-connector-java-8.0.15.jar), but with MariaDB 5.5.63 on localhost, I don't have that problem. 

If it can help....

Version: 6.1.4.2 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
Threads CPU : 4; OS : Windows 10.0; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: group threaded
Comment 2 Alexander Steinhöfer 2019-03-08 14:01:54 UTC
This problem seems to happen only on Windows 10 for me and my wife, when she was working with Ubuntu just now (same connector), it didn't crash at all.

I've noticed the crashes mostly when I was editting a form, saving it and then tried to view it.

Some more crash reports (somewhat older, but they are always the same nonetheless):

https://crashreport.libreoffice.org/stats/crash_details/0654dd55-6460-466f-a7c8-e65e36bf0b6f
https://crashreport.libreoffice.org/stats/crash_details/9cb8ca8c-a2e5-4077-ab43-3b1df42eafe5
Comment 3 Robert Großkopf 2019-03-09 10:43:20 UTC
(In reply to Alexander Steinhöfer from comment #2)
> This problem seems to happen only on Windows 10 for me and my wife, when she
> was working with Ubuntu just now (same connector), it didn't crash at all.

Which Java-version is running on Windows and on Ubuntu?
Comment 4 Alexander Steinhöfer 2019-03-13 13:18:24 UTC
On Ubuntu:
$ java --version
openjdk 10.0.2 2018-07-17
OpenJDK Runtime Environment (build 10.0.2+13-Ubuntu-1ubuntu0.18.04.4)
OpenJDK 64-Bit Server VM (build 10.0.2+13-Ubuntu-1ubuntu0.18.04.4, mixed mode)

On Windows:
C:\> java -version
java version "1.8.0_201"
Java(TM) SE Runtime Environment (build 1.8.0_201-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)

On Windows, the Java Control Panel tells me, that that's the latest JRE available.
I could install Java 11 JDK and try it again, if you think that could be helpful (although, I guess, most users would be on the latest JRE)!
Comment 5 Alex Thurgood 2019-04-23 10:33:56 UTC
@Alexander : from the trace you have provided via the crash reporter, several exceptions appear to be caught at lines 806 (explicit catch test for obtaining MetaData from the db), 813 (test for whether the ESCAPE PROCESSING PROPERTY has been set,  and 814 (explicit catch test) in SingleSelectQueryComposer.cxx

Reading the comment at line 796 of that same file, which refers to an OOo bug for Access:

https://bz.apache.org/ooo/show_bug.cgi?id=110111

and from Ocke's comments at the time :

https://bz.apache.org/ooo/show_bug.cgi?id=110111#c8

I'm guessing that the corresponding LO MetaData.cxx code needs adjusting somehow to present the correct sequence, however, there are quite a few of these in the LO source code, so I'd hasard a guess and say it might be :

/core⁩/connectivity⁩/source⁩/drivers⁩/jdbc⁩/ResultSetMetaData.cxx

or

/core⁩/connectivity⁩/source⁩/drivers⁩/jdbc⁩/DatabaseMetaData.cxx

or

/core/connectivity/source/drivers/writer/WDatabaseMetaData.cxx


in this particular instance, as your connection is JDBC and you mentioned you were trying to open a form (which is a Writer document).



You don't say what your form is based on, and whether or not it contains subforms, as this would help pinpoint the issue further.

Additionally, the mysql ConnectorJ/8.x series is known to produce a number of buggy behaviours currently with LO, so perhaps switching back to a 5.x series might provide a workaround for the time being.
Comment 6 Alex Thurgood 2019-04-23 10:38:31 UTC
I would add that if Ocke's comments from the OOo bug are anything to go by, then in relation to the 8.x ConnectorJ driver, the blame game as to whether it is a LO code problem or a Mysql code problem needs to be solved in some way...suffice it to say that Oracle have no real incentive to be concerned about bugs with their drivers in LO, unless the effects are more general and extend to other Java applications ;-)
Comment 7 shakhan 2019-10-03 17:35:42 UTC Comment hidden (spam)
Comment 8 Hugo First 2021-01-28 02:10:50 UTC Comment hidden (spam)
Comment 9 Hugo First 2021-04-21 22:22:54 UTC Comment hidden (spam)
Comment 10 Hugo First 2021-04-21 22:23:22 UTC Comment hidden (obsolete)
Comment 11 Xisco Faulí 2022-05-02 11:57:14 UTC
Thanks for reporting this issue.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.