sql/importer: TestExportImportBank failed

[cockroach-teamcity]

sql/importer.TestExportImportBank failed on master @ 3292e23e914f2b5a63e892fef1705ad476be4bd7:

=== RUN   TestExportImportBank
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestExportImportBank3022263666
    test_log_scope.go:81: use -show-logs to present logs inline
    test_server_shim.go:157: automatically injected an external process virtual cluster under test; see comment at top of test_server_shim.go for details.
    exportcsv_test.go:146: -- test log scope end --
test logs left over in: outputs.zip/logTestExportImportBank3022263666
--- FAIL: TestExportImportBank (9.82s)
=== RUN   TestExportImportBank/null=NULL
    exportcsv_test.go:133: error executing query="CREATE TABLE bank2 (\n\t\tid INT PRIMARY KEY,\n\t\tbalance INT,\n\t\tpayload STRING,\n\t\tFAMILY (id, balance, payload)\n\t)" args=[]: pq: relation "defaultdb.public.bank2" already exists
    --- FAIL: TestExportImportBank/null=NULL (0.67s)
=== RUN   TestExportImportBank/null=
    exportcsv_test.go:134: error executing query="IMPORT INTO bank2 CSV DATA ($1) WITH delimiter = '|', nullif = ''" args=["userfile:/t/TestExportImportBank/null=/*"]: pq: result is ambiguous: error=[NotLeaseHolderError] proxy failed, update client information desc: r68:/Tenant/10{-/Table/104/1/10} [(n1,s1):1, (n3,s3):2, (n2,s2):3, next=4, gen=10, sticky=1711523159.405364670,0], lease: repl=(n3,s3):2 seq=3 start=1711519561.447063165,0 exp=1711519567.446765215,0 pro=1711519561.446765215,0, closed_timestamp_policy: LAG_BY_CLUSTER_SETTING != et:desc:r68:/Tenant/10{-/Table/11} [(n1,s1):1, (n3,s3):2, (n2,s2):3, next=4, gen=11, sticky=1711523159.405364670,0], lease:repl=(n3,s3):2 seq=3 start=1711519561.447063165,0 exp=1711519567.446765215,0 pro=1711519561.446765215,0; r68: replica not lease holder; current lease is repl=(n3,s3):2 seq=3 start=1711519561.447063165,0 exp=1711519567.446765215,0 pro=1711519561.446765215,0 [propagate] (last error: key range /Tenant/10/Table/3/1/107/2/1-/Tenant/10/Table/53/1/955020615536803841/"legacy_payload"/1915-10-07T17:53:55.639340999Z/0/NULL outside of bounds of range /Tenant/10-/Tenant/10/Table/11; suggested ranges: [desc: r68:/Tenant/10{-/Table/11} [(n1,s1):1, (n3,s3):2, (n2,s2):3, next=4, gen=11, sticky=1711523159.405364670,0], lease: repl=(n3,s3):2 seq=3 start=1711519561.447063165,0 exp=1711519567.446765215,0 pro=1711519561.446765215,0, closed_timestamp_policy: LAG_BY_CLUSTER_SETTING desc: r108:/Tenant/10/Table/1{1-04/1/10} [(n1,s1):1, (n3,s3):2, (n2,s2):3, next=4, gen=11], lease: repl=(n3,s3):2 seq=3 start=1711519561.447063165,0 exp=1711519567.446765215,0 pro=1711519561.446765215,0, closed_timestamp_policy: LAG_BY_CLUSTER_SETTING])
    --- FAIL: TestExportImportBank/null= (2.41s)

Parameters:

• attempt=1
• run=27
• shard=3

Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-37110

[rytaft]

The second failure looks like a dup of #121098. The first one seems new.

[rytaft]

Looking at the code, it seems like we run the "null=" and "null=NULL" tests on the same database, one after the other. Since the "null=" test failed, we probably didn't successfully drop the table bank2, which is why it already existed for the "null=NULL" test. I'll submit a patch to make this test more reliable.