Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at bugzilla.redhat.com.
Bug 1744876 - Attempt to create Firebird database results in isc_create_database error
Summary: Attempt to create Firebird database results in isc_create_database error
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: libreoffice
Version: 30
Hardware: x86_64
OS: Linux
unspecified
high
Target Milestone: ---
Assignee: Caolan McNamara
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-08-23 05:07 UTC by Anthony E. Greene
Modified: 2019-09-02 07:56 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-09-02 07:56:25 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)
Screenshot of error dialog (22.74 KB, image/png)
2019-08-23 05:07 UTC, Anthony E. Greene 		no flags Details
strace (4.30 MB, text/plain)
2019-08-24 13:56 UTC, Anthony E. Greene 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Document Foundation 123797 0 None None None 2019-08-23 13:05:09 UTC
Document Foundation 125284 0 None None None 2019-08-23 13:06:51 UTC

Description Anthony E. Greene 2019-08-23 05:07:46 UTC 
Created attachment 1607195 [details]
Screenshot of error dialog

Description of problem:
Attempt to create Firebird Embedded database results in error:
firebird_sdbc error
*Unable to complete network request to host "localhost".
*Failed to establish a connection.
caused by
'isc_create_database'


Version-Release number of selected component (if applicable):
libreoffice-6.2.6.2-1.fc30


How reproducible:
Every time.


Steps to Reproduce:
1. In LibreOffice startup window, select Base Database.
2. Select: Create a new database; Firebird Embedded; Next
3. Select: Open the database for editing; Finish
4. Observe error dialog.


Actual results:
1. Error dialog is displayed.
2. Database document is opened for work, but attempts to create a table, query, form, or report all fail with the same isc_create_database error.


Expected results:
Database created successfully.


Additional info:
Same error is produced regardless of whether or not database is registered during creation, and regardless of whether it is opened for work when it is created or saved and opened afterward.
Comment 1 Anthony E. Greene 2019-08-23 05:21:14 UTC 
Same behavior reported on Manjaro distro: https://forum.manjaro.org/t/libre-office-base-6-2-0-3-cannot-open-or-create-firebird-embedded-databases/77109
Comment 2 Caolan McNamara 2019-08-23 08:41:43 UTC 
Same version of LibreOffice here shows no problem, and this is the only report to date. What is the output of

rpm -q libfbclient2 

?
In my working case its libfbclient2-3.0.4.33054-2.fc30.x86_64
Comment 3 Anthony E. Greene 2019-08-23 12:19:27 UTC 
 ~]$ rpm -q libfbclient2
libfbclient2-3.0.4.33054-2.fc30.x86_64
Comment 4 Caolan McNamara 2019-08-23 13:14:42 UTC 
Maybe a strace might be helpful in this case.

sudo dnf -y install strace
strace -f /usr/lib64/libreoffice/program/soffice.bin --base --nologo --norestore > ~/soffice.log 2>&1
attempt to create the firebird embedded db, close all soffice windows and then attach the soffice.log in your home dir here
Comment 5 Caolan McNamara 2019-08-23 20:08:46 UTC 
This doesn't seem the be the problem of https://bugs.documentfoundation.org/show_bug.cgi?id=125284 which is triggered by a Turkish locale which I debugged and found a fix for earlier, but worth including the output of

locale

as well in case there is some hint in there.
Comment 6 Anthony E. Greene 2019-08-24 13:56:06 UTC 
Created attachment 1607678 [details]
strace

~]$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
Comment 7 Caolan McNamara 2019-08-25 20:31:43 UTC 
[pid 32641] openat(AT_FDCWD, "/etc/firebird/plugins.conf", O_RDONLY) = -1 ENOENT (No such file or directory)

looks like the problem

how about

sudo dnf -y install firebird

seems we have a missing dependency on it
Comment 8 Anthony E. Greene 2019-08-26 08:46:30 UTC 
Installing firebird solves the issue. I was able to create a new firebird database and convert an existing HSQLDB database to firebird.
Comment 9 Steve Grubb 2019-08-31 13:01:21 UTC 
Why is firebird now being installed on my system? It is not my mail client. Seems like a better error message output when ENOENT is returned should tell the user to install firebird. This way people needing this feature understand what is wrong and can fix it. And those of us that do not use the feature keep our systems uncluttered.
Comment 10 Steve Grubb 2019-08-31 16:11:55 UTC 
OK, so firebird is a database. There does seem to be something strange with the dependencies. If I try to uninstall firebird, it says:
Removing dependent packages:
 libreoffice-emailmerge       x86_64 1:6.2.6.2-2.fc30            @updates  26 k
 libreoffice-help-en          x86_64 1:6.2.6.2-2.fc30            @updates  25 M
 libreoffice-ogltrans         x86_64 1:6.2.6.2-2.fc30            @updates 351 k
 libreoffice-writer2latex     x86_64 1.0.2-25.fc30               @fedora  505 k
 unoconv

OK, that seems good as that is a small subset of packages that I wouldn't use. So, if I try to remove those 
# rpm -e firebird libreoffice-emailmerge libreoffice-help-en libreoffice-ogltrans libreoffice-writer2latex unoconv
error: Failed dependencies:
	firebird is needed by (installed) libreoffice-core

So, core needs it? Looking at the spec file shows only base getting it explicitly. So, let's try to remove base

# rpm -q libreoffice-base
package libreoffice-base is not installed

Wonder if dnf/rpm has a problem with dependencies?
Comment 11 Vitaly Zaitsev 2019-08-31 17:34:41 UTC 
Now libreoffice-core require firebird. Please revert to previous spec version. I don't want to install this on my desktop.
Note You need to log in before you can comment on or make changes to this bug.