openoffice.org slowness

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

openoffice.org slowness

Dave Fisher
Hi -

There have been a couple of reports of slowness on OpenOffice.org over the holidays.

I’ve looked at this for other subdomains than openoffice.org. Take a look at the way Infra configures DNS servers and how clients are selecting which server to access. At least in my case my Mac or Airport Express is choosing a random one of two vs. the “closest”. This needs a little more investigation before bringing it to Infra. If you have experienced issues then let me know when, what you are getting when you measure latency, what operating system, and, if you are on your home or corporate network,

I am used traceroute, nslookup and dig (not shown). 

Daves-MacBook-Pro:foundation davewave$ traceroute www.openoffice.org
traceroute: Warning: www.openoffice.org has multiple addresses; using 140.211.11.105
traceroute to www.openoffice.org (140.211.11.105), 64 hops max, 52 byte packets
 1  192.168.1.1 (192.168.1.1)  1.618 ms  0.892 ms  0.753 ms
 2  96.120.88.133 (96.120.88.133)  12.497 ms  15.631 ms  13.140 ms
 3  be-10002-sur03.windsor.ca.sfba.comcast.net (68.85.217.153)  15.743 ms  22.678 ms  16.216 ms
 4  68.85.57.33 (68.85.57.33)  15.722 ms  13.270 ms  14.071 ms
 5  hu-0-18-0-2-ar01.santaclara.ca.sfba.comcast.net (68.85.154.49)  20.640 ms
    hu-0-18-0-7-ar01.santaclara.ca.sfba.comcast.net (68.85.154.121)  19.266 ms
    hu-0-18-0-0-ar01.santaclara.ca.sfba.comcast.net (68.85.154.57)  19.212 ms
 6  * * *
 7  ae-1-51.edge2.seattle3.level3.net (4.69.147.139)  33.508 ms  36.710 ms  34.288 ms
 8  ae-1-51.edge2.seattle3.level3.net (4.69.147.139)  33.860 ms  39.032 ms  33.844 ms
 9  university.edge2.seattle3.level3.net (4.59.234.70)  41.122 ms  48.191 ms  41.447 ms
10  ptck-p2-gw.nero.net (207.98.64.170)  42.250 ms
    ptck-p1-gw.nero.net (207.98.64.168)  41.272 ms
    ptck-p2-gw.nero.net (207.98.64.170)  40.652 ms
11  corv-p1-gw.nero.net (207.98.64.25)  49.420 ms
    corv-p2-gw.nero.net (207.98.64.27)  51.384 ms
    corv-p1-gw.nero.net (207.98.64.25)  44.897 ms
12  corv-car1-gw.nero.net (207.98.64.17)  51.578 ms
    corv-car1-gw.nero.net (207.98.64.19)  43.226 ms
    corv-car1-gw.nero.net (207.98.64.17)  42.365 ms
13  themis.apache.org (140.211.11.105)  41.674 ms  43.522 ms  46.291 ms
Daves-MacBook-Pro:foundation davewave$ nslookup www.openoffice.org
Server: 192.168.1.1
Address: 192.168.1.1#53

Non-authoritative answer:
Address: 140.211.11.105
Address: 88.198.26.2

See the IP Addresses and if they are on the same continent as you when you have trouble. See if the trace route has high latency.

Here are a couple of other domains so you can see the difference.


Daves-MacBook-Pro:foundation davewave$ nslookup felix.apache.org
Server: 192.168.1.1
Address: 192.168.1.1#53

Non-authoritative answer:
Address: 195.154.151.36
Address: 140.211.11.105

Daves-MacBook-Pro:foundation davewave$ nslookup openoffice.apache.org
Server: 192.168.1.1
Address: 192.168.1.1#53

Non-authoritative answer:
Address: 195.154.151.36
Address: 140.211.11.105

Daves-MacBook-Pro:foundation davewave$ traceroute openoffice.apache.org
traceroute: Warning: openoffice.apache.org has multiple addresses; using 195.154.151.36
traceroute to openoffice.apache.org (195.154.151.36), 64 hops max, 52 byte packets
 1  192.168.1.1 (192.168.1.1)  1.063 ms  1.200 ms  0.999 ms
 2  96.120.88.133 (96.120.88.133)  22.144 ms  13.075 ms  15.708 ms
 3  be-10002-sur03.windsor.ca.sfba.comcast.net (68.85.217.153)  91.124 ms  38.341 ms  15.470 ms
 4  68.85.57.33 (68.85.57.33)  15.444 ms  18.691 ms  15.896 ms
 5  hu-0-18-0-4-ar01.santaclara.ca.sfba.comcast.net (68.85.154.105)  19.993 ms
    hu-0-18-0-5-ar01.santaclara.ca.sfba.comcast.net (68.85.154.113)  18.778 ms
    hu-0-18-0-4-ar01.santaclara.ca.sfba.comcast.net (68.85.154.105)  23.711 ms
 6  * * *
 7  ae-2-3203.ear3.paris1.level3.net (4.69.161.126)  166.148 ms  164.100 ms  165.716 ms
 8  212.3.235.198 (212.3.235.198)  167.352 ms  163.755 ms  164.205 ms
 9  195.154.1.173 (195.154.1.173)  166.212 ms  171.636 ms  163.704 ms
10  tlp-eu-west.apache.org (195.154.151.36)  164.391 ms  175.081 ms  170.383 ms

So the project subdomain is slow for me. 

Regards,
Dave


signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: openoffice.org slowness

Andrea Pescetti-2
On 05/01/2018 Dave Fisher wrote:
> See the IP Addresses and if they are on the same continent as you when
> you have trouble. See if the trace route has high latency.

Thanks, this will indeed help a lot in troubleshooting and I have
interesting results:

$ wget it.openoffice.org
http://it.openoffice.org/
Resolving it.openoffice.org (it.openoffice.org)... 88.198.26.2,
140.211.11.105, 2a01:4f8:130:2192::2
Connecting to it.openoffice.org (it.openoffice.org)|88.198.26.2|:80...
failed: Connection timed out.
Connecting to it.openoffice.org
(it.openoffice.org)|140.211.11.105|:80... connected.
[ and then the download occurs normally ]

So basically the first choice for me is 88.198.26.2 and that one times out.

For some reason,
$ traceroute www.openoffice.org
always picks up 140.211.11.105 so it works fast.

But if I run
$ traceroute it.openoffice.org
it gets lost somewhere in the Hetzner network in Germany:

$ traceroute it.openoffice.org
traceroute to it.openoffice.org (88.198.26.2), 30 hops max, 60 byte packets
  1  [irrelevant local network, omitted] ...
  7  ae3-1.fra20.core-backbone.com (80.81.192.187)  36.559 ms  58.253 ms
  57.011 ms
  8  ae1-2014.nbg40.core-backbone.com (81.95.15.206)  49.496 ms  48.844
ms  45.724 ms
  9  core-backbone-100g-nbg.hetzner.de (81.95.15.6)  43.109 ms  44.708
ms  45.224 ms
10  core12.nbg1.hetzner.com (213.239.229.165)  48.203 ms
core11.nbg1.hetzner.com (213.239.229.161)  48.010 ms  43.750 ms
11  core21.fsn1.hetzner.com (213.239.245.222)  49.932 ms
core21.fsn1.hetzner.com (213.239.224.14)  57.115 ms  55.405 ms
12  ex9k1.dc4.fsn1.hetzner.com (213.239.229.146)  52.779 ms  51.393 ms
57.072 ms
13  * * *
14  * * *
15  * * *
16  * * *
17  * * *
...
30  * * *

I think this shows that indeed we need someone to check that DNS record.

Regards,
   Andrea.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: openoffice.org slowness

Hagar Delest-2
In reply to this post by Dave Fisher
Hi,

For the record, I think that the forums (or at least the English one) are also less responsive. Maybe due to the server change.

Hagar

Le 05/01/2018 à 20:53, Dave Fisher a écrit :

> Hi -
>
> There have been a couple of reports of slowness on OpenOffice.org <http://OpenOffice.org> over the holidays.
>
> I’ve looked at this for other subdomains than openoffice.org <http://openoffice.org>. Take a look at the way Infra configures DNS servers and how clients are selecting which server to access. At least in my case my Mac or Airport Express is choosing a random one of two vs. the “closest”. This needs a little more investigation before bringing it to Infra. If you have experienced issues then let me know when, what you are getting when you measure latency, what operating system, and, if you are on your home or corporate network,
>
> I am used traceroute, nslookup and dig (not shown).
>
> Daves-MacBook-Pro:foundation davewave$ traceroute www.openoffice.org <http://www.openoffice.org>
> *traceroute: Warning: www.openoffice.org <http://www.openoffice.org> has multiple addresses; using 140.211.11.105*
> traceroute to www.openoffice.org <http://www.openoffice.org> (140.211.11.105), 64 hops max, 52 byte packets
>  1 192.168.1.1 (192.168.1.1)  1.618 ms  0.892 ms  0.753 ms
>  2 96.120.88.133 (96.120.88.133)  12.497 ms  15.631 ms 13.140 ms
>  3 be-10002-sur03.windsor.ca.sfba.comcast.net <http://windsor.ca.sfba.comcast.net> (68.85.217.153) 15.743 ms  22.678 ms  16.216 ms
>  4 68.85.57.33 (68.85.57.33)  15.722 ms  13.270 ms  14.071 ms
>  5 hu-0-18-0-2-ar01.santaclara.ca.sfba.comcast.net <http://santaclara.ca.sfba.comcast.net> (68.85.154.49) 20.640 ms
> hu-0-18-0-7-ar01.santaclara.ca.sfba.comcast.net <http://santaclara.ca.sfba.comcast.net> (68.85.154.121) 19.266 ms
> hu-0-18-0-0-ar01.santaclara.ca.sfba.comcast.net <http://santaclara.ca.sfba.comcast.net> (68.85.154.57) 19.212 ms
>  6  * * *
>  7 ae-1-51.edge2.seattle3.level3.net <http://ae-1-51.edge2.seattle3.level3.net> (4.69.147.139) 33.508 ms  36.710 ms  34.288 ms
>  8 ae-1-51.edge2.seattle3.level3.net <http://ae-1-51.edge2.seattle3.level3.net> (4.69.147.139) 33.860 ms  39.032 ms  33.844 ms
>  9 university.edge2.seattle3.level3.net <http://university.edge2.seattle3.level3.net> (4.59.234.70) 41.122 ms  48.191 ms  41.447 ms
> 10 ptck-p2-gw.nero.net <http://ptck-p2-gw.nero.net> (207.98.64.170) 42.250 ms
> ptck-p1-gw.nero.net <http://ptck-p1-gw.nero.net> (207.98.64.168) 41.272 ms
> ptck-p2-gw.nero.net <http://ptck-p2-gw.nero.net> (207.98.64.170) 40.652 ms
> 11 corv-p1-gw.nero.net <http://corv-p1-gw.nero.net> (207.98.64.25) 49.420 ms
> corv-p2-gw.nero.net <http://corv-p2-gw.nero.net> (207.98.64.27) 51.384 ms
> corv-p1-gw.nero.net <http://corv-p1-gw.nero.net> (207.98.64.25) 44.897 ms
> 12 corv-car1-gw.nero.net <http://corv-car1-gw.nero.net> (207.98.64.17) 51.578 ms
> corv-car1-gw.nero.net <http://corv-car1-gw.nero.net> (207.98.64.19) 43.226 ms
> corv-car1-gw.nero.net <http://corv-car1-gw.nero.net> (207.98.64.17) 42.365 ms
> 13 themis.apache.org <http://themis.apache.org> (140.211.11.105) 41.674 ms  43.522 ms  46.291 ms
> Daves-MacBook-Pro:foundation davewave$ nslookup www.openoffice.org <http://www.openoffice.org>
> Server:192.168.1.1
> Address:192.168.1.1#53
>
> Non-authoritative answer:
> Name:www.openoffice.org <http://www.openoffice.org>
> Address: 140.211.11.105
> Name:www.openoffice.org <http://www.openoffice.org>
> Address: 88.198.26.2
>
> See the IP Addresses and if they are on the same continent as you when you have trouble. See if the trace route has high latency.
>
> Here are a couple of other domains so you can see the difference.
>
>
> Daves-MacBook-Pro:foundation davewave$ nslookup felix.apache.org <http://felix.apache.org>
> Server:192.168.1.1
> Address:192.168.1.1#53
>
> Non-authoritative answer:
> Name:felix.apache.org <http://felix.apache.org>
> Address: 195.154.151.36
> Name:felix.apache.org <http://felix.apache.org>
> Address: 140.211.11.105
>
> Daves-MacBook-Pro:foundation davewave$ nslookup openoffice.apache.org <http://openoffice.apache.org>
> Server:192.168.1.1
> Address:192.168.1.1#53
>
> Non-authoritative answer:
> Name:openoffice.apache.org <http://openoffice.apache.org>
> Address: 195.154.151.36
> Name:openoffice.apache.org <http://openoffice.apache.org>
> Address: 140.211.11.105
>
> Daves-MacBook-Pro:foundation davewave$ traceroute openoffice.apache.org <http://openoffice.apache.org>
> *traceroute: Warning: openoffice.apache.org <http://openoffice.apache.org> has multiple addresses; using 195.154.151.36*
> traceroute to openoffice.apache.org <http://openoffice.apache.org> (195.154.151.36), 64 hops max, 52 byte packets
>  1  192.168.1.1 (192.168.1.1)  1.063 ms  1.200 ms  0.999 ms
>  2  96.120.88.133 (96.120.88.133)  22.144 ms  13.075 ms  15.708 ms
>  3  be-10002-sur03.windsor.ca.sfba.comcast.net <http://windsor.ca.sfba.comcast.net> (68.85.217.153) 91.124 ms  38.341 ms  15.470 ms
>  4  68.85.57.33 (68.85.57.33)  15.444 ms  18.691 ms  15.896 ms
>  5  hu-0-18-0-4-ar01.santaclara.ca.sfba.comcast.net <http://santaclara.ca.sfba.comcast.net> (68.85.154.105) 19.993 ms
>     hu-0-18-0-5-ar01.santaclara.ca.sfba.comcast.net <http://santaclara.ca.sfba.comcast.net> (68.85.154.113) 18.778 ms
>     hu-0-18-0-4-ar01.santaclara.ca.sfba.comcast.net <http://santaclara.ca.sfba.comcast.net> (68.85.154.105) 23.711 ms
>  6  * * *
>  7 ae-2-3203.ear3.paris1.level3.net <http://ae-2-3203.ear3.paris1.level3.net> (4.69.161.126) 166.148 ms  164.100 ms  165.716 ms
>  8  212.3.235.198 (212.3.235.198)  167.352 ms  163.755 ms  164.205 ms
>  9  195.154.1.173 (195.154.1.173)  166.212 ms  171.636 ms  163.704 ms
> 10 tlp-eu-west.apache.org <http://tlp-eu-west.apache.org> (195.154.151.36) 164.391 ms  175.081 ms  170.383 ms
>
> So the project subdomain is slow for me.
>
> Regards,
> Dave
>

Reply | Threaded
Open this post in threaded view
|

Re: openoffice.org slowness

Matthias Seidel
In reply to this post by Andrea Pescetti-2
Hi Andrea,

I can confirm this behavior. When I ping openoffice.org, the IP changes
every second try:

$ ping openoffice.org
PING openoffice.org (88.198.26.2) 56(84) bytes of data.
^C
--- openoffice.org ping statistics ---
10 packets transmitted, 0 received, 100% packet loss, time 9219ms

$ ping openoffice.org
PING openoffice.org (140.211.11.105) 56(84) bytes of data.
64 bytes from themis.apache.org (140.211.11.105): icmp_seq=1 ttl=42
time=178 ms
64 bytes from themis.apache.org (140.211.11.105): icmp_seq=2 ttl=42
time=178 ms
64 bytes from themis.apache.org (140.211.11.105): icmp_seq=3 ttl=42
time=180 ms
64 bytes from themis.apache.org (140.211.11.105): icmp_seq=4 ttl=42
time=177 ms
^C
--- openoffice.org ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3003ms
rtt min/avg/max/mdev = 177.699/178.769/180.838/1.331 ms

88.198.26.2 is unreachable, 140.211.11.105 works as expected.

Regards, Matthias


Am 07.01.2018 um 01:02 schrieb Andrea Pescetti:

> On 05/01/2018 Dave Fisher wrote:
>> See the IP Addresses and if they are on the same continent as you
>> when you have trouble. See if the trace route has high latency.
>
> Thanks, this will indeed help a lot in troubleshooting and I have
> interesting results:
>
> $ wget it.openoffice.org
> http://it.openoffice.org/
> Resolving it.openoffice.org (it.openoffice.org)... 88.198.26.2,
> 140.211.11.105, 2a01:4f8:130:2192::2
> Connecting to it.openoffice.org (it.openoffice.org)|88.198.26.2|:80...
> failed: Connection timed out.
> Connecting to it.openoffice.org
> (it.openoffice.org)|140.211.11.105|:80... connected.
> [ and then the download occurs normally ]
>
> So basically the first choice for me is 88.198.26.2 and that one times
> out.
>
> For some reason,
> $ traceroute www.openoffice.org
> always picks up 140.211.11.105 so it works fast.
>
> But if I run
> $ traceroute it.openoffice.org
> it gets lost somewhere in the Hetzner network in Germany:
>
> $ traceroute it.openoffice.org
> traceroute to it.openoffice.org (88.198.26.2), 30 hops max, 60 byte
> packets
>  1  [irrelevant local network, omitted] ...
>  7  ae3-1.fra20.core-backbone.com (80.81.192.187)  36.559 ms  58.253
> ms  57.011 ms
>  8  ae1-2014.nbg40.core-backbone.com (81.95.15.206)  49.496 ms  48.844
> ms  45.724 ms
>  9  core-backbone-100g-nbg.hetzner.de (81.95.15.6)  43.109 ms  44.708
> ms  45.224 ms
> 10  core12.nbg1.hetzner.com (213.239.229.165)  48.203 ms
> core11.nbg1.hetzner.com (213.239.229.161)  48.010 ms  43.750 ms
> 11  core21.fsn1.hetzner.com (213.239.245.222)  49.932 ms
> core21.fsn1.hetzner.com (213.239.224.14)  57.115 ms  55.405 ms
> 12  ex9k1.dc4.fsn1.hetzner.com (213.239.229.146)  52.779 ms  51.393 ms
> 57.072 ms
> 13  * * *
> 14  * * *
> 15  * * *
> 16  * * *
> 17  * * *
> ...
> 30  * * *
>
> I think this shows that indeed we need someone to check that DNS record.
>
> Regards,
>   Andrea.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>


smime.p7s (5K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: openoffice.org slowness

Andrea Pescetti-2
In reply to this post by Hagar Delest-2
Hagar Delest wrote:
> For the record, I think that the forums (or at least the English one)
> are also less responsive. Maybe due to the server change.

I'm not sure it's the same problem. The problem being discussed here is
not about the site being responsive, but about something like: I open
http://it.openoffice.org and nothing happens for a few minutes (since
the first DNS times out), but then it loads (since it switches to the
second DNS entry) and from then on I can continue browsing at ordinary
speed until I close my browser.

If what you see on the forum is more like every page load being a little
slower than usual, then it must be a different problem. Yes, Infra
recently changed the SQL server. But this shouldn't have an impact on
performance, unless the new server is really too small. If you believe
this could be the case, we can Infra to monitor the system load on the
new server to be sure.

Regards,
   Andrea.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: openoffice.org slowness

Hagar Delest-2
OK, sorry, I focused on the time thing only.
Indeed if someone can have a look on the system load, just in case. Thanks.

Hagar

Le 07/01/2018 à 21:31, Andrea Pescetti a écrit :

> Hagar Delest wrote:
>> For the record, I think that the forums (or at least the English one) are also less responsive. Maybe due to the server change.
>
> I'm not sure it's the same problem. The problem being discussed here is not about the site being responsive, but about something like: I open http://it.openoffice.org and nothing happens for a few minutes (since the first DNS times out), but then it loads (since it switches to the second DNS entry) and from then on I can continue browsing at ordinary speed until I close my browser.
>
> If what you see on the forum is more like every page load being a little slower than usual, then it must be a different problem. Yes, Infra recently changed the SQL server. But this shouldn't have an impact on performance, unless the new server is really too small. If you believe this could be the case, we can Infra to monitor the system load on the new server to be sure.
>
> Regards,
>   Andrea.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]