Description: When trying to make a query, query window freezes as main window ; window «this window doesn't respond" "wait OR quit" » appear ; Waiting doesn't help so I choose "quit" and so, entire libreoffice quit, main and query windows. I reinstalled 24.8 version and everything goes well again. Steps to Reproduce: 1.Just try to make a query in any of the 3 ways except sql mode that I've not experimented 2. 3. Actual Results: Freeze Expected Results: :-) just as usual ! Reproducible: Always User Profile Reset: Yes Additional Info: No other information
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 199257 [details] Just a small base with 24.8 version but anybody can try to create a base with 25.2, it's impossible ! I've created this example base with libreoffice 24.8 because 25.2 version crashes and not let creating a base until the end (unable to fill a table). Just try to create a query and you'll see...
I'm trying to create a query, but is complaining about java missing. But I have checked in Tools - Advanced to use Java.
Version: 25.2.1.1 (X86_64) / LibreOffice Community Build ID: e538fb6403facdfd3db0250c3b3278236c675c2a CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
not reproduced in Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7da1497aa462e2b719aa9b308a749caf7b9a19b1 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded
Hi BogdanB, Do you think the java issue you are facing is the same as the OP ?
(In reply to Xisco Faulí from comment #6) > Hi BogdanB, > Do you think the java issue you are facing is the same as the OP ? not sure...
Hi moebius20, These are the steps I'm following: 1. Open the attached document 2. Click on query 3. Click on Requete1 or 1. Open the attached document 2. Click on query 3. Use Wizard to create Query 4. Follow the steps -> Not freeze. Is there any steps I'm missing ? Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded
No, perhaps this bug doesn't appear in windows ; I'm using linux...
And localization is french
Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
Please, explain the steps to reproduce it
(In reply to Xisco Faulí from comment #12) > Please, explain the steps to reproduce it Well, thank you for looking at that problem but it's so strange to need explaining steps ! At home, with my config, libeoffice freeze like a charm ! Well : - open libreoffice base - open an existing file : toto.odb - in the opened window, click on "queries" second item from the top in left side of the window -click on "créer une requête en mode ébauche" : create a query, first choice from the top - In the window that appear I choose table1 "add" and then "close" window - everything freeze so click the button to close the query window - on pop-up window that appears if I click on "Annuler" (cancel) pop-up window close but nothing else happens - so again try to close the query window and click on "forcer à quitter" (force to quit) and then whole libreoffice quit, not only the query window - end Second example : double-click on query "Requête1" ; the query run and give result and then everything freeze Fortunately, with libreoffice 24.8 everything work fine ! Cordialement,
No repro with Version: 25.8.0.0.alpha0+ (AARCH64) / LibreOffice Community Build ID: 7e1282affdb4e132a6329f378d6379155968b689 CPU threads: 8; OS: macOS 15.2; UI render: Skia/Metal; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded @moebius20 : what are your Skia settings in your LibreOffice user profile ?
On pc Debian x86-64 with master sources updated today + French UI, I don't reproduce this. I tried with gtk3, gen, kf6 and kf5 renderings. On which Linux distrib are you and which version do you use? How did you install LibreOffice, from distrib repositories or from official website? (the last one is more for distrib maintainers, at least for Linux packages rpm and deb files) could you try these: 1) apply https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile 2) open a terminal/console (if to export SAL_USE_VCLPLUGIN=gen soffice <fullpath of toto.odb> and try to reproduce this ?
What I see when running LO master daily build (18/02/2025) in a lldb session is shown below, underneath the list of actions: 1) Load toto.odb into running LO process 2) Click on Queries 3) Dismiss the migration to Firebird dialog. 4) Click on Create Query in Design Mode 5) Select Table1 from the list of tables, close the Table selection dialog 6) Choose fields from the table in the Query Designer. 7) Save the query 8) Execute the query. No crash or freeze at any of these steps. Lldb output: warn:legacy.osl:7702:179290:dbaccess/source/core/dataaccess/ModelImpl.cxx:766: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from! warn:legacy.osl:7702:179290:dbaccess/source/core/dataaccess/ModelImpl.cxx:766: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from! warn:legacy.osl:7702:179290:dbaccess/source/core/dataaccess/ModelImpl.cxx:766: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from! warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlTable.cxx:77: unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 db:command value=SELECT "ID" AS "Identifiant", "date-n" AS "Date Plant" FROM "Table1" warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlQuery.cxx:54: unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 db:name value=Query2 warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlTable.cxx:77: unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 db:command value=SELECT "Nom", "Prenom", "date-n", "profes" FROM "Table1" WHERE "profes" LIKE 'jar%' warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlQuery.cxx:54: unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 db:name value=Requête1 warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber not set (!) warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber not set (!) warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber not set (!) warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber not set (!) warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber not set (!) warn:vcl:7702:179290:vcl/source/app/unohelp2.cxx:50: TextDataObject::CopyStringTo: invalid clipboard!
(In reply to Julien Nabet from comment #15) > On pc Debian x86-64 with master sources updated today + French UI, I don't > reproduce this. > I tried with gtk3, gen, kf6 and kf5 renderings. > > On which Linux distrib are you and which version do you use? > How did you install LibreOffice, from distrib repositories or from official > website? (the last one is more for distrib maintainers, at least for Linux > packages rpm and deb files) > > could you try these: > 1) apply > https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile > > 2) open a terminal/console (if to > export SAL_USE_VCLPLUGIN=gen > soffice <fullpath of toto.odb> > and try to reproduce this > > ? Bonjour, debian bookworm Install with .deb package loaded from libreoffice.org I've already reset user profile with no result. I've done SAL_USE_VCLPLUGIN=gen /usr/local/bin/libreoffice25.2 And it works without freeze and no need to reset user profile, but render is ugly ! :-) cordialement,
(In reply to Alex Thurgood from comment #14) > No repro with > > Version: 25.8.0.0.alpha0+ (AARCH64) / LibreOffice Community > Build ID: 7e1282affdb4e132a6329f378d6379155968b689 > CPU threads: 8; OS: macOS 15.2; UI render: Skia/Metal; VCL: osx > Locale: fr-FR (fr_FR.UTF-8); UI: en-US > Calc: threaded > > @moebius20 : what are your Skia settings in your LibreOffice user profile ? What is a skia setting ?
Well This step cannot be proceeded because there's no firebird migration proposition... : 3) Dismiss the migration to Firebird dialog. Except this, freeze is guaranted ! (In reply to Alex Thurgood from comment #16) > What I see when running LO master daily build (18/02/2025) in a lldb session > is shown below, underneath the list of actions: > > 1) Load toto.odb into running LO process > > 2) Click on Queries > > 3) Dismiss the migration to Firebird dialog. > > 4) Click on Create Query in Design Mode > > 5) Select Table1 from the list of tables, close the Table selection dialog > > 6) Choose fields from the table in the Query Designer. > > 7) Save the query > > 8) Execute the query. > > No crash or freeze at any of these steps. > > > Lldb output: > warn:legacy.osl:7702:179290:dbaccess/source/core/dataaccess/ModelImpl.cxx: > 766: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the > storage from! > warn:legacy.osl:7702:179290:dbaccess/source/core/dataaccess/ModelImpl.cxx: > 766: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the > storage from! > warn:legacy.osl:7702:179290:dbaccess/source/core/dataaccess/ModelImpl.cxx: > 766: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the > storage from! > warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlTable.cxx:77: > unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 > db:command value=SELECT "ID" AS "Identifiant", "date-n" AS "Date Plant" FROM > "Table1" > warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlQuery.cxx:54: > unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 db:name > value=Query2 > warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlTable.cxx:77: > unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 > db:command value=SELECT "Nom", "Prenom", "date-n", "profes" FROM "Table1" > WHERE "profes" LIKE 'jar%' > warn:dbaccess:7702:179290:dbaccess/source/filter/xml/xmlQuery.cxx:54: > unknown attribute urn:oasis:names:tc:opendocument:xmlns:database:1.0 db:name > value=Requête1 > warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber > not set (!) > warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber > not set (!) > warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber > not set (!) > warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber > not set (!) > warn:svgio:7702:179290:svgio/source/svgreader/SvgNumber.cxx:74: SvgNumber > not set (!) > warn:vcl:7702:179290:vcl/source/app/unohelp2.cxx:50: > TextDataObject::CopyStringTo: invalid clipboard!
(In reply to moebius20 from comment #17) > ... > Bonjour, > debian bookworm > Install with .deb package loaded from libreoffice.org > I've already reset user profile with no result. > I've done SAL_USE_VCLPLUGIN=gen /usr/local/bin/libreoffice25.2 > And it works without freeze and no need to reset user profile, but render is > ugly ! :-) Ok so it seems related to gtk libs. I think you should uninstall completely LO then install LO from Debian repository. Now, you must know that "stable" flavour of Debian is more for servers so has very stable but quite old versions of apps . At the opposite, there's "sid" flavour, bleeding edges versions but may be unstable (that's why "sid" and unstable are the same). At the middle and it's what I use, is "testing" flavour, a kind of compromise between quite recent version and a relative stability. (I omit "experimental" flavour but I let this for experts) Now, if you don't want to upgrade to testing flavour you can stick to stable and configure Debian to just use some apps from testing. If LO from testing need more recent gtk libs, I suppose apt should do the job and retrieve them. To respond to your other message about Skia, more info here: https://wiki.documentfoundation.org/QA/FirstSteps#Graphics-related_issues_(_Skia_)
From what I can tell from the QA tester comments, this should be UNCONFIRMED, setting as such.
I rather think moebius20 should uninstall deb files and try what I proposed in my previous comment. I think there should really be some warning for debs and rpms on the website, they're for maintainers since dependencies must be managed. Meanwhile, waiting for moebius' feedback.
problem not occurs with : Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: bbb074479178df812d175f709636b368952c2ce3 CPU threads: 4; OS: Windows 7 Service Pack 1 X86_64 (6.1 build 7601); UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: threaded
No feedback after almost 3 months, let's put this one to WFM. Moebius: don't hesitate to reopen this tracker if you still reproduce this LO provided by the repositories of your Linux distrib.