Support Forum

15GB Error Log Table Row!

22 Answers

New Answer

JI jim
jim
Member

Mr Papa said
wow, your forum users must spend most of their time looking at the members list…

Perhaps, but I doubt enough to cause the error volume I’m seeing. Can that only be thrown by actual page views by members or might something else cause that particular error. Could bots be hammering it?

You may recall I added a snippet of code you provided to our Members View template so we only show certain groups, depending on the user. Might that have caused something? I just want to rule out any factors I may be able to address.

FYI: The SP Admin Error Log tab was unresponsive again so I viewed the table and there was only one entry, compared to the hundreds earlier, but still odd behavior.

MP Mr Papa
Mr Papa
Member

yes, that members list query is only executed on a member list page… sure, it could be bots, but something is hitting those pages… same for the members view template – only ran on members list pages…

what do you mean by error log tab unresponsive? When you click on that, nothing happens? spinning icon? nothing loads? errors?

JI jim
jim
Member

Mr Papa said
what do you mean by error log tab unresponsive?

The blocks just keep spinning by and the error log sub tab never loads. Only the primary admin tabs load from the Forum menu, but I can’t access the specific sub tabs. Looking into this further just now, it appears to be happening on all the sub tabs, in both Firefox and Safari.

Similar to the old ahah error=0 issue we used to have long ago, but with no error. Firebug error console shows the following GET in red, but never a response:

my.domain/index.php?sp_ahah=toolbox-loader&sfnonce=23b90479f4&loadform=errorlog&reload=sfreloadel&rnd=1356579587829

Pasting that into a new tab does load the pane by itself, but it never loads where it should, blocks just keep spinning and spinning…

When I did load it in a new tab, I noticed another 100+ member-view-class errors/notices, all with the same timestamp. As if the error is just being constantly thrown, so any help troubleshooting that is greatly appreciated.

MP Mr Papa
Mr Papa
Member

if you have mod_security going which I seem to remember, but could be thinking of different topic, its known to fail on ajax requests because of its high false alarm rate…

JI jim
jim
Member

OK, so mod_security may be causing Ajax to fail causing the Admin tabs to hang. I suppose the only suggestion for that is to turn off mod_security? If so, that is likely not going to happen. frown

Now, what can I do to help troubleshoot all these errors/notices being written to the log? Could the code I added to selectively show usergroups have anything to do with that? The Members list clearly isn’t getting viewed 100 times a minute.

Thanks again.

YS Yellow Swordfish
Yellow Swordfish
Member

On the possible mod_security issue it is not necessary to turn mod_security off completely. It is a matter of identifying the specific pattern that is causing the issue and removing or changing that. The useful thing about turning it off completely however, is simply to discover if that this the where the root of the problem lay.

On the members list issue and the somewhat over-zealous use of notices in php 5 – then this is not caused by hundreds of users all running the members list but a single members list request throwing the notice for each member record it processes. I see that Steve as hit that one on the head during my night so 5.2.1 will put a stop to those.

I am not sure what code you put in place to ‘selectively show users groups’ but are you aware that we did put support for something along these lines into 5.2 which may perhaps be allowing for the same thing?

JI jim
jim
Member

Yellow Swordfish said

On the possible mod_security … It is a matter of identifying the specific pattern that is causing the issue

Well, this is proving to be difficult as the issue of SP Admin sub-tabs not loading appears to be intermittent today. I’ll need to investigate this further whenever it presents itself.

…a single members list request throwing the notice for each member record it processes… 5.2.1 will put a stop to those.

Oh good. With nearly 5000 members this could explain how we accumulated millions of entries in the error log over the years. Earlier in this thread, Steve mentioned investigating why our table row wasn’t auto-truncating to the most recent 50 errors, so hopefully that functionality can be confirmed in 5.2.1 also. I’m monitoring my log to see if it exceeds 50 now, currently at 43…

…we did put support for something along these lines into 5.2 …

No, I was not aware of any new options to control viewing of the Members list. And I can’t seem to find it after reviewing the Options, User Groups, and Permissions admin panes. Was this support added to the Admin settings, or a template function?

Here is the code Steve provided which we’re using to only show certain user groups to all on the Members List while showing all groups to Admins and Moderators. If the new support addresses this need, please advise where I’ll find those settings.

Thanks again for all the help! Looking forward to 5.2.1…

MP Mr Papa
Mr Papa
Member

yes, the error log reduction to only last 50 entries is corrected in 5.2.1…

No, I dont think the membership changes Andy referred to will do what the code I gave you did…  you have some pretty unique requirements for what and how you wanted to show… all the changes were under the hoods and cleaned up and improved the use of the existing arguments to the class…  but will wait for Andy to confirm…