Crashing MySQL Schema Compare

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
devartison
Posts: 2
Joined: Wed 21 Oct 2015 02:36

Crashing MySQL Schema Compare

Post by devartison » Sun 01 Oct 2017 15:03

I need help ASAP, the app is crashing when doing a comparison. Here is the crash report, with connection strings removed:

=========================
General
=========================
Application: dbForge Schema Compare for MySQL
Product: Devart dbForge Schema Compare for MySQL
Product Edition: Standard
Product Locale: English
Assembly: schemacompare, Version=4.1.17.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\Compare Bundle for MySQL Trial\dbForge Schema Compare for MySQL\schemacompare.exe
Global cache: False
Framework: 4.6.2 or later

=========================
Exception Information
=========================
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.DbObjects.MySql
TargetSite: System.String T73YINRqVu(Devart.DbForge.DbObjects.MySql.MySqlTable, Devart.DbForge.DbObjects.DbObjectCollection, Devart.DbForge.DbObjects.DbObjectCollection, System.String, Devart.Shell.IOptionGroup, Devart.DbForge.IServerInformation, Boolean, Boolean, System.Collections.ArrayList, System.Collections.Generic.ICollection`1[System.String], System.Collections.Generic.ICollection`1[System.String])
HelpLink:
Type: System.NullReferenceException
Place: 1
Stack:
at Devart.DbForge.DbObjects.MySql.MySqlTable.T73YINRqVu(MySqlTable , DbObjectCollection , DbObjectCollection , String , IOptionGroup , IServerInformation , Boolean , Boolean , ArrayList , ICollection`1 , ICollection`1 )
at Devart.DbForge.DbObjects.MySql.MySqlTable.GetAlterText(IDbObject originalObject, IOptionGroup options, IServerInformation serverInformation)
at Devart.DbForge.Compare.SchemaComparer.r1LP54g6Yf(SchemaComparisonObject )
at Devart.DbForge.Compare.SchemaComparer.AddDifferentEqual(DbObject source, DbObject target, String group, IOptionGroup options, Boolean excludedByFilter, SchemaComparisonObject mappedObject)
at Devart.DbForge.Compare.SchemaComparer.CompareObjectsGroup(String group, List`1 sourceObjects, List`1 targetObjects, IOptionGroup options, Boolean excludedByFilter)
at Devart.DbForge.Compare.SchemaComparer.DoCompare(String group, IDictionary`2 sourceObjects, IDictionary`2 targetObjects, IOptionGroup options, Boolean excludedByFilter)
at Devart.DbForge.Compare.SchemaComparer.Compare(IDictionary`2 sourceObjects, IDictionary`2 targetObjects)
at Devart.DbForge.Compare.SchemaComparison.DoCompare()
at Devart.DbForge.Compare.DatabaseComparison`1.ComparisonDoWork()
at Devart.DbForge.Compare.SchemaComparison.ComparisonDoWork()
at Devart.DbForge.Compare.ComparisonOperation.DoWork()
at Devart.Shell.Common.AsyncOperation.AsyncOperation.fVM2LdvFrG()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

=========================
Window Layout
=========================
Active document window: 'company_base v..._prod (rds).scomp' (Compare)
Active window: 'company_base v..._prod (rds).scomp'
Active document 'company_base vs company_base_prod (rds).scomp'

Documents:
Name: 'company_base vs company_base_prod (rds).scomp', Caption: 'company_base v..._prod (rds).scomp', Visible: True, Active view: 'Compare', Initial view: 'Compare'

Toolwindows (visible or have been shown in current session):
Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed
Caption: 'Output', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Error List', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked

=========================
Connections
=========================

=========================
Loaded Assemblies
=========================
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
schemacompare, Version=4.1.17.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.1.17.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/schemacompare.exe
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
Devart.Shell.Interfaces, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.Interfaces.DLL
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
Devart.Shell.Studio, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.Studio.DLL
Devart.Shell.Common, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.Common.DLL
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
Devart.DbForge.Resources, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Resources.DLL
Devart.Shell.Resources, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.Resources.DLL
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
Devart.Shell.IocService, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.IocService.DLL
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
DevExpress.Utils.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/DevExpress.Utils.v13.2.DLL
DevExpress.XtraEditors.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/DevExpress.XtraEditors.v13.2.DLL
Autofac, Version=2.6.1.841, Culture=neutral, PublicKeyToken=09af7300eec23701 2.6.1.841 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Autofac.DLL
DevExpress.Data.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/DevExpress.Data.v13.2.DLL
DevExpress.XtraBars.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/DevExpress.XtraBars.v13.2.DLL
Devart.Shell.Controls, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.Controls.DLL
Devart.Shell.TextEditor, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.TextEditor.DLL
Devart.DbForge.MySql, Version=7.2.70.0, Culture=neutral, PublicKeyToken=09af7300eec23701 7.2.70.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.MySql.DLL
Devart.DbForge.Provider, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Provider.DLL
Devart.DbForge.Utils, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Utils.DLL
Devart.DbForge.Common.MySql, Version=7.2.70.0, Culture=neutral, PublicKeyToken=09af7300eec23701 7.2.70.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Common.MySql.DLL
Devart.DbForge.Data.Interfaces, Version=5.0.19.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.19.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Data.Interfaces.DLL
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
Devart.DbForge.Data.MySql, Version=5.0.231.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.231.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Data.MySql.DLL
Devart.DbForge.CommonServices, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.CommonServices.DLL
Devart.DbForge.Interfaces, Version=4.0.83.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.83.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Interfaces.DLL
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
Devart.Shell.TextEditor.Interfaces, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.TextEditor.Interfaces.DLL
Devart.Studio.Help, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Studio.Help.DLL
DevExpress.XtraGrid.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/DevExpress.XtraGrid.v13.2.DLL
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
Devart.DbForge.Compare.MySql, Version=7.2.70.0, Culture=neutral, PublicKeyToken=09af7300eec23701 7.2.70.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Compare.MySql.DLL
Devart.DbForge.Compare, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Compare.DLL
Devart.DbForge.UI, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.UI.DLL
Devart.Shell.Wizard, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.Wizard.DLL
DevExpress.XtraPrinting.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/DevExpress.XtraPrinting.v13.2.DLL
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
Devart.DbForge.TextComparer, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.TextComparer.DLL
Devart.Shell.TextCompare, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.TextCompare.DLL
Devart.DbForge.LanguageService.MySql, Version=7.2.70.0, Culture=neutral, PublicKeyToken=09af7300eec23701 7.2.70.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.LanguageService.MySql.DLL
Devart.DbForge.LanguageService, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.LanguageService.DLL
Devart.Shell.Compare, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Shell.Compare.DLL
Devart.IoC, Version=2.1.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.20.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.IoC.DLL
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Antlr3.Runtime.DLL
Devart.Ole.UndoManager, Version=1.0.878.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.878.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.Ole.UndoManager.DLL
Devart.DbForge.Resources.MySql, Version=7.2.70.0, Culture=neutral, PublicKeyToken=09af7300eec23701 7.2.70.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.Resources.MySql.DLL
Devart.DbForge.DbObjects, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.DbObjects.DLL
Devart.DbForge.DbObjects.MySql, Version=7.2.70.0, Culture=neutral, PublicKeyToken=09af7300eec23701 7.2.70.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.DbObjects.MySql.DLL
Devart.DbForge.DeclarationRepository.MySql, Version=7.2.70.0, Culture=neutral, PublicKeyToken=09af7300eec23701 7.2.70.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.DeclarationRepository.MySql.DLL
Devart.DbForge.DeclarationRepository, Version=6.1.130.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.1.130.0 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Devart.DbForge.DeclarationRepository.DLL
Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c 1.9.1.8 C:/Program Files/Devart/Compare Bundle for MySQL Trial/dbForge Schema Compare for MySQL/Ionic.Zip.DLL

=========================
System Information
=========================
Processor architecture: amd64
Processor quantity: 8
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz Intel64 Family 6 Model 60 Stepping 3

Total physical memory: 7884Mb
Total available paginal memory: 6645Mb
Process available virtual memory: 134216897Mb
Process private memory size: 90Mb
Display1: 1920x1080, 100% DPI
Display2: 1920x1200, 100% DPI

Operating System Name: Windows 10 Pro
Operating System Version: Microsoft Windows NT 10.0.14393.0
UAC status: Enabled
UAC level: Notify when app try to make changes
Is user in admin group: True
Is run as admin: False
Is process elevated: False
Elevation type: Limited
Integrity level: Medium

Instances: 1
Culture: English (United States)
Process started at 10/01/2017 10:59:15
Report created at 10/01/2017 11:00:10

alexa

Re: Crashing MySQL Schema Compare

Post by alexa » Mon 02 Oct 2017 14:28

Could you please perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Reproduce the issue and send us a *.log file with the latest date from the directory:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Schema Compare for MySQL\
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Post Reply