What's new
  • This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
  • Do not use Chrome Incognito when registering as it freezes the registration page.
  • Guest, Join Papa Zoom today for some uplifting biblical encouragement! --> Daily Verses

Feedback Site locking up?

Joined
Dec 14, 2012
Messages
6,568
Gender
Male
Christian
Yes
#41
There's an example of just how bad the problem can be. I posted my above post at just after 2:45AM my time. It should go through almost instantly but even though I tried repeatedly to get it to go through the time stamp shows it took ONE HOUR to go through! The site's working normally again now, but this kind of thing comes and goes without warning, all hours of the day and night. It makes it nearly impossible to do anything while this is happening and it even makes me afraid of moderating for fear that it will lock up in the middle of what I'm doing and mess things up.

There was talk a while ago about why we don't have many members. This kind of thing can't do much to help attract or keep members. I don't know much about how web sites work from the business end of it, but it seems that if there are very few members, there would be less profit from donations or wherever the profit comes from.
 

StoveBolts

Staff member
Administrator
Joined
Nov 4, 2004
Messages
13,551
Gender
Male
#42
Obadiah
There is more to running this forum than putting a pretty face to it (skin). It's like a car, you can wash it and keep it looking good, but you have to change the oil on a regular schedule and once in awhile give it a tune up.

Have one of the Admin's go into the Admin Console. Under the Tools section, have them read up on the different cache's and then have them rebuild them accordingly.
Secondly, they can log into the Host, which should be Gator and he / she can run an "Optimize" on the database too.... but first mirror the sandbox and "Optimize" the sandbox first and see if anything breaks before implementing any changes in production aka "Fellowship"

BTW, this is exactly why we set up a sandbox... and I see the Sandbox is being all but ignored. The Sandbox was put in place as a "Mirror" to "Fellowship". It's far from a mirror from what I can see.

Anyhow, step one would be for somebody to request a database backup from Gator. I'd then "Import" that into the sandbox. I'd then bring both forums into a "Mirrored" state (skins and other modifications). Then I'd start "rebuilding the cache" and see what breaks, if anything. Then, and only then start making changes in production aka Fellowship to fix the issue. And no, I don't buy it's "Gator's fault". It wasn't their fault last time as much as we'd all like to think it was.

There is a reason why I set things up the way I did and if nobody learned anything from the old forum when it crashed...which is why were on Xenfero, well... history will repeat itself.
 

StoveBolts

Staff member
Administrator
Joined
Nov 4, 2004
Messages
13,551
Gender
Male
#43
*sigh*

This is something only Greg can fix, as it will require a better server.
I disagree Nick. Run your stats.. your membership and growth isn't that high. Log into the Admin console and check out the server logs... see what's hanging. Check your Cron Jobs and make sure they are spanned appropriately so your not overlapping jobs or running them during peak times etc
 

StoveBolts

Staff member
Administrator
Joined
Nov 4, 2004
Messages
13,551
Gender
Male
#44
More likely the server isn't powerful enough. We're on a small plan.
It's a big enough plan to handle the load. We've checked out larger plans and they are way out of Greg's price range. I ran the numbers last time we went moving around and Gator offers the largest plan within his budget with the greatest resources and the numbers don't lie. It's not the resources Nick, it's about maintenance.

Have you checked the Xenforo logs? Have you logged into Gator and viewed their error logs? Have you done your due diligence in identifying the issues? I'd be willing to bet the Database is bloated again and I hope you've at least been watching what you install on this site with good documentation.

Not trying to bash you Nick, but being a site Admin means digging into the logs and understanding how the engine works and how to maintain it. I know it's not as fun as eye candy, but it's something that has to be done.

Lets say Greg did move to another host. Who's going to do it? And if you did, sure, it would last a few years until the Database got bloated again... Moving site isn't the first thing that should be looked at. You need to find root cause and you need to get the Sandbox mirrored to production and then fix this site.
 

StoveBolts

Staff member
Administrator
Joined
Nov 4, 2004
Messages
13,551
Gender
Male
#45
It must be a really small plan. It's now 2:45 AM and it's so slow it took me forever just to get to this thread. Do the servers really get that busy at this time of morning??? No sense in my trying to do any work on the threads or anything as It's just taking several minutes to do things that should happen close to instantly. :shame
Have Nick check the Cron Jobs. I set most of them to run early morning when this site sees the least amount of traffic. the fact that the site was slow at that hour even though the Cron Jobs were running is alarming.

One other thing... Is Greg running other sites on Host Gator? Somebody really needs to look at the site from a Host Gator perspective. Run some stats from Host Gator and veiw the error logs and compare them with Xenfero's error logs...
 
Joined
Feb 27, 2009
Messages
14,530
Gender
Male
#46
StoveBolts I haven't been able to be around here for a while, only coming back more recently. I have no access to databases/hostgator. There is a large part that is indeed Greg's job, if he is the only person that has access to it. And yes, I believe there are other sites running too.

No one's changed any cron jobs, so I'll look at the caches.
 

StoveBolts

Staff member
Administrator
Joined
Nov 4, 2004
Messages
13,551
Gender
Male
#47
Check the error logs. I'll see if my server credentials still work. If they do I'll send them to you
 

StoveBolts

Staff member
Administrator
Joined
Nov 4, 2004
Messages
13,551
Gender
Male
#48
Eora
Sorry for the long wait. I had a sudden bout with bronchitis.
Greg has changed the pw for hostgator, so you might reach out to him to give you the new pw. Tell him you need to look at the server error logs so you can figure out what files are conflicting and causing the lock up on the site. (You can also run some diagnostics / repairs on the sandbox database, then prod) If the database diagnostics / repair doesn't fix the lockups and we're still haning on a file, hopefully you'll be able to to take the file names to the xenfero site for assistance. Perhaps it's a bug in their code. Who knows. But you may not be the only one experiencing this. Also, have you checked the boards error logs? That might give you a clue as well.
Lastly, have you learned up on the different cache's? If so, it would be my recommendation to mirror the sandbox to come as close to Fellowship as possible, and then start making changes prior to implementing any "fixes" in production aka Fellowship.
.02
Let me know if you have any questions. Otherwise, good luck and I hope you'll be able to straighten out the issue.
As for why a certain file would be hanging, keep in mind that each file invokes DML (https://en.wikipedia.org/wiki/Data_manipulation_language) and there are database rules for accessing data. if a query hangs, it will stop any other queries from running on that table. There are many reasons why a query would hang.
 
Last edited: