Allow snapshot isolation to be used for the outbox #2206
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 |
|