I'm running an Umbraco v. 4.7 site where I'm having some problems with the Log table. Every month or so, the log table is completely filled up and so is the sql transaction log.
I've never experienced this before and i can't simply figure out why this particular site is acting like this. I'm not doing any Log.Add() in the source code.
Umbraco will log a lot, also every document version change is logged. I would just clear the log table by Truncate Table UmbracoLog this will clear the log table and transaction log..
In 4.7 there's a bug in the annoying lockout screen that causes thousands of entries to be written to the Log table. It was fixed in 4.7.1. If you upgrade, the issue should stop ocurring. If you look at the log table and the errors are all login related, then that is likely the problem.
It's also possible that if the site is subjected to a heavy script based attack looking to do SQL injection or some other URL based attack vector that that a lot of errors would appear in the log table. If this was the case you'd expect to see a lot of 404 type errors in the table.
Full log table
Hi all,
I'm running an Umbraco v. 4.7 site where I'm having some problems with the Log table. Every month or so, the log table is completely filled up and so is the sql transaction log.
I've never experienced this before and i can't simply figure out why this particular site is acting like this. I'm not doing any Log.Add() in the source code.
Has anyone ever had this problem before? :-)
Thanks in advance,
Bo
Hi Bo,
Umbraco will log a lot, also every document version change is logged. I would just clear the log table by Truncate Table UmbracoLog this will clear the log table and transaction log..
Cheers,
Richard
In 4.7 there's a bug in the annoying lockout screen that causes thousands of entries to be written to the Log table. It was fixed in 4.7.1. If you upgrade, the issue should stop ocurring. If you look at the log table and the errors are all login related, then that is likely the problem.
It's also possible that if the site is subjected to a heavy script based attack looking to do SQL injection or some other URL based attack vector that that a lot of errors would appear in the log table. If this was the case you'd expect to see a lot of 404 type errors in the table.
If upgrading to 4.7.1 isn't an option, you could always look at disabling the login events in the umbraco config: http://our.umbraco.org/wiki/reference/files-and-folders/files-in-the-config-folder/umbracosettingsconfig
Hope that helps!
Hi Richard and Tim,
Hmm, I think I may have to upgrade to version 4.7.1 and see if that helps then :-)
Thanks for your replies!
- Bo
is working on a reply...