Skip to content

BCP intermittent error babelfish_view_def_pkey #13

@staticlibs

Description

@staticlibs

BCP import error happens intermittently with the following messages in log:

2024-03-23 15:18:56.590 GMT [2424] ERROR:  duplicate key value violates unique constraint "babelfish_view_def_pkey"
2024-03-23 15:18:56.590 GMT [2424] DETAIL:  Key (dbid, schema_name, object_name)=(5, dbo, sp_describe_first_result_set_view_41) already exists.
2024-03-23 15:18:56.590 GMT [2424] CONTEXT:  SQL statement "CREATE VIEW sp_describe_first_result_set_view_41 as select * from adventureworks2019.Sales.SalesOrderDetail"
	PL/tsql function sp_describe_first_result_set(nvarchar,nvarchar,tinyint) line 3 at SQL statement
	SQL statement "EXEC sp_describe_first_result_set @p1"
	PL/tsql function inline_code_block line 1 at EXEC

Cannot reliably reproduce this, problem happens only on Windows.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingwindowsIssue is specific to Windows

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions