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

CONFIG statement cannot be used inside a user transaction. #2185

Closed
seb-urbaniak opened this issue Oct 27, 2018 · 1 comment
Closed

CONFIG statement cannot be used inside a user transaction. #2185

seb-urbaniak opened this issue Oct 27, 2018 · 1 comment

Comments

@seb-urbaniak
Copy link

@seb-urbaniak seb-urbaniak commented Oct 27, 2018

Which version and edition of Flyway are you using?

Flyway Community Edition 5.2.1 by Boxfuse

If this is not the latest version, can you reproduce the issue with the latest one as well?

Latest.

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

flyway.cmd

Which database are you using (type & version)?

Microsoft SQL Server Enterprise 64-bit (v14.0.3045.24)

Which operating system are you using?

Microsoft Windows 10 Enterprise 64bit (v10.0.17134)

What did you do?

Trying to do:
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

in my beforeMigrate.sql callback

What did you expect to see?

Clean execution.

What did you see instead?

ERROR: Error while executing beforeMigrate callback:
Migration beforeMigrate.sql failed
SQL State : S0000
Error Code : 574
Message : CONFIG statement cannot be used inside a user transaction.

(this is very likely related to the fix of: #2175)

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Oct 27, 2018

Argh! That is indeed an unfortunate regression. Will be fixed in the next patch release.

axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Oct 27, 2018
dohrayme pushed a commit to dohrayme/flyway that referenced this issue Feb 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.