Description: Form based filter search now hangs the software after upgrading to : Version: 6.2.0.3 (x64) Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-CA (en_CA); UI-Language: en-GB Calc: threaded Steps to Reproduce: 1. Open a Base form and click on form based filter... software hangs 2. 3. Actual Results: Software hangs as above... forced to close and recover database Expected Results: Software hangs Reproducible: Always User Profile Reset: No Additional Info: Actually allowed me to click on a form entry box and enter a searcvh criteria value
Tested with LO 6.2.0.3 and LO 6.2.1.2 on OpenSUSE 64bit rpm Linux. Didn't see any buggy behaviour when filtering with the form based filter.
Confirming this problem with form-based filter button on Mac OSX version 10.11.6 'El Capitan' using HSQLDB version 2.x in a 'split' database setup. A freeze occurs as soon as the form-based filter button in the form window is clicked. It is necessary then to force-quit the LibreOffice application. The problem always occurs with LO 6.2.0.3. The problem does NOT happen with LO version 6.1.5.2
No repro with Version: 6.2.0.3 Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 Threads CPU : 8; OS : Mac OS X 10.14.3; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded Tested with embedded hsqldb. @Brent : please indicate which kind of database file your are using, and which controls are present in your form. Ideally, please provide a sample ODB file in which the behaviour is shown.
@frofa : neither your macOS version, nor your db setup are commonplace today, so the results you encountered may be specific to your environment. For example, you don't mention : - which version of Java you are using ; - whether, or where, you have added the hsqldb.jar to enable access to the split database - these are known to cause specific issues on macOS and so may interfere with the results of testing.
I can reproduce the hang in a form which has a subform, but that was never mentioned in the original bug report. @Brent : we need more detail from you as to how you form is setup, please provided a sample ODB file that causes the hang with more detailed instructions. @frofa : did your testing include a main form with a subform - which controls are included ?
@Alex Thurgood : Yes, in my test the form does have a sub-form (plus two additional sub-sub forms). The main form has a simple LIST-BOX control that stores a contact NAME's ID (integer) in a FILTER table, so after selecting a specific CONTACT NAME, the sub-form displays all that contact's details once a REFRESH button is clicked. Also, the CONTACT details sub-form has two additional 'sub-sub' forms to display some additional LISTS of information about the selected contact. Note: I have another simpler form that does not include the FILTER TABLE setup (as above) but only the 2 'additional information' sub-forms as above-mentioned, and that setup also causes the form-based filter crash as described.
@frofa : thanks for the feedback. We also need Brent to chip in with his setup as currently his report is too vague. If he doesn't have the same or similar setup as what you and I have reported, we can open a separate bug report for our own findings.
@frofa : can you write a new report anyway, and put me on CC ? I'll confirm it at least for macOS. If you don't want to post a sample embedded db, I have one from another bug report I can resubmit. If Brent confirms he has a similar setup, we can then mark this as a DUP of that other report.
Created attachment 149878 [details] Base database with Form Issue
Sorry I have been traveling... The database is used as a address and invoicing database... with 4 tables, a number of queries, one form and a number of reports (Writer and Calc Formats)... The Form utilizes two of the tables with one main form from one table and one sub form from a second table. No issues with Version 6.1.5.2 or earlier... A sample of the database is attached... removing all but the two tables involved, all real data, and all reports etc. (for privacy reasons)... AN ADDITIONAL QUESTION: When entering or editing data in this form, the total records available changes to "1" and you can't refresh to all records or at least I can't find a way to show all records again. I must close the form and reopen... sorry for the second question but I have not been able to find a reason or what to do about this... Regards, Brent Warkentin
@Brent : thanks. Indeed, no hang with Version: 6.1.5.2 Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 Threads CPU : 8; OS : Mac OS X 10.14.3; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group threaded but confirming with Version: 6.2.0.3 Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 Threads CPU : 8; OS : Mac OS X 10.14.3; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded and test file provided by Brent. Regression
With the attached database I could confirm the behaviour. Form based filter didn't work in the form with Version: 6.2.1.2 Build-ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 CPU-Threads: 6; BS: Linux 4.12; UI-Render: Standard; VCL: gtk3; Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded but works with LO 6.1.5.2
Is any work being done on this 'high major' importance issue? Users of the form-based filter button on FORMS with SUBFORMS will be unable to upgrade beyond LO/Base v6.1.x if it is not fixed. (Does anyone know a workaround?)
Has there been any progress on fixing this regression (surely affecting many Base users? e.g. https://ask.libreoffice.org/en/question/202280/form-filter-freezes-in-base/
(In reply to frofa from comment #14) > Has there been any progress on fixing this regression (surely affecting many > Base users? e.g. > https://ask.libreoffice.org/en/question/202280/form-filter-freezes-in-base/ Have tested it with LO 6.3.0.2. Form based filter works as expected there. Could you please test it also with LO 6.3.*?
Created attachment 153105 [details] Apple stacktrace after hang FWIW, enclosing an Apple stack trace after hang with Version: 6.2.4.2 Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 Threads CPU : 8; OS : Mac OS X 10.14.5; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded
No hang with Version: 6.4.0.0.alpha0+ Build ID: 4fe32e65cc56cec959af811a9a99348e764e4966 CPU threads: 4; OS: Mac OS X 10.14.5; UI render: default; VCL: osx; Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US Calc: threaded Given Robert's comments wrt 6.3 and the above test, closing as RESOLVED WFM. As we don't know which commit might have fixed this, we can't ask for backport to 6.2
Created attachment 155422 [details] form with subform firebird embedded The problem still exists with LO Version: 6.2.8.2 (x64) In Version 6.0.7 the problem was not existing. I am working under Windows 7 x64 Professional Service Pack 1 The problem occurs with MariaDB 10.3.11 as well as with firebird embedded. Obviously any form with a subform produces the error of 'hanging the base application' whenever the 'Form based Filter'-button is clicked.
see comment 18 and the eample dated 2019-10-31
(In reply to joachim from comment #18) > Created attachment 155422 [details] > form with subform firebird embedded > > The problem still exists with LO Version: 6.2.8.2 (x64) > In Version 6.0.7 the problem was not existing. > I am working under Windows 7 x64 Professional Service Pack 1 > The problem occurs with MariaDB 10.3.11 as well as with firebird embedded. > Obviously any form with a subform produces the error of 'hanging the base > application' whenever the 'Form based Filter'-button is clicked. Pleas test with a Version LO 6.3.3.2. You are testing with a version where no bugfixes would be made for. I could confirm it isn't working right with LO 6.2.6.2, but it is working right without buggy behaviour with LO 6.3.0.2 and all other LO 6.3.-version I installed here, for example 6.3.3.2 on OpenSUSE 15 64 bit rpm Linux. So I will close this bug again as WORKSFORME.
Indeed, this works fine with Version: 6.3.1.2 Build ID: b79626edf0065ac373bd1df5c28bd630b4424273 Threads CPU : 4; OS : Mac OS X 10.15.1; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded Confirming Robert's findings, this is resolved WFM.