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.
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).
OK, I can reproduce this with another ODB file. Confirming. Yet another major regression in an EOL allegedly "still" bug-fixed release...
Created attachment 128764 [details] Test Beispiel_Sport.odb with which LO crashes
Created attachment 128765 [details] Test 2014_freshman_books.odb which can't be opened due to alleged version mismatch
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.
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.
The first error message with 5233 is : Statut SQL: 28501 Code d'erreur: -4001 invalid authorization specification - not found: SA
I'm using JDK 1.8.0_112
I also get a crash in LO 5142 with Beispiel_Sport.odb as soon as I click on the Tables icon.
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.
Sigh, this gives the same backtrace as the report that was closed the other day because 51xx is EOL....
Created attachment 128767 [details] backtrace from lldb debugging session
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)
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.
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 ?
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 ***
(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".)
Thanks. Does this affect other versions as well?
(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).