BUG: DbUpdateConcurrencyException when updating and inserting multiple records — oracle-tech

    Forum Stats

  • 3,716,136 Users
  • 2,242,961 Discussions
  • 7,845,842 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

BUG: DbUpdateConcurrencyException when updating and inserting multiple records

4119029
4119029 Member Posts: 4
edited December 2019 in ODP.NET

When updating and adding multiple rows I am getting a DbConcurrency exception.  Note no table has more than 10 rows in it.  This only occurs when multiple rows are updated AND inserted within the same SaveChanges() operation.

Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: 'Database operation expected to affect 1 row(s) but actually affected 2858 row(s).

The sample code is located here: https://github.com/inferno31/oefc-concurrency-issue

Reproduction instructions here: https://github.com/inferno31/oefc-concurrency-issue/blob/master/WFConcurrencyIssue/Readme.md

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,753 Employee
    edited October 2019

    This bug (30452644) has been reported previously. The Oracle EF Core dev team is working on identifying the root cause and fixing the issue.

  • 4119029
    4119029 Member Posts: 4
    edited October 2019

    Are these defects tracked publicly?  When can we expect a fix?

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,753 Employee
    edited October 2019

    The bug info is public, but requires a My Oracle Support account to access. In general, the DBA has access to a MOS account.

    Currently, we're working on simplifying the test case to remove external dependencies to identify the root cause.

  • 4119029
    4119029 Member Posts: 4
    edited October 2019

    We have an enterprise agreement with Oracle, where can I view these bugs?  Having visibility to them would have saved me 3 days of troubleshooting.  Plus I need to plan my release around these fixes.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,753 Employee
    edited October 2019

    https://support.oracle.com/

    I believe you should be able to sign in with your Oracle account that you use for these forums. However, your account needs to associated with a customer identifier so that you have the privileges to view bugs and can open service requests.

    The bug is not fixed yet. When it is fixed and you need a patch ASAP, you can request a one-off patch. Oracle normally bundles accumulated fixes together every few weeks in a bundled patch. We only create one-off patches for customers needing a specific fix ahead of the next planned bundle patch.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,753 Employee
    edited December 2019

    Bug 30452644 has been fixed and is available in NuGet Gallery as part of ODP.NET EF Core 19.6.

Sign In or Register to comment.