Skip to content

roachtest/sqlsmith: non-nullable column with no value during backfill #73372

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.sqlsmith/setup=rand-tables/setting=default failed with artifacts on release-21.2 @ 66a451b4e8e948925782c3877f49d0777c9db812:

The test failed on branch=release-21.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=rand-tables/setting=default/run_1
	sqlsmith.go:223,sqlsmith.go:256,test_runner.go:777: error: pq: internal error: failed to construct index entries during backfill: Non-nullable column "table2:col2_10" with no value! Index scanned was "primary" with the index key columns (col2_3,col2_5,col2_4,col2_1,col2_2) and the values ('BOX(-0.4617848234054447 0.9693919887931086,1.2249223709052481 1.8834189112191637)',997066855,e'\x7f',1949454573,492325614)
		stmt:
		ALTER TABLE defaultdb.public.table2 ALTER PRIMARY KEY USING COLUMNS (col2_4, col2_1);
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions