This bug was filed from the crash reporting server and is br-171bea4d-6542-42bf-a0bd-68f6f3591b0a. =========================================
Could you provide minimal step by step process to reproduce this?
Created attachment 165861 [details] Error reproduction and database for details - see attachment
IdidITmyWay: I saw you assigned yourself this bug, do you want to fix this yourself? BTW, on pc Debian x86-64 with master sources updated today with gen rendering, I don't reproduce the crash. Caolán: I don't know if it's related or if it's another pb but with gtk3, I can't even see the list of the columns of the table in relationship dialog. It blinks a lot and I got a lot of these in console: ** (soffice:36996): WARNING **: 10:49:16.257: Focused object has invalid index in parent (remark: for odt, I got a lot of: warn:vcl:37168:37168:vcl/source/gdi/bitmapex.cxx:133: BitmapEx: forced mask to monochrome)
Created attachment 165864 [details] System Information Sorry, I am not able to fix the problem by myself. You wrote: WARNING: "Focused object has invalid index in parent" This could be a good hint! Initially I did accidentally define the - now - foreign field as VARCHAR and assigned PRIMARY KEY to it. I also had a unique constraint over (GbNr, EZ, Parzelle), which I had to remove to be allowed, changing the type. Si I removed the unique constraint and changed the field type to integer. Maybe, there is a remaining trace (not completely cleaned) from that activities before. Your remark about ODT: I took the screenshot with "Gnome-Screenshot". Maybe there is a bug in screenshot producing erroneous bitmaps. You recognized, that I am using the youngest release of Libreoffice? I am sure, you saw it already: I am using Firebird as the internal database.
(In reply to IdidITmyWay from comment #4) > Created attachment 165864 [details] > System Information > > Sorry, I am not able to fix the problem by myself. No problem of course :-) > You wrote: WARNING: "Focused object has invalid index in parent" > This could be a good hint! Perhaps > Initially I did accidentally define the - now - foreign field as VARCHAR and > assigned PRIMARY KEY to it. > I also had a unique constraint over (GbNr, EZ, Parzelle), which I had to > remove to be allowed, changing the type. > Si I removed the unique constraint and changed the field type to integer. > Maybe, there is a remaining trace (not completely cleaned) from that > activities before. I don't know > Your remark about ODT: > I took the screenshot with "Gnome-Screenshot". Maybe there is a bug in > screenshot producing erroneous bitmaps. > You recognized, that I am using the youngest release of Libreoffice? > I am sure, you saw it already: I am using Firebird as the internal database. Firebird support in LO has been put back experimental several months ago. Also, there's almost no more fixes in Base part because dev experts are on other subjects so don't expect this to be fixed soon.
BTW, you can try this workaround: - launch console - type export SAL_USE_VCLPLUGIN=gen (so you'll use "gen" rendering instead of "gtk3") - launch LO and give a new try.
Thank you for the workaround hint! My understandig is: the old database HSQL implementation is near end of life. This is, why I decided for my project to take the Firebird variant. You said, Firebird support in LO is put back experimental. ~~~~~~~~~~~~~~~~~~~~~ Is this because of being not stable enough, or is there a decision process that LO will also move away from Firebird to a third database implementation? ~~~~~~~~~~~~~~~~~~~~~~~~~~~++ I am going to comtinue my way with Firebird for my project and it looks like I may find a lot of more issues. Does it make sense to raise tickets or is there a major LO rework in progress and my tickets do not bring additional clarifications. ~~~~~~~~~~~~~~~~~~~~ If you like, you can cancel or close the ticket. The pure SQL interface is a good door for successful workarounds.
I tried your hint with "export SAL_USE_VCLPLUGIN=gen" and I SUCCEEDED! Well- problem solved for me. Thank you
(In reply to IdidITmyWay from comment #7) > Thank you for the workaround hint! > > My understandig is: the old database HSQL implementation is near end of life. > This is, why I decided for my project to take the Firebird variant. > You said, Firebird support in LO is put back experimental. > ~~~~~~~~~~~~~~~~~~~~~ > Is this because of being not stable enough, or is there a decision process > that LO will also move away from Firebird to a third database implementation? LO uses HSQLDB 1.8 (so quite old). The goal was first to get rid of Java and Firebird was the only candidate which: - has license compatibility - allows to call it: - client/server (client is LO Base, Firebird is the server) - embedded Firebird (no external Firebird server) - has C/C++ connector - mature enough There've a lot of work from different people then it slowed down until almost a stop because people moved on other things. So now we're in the middle of the bridge: - Firebird implementation in LO isn't stable enough (just consider the number of bugs) - the old HSQLDB version remained See http://document-foundation-mail-archive.969070.n3.nabble.com/About-putting-back-Firebird-experimental-tt4265392.html#a4266137 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~++ > I am going to comtinue my way with Firebird for my project and it looks like > I may find a lot of more issues. > Does it make sense to raise tickets or is there a major LO rework in > progress and my tickets do not bring additional clarifications. I think there's no need to submit new tickets but it's only my opinion. To put it clearly, I think Base part is (almost?) dead. > ~~~~~~~~~~~~~~~~~~~~ > If you like, you can cancel or close the ticket. The pure SQL interface is a > good door for successful workarounds. I'll let other decide, I'm neither a TDF member nor an expert. If you don't need embedded, I'd move towards MariaDB. If you need embedded, I think that badfully, I'd stick on HSQLDB. Again, just my opinion.
re comment #3: I think https://gerrit.libreoffice.org/c/core/+/103523 will solve that problem I couldn't reproduce the crash in 7-0 locally, but the problem in master of comment #3 appears to also exist, but not as severely, in 7-0 and I have to try a few times to get the combobox to dropdown so its plausible that the backport of the master fix, which is need focus related, to 7-0 of https://gerrit.libreoffice.org/c/core/+/103524 has a bearing on this
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/70866d4663e7e7414539a5e8664385d8b13ba034 Related: tdf#137016 check if subcontrol has the focus It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thank you Caolán, I confirm I don't reproduce the behavior I had. I can't reproduce the crash anyway. Should we put this to WFM since the fix is useful of course but not related to the bugtracker?
I feel its likely the source problem. I'll tentatively call it fixed. There is a backport of the relevant bit to 7-0 in gerrit. Maybe the original reporter could give a daily a try and see if it is still reproducible after my change.
Sorry for actually not being able to test your patch, because of loosing my test environment. I don't want to use my production environment for that.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/9d30d3bb93171a12655dc89066fe065e2c2af658 Related: tdf#137016 check if subcontrol has the focus It will be available in 7.0.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.