Also Known As: banshee_revora (Steam) Joined: 15 Aug 2002 Location: Brazil
Posted: Fri Aug 29, 2014 12:07 am Post subject:
PPM is now stable again.
Subject description: The main source of the error 503s has been tracked and fixed.
After a long fight against the thousands of error 503s that were haunting this place, we are safe to say that we've found the main source of the problem and we can now follow a better tiberian vision envisioned by Kane, from now on.
In the latest weeks, we have moved two hostees to their own accounts (The Dawn of the Tiberium Age and Twisted Insurrection), optimized many scripts and hosted sites, forum software, tweaked many .htaccess files, robots.txt and even reformed the way Google crawls this place.
But the source of the problem was in the way that sites and scripts written by me tried to close the mysql connection, everytime they ran. The problem was... phpBB does create a persistent mysql connection. It doesn't close it. If you ask it to close it, it will try to close it and ignore the error message. The several attempts at once to close a persistent connection that can't be closed does lock the sites resources (in this case, the connection to mysql). In some cases, it could crash the php process that handles the site. In these cases, the evil error 503 appeared. Even if we used the latest phpBB that is under development, this problem would also happen.
Now, the site is much faster and it has not reported any error 503 since the solution was applied. Let's hope it continues like that for a long time.
By the way, for those who read the last news post, Twisted Insurrection has been fully moved to a new account and it is working correctly now. Everything works! Have fun and enjoy this place! QUICK_EDIT
Thanks for putting in the time and effort, it is well appreciated that it's back up and running again. _________________ "Don't beg for things; Do it yourself or you'll never get anything." QUICK_EDIT
Also Known As: ZivDero Joined: 23 Jul 2013 Location: Russia
Posted: Fri Aug 29, 2014 8:12 pm Post subject:
Need more! Yuri Miner
Loading times are still a bit long and it occasionally throws a 503.
But this is waaaay better than it was. _________________
DarkVen9109 wrote:
What in the name of insanity is this? I FRICKING LOVE THIS LOGICCCC!!!!!!!!!!!!OOOOOOOOHEEAWWWWWWWWWWWYAAAAAAAAAAAAAAAAAWWWWWW PEW PEW PEW PEW BOOM BOOM BOOM!! Nice I love this!!!! Ferriswheel bomb, Dive bomb. New Logic discovered thanks to Kenosis
Also Known As: banshee_revora (Steam) Joined: 15 Aug 2002 Location: Brazil
Posted: Fri Aug 29, 2014 10:06 pm Post subject:
Quote:
It runs like a Japanese train here.
I don't know if this is good or not. It's probably good. If it was a brazilian train, I would consider it an offense .
Quote:
Loading times are still a bit long and it occasionally throws a 503.
Yea, cPanel is also reporting constant Error 503s, although it is not as constant as before. I'm still trying out of couple of things to improve the situation. In the morning, I've tweaked a minor bit of code that could try to close mysql with a persistent connection. Now, I've disabled two very old versions of PPM's website that still made a massive usage of the database (and bots were still browsing it very often for reasons beyond my comprehension). Let's see if it improves in the next hours. QUICK_EDIT
Also Known As: ZivDero Joined: 23 Jul 2013 Location: Russia
Posted: Mon Sep 01, 2014 7:50 am Post subject:
Seems way better than it was last time. Loads quickly and not 503s just yet. _________________
DarkVen9109 wrote:
What in the name of insanity is this? I FRICKING LOVE THIS LOGICCCC!!!!!!!!!!!!OOOOOOOOHEEAWWWWWWWWWWWYAAAAAAAAAAAAAAAAAWWWWWW PEW PEW PEW PEW BOOM BOOM BOOM!! Nice I love this!!!! Ferriswheel bomb, Dive bomb. New Logic discovered thanks to Kenosis
Banshee, did you ever notice if there are some Chinese bots or users illegally going through this forum? Due to the discussion of the Zero Hour mod tool earlier which may or may not be related to the slowdowns of this website, I think it's time you need to investigate this and ban whoever hacked and slowed down this site.
As of now, the site may be partially stable, but it's still not as fast going through this site. _________________ RIP PurpleScrin (2007-2010) QUICK_EDIT
Joined: 22 Nov 2010 Location: Iszkaszentgyorgy, Hungary
Posted: Mon Sep 01, 2014 5:48 pm Post subject:
You're paranoiac. _________________ "If you didn't get angry and mad and frustrated, that means you don't care about the end result, and are doing something wrong." - Greg Kroah-Hartman
=======================
Past C&C projects: Attacque Supérior (2010-2019); Valiant Shades (2019-2021)
=======================
WeiDU mods: Random Graion Tweaks | Graion's Soundsets
Maintainance: Extra Expanded Enhanced Encounters! | BGEESpawn
Contributions: EE Fixpack | Enhanced Edition Trilogy | DSotSC (Trilogy) | UB_IWD | SotSC & a lot more... QUICK_EDIT
Also Known As: banshee_revora (Steam) Joined: 15 Aug 2002 Location: Brazil
Posted: Mon Sep 01, 2014 9:23 pm Post subject:
Zocom, the chinese bots who floods this place are not registered members and, they may not necessarily have a fixed IP, nor an ID that identifies it as a bot. Sometimes, when you ban an IP of a bot, you might be banning a potential user that could be in the same ISP than this bot.
So, I'm not the kind of person who likes to use my energy on these things. QUICK_EDIT
You cannot post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum