Bug 139320 - LO Vanilla - creating Firebird embedded ODB file on macOS Apple Silicon M1 throws error and creates unusable database file
Summary: LO Vanilla - creating Firebird embedded ODB file on macOS Apple Silicon M1 th...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: ARM macOS (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: notBibisectable, regression
Depends on:
Blocks: Database-Firebird-Default
  Show dependency tree / graph
 
Reported: 2020-12-30 14:57 UTC by Alex Thurgood
Modified: 2021-06-24 10:26 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2020-12-30 14:57:03 UTC 
Description:
Attempting to activate any basic function in a new embedded Firebird ODB file with 

Version: 7.0.4.2
Build ID: 86854cc6f33e285facadff0644b2db752e193d8c
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

gives the following error message: 

Impossible d'établir la connexion à la source de données « TestEMP ».
firebird_sdbc error:
*lock manager error
caused by
'isc_create_database'

The file is created, can be saved, and can also be reloaded, but clicking on any of the basic icons on the left hand side of the main Base window brings up the same error.

The ODB file was saved to the Downloads folder.


Steps to Reproduce:
See above.

Actual Results:
An error message is displayed, and none of the basic main Base functionality is available to add tables, define queries, etc

Expected Results:
The database wizard should allow the user to access the main basic functions of the Base window interface without throwing an error.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.4.2
Build ID: 86854cc6f33e285facadff0644b2db752e193d8c
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 1 Alex Thurgood 2020-12-30 14:59:32 UTC 
The same file opens just fine without errors using TDF build :


Version: 7.0.3.1
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 2 Julien Nabet 2021-01-16 15:45:18 UTC 
On pc Debian x86-64 with LO Debian package 7.0.4.2, I don't reproduce this.

I know nothing about LO Vanilla so can't help here.
=> uncc myself.
Comment 3 Julien Nabet 2021-02-20 09:07:24 UTC 
just wonder if the fix for tdf#140332 could help for this one too.
Comment 4 Xisco Faulí 2021-02-22 09:29:10 UTC 
Hi Alex,
is this issue fixed after the fix for bug 140332 ?
Comment 5 Alex Thurgood 2021-02-22 10:12:07 UTC 
(In reply to Xisco Faulí from comment #4)
> Hi Alex,
> is this issue fixed after the fix for bug 140332 ?

The issue was only present in LO Vanilla, and there hasn't yet been a newer release that integrates the changes made in bug 140332 to my knowledge.
Comment 6 QA Administrators 2021-02-23 04:26:48 UTC Comment hidden (obsolete)
Comment 7 Alex Thurgood 2021-06-24 10:26:36 UTC 
Seems to be working again now with

Version: 7.1.4.2 / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Mac OS X 11.4; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded