Navigation Menu

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Timeout when creating Stored Procedure containing linked server (SQL Server 2019) #610

Closed
dbruk9 opened this issue Apr 4, 2022 · 2 comments
Closed

Timeout when creating Stored Procedure containing linked server (SQL Server 2019) #610

dbruk9 opened this issue Apr 4, 2022 · 2 comments
Labels
dbup-sqlserver Issue or pull request regarding dbup-sqlserver project question Developer asks to help him deal with some problem

Comments

@dbruk9
Copy link
Contributor

dbruk9 commented Apr 4, 2022 •
edited

When I have builder.WithTransactionPerScript() , executing scripts that create stored procedures time out. The same scripts run fine in SQL Server Management Studio.
If I set builder to builder.WithoutTransaction(), it executes without any issues.
I've tried debugging with DbUp source but I don't see anything specific stand out that would cause this. Any thoughts?

I am using SQL Server and DbUp v4.5.0.
@dbruk9 dbruk9 added the bug Something isn't working label Apr 4, 2022
@shishank-jain
Copy link

shishank-jain commented Apr 25, 2022 •
edited

Try using .WithExecutionTimeout(TimeSpan.FromSeconds(300)) with TransactionPerScript()

@sungam3r sungam3r added question Developer asks to help him deal with some problem dbup-sqlserver Issue or pull request regarding dbup-sqlserver project and removed bug Something isn't working labels Aug 21, 2023
@sungam3r
Copy link
Member

Closed due inactivity.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
dbup-sqlserver Issue or pull request regarding dbup-sqlserver project question Developer asks to help him deal with some problem
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@dbruk9 @sungam3r @shishank-jain