Summary: | LO Base freeze when using a form with macro to enter MySQL data | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | J-Paul <arverne> |
Component: | LibreOffice | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | adamseskunas, iplaw67 |
Priority: | medium | ||
Version: | 7.6.4.1 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 104790 | ||
Attachments: |
Table MySQL
LO Base to test |
Description
J-Paul
2022-05-25 12:26:03 UTC
Created attachment 180368 [details]
Table MySQL
Created attachment 180369 [details]
LO Base to test
@J-Paul : could you try and reproduce this behaviour with a more simplified embedded HSQLDB example and corresponding form (preferably with a reduced data set)? I downloaded your SQL dump and tried to import the data into a test database, but then I ended up having to edit a number of form controls as the queries which are used to populate them are highly dependent on the db name you have used, and I still couldn't get the form to work properly even without macros, so I gave up. Sorry ! Of course, it's quite impossible to use it without the real MySQL database because the form and queries need some other configuration tables (I can provide them). I could do what you ask for but if I change the database type, the problem is over ! I mean : now, I have switched to a MySQL JDBC connection and I have no more this problem. So this issue seems to depend of the direct connection to MySQL. On the french OpenOffice/LibreOffice Forum, several people say they have no problem with a direct connection OpenOffice-MySQL. So, this issue seems to be specific to LO. Would it be better with MariaDB (other people say the connector has been developed for MariaDB) ? [Automated Action] NeedInfo-To-Unconfirmed @J-Paul: if you're using a distrib-provided version of LO, you might be able to install the corresponding debug packet, and then run LO in a lldb debugger or gdb session until it crashes to get a full backtrace with symbols, and then paste the output to a text file which you could attach to this bug report. Could not reproduce using Version: 7.5.3.2 (X86_64) Build ID: 50(Build:2) CPU threads: 1; OS: Linux 6.3; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded and Version: 7.7.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5a2c6f4df7149f8c1f543f120fe19bd66abfc189 CPU threads: 1; OS: Linux 6.3; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Was not able to use @J-Paul 's database as it was too complicated to set up. Used a simple one table MySQL database, directly connected, with a simple 3 field form and a simple macro that filled out one of the fields. @J-Paul can you try and reproduce with a simple database? Setting to NEEDINFO. Dear J-Paul, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping Hello, I understand very well your request but I can't reach it ! I mean : the "How to debug" webpage of the wiki is too much technical for me : I don't understand how to use the commands and what are the consequences of what is required. So it is not usable for me. I'm sorry. @J-Paul : the error message points to a gdk issue, and my own searching with the error message leads to a suggestion that the problem of freezing is linked to the use of Wayland as the desktop UI default provided by Ubuntu. I have encountered many such UI freezes with Wayland unfortunately, not just with LibreOffice, some requiring force kill of the application. One way to test this is to start an Xorg session instead of Wayland when you open a desktop session from the user login screen. If the problem still persists in LibreOffice when using a Xorg session, then the problem is 'likely with the Gnome core snap package used by Ubuntu. In any of these eventualities, the problem would not lie with LibreOffice, this would therefore not be our bug. Hello, That was easy ! But it is not the good answer… I try to use this LO Base file in a Wayland and then in a Xorg session : same issue ! The app freezes or close suddenly ! I have only to make a search in a table to get the freeze. I have looked in the system log and the Journal : I have not seen anything. [Automated Action] NeedInfo-To-Unconfirmed |