Bug 103939 - Crash when browsing tables in Base on MacOS Sierra 10.12.1
Summary: Crash when browsing tables in Base on MacOS Sierra 10.12.1
Status: RESOLVED DUPLICATE of bug 103719
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All macOS (All)
: highest critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2016-11-15 14:57 UTC by Gerhard Schaber
Modified: 2016-11-17 12:57 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Test Beispiel_Sport.odb with which LO crashes (22.76 KB, application/vnd.oasis.opendocument.database)
2016-11-15 15:23 UTC, Alex Thurgood
Details
Test 2014_freshman_books.odb which can't be opened due to alleged version mismatch (30.61 KB, application/vnd.oasis.opendocument.database)
2016-11-15 15:24 UTC, Alex Thurgood
Details
backtrace from lldb debugging session (18.15 KB, text/plain)
2016-11-15 16:21 UTC, Alex Thurgood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gerhard Schaber 2016-11-15 14:57:38 UTC
Open any database file and then go to Tables on the panel on the left side.

The color profile on the Mac is set to generic, so this is not it. LO even loads the database file, it only crashes when Java is involved, it seems.

I tested with JDK 8 Update 101, 111, and 112. It happens with all of those versions. It actually works with the very old Java 8 Update 74.

I am not sure whether this is a Java or LO issue.
Comment 1 Alex Thurgood 2016-11-15 15:19:46 UTC
Testing with :


Version: 5.1.6.2
Build ID: 07ac168c60a517dba0f0d7bc7540f5afa45f0909
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group



I don't get a crash, but I get the following error message instead :

Impossible d'établir la connexion à la source de données "2014 freshman books".

Statut SQL: HY000

La connexion n'a pas pu être établie. La base de données a été créée par une version plus récente de LibreOffice.

This is of course an incorrect error message for a file that was created with a previous version of LO (and not a newer one).
Comment 2 Alex Thurgood 2016-11-15 15:22:12 UTC
OK, I can reproduce this with another ODB file.

Confirming.

Yet another major regression in an EOL allegedly "still" bug-fixed release...
Comment 3 Alex Thurgood 2016-11-15 15:23:21 UTC
Created attachment 128764 [details]
Test Beispiel_Sport.odb with which LO crashes
Comment 4 Alex Thurgood 2016-11-15 15:24:55 UTC
Created attachment 128765 [details]
Test 2014_freshman_books.odb which can't be opened due to alleged version mismatch
Comment 5 Alex Thurgood 2016-11-15 15:26:02 UTC
Comment 1 refers to the test using the "version mismatch" ODB attached file.

Comment 2 refers to the test using "Test ODB which crashes" file.
Comment 6 Alex Thurgood 2016-11-15 15:31:02 UTC
If I try and open the 5.1.6 crasher ODB file in 

Version: 5.2.3.3
Build ID: d54a8868f08a7b39642414cf2c8ef2f228f780cf
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

I get a first error message that the db can't be opened due to an incorrect "SA" authentication identifier, then I get a subsequent error message :

Impossible d'établir la connexion à la source de données "Beispiel_Sport".

tatut SQL: HY000

La connexion n'a pas pu être établie. La base de données a été créée par une version plus récente de LibreOffice.
Comment 7 Alex Thurgood 2016-11-15 15:32:21 UTC
The first error message with 5233 is :

Statut SQL: 28501
Code d'erreur: -4001

invalid authorization specification - not found: SA
Comment 8 Alex Thurgood 2016-11-15 15:36:58 UTC
I'm using JDK 1.8.0_112
Comment 9 Alex Thurgood 2016-11-15 15:44:49 UTC
I also get a crash in LO 5142 with Beispiel_Sport.odb as soon as I click on the Tables icon.
Comment 10 Alex Thurgood 2016-11-15 16:10:00 UTC
As I get the same authentication error message 


Statut SQL: 28501
Code d'erreur: -4001

invalid authorization specification - not found: SA


with LO5032 and Apple's JavaforOSX in combination with Oracle JDK 1.8.0_112, and in view of Gerhard's original comment with respect to JDK 1.8.0_74, I'm going to hasard a guess that this is a problem with the JDK subversion numbers above 100 again and some incompatibility with hsqldb.jar.
Comment 11 Alex Thurgood 2016-11-15 16:19:54 UTC
Sigh, this gives the same backtrace as the report that was closed the other day because 51xx is EOL....
Comment 12 Alex Thurgood 2016-11-15 16:21:28 UTC
Created attachment 128767 [details]
backtrace from lldb debugging session
Comment 13 Julien Nabet 2016-11-15 16:25:00 UTC
Stephan: thought you might be interested in this one. Indeed, even if it concerns Base, it seems related to Java part (according to the bt provided by Alex)
Comment 14 Gerhard Schaber 2016-11-15 16:35:58 UTC
In contrast to LO 5.1.6.2, I can browse the tables with LO 5.2.3.3, and even open forms.

One thing is strange, though. In the list of available Java runtimes, LO 5.2.3.3 shows 3 times the version 1.8.0_112, and once 1.8.0_74. It seems it replaces the Java updates 101 and 111 with 112.

LO 5.1.6.2 shows the Java runtimes correctly, but on the other hand browsing tables only works in conjunction with Java update 74 with that version.
Comment 15 Alex Thurgood 2016-11-15 16:37:48 UTC
I could open yet another Base ODB file in LO 5233 without causing a crash, however this hadn't previously been opened by LO 5162.

When I then attempted to open this other ODB files in LO 5162, I get the error message of comment 1. Any subsequent attempt to open the same file in LO5233 leads to the same message, so the file is effectively corrupt.


This means that both LO 5233 and LO5162 corrupt existing ODB files when used with a JDK 1.8.0 > 99


@Stephan - any advice ?
Comment 16 Stephan Bergmann 2016-11-16 20:35:41 UTC
From "I tested with JDK 8 Update 101, 111, and 112. It happens with all of those versions. It actually works with the very old Java 8 Update 74." in comment 0 and "terminating with unexpected exception of type jfw_plugin::MalformedVersionException" in attachment 128767 [details] this is apparently a duplicate of bug 103719 (i.e., the fix for bug 101057 about three-digit Java update version in LO 5.1.5 missing in 5.1.6).

(If any other specific issues mentioned in this bug's various comments remain, please file new bugs for those.)

*** This bug has been marked as a duplicate of bug 103719 ***
Comment 17 Stephan Bergmann 2016-11-17 11:21:58 UTC
(In reply to Gerhard Schaber from comment #14)
> One thing is strange, though. In the list of available Java runtimes, LO
> 5.2.3.3 shows 3 times the version 1.8.0_112, and once 1.8.0_74. It seems it
> replaces the Java updates 101 and 111 with 112.
> 
> LO 5.1.6.2 shows the Java runtimes correctly

(That 5.2 regression should be fixed now with <https://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-5-2&id=7e819f20f36ed0208ad9a46bdccbdb52fb353b54> "Fix regression in bubbleSortVersion".)
Comment 18 Gerhard Schaber 2016-11-17 12:36:48 UTC
Thanks. Does this affect other versions as well?
Comment 19 Stephan Bergmann 2016-11-17 12:57:45 UTC
(In reply to Gerhard Schaber from comment #18)
> Thanks. Does this affect other versions as well?

That regression presumably got introduced into master towards LO 5.2 (so any LO 5.2.x and upcoming 5.3 would be affected, but no 5.1.x or earlier); fixes are in libreoffice-5-2 (towards LO 5.2.4) and master (towards LO 5.3).