Bug: Exception "A transaction is already in progress; nested/concurrent transactions aren't supported." when using TransactionScope with PostgreSQL bulk operations about repodb HOT 9 CLOSED

You are not annoying us, FYI. We are happy and glad that you keep pushing for follow-ups, and please continue to do so. 💯

We can release a alpha (not beta) of the next version since I know there is still a pending bug on the MySql extension after some refactoring. We can do it before EOD of CET.

Would that work for you?

from repodb.

By the way, it does not mean it is not fully tested, it is then on low-quality. Our >10K Unit and Integration Tests are passing on that latest release, so the quality are there. But, we are not giving a guarantee as it is not yet a full official release of that version.

from repodb.

Hello again!!!

I was faced another problem related with this.

In some database operations in my code, I use a explict transaction, passing it to the bulk insert operation inside RepoDb.

The same error was thrown, so I looked inside NpsqlWrapper and found and mislogic in the condition to check if we already have a transaction.

var hasTransaction = (transaction == null || Transaction.Current != null);

If we use a explicit transaction, the logic is falsy, because the variable must NOT be null so that hasTransaction get to be true. This cause the code to start another transaction with one already existing in the connection throwing the error.

I would love to contribute with another PR to fix this issue!

Library Version:

Example: RepoDb v1.13.1 and RepoDb.PostgreSql v1.13.1 and RepoDb.PostgreSql.BulkOperations v1.13.1

from repodb.

Closing this issue. Currently, RepoDB has some pending changes on its extension library which still limit me to push a new beta release on main package. When do you think you need a new pack for this?

from repodb.

When do you think it would be possible to release a beta version? It would be great to have a new version as soon as possible, but I can try to use it building locally for now...

If I build and use the release from the master branch, would I have any problems with new code that it's not ready for a beta version, like you said?

Thanks so much for the reply!

from repodb.

When do you think it would be possible to release a beta version? It would be great to have a new version as soon as possible, but I can try to use it building locally for now...

If I build and use the release from the master branch, would I have any problems with new code that it's not ready for a beta version, like you said?

Thanks so much for the reply!

Hey @mikependon ,

Just wanted to drop a quick message to see if there are any updates on this issue. I'm sorry if I'm being annoying! Just wanted a tip to see what can I do with my project :)

Cheers

from repodb.

You are not annoying us, FYI. We are happy and glad that you keep pushing for follow-ups, and please continue to do so. 💯

We can release a alpha (not beta) of the next version since I know there is still a pending bug on the MySql extension after some refactoring. We can do it before EOD of CET.

Would that work for you?

It would be very nice!

Will I be able to download it from nuget itself or should I get it from the website instead?

Thank you!

from repodb.

The alpha versions is now available including the extended libraries. It has all the latest changes/PRs, including yours. They are not fully tested yet.

Install-Package RepoDb.SqlServer -Version 1.13.1-alpha1

Please feel free to revert if you have questions and thanks!

from repodb.

Thank you very much!

Just got it here! Gonna test my use cases here!

Closing the issue!

from repodb.