Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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...Administration ...Administration ...SQL Database grows to max size 10GB cant use DNNSQL Database grows to max size 10GB cant use DNN
Previous
 
Next
New Post
7/12/2012 3:13 PM
 
Cody Walbaum


Joined: 7/7/2006
Posts: 207
erik hinds wrote:

Are your logs filling up? Try shrinking the db and files.

Also you can use this query to find out what tables are the largest

USE DatabaseName
GO
CREATE TABLE #temp (
table_name sysname ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))
SET NOCOUNT ON
INSERT #temp
EXEC sp_msforeachtable 'sp_spaceused ''?'''
SELECT a.table_name,
a.row_count,
COUNT(*) AS col_count,
a.data_size
FROM #temp a
INNER JOIN information_schema.columns b
ON a.table_name collate database_default
= b.table_name collate database_default
GROUP BY a.table_name, a.row_count, a.data_size
ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC

DROP TABLE #temp

 Ran this and dnn_Events was largest at about 2.2MB, then dnn_Packages was 2MB the rest all are about 600kb or less and nothing adds up to 10GB

Ran the other script suggested as well with no changes to the DB size.  It is very strange brew here...,

I believe if i was running enterprise edition this DB would be 500GB or whatever hte max my hard drive can hold...
 
New Post
7/12/2012 3:38 PM
 
Cody Walbaum


Joined: 7/7/2006
Posts: 207
It looked like it was 10.2GB which it is since it grew to that size however it shows 10.1GB of free space now after running that truncate script mentioned it seems to have done the trick.

Thanks a lot for the assistance would love to buy you both a beer or coffee :)
 
New Post
7/12/2012 3:55 PM
 
Cody Walbaum


Joined: 7/7/2006
Posts: 207

OK i had an issue with it saying there was no instance of an object error not allowing the website to be viewed so I backed off to 6.0 and re ran the update script to bring the site back to life and it worked. 

Looking in event viewer I have these warnings and general exceptions during that update:

Warnings

: (TRUNCATED TO 500 CHARS): System.Data.SqlClient.SqlException: Invalid column name 'Level'. Invalid column name 'TabPath'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataRe


General Exception:

RawURL: /Install/InstallWizard.aspx?__U=1342121533125

AbsoluteURL: /Install/InstallWizard.aspx

 Message: System.Exception: Attempt made to run a Database Script - Possible Attack

 

I get like 1 every second... from google and bing bots accessing pages then after the update and recycled app they stop...  I will pay close attention to this because it seems an error was happening like the following one every second until finally I had the updates done:

AssemblyVersion: 6.2.1

PortalID: -1

PortalName:

UserID: -1

UserName:

ActiveTabID: -1

ActiveTabName:

RawURL: /Community/Forum/tabid/316/forumid/1/postid/270/scope/posts/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer:

UserAgent: Mozilla/5.0 (compatible; Ezooms/1.0; ezooms.bot@gmail.com)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider 

InnerException: Invalid object name 'dnn_vw_Tabs'.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.

StackTrace:

Message: System.Data.SqlClient.SqlException: Invalid object name 'dnn_vw_Tabs'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetTabPaths(Int32 portalId, String cultureCode) at DotNetNuke.Entities.Portals.PortalController.GetPortalDictionaryCallback(CacheItemArgs cacheItemArgs) at DotNetNuke.Common.Utilities.DataCache.GetCachedDataFromRuntimeCache(CacheItemArgs cacheItemArgs, CacheItemExpiredCallback cacheItemExpired) 

 

I have now cleared the logs and am going to monitor it from here.
 

 

 

 
 
 Page 2 of 2
Previous12 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQL Database grows to max size 10GB cant use DNNSQL Database grows to max size 10GB cant use DNN


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out