Bug 32236 - Community page delay to load
Summary: Community page delay to load
Status: RESOLVED FIXED
Alias: None
Product: Websites
Classification: Unclassified
Component: www.mageia.org (show other bugs)
Version: trunk
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: Sysadmin Team
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-04 02:50 CEST by katnatek
Modified: 2023-09-11 23:22 CEST (History)
2 users (show)

See Also:
Source RPM:
CVE:
Status comment:


Attachments
Firefox inspector timing for page load (54.96 KB, image/png)
2023-09-04 23:36 CEST, Dave Hodgins
Details

Description katnatek 2023-09-04 02:50:43 CEST
Description of problem:

Community page in all locales take more time to load compared with other pages

By example https://www.mageia.org/en/community/


Not sure if really its a bug or is related to some wok done by the page.
Comment 1 Dave Hodgins 2023-09-04 23:36:50 CEST
Created attachment 13970 [details]
Firefox inspector timing for page load

Confirmed. Checking with cache disabled in firefox/inspector shows it's
waiting 10 seconds after the tls handshake and then taking 3ms to actually
transfer the data.

CC: (none) => davidwhodgins

Comment 2 Dave Hodgins 2023-09-04 23:38:01 CEST
Adding sysadmin team to cc list as it looks like a server issue.

CC: (none) => sysadmin-bugs

Comment 3 Manuel Hiebel 2023-09-05 09:19:19 CEST
looks that related to div that get blog post https://gitweb.mageia.org/web/www/tree/lib/news.php
same issue now on https://www.mageia.org/en as I added them back (previously removed as it was telling about RC1 until this morning)

Same it cannot get that it needs

removing again from main page.

Strange issue, as it work fine on my test server.
Comment 4 Dave Hodgins 2023-09-05 15:15:42 CEST
www.mageia.org is in the LOST-OASIS data center while the blog comes from the
SCALEWAY data center.

Anyway, while removing the blog from https://www.mageia.org/en/community/
leaves a large blank area, the loading time has increased to 25.60 s.

Something is still very wrong.
Comment 5 Thomas Backlund 2023-09-05 15:44:55 CEST
does it work better now ?
Comment 6 Dave Hodgins 2023-09-05 18:01:33 CEST
No. Firefox inspector with cache disabled shows it's currently 25.60 seconds.
Comment 7 katnatek 2023-09-05 18:05:33 CEST
(In reply to Thomas Backlund from comment #5)
> does it work better now ?

It works a few worst :(

I suggest move the planet parse code to a php script, store the result in file, include_once the file in the right part, cron the php script to be run 2 or 3 times at day (i think we not generate a load of post that need a high number)
Comment 8 Manuel Hiebel 2023-09-05 21:27:18 CEST
its suppose to create a caches files in _nav/var/tmp/cache
http://gitweb.mageia.org/web/www/tree/lib/news.php#n71

that we can delete with 
https://wiki.mageia.org/en/Managing_the_website#Options_for_deleting_feed_and_navigation_cache

http://gitweb.mageia.org/web/www/tree/test/lang.php#n13

but on my server I don't have necessary these files present or recreated, but even if they are missing or not there is no delay on the webpage.

So I don't understand right now

If nothing has changed on server side I will disable it and tests later
Comment 9 Manuel Hiebel 2023-09-05 23:40:05 CEST
Ok, the curl extension is not enable so it use fsockopen
https://www.mageia.org/test/sp_test.php

But there is an error:
fsockopen error: Connection timed out

https://mga.hiebel.eu/test/news.php

On my server, w/ and w/o the curl extension, it works
Comment 10 Manuel Hiebel 2023-09-05 23:41:31 CEST
Sorry last link should be https://mageia.org/test/news.php
Comment 11 katnatek 2023-09-06 00:13:23 CEST
(In reply to Manuel Hiebel from comment #10)
> Sorry last link should be https://mageia.org/test/news.php

Now the Community page load time is good, the test page delay 00:11:55 to load
Comment 12 Dave Hodgins 2023-09-06 00:48:25 CEST
Loading https://www.mageia.org/test/news.php takes 12.80 s, displaying the
graphical header and then a text box starting with ...
NULL
int(1575832)
int(1670600)
SimplePie Object
(
    [data] => Array
        (
        )

    [error] => fsockopen error: Connection timed out
    [status_code] => 
    [sanitize] => SimplePie_Sanitize Object
<snip rest>

The community page is now loading in 1.92 s, with the "Planet | Blog | Forums"
links in the dialog on the left side.
Comment 13 Manuel Hiebel 2023-09-06 09:22:25 CEST
this morning it works fine, no "Connection timed out", did a sysadmin made some changes ?
Comment 14 katnatek 2023-09-06 18:54:52 CEST
(In reply to Manuel Hiebel from comment #13)
> this morning it works fine, no "Connection timed out", did a sysadmin made
> some changes ?

The planet part has been restored and load time is good, so i close the bug
Thank to all for your attention even when i not was sure if exist a issue

Status: NEW => RESOLVED
Resolution: (none) => FIXED

Comment 15 katnatek 2023-09-07 19:48:13 CEST
I think you should deep check the server were is the planet, again is slowing the load time of main and community page

GET
https://www.mageia.org/es/community/
[HTTP/1.1 200 OK 21022ms]

Resolution: FIXED => (none)
Status: RESOLVED => REOPENED

Comment 16 Dave Hodgins 2023-09-08 03:22:21 CEST
It looks as if the ipv6 connection between LOST-OASIS and SCALEWAY is failing
so it's timing out and then falling back to ipv4.
Manuel Hiebel 2023-09-08 12:26:31 CEST

Assignee: atelier-bugs => sysadmin-bugs

Comment 17 Thomas Backlund 2023-09-11 12:31:11 CEST
yeah, a puppet bug caused a failed update for neru ipv6, does it work better now ?

(I dont have ipv6 so I cant test myself)
Comment 18 Dave Hodgins 2023-09-11 18:34:36 CEST
Checked my router and it has ipv6 working again, so I re-enabled it in my
install. It wasn't working, so I had disabled ipv6 in sysctl and firefox
when I was testing it for the prior comments.

https://www.mageia.org/en/ took 15.26s
https://www.mageia.org/en/community/ took 12.80s
https://blog.mageia.org/en/ took 5.12s

While the blog on neru has improved noticeably, the main site on sucuk is
still slower than what it used to be.

Is ipv6 working on sucuk?
Comment 19 Dave Hodgins 2023-09-11 18:40:10 CEST
Ignore comment 18.
[dave@x3 ~]$ ping -4 -c 1 sucuk.mageia.org|grep from
64 bytes from sucuk.mageia.org (212.85.158.151): icmp_seq=1 ttl=41 time=124 ms
[dave@x3 ~]$ ping -6 -c 1 sucuk.mageia.org|grep from
64 bytes from sucuk.mageia.org (2a02:2178:2:7::7): icmp_seq=1 ttl=46 time=120 ms
[dave@x3 ~]$ ping -4 -c 1 neru.mageia.org|grep from
64 bytes from neru.mageia.org (163.172.148.228): icmp_seq=1 ttl=47 time=105 ms
[dave@x3 ~]$ ping -6 -c 1 neru.mageia.org|grep from
64 bytes from 2001:bc8:634:240e::1 (2001:bc8:634:240e::1): icmp_seq=1 ttl=45 time=108 ms

So it's working ok on both. I'm not sure why sucuk is slow loading the page,
but it's probably just the web page itself rather then a networking issue.
Comment 20 katnatek 2023-09-11 19:06:11 CEST
GET
https://www.mageia.org/es/community/
[HTTP/1.1 200 OK 20837ms]
Comment 21 Thomas Backlund 2023-09-11 21:02:53 CEST
hum, reading this bugreport again I see simplepie wants curl, so php-curl is now installed.

does it work better for you ?
Comment 22 katnatek 2023-09-11 21:35:29 CEST
(In reply to Thomas Backlund from comment #21)
> hum, reading this bugreport again I see simplepie wants curl, so php-curl is
> now installed.
> 
> does it work better for you ?

yes

GET
https://www.mageia.org/es/community/
[HTTP/1.1 200 OK 840ms]
Comment 23 Dave Hodgins 2023-09-11 23:22:33 CEST
Much better.

In firefox I right click on the page and select inspect. After clicking on
the network header and then the reload for the page (with cache disabled
as part of inspect), it's now 1.60s

Closing as fixed.

Resolution: (none) => FIXED
Status: REOPENED => RESOLVED


Note You need to log in before you can comment on or make changes to this bug.