Patreon Logo Support us on Patreon to keep GamingOnLinux alive. This ensures all of our main content remains free for everyone. Just good, fresh content! Alternatively, you can donate through PayPal Logo PayPal. You can also buy games using our partner links for GOG and Humble Store.
Title: [Solved] Stalled requests with high paging settings
Page: 1/3
  Go to:
jens 12 Oct 2017
User Avatar
  • Supporter
Hi,

Within my profile I have set the following:
Comments & forum posts per-page: 50
Articles per-page, for homepage and category (tag) view: 25

After doing that some links, e.g. jumping from a notification directly to a message, are very very slow. The request, e.g. https://www.gamingonlinux.com/index.php?module=articles_full&aid=10447&comment_id=105433&clear_note=51266 seems to stall. I have to close and open my browser to navigate again. The site though is fast when navigating from the front page and not by notifications. I experience the same when posting a reply to a longer thread. My message got posted, but redirecting to the result seem to stall.
Liam Dawe 12 Oct 2017
Interesting, just to check something, do you have any users blocked? Don't need names, even if it's just one person a yes or no will do. Just to narrow it down.
jens 12 Oct 2017
User Avatar
  • Supporter
Quoting: liamdaweInteresting, just to check something, do you have any users blocked? Don't need names, even if it's just one person a yes or no will do. Just to narrow it down.
Nope, no blocked user(s).
Liam Dawe 12 Oct 2017
Okay, I did an adjustment for when you're hitting a notification. Can you re-test?
jens 12 Oct 2017
User Avatar
  • Supporter
No, sorry ,still the same.
Liam Dawe 12 Oct 2017
How long are we talking? For me it's practically instant.
jens 12 Oct 2017
User Avatar
  • Supporter
OK, eventually something was still cached om my side, seems a lot faster now. Thanks!
Liam Dawe 12 Oct 2017
Glad to hear it, as if it's fine my end then it can't have been the code, unless you did have hundreds of people blocked it had to remove posts for before displaying :)
jens 13 Oct 2017
User Avatar
  • Supporter
No, sorry, it is still broken for new notifications. I guess the issue happens when first something needs to be updated in your database (marking a notification as read). It's not just seconds, the request seems to hang forever.
Liam Dawe 13 Oct 2017
Since I have never encountered the issue and no one else has reported it, it's going to be hard to track down.

What browser and what plugins are you using?

Considering the amount of topics i end up following and the amount of notifications I get constantly, it's been tested extensively.

Edit: I just made a minor improvement to the handling. Who knows, maybe it will help.
Edit #2: Okay, I've made another adjustment that actually reduces the amount of MySQL queries it needs to do, by cutting one out completely.
jens 13 Oct 2017
User Avatar
  • Supporter
Thanks, I'll report back. I don't get that much notifications :)
To clarify: I never had this before I changed my paging settings, so quite sure it's related to that.

PS: I do see notifications in the notification center for regular threads, but not from the forum here. is this correct? I'm "subscribed without e-mail".
Liam Dawe 13 Oct 2017
Let me know how you get on, I'm constantly getting them and the entire page loads and displays everything within seconds for me.

The notification system is not integrated with the forum yet, waiting until I'm completely happy with it first.
jens 14 Oct 2017
User Avatar
  • Supporter
No, sorry, the problem is still there. must be something different :(
Can you see some long running requests or queries on your side?

It's standard Chrome with Adblock disabled for this site.
Liam Dawe 14 Oct 2017
Well it's not doing anything heavy and i'm really surprised, even on my mobile net on my phone it's fast.

If multiple others report the same thing, then I can take a look again. For now ill have to sit on it sinve it never happens to me and even on my slower net on my mobile its fine. :(

Sorry.
jens 14 Oct 2017
User Avatar
  • Supporter
Just to be sure, are you using similar paging settings like me (Comments & forum posts per-page: 50
Articles per-page, for homepage and category (tag) view: 25). These hanging requests started after I changed my preferences to that numbers.
Liam Dawe 14 Oct 2017
Yes exacrly the same settings.

I just tested on my mobile net, while its downloading (so its slow) and a new notification loaded the actual page in about 3 seconds.
jens 14 Oct 2017
User Avatar
  • Supporter
mmh, weird indeed. As I said, it's not slow, the request stalls completely and never finishes. While a request hangs I can't even open your front page in a new tab. That request hangs too. Like a deadlock on the session or similar. A browser restart is the only solution.
Liam Dawe 14 Oct 2017
Quoting: jensmmh, weird indeed. As I said, it's not slow, the request stalls completely and never finishes. While a request hangs I can't even open your front page in a new tab. That request hangs too. Like a deadlock on the session or similar. A browser restart is the only solution.
Ah, i was going by slow loading not a deadlock. To me that sounds like a browser issue, never once encountered that anywhere on GOL.

Only thing I can think of is to have the F12 menu open, with the console tab open and see if anything interesting comes up there.
jens 14 Oct 2017
User Avatar
  • Supporter
I already did that. Nothing strange there. I see a
"Uncaught TypeError: Cannot read property 'getEditor' of undefined
at a (ckeditor.js:344)
at Object.CKEDITOR.replace (ckeditor.js:348)
at 2984:1133"
but that seems unrelated.

My guess would be a database deadlock somewhere since I seem to experience this only in combination with a write action into the db ("mark notification as read", "set last login date" or "edit a post"). But indeed strange that I seem to be the only one experiencing this. Could be that I'm the only "normal" user using this paging settings ;). Your user account has certainly a different user role than mine. Eventually that make a difference too.
Liam Dawe 14 Oct 2017
If there was a deadlock in the DB it would affect everyone regardless of the setting. It sounds like an issue your end.

Try a different browser for a while and if you dont see the issue that will say it all.

User role has nothing to do with this issue, it runs the same for each of us.
jens 14 Oct 2017
User Avatar
  • Supporter
No, a deadlock in a database should affect only the participating transactions. But of course no idea if you actually use transactions. Dunno if this is a db-deadlock, just the symptoms seem similar. From my experience I'm pretty sure this is a server-side issue. My browser fires the request, but the request times out.

Anyway, I understand that this one seems difficult to track down, lets see if somebody else experiences this. It took me a few months until I reported it here since this is annoying behavior, but with a workaround.
While you're here, please consider supporting GamingOnLinux on:

Reward Tiers: Patreon Logo Patreon. Plain Donations: PayPal Logo PayPal.

This ensures all of our main content remains totally free for everyone! Patreon supporters can also remove all adverts and sponsors! Supporting us helps bring good, fresh content. Without your continued support, we simply could not continue!

You can find even more ways to support us on this dedicated page any time. If you already are, thank you!
Login / Register