Bug 144354 - Mail Merge Wizard freezes LibreOffice with multiple versions installed from debs
Summary: Mail Merge Wizard freezes LibreOffice with multiple versions installed from debs
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
 
Reported: 2021-09-07 11:11 UTC by Stéphane Guillou (stragu)
Modified: 2022-04-28 09:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
debug output in console (23.82 KB, text/plain)
2021-09-08 05:24 UTC, Stéphane Guillou (stragu)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stéphane Guillou (stragu) 2021-09-07 11:11:26 UTC
Description:
Opening the Mail Merge Wizard does not show any dialog, and makes Writer unresponsive.

Steps to Reproduce:
1. Open Writer
2. Got to Tools > Mail Merge Wizard

Actual Results:
LibreOffice hangs, the dialog does not show. The interface is unresponsive. The only option is to force quit the application.

Expected Results:
The dialog opens normally.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Tested with:

Version: 7.0.6.2
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

and

Version: 7.1.5.2 / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

and

Version: 7.2.0.4 / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

and

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 4cd3ce9848aa039b8d443a1257d1298231680b01
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-09-06_04:39:11
Calc: threaded

Operating system is Ubuntu Budgie 18.04
Unrelated to GTK3 because I also tried with SAL_USE_VCLPLUGIN=gen : same problem.
Comment 1 Michael Weghorn 2021-09-07 11:31:12 UTC
Cannot reproduce with

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 26e45694433721a8837a2133c05798776576def6
CPU threads: 12; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

(In reply to stragu from comment #0)
> User Profile Reset: Yes

Can you once again try with a fresh profile, and whether it also happens in safe mode?
Comment 2 Timur 2021-09-07 14:09:30 UTC
No repro, and hardly will anyone reproduce, that's likely some local issue. 
Maybe related to multiple LO, I don't know how you installed them.
Comment 3 Julien Nabet 2021-09-07 19:06:13 UTC
On pc Debian x86-64 with master sources updated today + gtk3 rendering I don't reproduce this.

Could you try https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile ?

Also, since you tested 7.2.0.4, I supposed you used deb files from TDF.
Indeed LO ppa only propose 7.1.6 as the most recent LO version for the moment (see https://launchpad.net/~libreoffice/+archive/ubuntu/ppa)

Have in mind that deb and rpms from TDF are more for distrib maintainers who check dependencies and prepare packaging for repositories of the distribs.

Perhaps it could help you upgrade to Ubuntu 20.04 LTS or even Ubuntu 21.04 so you'll be sure to have more recent libs.
Comment 4 Stéphane Guillou (stragu) 2021-09-07 22:50:49 UTC
I've tried:
- reboot
- safe mode
- reset to factory settings (including user profile)
- removed the whole profile directory (for all versions)

All version are installed from debs.

Anything else I could try? Should I try a debug version?
Comment 5 Stéphane Guillou (stragu) 2021-09-08 05:24:22 UTC
Created attachment 174871 [details]
debug output in console

Attaching the console output when running the latest master debug.

This is the console output when I try to open the wizard. Not sure if there are some relevant pointers in there?

---------

warn:legacy.osl:4461:4461:dbaccess/source/core/dataaccess/ModelImpl.cxx:765: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from!
warn:legacy.osl:4461:4461:dbaccess/source/core/dataaccess/ModelImpl.cxx:765: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from!
warn:legacy.osl:4461:4461:dbaccess/source/core/dataaccess/ModelImpl.cxx:765: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from!
warn:sal.osl:4461:4461:sal/osl/unx/module.cxx:155: dlopen(libebook-1.2.so.20, 1): libebook-1.2.so.20: cannot open shared object file: No such file or directory
warn:sal.osl:4461:4461:sal/osl/unx/module.cxx:155: dlopen(libebook-1.2.so.20, 1): libebook-1.2.so.20: cannot open shared object file: No such file or directory
warn:sal.osl:4461:4461:sal/osl/unx/module.cxx:155: dlopen(libebook-1.2.so.20, 1): libebook-1.2.so.20: cannot open shared object file: No such file or directory
warn:sal.osl:4461:4461:sal/osl/unx/module.cxx:155: dlopen(libebook-1.2.so.20, 1): libebook-1.2.so.20: cannot open shared object file: No such file or directory
warn:sal.osl:4461:4461:sal/osl/unx/module.cxx:155: dlopen(libebook-1.2.so.20, 1): libebook-1.2.so.20: cannot open shared object file: No such file or directory
warn:dbaccess:4461:4461:dbaccess/source/core/dataaccess/connection.cxx:344: DBG_UNHANDLED_EXCEPTION in OConnection exception: com.sun.star.sdbc.SQLException message: Invalid descriptor index. /tinderbox/buildslave/source/libo-master/connectivity/source/commontools/dbexception.cxx:358 SQLState: 07009 ErrorCode: 0
    wrapped: void message: /tinderbox/buildslave/source/libo-master/tools/source/debug/debug.cxx:104
warn:sal.osl:4461:4461:sal/osl/unx/module.cxx:155: dlopen(libebook-1.2.so.20, 1): libebook-1.2.so.20: cannot open shared object file: No such file or directory
Comment 6 Stéphane Guillou (stragu) 2021-09-08 05:34:17 UTC
I saw the mention of libebook-1.2, so tried to locate it:

locate libebook-1.2
/usr/lib/x86_64-linux-gnu/libebook-1.2.so.19
/usr/lib/x86_64-linux-gnu/libebook-1.2.so.19.1.3
/usr/share/doc/libebook-1.2-19
/usr/share/doc/libebook-1.2-19/changelog.Debian.gz
/usr/share/doc/libebook-1.2-19/copyright
/var/lib/dpkg/info/libebook-1.2-19:amd64.list
/var/lib/dpkg/info/libebook-1.2-19:amd64.md5sums
/var/lib/dpkg/info/libebook-1.2-19:amd64.shlibs
/var/lib/dpkg/info/libebook-1.2-19:amd64.symbols
/var/lib/dpkg/info/libebook-1.2-19:amd64.triggers

Could the version mismatch be the issue?
Looks like libebook-1.2.so.20 is only available form Ubuntu 20.04: https://packages.ubuntu.com/focal/libs/libebook-1.2-20
Comment 7 Michael Weghorn 2021-09-08 05:42:42 UTC
Can you try what happens if you (temporarily) uninstall libebook-1.2 and try again?
Comment 8 Stéphane Guillou (stragu) 2021-09-08 12:34:15 UTC
Hm uninstalling it would also remove packages like gnome-shell and ubuntu-session, I'm not sure I want to try that...

I also tried:
- installing LO 6.0.7 from debs (because that is the version offered by Ubuntu 18.04): same issue

But then I tried:
- installing LO 7.0.6 from PPA http://ppa.launchpad.net/libreoffice/libreoffice-7-0/ubuntu : the wizard works! (although the other versions installed still don't)

So I guess using a PPA (or the default packages offered by the distribution) also installs whatever was missing for the wizard to work.

But it's the first time I have this kind of issue, having been testing LibreOffice for a while, using mainly the debs provided by the LO website: I have never seen a feature fail because I was on an Ubuntu version that was released 3 years ago.
Shouldn't this be looked into anyway, as Ubuntu 18.04 is still supported until at least 2023 and I expect many people to download new versions from the website?

In case it is helpful to identify what made the difference, here is the list of packages installed from the PPA when I did "sudo apt install libreoffice":

coinor-libcbc3 coinor-libcoinmp1v5 firebird3.0-common firebird3.0-common-doc firebird3.0-server-core firebird3.0-utils fonts-opensymbol gstreamer1.0-gtk3 libboost-date-time1.65.1 libboost-locale1.65.1 libbsh-java libclucene-contribs1v5 libclucene-core1v5 libcommons-logging-java libel-api-java libexttextcat-2.0-0 libexttextcat-data libfbclient2 libhsqldb1.8.0-java libib-util libjsp-api-java libjuh-java libjurt-java liblangtag-common liblangtag1 liblibreoffice-java libmhash2 libmythes-1.2-0 librasqal3 librdf0 libreoffice libreoffice-base libreoffice-base-core libreoffice-base-drivers libreoffice-calc libreoffice-common libreoffice-core libreoffice-draw libreoffice-gnome libreoffice-gtk3 libreoffice-impress libreoffice-java-common libreoffice-math libreoffice-nlpsolver libreoffice-report-builder libreoffice-report-builder-bin libreoffice-script-provider-bsh libreoffice-script-provider-js libreoffice-script-provider-python libreoffice-sdbc-firebird libreoffice-sdbc-hsqldb libreoffice-sdbc-mysql libreoffice-sdbc-postgresql libreoffice-style-colibre libreoffice-style-elementary libreoffice-style-yaru libreoffice-wiki-publisher libreoffice-writer libridl-java libservlet-api-java libservlet3.1-java libuno-cppu3 libuno-cppuhelpergcc3-3 libuno-purpenvhelpergcc3-3 libuno-sal3 libuno-salhelpergcc3-3 libunoil-java libunoloader-java libwebsocket-api-java lp-solve python3-uno uno-libs-private ure

What could be missing from the debs downloaded from the website?
Comment 9 Julien Nabet 2021-09-08 17:33:17 UTC
Rene: thought you might be interested in this one.
Comment 10 Julien Nabet 2021-12-20 13:28:53 UTC
I think you should just remove all LO debs packages and related then install LO from ppa if you want newer version than plain Ubuntu.

About Ubuntu itself, either you want to stick to LTS and you can upgrade to 20.04 or you can try last Ubuntu 21.10.

Let's put this one to NEEDINFO the time you try all this.
Comment 11 Stéphane Guillou (stragu) 2021-12-22 02:55:39 UTC
Julien, Ubuntu 18.04 is an LTS supported until 2028, so I expect us to try an check if debs are still working for that distribution for a while more, especially since it is the main method of installation advertised on https://www.libreoffice.org/download/download/ (and there isn't even a mention of PPAs on that page)

Wouldn't you agree?
Comment 12 QA Administrators 2021-12-22 05:41:05 UTC Comment hidden (obsolete)
Comment 13 Julien Nabet 2021-12-22 08:18:41 UTC
(In reply to stragu from comment #11)
> Julien, Ubuntu 18.04 is an LTS supported until 2028, so I expect us to try
> an check if debs are still working for that distribution for a while more,
> especially since it is the main method of installation advertised on
> https://www.libreoffice.org/download/download/ (and there isn't even a
> mention of PPAs on that page)
> 
> Wouldn't you agree?

I agree it's the main method for Windows and MacOs but not for Linux distrib.
For Linux, the first choice is the distrib repository.
For Ubuntu, I'd say that second choice is PPA or snap.
deb/rpms come after for me.
Now perhaps I'm wrong.

Anyway, can't help here=> uncc myself.
Comment 14 Timur 2022-04-28 09:33:40 UTC
I don't see what's to be fixed here. Others don't reproduce nor is this supported. 
That Ubuntu 18 is supported is hardly relevant, they don't update LO.
So I close.