← Back to team overview

desktop-packages team mailing list archive

[Bug 889422] Re: Libreoffice calc FILEOPEN very slow, it takes about 15 minutes

 

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)

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/889422

Title:
  Libreoffice calc FILEOPEN very slow, it takes about 15 minutes

Status in “libreoffice” package in Ubuntu:
  Incomplete

Bug description:
  I first asked around in the ubuntu newsgroups, and people there asked me to file
  this bug in Bugzilla/Libreoffice and also in launchpad to make sure it is not a 
  Kubuntu packaging issue.
  Further info and strace log files can be found on bugzilla 
  Bug 42684 - FILEOPEN very slow, network/dns related, it takes about 15 minutes
  I am running Kubuntu 11.10 and the version of LO is
  LibreOffice 3.4.3   OOO340m1 (Build:302)

  The problem is that LO wants to resolve url's + their security certificates present in the sheet
  I guess some urls cannot be resolved, and after about 15 minutes, LO gives up and finally opens the document.
  I think the problem first appeared after an upgrade (not shure if it appeared after installing Kubuntu 11.10 or before)
  It was not there in 11.04 for some time, but perhaps it appeared later on in 11.04 after adding the backport ppa, I don't
  remember anymore.
  I dont' have this problem when I open the same file on my daughters laptop (WIN7-Openoffice 3.1)
  Let me know if you need further info.
  --- 
  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

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/889422/+subscriptions


References