Slow log-in at the first connection to Confluence

[Sharad Ahlawat]

We just upgraded to 7.3.0 because of a security patch. After the upgrade, we noticed a strange problem.

1. If users don't log in, just establishing the first Confluence connection to the root directory would take 40 seconds to get the first page display.

2. Under the same condition (no user login), if users visit any specific page (ie. not root cause), we do not see the same delay.

3. If users log in, we do not see the same delay in either root directory or any specific page. 

We did a little analysis and found Confluence would trigger a module called quickload (funny, it is totally the opposite) and slow down the whole Confluence in #1 (no user log in, and open the root directory). The same module is not triggered in #2 or #3.

Anyone knows how to disable this quickload or how to fix this problem? We were using 6.15.0 and did not see the same problem.

[Sharad Ahlawat]

Is there a way I can downgrade from 7.13.0 to 7.12.0 or even 6.15.x to see if I can resolve this problem? We did not have this problem in 6.15.4.

[Tinker Fadoua]

@Sharad Ahlawat 

What are you seeing on the logs?

Can you hide any personal info copy/paste some lines from the logs please?

Best,

Fadoua

[Sharad Ahlawat]

I reset the catalina.out log and then connect to the root directory. Waited 40 seconds to get the page up. No log is ever recorded at catalina.out. 

root@ip-172-31-0-248:/opt/atlassian/confluence/logs# ls -al catalina.out-rw-r--r-- 1 root root 0 Sep 19 01:59 catalina.out

=== connect to https://docs.pica8.com

=== waited 40 seconds for the page to be rendered.

root@ip-172-31-0-248:/opt/atlassian/confluence/logs# date

Sun Sep 19 02:00:35 UTC 2021

root@ip-172-31-0-248:/opt/atlassian/confluence/logs# ls -al catalina.out

-rw-r--r-- 1 root root 0 Sep 19 01:59 catalina.out

In the meantime, I checked /var/atlassian/application-data/confluence/logs.

In atlassian-confluence.log, there are repetitive warnings. I am not sure if these are related.

2021-09-19 01:35:40,583 WARN [http-nio-8090-exec-29] [webresource] requireWebResource requiring something that doesn't look like the web resource "confluence.macros.newcode.macro.mobile", it will be ignored.

 -- referer: https://docs.pica8.com/plugins/servlet/mobile?contentId=3084964 | url: /rest/mobile/1.0/content/3084964 | traceId: 218c8d5728e03dbf | userName: anonymous

2021-09-19 01:45:34,535 WARN [http-nio-8090-exec-13] [webresource] requireWebResource requiring something that doesn't look like the web resource "confluence.macros.newcode.macro.mobile", it will be ignored.

 -- referer: https://docs.pica8.com/plugins/servlet/mobile?contentId=41717191 | url: /rest/mobile/1.0/content/41717191 | traceId: 0df084f008cef894 | userName: anonymous

2021-09-19 01:45:34,538 WARN [http-nio-8090-exec-13] [webresource] requireWebResource requiring something that doesn't look like the web resource "confluence.macros.newcode.macro.mobile", it will be ignored.

 -- referer: https://docs.pica8.com/plugins/servlet/mobile?contentId=41717191 | url: /rest/mobile/1.0/content/41717191 | traceId: 0df084f008cef894 | userName: anonymous

2021-09-19 02:00:51,524 WARN [http-nio-8090-exec-39] [confluence.util.profiling.DefaultActivityMonitor] close Exceeded the threshold of 60000 ms: ActivitySnapshot{startTime=1632016790304, threadId=1751, threadName='http-nio-8090-exec-39', userId='<unknown>', type='web-request', summary='/'}

 -- url: / | traceId: e360cb1708132321 | userName: anonymous

[Tinker Fadoua]

In Confluence logs we mainly worry about Errors. WARN are not critical.

Did you see the following page:

https://confluence.atlassian.com/doc/confluence-7-3-upgrade-notes-983794548.html

Best,

Fadoua

[Sharad Ahlawat]

I just read through it, but cannot see anything might be related to what we are seeing. We just upgraded from 6.15, and have been using MySQL. Nothing seems to be alerting in the upgrade notes to our configuration.

[Sharad Ahlawat]

If you can check the following three links (of the same Confluence server), you can see the difference.

https://docs.pica8.com

https://docs.pica8.com/display/PicOS412sp/Release+Notes+for+PICOS+4.1

https://docs.pica8.com/display/PicOS412sp/Hardware+Guides

[Tinker Fadoua]

Can you try to disable Synchrony and see if you will still experience the same problem?

[Sharad Ahlawat]

The Collaborative Editing mode was turned off and Synchrony was never enabled. 

[Tinker Fadoua]

interesting!!! Even though it is disabled you are having this issue.

Let me go through what you shared and check some documents then get back to you tomorrow evening.

Best,

Fadoua

[Sharad Ahlawat]

We found the Confluence program was stuck at "Quickload" for 40 seconds before it returns. Is there a way to disable this "Quickload" module?

[Tinker Fadoua]

that is exactly what I want to search

[Sharad Ahlawat]

Thank you for your help. I will wait for your reply. In the meantime, I will try turning on the collaborative mode and then turning it off. See if that makes any difference.

[Sharad Ahlawat]

Tried turning on the Collaborative Editing (worked)

Then tried to restart Synchrony 2 minutes after the Collaborative Editing is turned on. It failed with ERROR.

Then I turned off the Collaborative Editing (worked)

Then logged out from my account and tried https://docs.pica8.com. The problem is still the same.

[Tinker Fadoua]

Concurring editing can make your Confluence slow sometimes. I tried to look for information related to Quickload wasn't able to find anything.

I tagged Atlassian Engineers so that you can get the assistance you need.

All the best,

Fadoua

[Shannon S]

Hello @Tinker Fadoua Thank you for escalating this to us!

@Sharad Ahlawat, I'd like us to take a look at this in support, so we can look at your server logs. I've raised a ticket for you now. Please keep an eye in your email for that ticket number!

Take care,

Shannon