[Upstream] LibreOffice hangs for 30+ seconds when connected to the Internet

Bug #734424 reported by Gabe A
44
This bug affects 5 people
Affects Status Importance Assigned to Milestone
LibreOffice
Invalid
Medium
libreoffice (Ubuntu)
Fix Released
Undecided
Unassigned

Bug Description

Binary package hint: libreoffice

LibreOffice: long load time when connected to the internet. Loading bar hangs at earliest stage.

WORKAROUND: add "127.0.0.1 hostname localhost hostname.(none)" (without quotes) to /etc/hosts.

The issue is that ever since OpenOffice 3.2.1 (NOT 3.2.0), the application attempts to use a hacky protocol to connect to the internet instead of the host's machine for some reason at an early stage during its load. Equally strange is that it only rears its head in kubuntu, as far as I know.

Problem existed since Kubuntu 10.04 including latest up-to-date 11.04, all architectures, OpenOffice versions 3.2.1 through LibreOffice 3.3.1. When offline, the problem does not appear at all. Multiple resolutions, systems, graphics cards, architectures, packages tested, all with same result.

It is unlikely that the software transmits enough information to any resolvable location on the internet to comprise a security breach, but the possibility of erroneously transmitting user information across the internet instead of the local machine may comprise a risk of some sort. Also, recall that Oracle took over OpenOffice at the first version that exhibits this strange, crippling showstopper, so cause for alarm (paranoia) may be warranted, though it is highly unlikely.

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: libreoffice-core 1:3.3.1-1ubuntu5
ProcVersionSignature: Ubuntu 2.6.38-6.34-generic 2.6.38-rc7
Uname: Linux 2.6.38-6-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Sun Mar 13 13:14:03 2011
ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
ProcEnviron:
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
Gabe A (gabextreme) wrote :
Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in libreoffice (Ubuntu):
status: New → Confirmed
penalvch (penalvch)
summary: - [KUBUNTU ONLY]LibreOffice hangs for 20-30 seconds on load when connected
- to the Internet
+ LibreOffice hangs for 20-30 seconds on load when connected to the
+ Internet
description: updated
Revision history for this message
penalvch (penalvch) wrote : Re: LibreOffice hangs for 20-30 seconds on load when connected to the Internet

Gabe A, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. Thanks in advance.

tags: added: lo33
Changed in df-libreoffice:
status: New → Incomplete
Revision history for this message
In , Marc (mbbs) wrote :
Download full text (4.6 KiB)

Created attachment 53273
strace while opening the file

When I open the file homesheet2011.ods, it takes about 15 minutes before it is open.
When I open the same document with openoffice 3.1, the document opens normally.
OS: Kubuntu 11.10, upgrade on one PC, fresh install on laptop (same problem)
Installed via the Kubuntu repositories.
SW release: LibreOffice 3.4.3 OOO340m1 (Build:302)

> The top command shows my CPU is 100% occupied
> asks: 170 total,   2 running, 167 sleeping,   0 stopped,   1 zombie
> Cpu(s): 53.6%us,  3.2%sy,  0.0%ni, 40.3%id,  2.8%wa,  0.0%hi,  0.2%si,
> 0.0%st
> Mem:   2054052k total,  1637320k used,   416732k free,    36568k buffers
> Swap:  2087932k total,    19180k used,  2068752k free,   576984k cached
>
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> 15890 marc      20   0  371m 209m  60m R  100 10.4   3:13.20 soffice.bin
>  1055 root      20   0  146m  46m  33m S    4  2.3   3:57.71 Xorg
>  1601 marc      20   0  299m  50m  20m S    3  2.5   5:29.93 kwin
>  3562 marc      20   0  497m 241m  25m S    3 12.0   3:54.00 rekonq
>  1611 marc      20   0  260m  21m  13m S    2  1.1   2:57.86 knotify4
>  2288 marc      20   0  138m  40m  23m S    2  2.0   3:08.79 dolphin
>  8076 marc      20   0  109m  24m  17m S    2  1.2   0:01.84 konsole

The problem is network/dns related (see network trace),
Calc wants to resolve some urls and their thawte and verisign certificates.

marc@marc-6320:~/Documents/OOO330_m20_native_packed-1_en-US.9567/DEBS$ sudo
tcpdump -nnl -i wlan0 -s 1536 dst port 53
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on wlan0, link-type EN10MB (Ethernet), capture size 1536 bytes
00:08:34.412749 IP 192.168.0.184.50638 > 195.130.130.1.53: 11395+ A?
marc-6320.(none). (34)
00:08:34.427846 IP 192.168.0.184.56845 > 195.130.130.1.53: 60767+ A?
marc-6320.(none).lan_dn. (41)
00:09:08.680435 IP 192.168.0.184.37999 > 195.130.130.1.53: 53290+ A?
secure.keytradebank.com. (41)
00:09:08.817358 IP 192.168.0.184.57854 > 195.130.130.1.53: 54384+ A?
SVRIntl-aia.verisign.com. (42)
00:09:09.117648 IP 192.168.0.184.52596 > 195.130.130.1.53: 5621+ A?
crl.verisign.com. (34)
00:09:09.542308 IP 192.168.0.184.49393 > 195.130.130.1.53: 31157+ A?
SVRIntl-crl.verisign.com. (42)
00:09:10.457164 IP 192.168.0.184.43200 > 195.130.130.1.53: 14130+ A?
www.keytradebank.com. (38)
00:09:10.549438 IP 192.168.0.184.53301 > 195.130.130.1.53: 64786+ A?
www.thawte.com. (32)
00:09:10.930726 IP 192.168.0.184.36438 > 195.130.130.1.53: 57057+ A?
crl.thawte.com. (32)
00:09:11.323096 IP 192.168.0.184.49990 > 195.130.130.1.53: 43965+ A?
crl.thawte.com. (32)
00:09:11.881908 IP 192.168.0.184.55908 > 195.130.130.1.53: 50958+ A?
secure.keytradebank.com. (41)
00:09:11.953006 IP 192.168.0.184.60660 > 195.130.130.1.53: 44754+ A?
SVRIntl-aia.verisign.com. (42)
00:09:12.340463 IP 192.168.0.184.37211 > 195.130.130.1.53: 9710+ A?
www.keytradebank.com. (38)
00:09:12.431319 IP 192.168.0.184.38837 > 195.130.130.1.53: 47319+ A?
www.thawte.com. (32)
00:09:14.133780 IP 192.168.0.184.52429 > 195.130.130.1.53: 6557+ A?
citibankonline.citibank.be. (44)
00:09:14.304999 IP 192.168.0.184.60316 ...

Read more...

Revision history for this message
In , NoOp (glgxg) wrote :

I wonder if this could be related to:
https://bugs.freedesktop.org/show_bug.cgi?id=32640
[LibreOffice localized as BrOffice (auto) takes a long time to start]
which was supposedly fixed in 3.3. Can you install 3.3.4 directly and test?

Revision history for this message
In , Marc (mbbs) wrote :

Created attachment 53430
strace of sheet open in LO 3.3

Revision history for this message
In , Marc (mbbs) wrote :

When opening the file in LO 3.3, LO stops.
I think some dependencies are missing.
I add an strace and below is the command line output

arc@VASTEPC:~$ strace -o /tmp/strace.log -f -tt -s 512 libreoffice

(soffice:2265): Gtk-WARNING **: /opt/libreoffice/program/../basis-link/ure-link/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by /usr/lib/i386-linux-gnu/gtk-2.0/2.10.0/engines/liboxygen-gtk.so)
marc@VASTEPC:~$ strace -o /tmp/strace.log -f -tt -s 512 libreoffice

(soffice:2351): Gtk-WARNING **: /opt/libreoffice/program/../basis-link/ure-link/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by /usr/lib/i386-linux-gnu/gtk-2.0/2.10.0/engines/liboxygen-gtk.so)
marc@VASTEPC:~$ strace -o /tmp/strace.log -f -tt -s 512 libreoffice

(soffice:2392): Gtk-WARNING **: /opt/libreoffice/program/../basis-link/ure-link/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by /usr/lib/i386-linux-gnu/gtk-2.0/2.10.0/engines/liboxygen-gtk.so)
terminate called after throwing an instance of 'eIDMW::CMWException'
  what(): std::exception

When opening a simple file with just a few numbers in it, it works.

Revision history for this message
In , Marc (mbbs) wrote :

Hi,
Sorry for the delay, it was kind of hectic at work.
I also did not want to attach the sheet causing the problem, as it contains all my personal data.
I threw out my personal stuff, and the sheet still has the problem, so I'll attach it to the bug report,
along with a new strace.log

As you see on the tcpdump output, the problem is dns related.
 here I start tcpdump and opened the sheet test4homesheet2011.ods from file/recent documents
marc@VASTEPC:~$ sudo tcpdump -nnl -i eth0 -s 1536 dst port 53
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth0, link-type EN10MB (Ethernet), capture size 1536 bytes
22:08:36.516401 IP 192.168.0.205.57638 > 195.130.131.129.53: 32882+ A? citibankonline.citibank.be. (44)
22:08:36.690849 IP 192.168.0.205.47362 > 195.130.131.129.53: 56456+ A? EVIntl-aia.verisign.com. (41)
22:08:37.105135 IP 192.168.0.205.50653 > 195.130.131.129.53: 32734+ A? crl.verisign.com. (34)
22:08:37.375983 IP 192.168.0.205.55451 > 195.130.131.129.53: 64940+ A? EVSecure-crl.verisign.com. (43)
22:08:37.758145 IP 192.168.0.205.53332 > 195.130.131.129.53: 48144+ A? EVIntl-crl.verisign.com. (41)
22:08:39.148293 IP 192.168.0.205.42231 > 195.130.131.129.53: 1009+ A? citibankonline.citibank.be. (44)
22:08:39.289922 IP 192.168.0.205.45455 > 195.130.131.129.53: 27165+ A? EVIntl-aia.verisign.com. (41)
22:17:12.191380 IP 192.168.0.205.41869 > 195.130.131.129.53: 34958+ A? citibankonline.citibank.be. (44)
22:17:12.360221 IP 192.168.0.205.55684 > 195.130.131.129.53: 37503+ A? EVIntl-aia.verisign.com. (41)
^C
9 packets captured
9 packets received by filter
0 packets dropped by kernel

marc@VASTEPC:~$ date
Thu Nov 17 22:17:45 CET 2011 (at this moment, the sheet opened)

- this week there was a libreoffice update from Kubuntu, the problem is still
  there.

Some info from the ubuntu-bug command:
ApportVersion: 1.23-0ubuntu4
Architecture: i386
DistroRelease: Ubuntu 11.10
InstallationMedia: Kubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012)
NonfreeKernelModules: nvidia
Package: libreoffice 1:3.4.4-0ubuntu1
PackageArchitecture: i386
ProcEnviron:
 LANGUAGE=
 LANG=en_US.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.0.0-13.22-generic 3.0.6
Tags: oneiric
Uname: Linux 3.0.0-13-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm admin cdrom dialout lpadmin plugdev sambashare

Revision history for this message
In , Marc (mbbs) wrote :

Created attachment 53635
strace after throwing out personal stuff and after a LO upgrade in Ubuntu

Revision history for this message
In , Marc (mbbs) wrote :

Created attachment 53636
sheet showing the problem described in the bug report

Revision history for this message
In , NoOp (glgxg) wrote :

Confirmed in LO 3.4.4 final (linux):
LibreOffice 3.4.4
OOO340m1 (Build:402)

I finally had to kill the process as it was taking over 95% of my cpu and heating up my system.

Opens fine in LO 3.3.4 final (linux):
LibreOffice 3.3.4
OOO330m19 (Build:401)
tag libreoffice-3.3.4.

And go-oo Ubuntu distribution 3.2.1 (linux)
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1

And fine in:
OOo-dev 3.4.0
DEV300m106 (Build: 9582)

So this appears to be a regression between LO 3.3.4 and LO 3.4.4. Can you please try with 3.3.4?

Revision history for this message
In , Jbf-faure-9 (jbf-faure-9) wrote :

It seems that there is 2 problems in this spreadsheet:
1/ named range with unknown references
2/ the sheet Zichtrekening
If you remove this sheet and the named range with unknown references, the file opens in less than few seconds.
If you only remove the sheet Zichtrekening, the file opens in fews seconds.

Best regards. JBF

Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote :
Revision history for this message
In , Marc (mbbs) wrote :

Hi,
I decided to try out some distros.
When I use the same file in Chackra, it only takes 3 minutes instead of 15
to load it.
Any ideas on why this is ?
LibreOffice 3.4.4 OOO340m1 (Build:401)

I'll upload a new strace

Marc

Revision history for this message
In , Marc (mbbs) wrote :

Created attachment 53882
strace taken with Chackra distro instead of Kubuntu 11.10

strace taken with Chackra distro (latest version and packages up to date) instead of Kubuntu 11.10.
opening the file is much quicker.

Revision history for this message
Marc (mbbs) wrote :

My bug has been marked as a duplicate of this on, so I'll report more info here.

I installed a second distro on my PC and tried to load the file again.
To my surprise, the file loaded much "faster", 2 minutes instead of 15 minutes.
I made a new strace of this, so you can see what is different.
My launchpad bug Bug report #889422
My Bugzilla Libreoffice bug bug 42684
Distro: Chakra latest download of the rolling distro, all packages up to date.
LibreOffice: 3.4.4 OOO340m1 (Build:401)

Any ideas on why this is ?

Revision history for this message
Marc (mbbs) wrote :
penalvch (penalvch)
Changed in df-libreoffice:
importance: Undecided → Unknown
status: Incomplete → Unknown
summary: - LibreOffice hangs for 20-30 seconds on load when connected to the
+ [Upstream] LibreOffice hangs for 30+ seconds when connected to the
Internet
Revision history for this message
In , penalvch (penalvch) wrote :

As per downstream bug:
https://bugs.launchpad.net/df-libreoffice/+bug/734424

this occurs in both Ubuntu 32 and 64-bit, with earliest version found 3.3.1.
Platform -> All
Version -> 3.3.1

Changed in df-libreoffice:
importance: Unknown → Medium
status: Unknown → Confirmed
Revision history for this message
In , NoOp (glgxg) wrote :

@ Christopher: Please see my Comment #7: The test file opens in less than 10 seconds in:
And go-oo Ubuntu distribution 3.2.1 (linux)
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1

and

Opens fine in LO 3.3.4 final (linux):
LibreOffice 3.3.4
OOO330m19 (Build:401)
tag libreoffice-3.3.4.
(Standard LO on Ubuntu 10.10 - 32 and 64bit)

It is only in LO 3.4.4 that I encounter the problem. This is regardless of the /etc/hosts workaround suggested in https://bugs.launchpad.net/df-libreoffice/+bug/734424.

@ mbohets: As previously requested, can you (or anyone else) please try with 3.3.4 linux?

Revision history for this message
In , Marc (mbbs) wrote :

I already did that, see comment 3.

Revision history for this message
Marc (mbbs) wrote :

I did this, see comment 3 of https://bugs.freedesktop.org/show_bug.cgi?id=42684
Openoffice 3.3.0 OOO330m20 Build:9567 also crashes when loading the file

Any idea where I can find OO 3.1 for linux ?
On my daughter's pc, the file loads without any problem in OO 3.1 for windows.
or should I revert back to a previous version of kubuntu to work with my file again ?

Revision history for this message
In , NoOp (glgxg) wrote :

I saw comment #3. Did you resolve the glibc dependency issues & then try 3.3.4?

Revision history for this message
In , Marc (mbbs) wrote :

I have no idea how to solve the dependency problem.
I searched for GLIB in synaptic but it is not there.
When I google around a bit, I see it has something to do with libstcc++.
In Kubuntu, libstdc++6 and libstdc++6-dev are installed.

I guess my linux skills are not enough to solve this.

I googled a bit further and found a lot of people with this GLIBCXX_3.4.11' not found problem,but no solution.
some people suggested to delete the link to libstdc++.so.6 but when I did that,
LO threw another error

libreoffice -calc
/opt/libreoffice/program/soffice.bin: symbol lookup error: /usr/lib/i386-linux-gnu/gtk-2.0/2.10.0/engines/liboxygen-gtk.so: undefined symbol: cairo_surface_create_for_rectangle
marc@VASTEPC:/opt/libreoffice/ure/lib$ sudo mv libstdc++.so.6.orig libstdc++.so.6

So I put it back

Revision history for this message
In , NoOp (glgxg) wrote :

Have a look through this bug report:
<https://bugs.freedesktop.org/show_bug.cgi?id=32852>
[[Linux] video / `GLIBCXX_3.4.11' not found]
This is how I ended up resolving the issue:
<https://bugs.freedesktop.org/show_bug.cgi?id=32852#c19>

Revision history for this message
In , Marc (mbbs) wrote :

No luck, I removed libavcodec-extra-52, and libavcodec was pulled in.
When starting LO, I got the same error, also after a reboot.

After that, I also tried
  export LD_LIBRARY_PATH=/usr/lib:$LD_LIBRARY_PATH

in /opt/libreoffice3.4/program/soffice
so that the /usr/lib/libstdc++.so.6 library
is loaded instead of the one which comes with LO

But no luck either

Revision history for this message
In , Marc (mbbs) wrote :

Hi, I was not able to solve the dependancies.

The LO version I got when installing Aptosid distro on a laptop from work
3.3.3 build 301

My file opens there in less than 3 seconds (full contents, without the deletions
I did in the file I uploaded here.

If someone can point me to a distro with LO 3.3.4 to try this out as NooP requested, I'll be glad to install it and see what happens.

Revision history for this message
Marc (mbbs) wrote :

Hi, I was not able to solve the dependencies.

The LO version I got when installing Aptosid distro on a laptop from work
is 3.3.3 build 301

My file opens there in less than 3 seconds
(full contents, without the deletions I did in the file I uploaded here).

If someone can point me to a distro with LO 3.3.4 to try this out as NooP
requested, I'll be glad to install it and see what happens.

Revision history for this message
In , Kohei Yoshida (kohei-yoshida) wrote :

Taking this off the 3.4 most annoying.

The delay is caused by a slow connection to the file that is externally linked. Removing that externally linked image makes the file open instantly, using the latest 3.5 build.

Revision history for this message
In , Cno (cno) wrote :

(In reply to comment #19)

> The delay is caused by a slow connection to the file that is externally linked.

Is it clear what causes that delay? If it is just the connection, then this one should be closed as "notabug" IMO

Revision history for this message
In , Marc (mbbs) wrote :

If it is not a bug, why do previous versions of LO open the exact same file without any problem ?

Revision history for this message
In , Marc (mbbs) wrote :

I just installed Kubuntu 12.04 alpha1.
It contains LibreOffice 3.5.0beta2, and there the file opens fine again, without any delays, and without having to change any contents

Thanks a lot for fixing it, now I won't have to use an old Kubuntu version anymore to be able to use my homesheet again.

It is a sheet in which I keep all my home stats like
- bank records
- electricity, water use
- solar panel production
....

So I needed it fairly often.

I guess the bug report can be closed with status solved.

Revision history for this message
Marc (mbbs) wrote :

When opening the file in the 3.5beta2 version of Kubuntu 12.04 alpha 1, the unmodified file opens very quick again.
I marked the bug as resolved In freedesktop.org Bugzilla #42684.

Herewith I would like to thank everyone involved in solving this issue.
It was a file I use to keep details of about everything in my household, so I needed it rather often,
and I am very happy I don't need to revert to an old Kubuntu version to keep using it.

Best rgds,

Marc

Marc (mbbs)
Changed in libreoffice (Ubuntu):
status: Confirmed → Fix Released
Revision history for this message
Marc (mbbs) wrote :

I just put the status in Fix released here also. If this does not reflect correctly the status, because it is released in a LO beta version and in a Kubuntu alpha version, please correct it.
To me it seamed the closest thing to the possible status choises.

By the way, the 12.04 alpha 1 version seems pretty stable and useable already,
so I guess it will be a great release when all missing things and glitches are ironed out in april.
It is the first time I use an alpha version and I am surprised about the useability of it, so thanks to the entire Kubuntu team
and all the upstream people too for all the good work

Marc

Changed in df-libreoffice:
status: Confirmed → Fix Released
Revision history for this message
In , Libreoffice-z (libreoffice-z) wrote :

<https://bugs.freedesktop.org/page.cgi?id=fields.html#status>
We should use FIXED only if a known fix has solved the problem; if the problem only disappeared without known reason, please use WORKSFORME.

Changed in df-libreoffice:
status: Fix Released → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.