https://bugs.documentfoundation.org/show_bug.cgi?id=165839
Bug ID: 165839
Summary: Libreoffice Base hangs when two connections to a
server via internal drive edit the same table
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When there are more than one connections to a firebird server via internal
driver and two or more of the connections try to modify the same table,
LibreOffice hangs and you need to kill it to recover
Steps to Reproduce:
In order to reproduce the error it is necessary to have a Firebird server (no
matter the version) and to have a database that can be accessed remotely and a
user that can access at least with localhost.
Please note that on some systems, depending on the configuration, sysdba cannot
remotely access the server.
If you want to test with a single machine, you need to create two .odb files
with the same configuration but with different names.
To facilitate the instructions I have made the connection to the employee
database which is installed by default with the alias employee in the
installations made with the installers downloaded from the firebirdsql.org
page. May be this database don't exists if you made the installation with your
system the repository.
1. Open LibreOffice Base
2. Select *Connect to an existing database*. In the dropdown select *Firebird
external*. Click *Next*
3. In the connection string text box type <host>[/port]:<path-or-alias>, in our
case *localhost:employee*. Click *Next*
4. Write the user name in the text box and check *Password required*. If
desired click on *Test Connection* button. Click on *Next*
5. click *Finish* and give a name to the .odb file.
6. Open two connection to the same database. As said before, if you are going
to test with two connections in the same equipment, copy the .odb file created
in previous step with a different name.
7. Start editing one table in one connection, but don't save anything for the
moment
8. Edit the same table in the other connection. Save the changes.
9. LibreOffice hangs. The only way to recover is killing LibreOffice and
restart.
Actual Results:
LibreOffice hangs
Expected Results:
LibreOffice should save the edition in the second connection an allow
continuing the edition in the first one
Reproducible: Always
User Profile Reset: No
Additional Info:
I think, currently the most used way to connect to a Firebird server is with
the JDBC connector provided in the Firebird website, but the from the Jaybird 6
version of the driver, the connection to LibreOffice is not supported. The
internal Firebird driver is the recommended way to connect given by Firebird
team.
Tested with:
-----------
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 1d8ff7bd62249ad0f825eaca18ea524d9d7c6c2e
CPU threads: 16; OS: Windows 11 X86_64 (build 22631); UI render: Skia/Vulkan;
VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL threaded
-----------
Version: 25.2.1.2 (X86_64) / LibreOffice Community
Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render:
Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL threaded
-----------
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
