Skip to content

workload: executing "workload run tpcc --init" fails with "failed insert into warehouse: pq: there is no unique or exclusion constraint matching the ON CONFLICT specification" #27981

@HeikoOnnebrink

Description

@HeikoOnnebrink

BUG REPORT

Please describe the issue you observed:

  • What did you do?
    ./workload run tpcc "postgres://root@1.2.3.4:26257/tpcc?sslmode=verify-full&sslrootcert=/home/core/cert/ca.crt&sslcert=/home/core/cert/client.root.crt&sslkey=/home/core/cert/client.root.key" --warehouses=100 --drop --init

  • What did you expect to see?
    init db with tpcc data

  • What did you see instead?
    Error: failed insert into warehouse: pq: there is no unique or exclusion constraint matching the ON CONFLICT specification
    problem occurred with https://edge-binaries.cockroachdb.com/cockroach/workload.LATEST from 2018/07/24.
    Reverting back to older bin worked fine.
    Unfortunately workload does not expose version info (suggest to add -v switch for making support easier)

Metadata

Metadata

Assignees

Labels

A-testingTesting tools and infrastructureC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the community

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions