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
Summary: | Attempt to create Firebird database results in isc_create_database error | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | [Fedora] Fedora | Reporter: | Anthony E. Greene <agreene> | ||||||
Component: | libreoffice | Assignee: | Caolan McNamara <caolanm> | ||||||
Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||||
Severity: | high | Docs Contact: | |||||||
Priority: | unspecified | ||||||||
Version: | 30 | CC: | caolanm, dtardon, erack, sbergman, sgrubb, vitaly | ||||||
Target Milestone: | --- | ||||||||
Target Release: | --- | ||||||||
Hardware: | x86_64 | ||||||||
OS: | Linux | ||||||||
Whiteboard: | |||||||||
Fixed In Version: | Doc Type: | If docs needed, set a value | |||||||
Doc Text: | Story Points: | --- | |||||||
Clone Of: | Environment: | ||||||||
Last Closed: | 2019-09-02 07:56:25 UTC | Type: | Bug | ||||||
Regression: | --- | Mount Type: | --- | ||||||
Documentation: | --- | CRM: | |||||||
Verified Versions: | Category: | --- | |||||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
Cloudforms Team: | --- | Target Upstream Version: | |||||||
Embargoed: | |||||||||
Attachments: |
|
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 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 ~]$ rpm -q libfbclient2 libfbclient2-3.0.4.33054-2.fc30.x86_64 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 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. 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=
[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 Installing firebird solves the issue. I was able to create a new firebird database and convert an existing HSQLDB database to firebird. 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. 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? Now libreoffice-core require firebird. Please revert to previous spec version. I don't want to install this on my desktop. |
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.