Products

Solutions

Learn More

Partners

Community

Blog

About

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...DNN 8.x problem -- SQL database Log file gets out of controlDNN 8.x problem -- SQL database Log file gets out of control
Previous
 
Next
New Post
3/2/2017 5:45 PM
 

I have a single DNN 8.0.4 installation running a single web site... the SQL database data file stays around ~1.5GB, but the transaction log keeps growing and getting full -- all the way up to 2.0GB limit I set, which makes scheduled SQL backups fail... 

I increased the log limit to 4GB -- and it took a little over a week to fill up all that space, too!

I have other installations that do not present this problem... what can cause this?

 
New Post
3/3/2017 6:12 PM
 
One place to check is the DNN Event Log. See if there's something that is logging errors, and then you'll have to figure out what's going wrong and fix it.



Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)
 
New Post
3/13/2017 6:35 AM
 
I am unable to open the log -- I get this error message when I try:


Error: View a historical log of database events such as event schedules, exceptions, account logins, module and page changes, user account activities, security role activities, etc. is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.Execute(String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, Int32 timeout, String sql, Object[] args) at DotNetNuke.Data.DataProvider.PurgeLog() at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.PurgeLogBuffer() at DotNetNuke.Services.Log.EventLog.LogController.PurgeLogBuffer() at Dnn.Modules.LogViewer.LogViewer. (EventArgs e) --- End of inner exception stack trace ---

 
New Post
3/13/2017 8:50 AM
 
Hello there,

this is one weird situation, I haven't seen it before I think.
You can access the event log through the database yet it's a bit of a pain to examine the logs like that.
I think you should try to figure out why you can't access the event viewer through your website. Could you access the event viewer normally before? What changed since then? An upgrade perhaps? Did you move servers? Something must have changed before the problem appeared.
 
New Post
3/13/2017 10:51 AM
 
This usually happens when you set the backup mode to full, but don't do any transaction log backups (or full backups) of the database.

Solutions:

First: Make a backup of your database. You should then be able to set the database backup mode to simple and shrink the log files.

Then: Either set your backup mode to Simple, and do one or two full backups a day (when your site does not change contents too often).
Or: Set your backup mode to Full and do regular transaction log backups (in 10-15 minutes intervals), and one full backup a day (when your site has a lot of changes, and even minimal data loss is unacceptable).

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP
helferlein.com - Michael Tobisch's Site about DNN, SQL Server, ASP.Net and other related stuff dnn-Connect.org - The most vibrant community around the DNN-platform
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...DNN 8.x problem -- SQL database Log file gets out of controlDNN 8.x problem -- SQL database Log file gets out of control


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW