Skip to content

Bulk insert issue with GUID primary key #86

Description

@SivaTR

I got below error when try to insert multiple values.

I am using postgresql , For primary key am using gen_random_uuid().

Npgsql.PostgresException
HResult=0x80004005
Message=23505: duplicate key value violates unique constraint "test_pkey"

DETAIL: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
Source=Npgsql
StackTrace:
at Npgsql.Internal.NpgsqlConnector.d__233.MoveNext()
at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateMachineBox1.System.Threading.Tasks.Sources.IValueTaskSource.GetResult(Int16 token)
at Npgsql.NpgsqlDataReader.d__52.MoveNext()
at Npgsql.NpgsqlDataReader.d__52.MoveNext()
at Npgsql.NpgsqlDataReader.NextResult()
at Npgsql.NpgsqlCommand.d__119.MoveNext()
at Npgsql.NpgsqlCommand.d__119.MoveNext()
at System.Threading.Tasks.ValueTask1.get_Result() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Npgsql.Bulk.NpgsqlBulkUploader.InsertPortion[T](IEnumerable1 list, List1 insertParts, NpgsqlConnection conn, NpgsqlBulkCodeBuilder1 codeBuilder, String tempTableName, EntityInfo entityInfo, InsertConflictAction onConflict)
at Npgsql.Bulk.NpgsqlBulkUploader.Insert[T](IEnumerable1 entities, InsertConflictAction onConflict) at Npgsql.Bulk.NpgsqlBulkUploader.Insert[T](IEnumerable1 entities)
at TestBulkInsert.SqlBulkHandler.Insert[T](IEnumerable`1 entities) in C:\Users\TestBulkInsert\TestBulkInsert\SqlBulkHandler.cs:line 19
at Program.

$(String[] args) in C:\Users\TestBulkInsert\TestBulkInsert\Program.cs:line 125

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions