Skip to content

Allow snapshot isolation to be used for the outbox #2206

Allow snapshot isolation to be used for the outbox

Allow snapshot isolation to be used for the outbox #2206

Triggered via pull request December 4, 2024 08:44
Status Failure
Total duration 14m 17s
Artifacts 1

ci.yml

on: pull_request
Matrix: build
Fit to window
Zoom out
Zoom in

Annotations

12 errors
Windows-PostgreSql
Error: The process 'C:\Program Files\PowerShell\7\pwsh.exe' failed with exit code 1
Windows-Oracle
Error: The process 'C:\Program Files\PowerShell\7\pwsh.exe' failed with exit code 1
Should_clear_operations_on_dispatched_messages: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Outbox/OutboxStorageTests.cs#L74
System.Exception : Failed to ExecuteNonQuery. CommandText: insert into [dbo].[PersistenceTests_OutboxData] ( MessageId, Operations, PersistenceVersion ) values ( @messageid, @operations, @PersistenceVersion ) ----> Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_find_existing_outbox_data: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Outbox/OutboxStorageTests.cs#L44
System.Exception : Failed to ExecuteNonQuery. CommandText: insert into [dbo].[PersistenceTests_OutboxData] ( MessageId, Operations, PersistenceVersion ) values ( @messageid, @operations, @PersistenceVersion ) ----> Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_not_store_when_transaction_not_committed: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Outbox/OutboxStorageTests.cs#L129
System.Exception : Failed to ExecuteNonQuery. CommandText: insert into [dbo].[PersistenceTests_OutboxData] ( MessageId, Operations, PersistenceVersion ) values ( @messageid, @operations, @PersistenceVersion ) ----> Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_store_when_transaction_committed: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Outbox/OutboxStorageTests.cs#L152
System.Exception : Failed to ExecuteNonQuery. CommandText: insert into [dbo].[PersistenceTests_OutboxData] ( MessageId, Operations, PersistenceVersion ) values ( @messageid, @operations, @PersistenceVersion ) ----> Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_throw_if_trying_to_insert_same_messageid: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Outbox/OutboxStorageTests.cs#L100
System.Exception : Failed to ExecuteNonQuery. CommandText: insert into [dbo].[PersistenceTests_OutboxData] ( MessageId, Operations, PersistenceVersion ) values ( @messageid, @operations, @PersistenceVersion ) ----> Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_create_new_sagas_when_committed: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Sagas/When_multiple_sagas_in_outbox_transaction.cs#L25
Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_not_create_new_sagas_when_not_committed: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Sagas/When_multiple_sagas_in_outbox_transaction.cs#L73
Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_not_update_existing_sagas_when_not_committed: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Sagas/When_multiple_sagas_in_outbox_transaction.cs#L172
Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Should_update_existing_sagas_when_committed: _1/nservicebus.persistencetests.sources/9.2.2/contentFiles/cs/net8.0/NSB.PersistenceTests/Sagas/When_multiple_sagas_in_outbox_transaction.cs#L122
Microsoft.Data.SqlClient.SqlException : Snapshot isolation transaction failed accessing database 'nservicebus' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 16.00.1000 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 3952 HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink HelpLink.LinkId: 20476
Windows-SqlServer
Exit code = 1

Artifacts

Produced during runtime
Name Size
NuGet packages Expired
970 KB