pauses in the admin section

lonk · Regular Joined: Aug 04, 2006 Posts: 60

Hello all,
I am having some major issues with the admin section. It does happen when you click on the non-admin sections but its rare. I can sit there for 4 minutes while its thinking about open the blocks or modules. it made setting up the forum a real pain. i changed theme back to the ones that came with Ravennuke and it still does it. I do not see any errors. I have some errors that it could find an image in a theme i am using but i fixed that. I really could use some help.

Thanks
Lonk

nuken · Posted: Tue Jul 19, 2011 5:04 am

Try clearing your browsers cache.

lonk · Regular Joined: Aug 04, 2006 Posts: 60

im asking for help becuase the simple things did not work. i have done that. other users are reporting pauses from the website.

Palbin · Posted: Tue Jul 19, 2011 3:00 pm

I think you need to contact your host. It sounds like a problem with the web server.

bobbyg · Posted: Tue Jul 19, 2011 3:51 pm

If you are on a shared server and activity is high on any of the other sites (especially if large amonts of uploads or downloads are taking place) you will see your page take a long time to load.

If you experience a pause, try clicking the refresh.

lonk · Regular Joined: Aug 04, 2006 Posts: 60

ok ill try that then. ill let you know what i find out

lonk · Regular Joined: Aug 04, 2006 Posts: 60

ill open a ticket

Susann · Posted: Wed Jul 20, 2011 11:31 am

I have tried for a limited time eAccelator with my RavenNuke site and the difference between the loading time within the administration was really noticeable. Maybe you host offers such or similars extensions too. Try it out.
However, you should not have such issues normally. Maybe something is wrong with your .htaccess, files or Browser. Who knows.

myrtletrees · Posted: Wed Aug 03, 2011 9:04 am

I have the same exact problem with my site. The regular areas of the site load just fine and quickly. However, as soon as I go to any admin area, the site comes to a screeching halt. Page loads can take up to minutes. ESPECIALLY when I try to edit or post news. I'm wondering if the News editor is causing the server load to spike?

EDIT: I just tested some more. It does not matter. ANY AREA of the admin area brings my site to a screeching halt. Even the admin login page loads very very slow.

I've opened a ticket with my host, but they say the site loads fine for them (typical).

I guess my only other plan of attack is to give them admin access to my site so they can see the slow load times in the admin area.

My question is why would only the admin area of my site be slow?

nuken · Posted: Wed Aug 03, 2011 9:34 am

Turn on error reporting and see if you are getting any errors.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

And temporarily rename your .htaccess file (unless you're using shortlinks)

myrtletrees · Posted: Wed Aug 03, 2011 10:59 am

nuken wrote:

Turn on error reporting and see if you are getting any errors.

Forgive me, but how do I turn on debugging?

kguske wrote:

And temporarily rename your .htaccess file (unless you're using shortlinks)

I use shortlinks....ugh.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

It still might be worth renaming your .htaccess file long enough to test the impact on admin performance. If it's much better with the renamed .htaccess, then you know there is a problem in .htaccess (more likely a server configuration issue that is highlighted by .htaccess).

killing-hours · Posted: Wed Aug 03, 2011 11:17 am

Debugging Switch:

config.php ---> Line 70ish " $display_errors = false ----> $display_errors = true "

Also, is this happening with all browsers?? Do you have other pc's to test from to see if the issue is specific to a pc?

I ask because I'm noticing some stalls in FF5 on my work pc... but not on my home pc with all sorts of sites.

myrtletrees · Posted: Wed Aug 03, 2011 12:12 pm

killing-hours wrote:

Debugging Switch:

config.php ---> Line 70ish " $display_errors = false ----> $display_errors = true "

Also, is this happening with all browsers?? Do you have other pc's to test from to see if the issue is specific to a pc?

I ask because I'm noticing some stalls in FF5 on my work pc... but not on my home pc with all sorts of sites.

Happens with both IE and FF. I am still using FF 3.xx. FF4 sucked and I am scared to go to FF5.

I tried from another PC and it seems better.

I have done the typical stuff. clearing cache etc. I also reformatted my drive yesterday and this is a fresh install of Windows 7. I reinstall my OS at least once a year out of habit.

I'm really starting to think this is a server side issue but there is no way for me to prove that.

Also, it looks like debugging in my config was already on. Could that be an issue? oops?

nuken · Posted: Wed Aug 03, 2011 12:58 pm

That could cause problems. After you set error reporting to false, be sure to empty rnlogs/dblog as it can become very large in a short amount of time.

montego · Posted: Wed Aug 03, 2011 6:45 pm

myrtletrees, have you added anything recently to your site? Is it only when you try and post an update / new something where you are seeing the slow-down or also on just navigating around?

Quote:

Also, it looks like debugging in my config was already on. Could that be an issue? oops?

Definitely never good to have turned on with a production site. I also think nuken meant to turn on SQL error reporting, which is the $loglevel variable within rnconfig.php. I would set this to 1 and make sure rnlogs/dblog is write-able (usually 666). Run through a few admin areas where you notice the slow down and then check the dblog file to see if there are any errors in it.

The admin area definitely does a bunch of file system reads but I don't recall ever having seen the admin slow and not the main end-user side not also be slow. And, ShortLinks really doesn't do too much in the admin side (yes, can still have a few left-hand blocks and the over-all page tap, but the end-user side would do a ton more).

myrtletrees · Posted: Wed Aug 03, 2011 7:40 pm

montego wrote:

myrtletrees, have you added anything recently to your site? Is it only when you try and post an update / new something where you are seeing the slow-down or also on just navigating around?

Quote:

Also, it looks like debugging in my config was already on. Could that be an issue? oops?

Definitely never good to have turned on with a production site. I also think nuken meant to turn on SQL error reporting, which is the $loglevel variable within rnconfig.php. I would set this to 1 and make sure rnlogs/dblog is write-able (usually 666). Run through a few admin areas where you notice the slow down and then check the dblog file to see if there are any errors in it.

The admin area definitely does a bunch of file system reads but I don't recall ever having seen the admin slow and not the main end-user side not also be slow. And, ShortLinks really doesn't do too much in the admin side (yes, can still have a few left-hand blocks and the over-all page tap, but the end-user side would do a ton more).

Nothing new added except a few articles. Nothing out of the ordinary.

What seems to be causing the slow load is images. When I get into the main Admin page, the images take FOREVER to load.

I checked my rnlog and dblog, both were not writable by all. dblog was 644, rnlogs was 755.

I turned on debug to level 1 as you requested. What file do I check for the log info?

Susann · Posted: Thu Aug 04, 2011 4:30 am

You have to check the entries in the file /rnlog/dblog to find out more about possible SQL errors.

Also its always good idea to reduce the size of images because visitors dont wait too long.

myrtletrees · Posted: Thu Aug 04, 2011 7:46 am

Susann wrote:

You have to check the entries in the file /rnlog/dblog to find out more about possible SQL errors.

Also its always good idea to reduce the size of images because visitors dont wait too long.

Yes I always reduce image size,s etc. Habit.

Just got a response from my Web Host:

"We checked the site a few times since you started this ticket. We have also been monitoring the server. Your site should be fine again, we have a site that was using to many resources at different times so it was kind of a hard problem to track down. If you continue to have problems please let us know and we will be sure to do everything we can to resolve any issues quickly."

killing-hours · Posted: Thu Aug 04, 2011 7:49 am

Good to hear myrtletress... Wink

Susann · Posted: Thu Aug 04, 2011 8:05 am

They will usally not fix your SQL errors. Therefore I would track it in dblog for a short time and afterthat set it back to default.

killing-hours · Posted: Thu Aug 04, 2011 8:11 am

myrtletrees wrote:

we have a site that was using to many resources at different times so it was kind of a hard problem to track down.

What the host is saying... is that on the "shared" server myrtletrees is on... there was another site that was hogging up the resources of that server. Therefore slowing the other sites on the server down.

Since the admin area generally loads more images than the rest of the site... if you loaded it while in the midst of that other site hogging... you'd see a pause in the admin area.

myrtletrees · Posted: Thu Aug 04, 2011 8:33 am

Still getting the pause occasionally....*sigh*

myrtletrees · Posted: Thu Aug 04, 2011 9:18 am

OKAY. Here's what I have in my dblog file so far:

This one is repeated MANY times:

August 4, 2011, 9:26 am 1054 : Unknown column 'vidid' in 'where clause'
SQL was: SELECT * FROM nuke_comments where vidid = qvidid LIMIT 0,20
remote addr: "DIFFERENT IP's"

Then there is this one:

August 4, 2011, 6:12 am 1100 : Table 'nuke_session' was not locked with LOCK TABLES
SQL was: INSERT INTO nuke_session (uname, time, host_addr, guest) VALUES ('barefootnit', '1312456367', '209.225.100.109', '0')
remote addr: 209.225.100.109

That one only shows up one time...