Get around error Invalid access to memory location.

dkekishdkekish Posts: 7 Bronze 2
in SQL Source Control
I'm suddenly getting Invalid access to memory location. when trying to commit to my local git repository.  Anyone have any ideas?
Tagged:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Hi, thank you for your forum post.

    Is there any further information in the SQL Source Control log file that may provide further information on what maybe generating the error?

    You will find the logs in this path:
    C:\Users\<user name>\AppData\Local\Red Gate\Logs\SQL Source Control

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • dkekishdkekish Posts: 7 Bronze 2
    I see some messages in the log like this

    2023-04-26 06:28:02.391 -04:00|Warning|RedGate.SQLSourceControl.Engine.CompareEngineImpl.CompareLogger|106| Synchronization Warning High::One of the fields [Oracle].[ColumnData].[TSQL_StageColumnInfo] and [Oracle].[ColumnData].[TSQL_StageColumnInfo] are computed - computed columns cannot be compared when one of the data sources is a scripts folder..
    2023-04-26 06:54:05.963 -04:00|Warning|RedGate.SQLSourceControl.Engine.Diff.ObjectExplorerState.DatabaseObjectCollection|20| Object [DatabaseObjectId: Name=pr_RebuildTableScripts, Owner=dbo, ObjectType=Stored Procedure] was in state "New" has changed by "New", that doesn't make sense
    2023-04-26 09:30:34.509 -04:00|Warning|RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy|100| An exception occurred whilst building from a parent; this exception has been given to SSMS for it to handle
    System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
       at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
       at System.Data.SqlClient.SqlDataReader.Read()
       at Microsoft.SqlServer.Management.Smo.DataProvider.ReadInternal()
       at Microsoft.SqlServer.Management.Smo.DataProvider.Read()
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Read(Object[]& values)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(IList`1 targetList, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy.Build(IList`1 nodes, INodeInformation source, INavigableItem parent, IFilterProvider filter)
    ClientConnectionId:980a1e6e-890e-4da9-8c91-ab32a23db622
    Error Number:1222,State:51,Class:16
    2023-04-26 10:01:26.843 -04:00|Warning|RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy|10| An exception occurred whilst building from a parent; this exception has been given to SSMS for it to handle
    System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
       at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
       at System.Data.SqlClient.SqlDataReader.Read()
       at Microsoft.SqlServer.Management.Smo.DataProvider.ReadInternal()
       at Microsoft.SqlServer.Management.Smo.DataProvider.Read()
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Read(Object[]& values)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(IList`1 targetList, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy.Build(IList`1 nodes, INodeInformation source, INavigableItem parent, IFilterProvider filter)
    ClientConnectionId:fbe567c5-fa62-4a84-83f1-e9a11c60b079
    Error Number:1222,State:51,Class:16
    2023-04-26 10:23:39.940 -04:00|Warning|RedGate.SQLSourceControl.Engine.CompareEngineImpl.CompareLogger|133| AddDependencyStack: failed to resolve dependency from [Oracle].[ColumnData]

    The dependency error at the bottom is a long list of dependency issues, all about 1 ms apart.

    The next time I tried to use the plugin, it was all good again, is this possibly an issue on the server that was just not expected?
    · Share on Twitter
  • Jon_KirkwoodJon_Kirkwood Posts: 424 Silver 5
    Hi there, yes it's possibly an initial caching error or some of the dependencies were run out of order to their creation scripts so they errored out.

    Are you still getting errors when re-running the process now?
    Jon Kirkwood | Technical Support Engineer | Redgate Software
    · Share on Twitter
Sign In or Register to comment.