[Libreoffice-bugs] [Bug 42684] New: FILEOPEN very slow, it takes about 15 minutes

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Mon Nov 7 23:15:29 CET 2011


https://bugs.freedesktop.org/show_bug.cgi?id=42684

             Bug #: 42684
           Summary: FILEOPEN very slow, it takes about 15 minutes
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.2 release
          Platform: x86 (IA32)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: mbohets at gmail.com


Created attachment 53273
  --> https://bugs.freedesktop.org/attachment.cgi?id=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 at 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 > 195.130.130.1.53: 29831+ A? EVIntl-
aia.verisign.com. (41)
00:09:14.889239 IP 192.168.0.184.44654 > 195.130.130.1.53: 43734+ A? 
EVSecure-crl.verisign.com. (43)
00:09:15.304504 IP 192.168.0.184.56166 > 195.130.130.1.53: 58082+ A? EVIntl-
crl.verisign.com. (41)
00:09:16.678805 IP 192.168.0.184.46363 > 195.130.130.1.53: 40532+ A? 
citibankonline.citibank.be. (44)
00:09:16.818202 IP 192.168.0.184.46140 > 195.130.130.1.53: 3943+ A? EVIntl-
aia.verisign.com. (41)
00:19:18.689824 IP 192.168.0.184.34335 > 195.130.130.1.53: 41972+ A? 
citibankonline.citibank.be. (44)
00:19:18.840882 IP 192.168.0.184.38792 > 195.130.130.1.53: 7530+ A? EVIntl-
aia.verisign.com. (41)

While googling for this problem, I saw some messages where calc wabts to
resolve the hostname of its own system, which can easily be solved with an
entry in /etc/host, but here calc also wants to resolve urls inside the
spreadsheet.

In strace.log, you see excactly how long it takes to open the file and you can
also see what url resolving is going on (the file contains www.citibank.be and
keytrade.be) and what additional ssl and certificates that are not mentioned in
the file calc also wants to resolve.

The problem is perfectly reproducable, please let me know if you need
additional information.
I did not attach the file itself as it contains my bank account data. 

How can this be turned off (I did not find an option in settings)
Why is calc doing this ? I don't see the purpose of this, it only seems to be a
wast of bandwidth and dns resources.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.


More information about the Libreoffice-bugs mailing list