System.OutOfMemoryException When trying to upgrade
Hi All trying to upgrade from 6.2.2 - 6.2.5
please assits my database is 1TB so its a huge db.
2017-07-25 10:24:17,646 [49] INFO Umbraco.Core.DatabaseContext - [Thread 47] Database configuration failed with the following error and stack trace: Exception of type 'System.OutOfMemoryException' was thrown.
at Umbraco.Core.Models.EntityBase.TracksChangesEntityBase.ResetDirtyProperties(Boolean rememberPreviouslyChangedProperties)
at Umbraco.Core.Models.EntityBase.Entity.DeepClone()
at Umbraco.Core.Models.PropertyType.DeepClone()
at Umbraco.Core.Models.Property.DeepClone()
at Umbraco.Core.Models.PropertyCollection.DeepClone()
at Umbraco.Core.Models.DeepCloneHelper.DeepCloneRefProperties(IDeepCloneable input, IDeepCloneable output)
at Umbraco.Core.Models.EntityBase.Entity.DeepClone()
at Umbraco.Core.Persistence.Caching.RuntimeCacheProvider.Save(Type type, IEntity entity)
at Umbraco.Core.Persistence.Repositories.RepositoryBase2.Get(TId id)
at Umbraco.Core.Persistence.Repositories.MediaRepository.<PerformGetByQuery>d__b.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator1.MoveNext()
at System.Collections.Generic.List1.InsertRange(Int32 index, IEnumerable1 collection)
at System.Collections.Generic.List1.AddRange(IEnumerable1 collection)
at Umbraco.Core.Services.MediaService.RebuildXmlStructures(Int32[] contentTypeIds)
at Umbraco.Web.Strategies.Migrations.RebuildMediaXmlCacheAfterUpgrade.MigrationRunnerMigrated(MigrationRunner sender, MigrationEventArgs e)
at Umbraco.Core.Events.TypedEventHandler2.Invoke(TSender sender, TEventArgs e)
at Umbraco.Core.Events.EventExtensions.RaiseEvent[TSender,TArgs](TypedEventHandler2 eventHandler, TArgs args, TSender sender)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade)
at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData()
2017-07-25 10:24:17,651 [49] INFO Umbraco.Core.DatabaseContext - [Thread 47] The database schema validation produced the following summary:
The following tables were found in the database, but are not in the current schema:
BrandReportSummary,VehicleImport,QuickMonitorUnmatchedImport,vAVE,vBrand,vCategory,vMembers,vModel,vOnline,vPrint,vRadio,vRange,QuickFleetBookingData,vSocial,QuickFleetData,vSocialItems,QuickFleetHistoryData,vTV,uShareAuthorizations,uShareServiceProviders,WG2KFormSubmisions,qmTransactionsNew,EVENT,EVENTMETA,rsvpEmailList,rsvpEmailListPerson,rsvpFieldType,rsvpInvitation,QuickMonitorDataTableau,qfVehicleBooking,rsvpInvitationList,rsvpPerson,rsvpRegistration,qfVehiclesBackup,rsvpRegistrationData,qfBookingRequest,CMSImportCustomRelation,rsvpRegistrationField,CMSImportMediaRelation,rsvpSendStatus,qfFleetAVEDat,qfVehicleAVE,CMSImportRelation,QuickFleetAVEData,CMSImportScheduledItems,CMSImportScheduledTask,CMSImportState,NodeAccess,vMediaOwner,vNodeRelatedMedia,SEARCHDATA,vSiteMedia,qfCategoryLoanAgreement,vRSVPEmailList,lNodeRelatedMedia,vRSVPEmailListPerson,MemberBulkDelete,vRSVPInvitationList,vRSVPInvitationRegistration,vRSVPInvitations,vRSVPRegistration,lSiteMedia,vRSVPRegistrationData,vRSVPRegistrationField,ELMAH_Error,qfReport,qfVehicleHistory,qmMailJob,qmMailQueue,qmMailQueueAudit,qmtranbackup2,FleetVehicleImport,qmTransactions,qfVehicles,qmtransactionsbackup,qpViewLog,QuickMonitorData,BrandReportData
Damiaan thanks for the reply but that is not an option as our business is the data and most of the data is media, The site has been created in 6.2.2 so there are no previous versions of the site.
Btw the previous versions are the previous version of every changed content node. You probably don't need every change since the site was up and running.
System.OutOfMemoryException When trying to upgrade
Hi All trying to upgrade from 6.2.2 - 6.2.5 please assits my database is 1TB so its a huge db.
2017-07-25 10:24:17,646 [49] INFO Umbraco.Core.DatabaseContext - [Thread 47] Database configuration failed with the following error and stack trace: Exception of type 'System.OutOfMemoryException' was thrown. at Umbraco.Core.Models.EntityBase.TracksChangesEntityBase.ResetDirtyProperties(Boolean rememberPreviouslyChangedProperties) at Umbraco.Core.Models.EntityBase.Entity.DeepClone() at Umbraco.Core.Models.PropertyType.DeepClone() at Umbraco.Core.Models.Property.DeepClone() at Umbraco.Core.Models.PropertyCollection.DeepClone() at Umbraco.Core.Models.DeepCloneHelper.DeepCloneRefProperties(IDeepCloneable input, IDeepCloneable output) at Umbraco.Core.Models.EntityBase.Entity.DeepClone() at Umbraco.Core.Persistence.Caching.RuntimeCacheProvider.Save(Type type, IEntity entity) at Umbraco.Core.Persistence.Repositories.RepositoryBase
2.Get(TId id) at Umbraco.Core.Persistence.Repositories.MediaRepository.<PerformGetByQuery>d__b.MoveNext() at System.Linq.Enumerable.WhereEnumerableIterator1.MoveNext() at System.Collections.Generic.List1.InsertRange(Int32 index, IEnumerable1 collection) at System.Collections.Generic.List1.AddRange(IEnumerable1 collection) at Umbraco.Core.Services.MediaService.RebuildXmlStructures(Int32[] contentTypeIds) at Umbraco.Web.Strategies.Migrations.RebuildMediaXmlCacheAfterUpgrade.MigrationRunnerMigrated(MigrationRunner sender, MigrationEventArgs e) at Umbraco.Core.Events.TypedEventHandler2.Invoke(TSender sender, TEventArgs e) at Umbraco.Core.Events.EventExtensions.RaiseEvent[TSender,TArgs](TypedEventHandler2 eventHandler, TArgs args, TSender sender) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade) at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData() 2017-07-25 10:24:17,651 [49] INFO Umbraco.Core.DatabaseContext - [Thread 47] The database schema validation produced the following summary: The following tables were found in the database, but are not in the current schema: BrandReportSummary,VehicleImport,QuickMonitorUnmatchedImport,vAVE,vBrand,vCategory,vMembers,vModel,vOnline,vPrint,vRadio,vRange,QuickFleetBookingData,vSocial,QuickFleetData,vSocialItems,QuickFleetHistoryData,vTV,uShareAuthorizations,uShareServiceProviders,WG2KFormSubmisions,qmTransactionsNew,EVENT,EVENTMETA,rsvpEmailList,rsvpEmailListPerson,rsvpFieldType,rsvpInvitation,QuickMonitorDataTableau,qfVehicleBooking,rsvpInvitationList,rsvpPerson,rsvpRegistration,qfVehiclesBackup,rsvpRegistrationData,qfBookingRequest,CMSImportCustomRelation,rsvpRegistrationField,CMSImportMediaRelation,rsvpSendStatus,qfFleetAVEDat,qfVehicleAVE,CMSImportRelation,QuickFleetAVEData,CMSImportScheduledItems,CMSImportScheduledTask,CMSImportState,NodeAccess,vMediaOwner,vNodeRelatedMedia,SEARCHDATA,vSiteMedia,qfCategoryLoanAgreement,vRSVPEmailList,lNodeRelatedMedia,vRSVPEmailListPerson,MemberBulkDelete,vRSVPInvitationList,vRSVPInvitationRegistration,vRSVPInvitations,vRSVPRegistration,lSiteMedia,vRSVPRegistrationData,vRSVPRegistrationField,ELMAH_Error,qfReport,qfVehicleHistory,qmMailJob,qmMailQueue,qmMailQueueAudit,qmtranbackup2,FleetVehicleImport,qmTransactions,qfVehicles,qmtransactionsbackup,qpViewLog,QuickMonitorData,BrandReportDataIf possible, I would first remove some data. I used most of the time this script. Or a package like unversion.
Kind regards
Damiaan
Damiaan thanks for the reply but that is not an option as our business is the data and most of the data is media, The site has been created in 6.2.2 so there are no previous versions of the site.
And do you need all versions of every content node? What is the biggest table?
Btw the previous versions are the previous version of every changed content node. You probably don't need every change since the site was up and running.
cmsPropertyData dbo Rows(1109983994) Size(56972.25)MB And cmsPreviewXml dbo Rows(4999496) Size(60521.92)MB
okay, cool will use the tool to see if I can get it a bit smaller but do you think this will sort out the problem?
is working on a reply...