sql/importer: TestExportImportBank failed

[cockroach-teamcity]

sql/importer.TestExportImportBank failed with artifacts on master @ 9b43dc50d468171bc9919dc684b7274b63e13da2:

        52, 0, NULL
        53, 0, initial-whOANTOJQVUutFxlDtlMKQuqbqYQPmJFNsZvbUgAWHGrTMLVDqATjPpHuLptNytSmiwyiGLGqHxDYcbMHOyQOUJWiAFQ
        54, 0, NULL
        55, 0, initial-SeOsPYfVUQYgtTIybfyNXRRRumxPIxBRSkQwiJnmHoPSNJpLWRiiIlabPVpOIbYUsMwVPrVzYMOmlmzEudqpHxWWBwAi
        56, 0, NULL
        57, 0, initial-RzeEMTvfaOsHwDXzUAxAVbNxoLHTeuIesEQcplVsSENRUoCJpZXrmUcndPLqlZpxbBJLsQpAYgPmuZXirwwgrkdFfoEs
        58, 0, NULL
        59, 0, initial-hDwojdiFkKHeKUTgrIwmCPEgDxfhtnKcpsSXkyTCYhjvAZZEhuxhytNGEyBRUFDcCufrIHkdRHkqlPLzXgSJEpjsGxKe
        60, 0, NULL
        61, 0, initial-dUduOKwKufttrJydZOyEXkOwYNtdOQdokXOlincZpmoUYRiEzpZaJTlZrBfvNopMQTjvlkGfVcCADYYuzGLhoXdLUyre
        62, 0, NULL
        63, 0, initial-loZRUzzumfhPpUhNCsPgdGeRCEcJjHmYdtljHQUGMRHkLSIpEYINoQBcUodussmAXPNRxlbEIdthbYxFdaCsPDEjGowb
        64, 0, NULL
        65, 0, initial-XZZNjhSQoEDlJUdDrDhKLbWIhMYtmnMsibxAIstEfMYohFVVmbnIORFTKAAxyIPuTeUsnIPTnsExtJbvlatmvzfIiPcI
        66, 0, NULL
        67, 0, initial-mpylUUPGxZVrGBJPzJzJURvLFJpBgVFEknlDPTjwUeGaOWxgSZIiMpXyjayFYpvjdQTcizZpeiGAcfgLEpnAriptgWfm
        68, 0, NULL
        69, 0, initial-ulOpdIWRbmiUuPAKTQboHllqVsGJrhTbZJQLgbSPhFbmWIyFvdXHxYvWrWZrQFcQNsYVAekuEejiIJFrVllwyuYdfHFT
        70, 0, NULL
        71, 0, initial-edLblpGhUiAawxVUIJNUEJtPOYVdeyAXhZIHjtHhTmsQMDmZqPXLQQCSNbgERLWxIXeHrigIKetOBSXpYDkTebiouRYa
        72, 0, NULL
        73, 0, initial-giPlrNwRfGQPmPppDiGNGTPzRZWFBboEmpYCOoWhVCwzXhIXoXeeFqnbiJBmzddHpCHYgCXKRlPYkUOlxzfnqHJrnrES
        74, 0, NULL
        75, 0, initial-vpVYfSgECWZDThuhAOjvMpROFshpoHJrrwfEFxONAYaNBGpFlItELoYfaAKUDHrKVtkVavvAeOHyfluuedANyJRdboRo
        76, 0, NULL
        77, 0, initial-elDuzxiHIEpBFxvZVwROVJlsVVTjNeAciMtQhCiWThBaHuFpOaevPkmPlfeXwerYNJQoHyDFnJuJtFDPGFfgtPOKBwcs
        78, 0, NULL
        79, 0, initial-RkoVmRhkTWuSmBGMVpxKVhClWxgDjBntqiUnFIyKtdxmGpGxiCLUVNevexpaaBbLnfMwiBlcykTWFSIPeUXVilVlDGQi
        80, 0, NULL
        81, 0, initial-vqimCJKePpLeHnNGixUoTJDfDAxzrSWILWDmQuyUkgaxBZfHMfrePeIZQGiKVgQQJvTFupysyZzZkwnaGojkNeuXceuh
        82, 0, NULL
        83, 0, initial-XmUpUuCZMfVpjzWJLWyOXIldBgYkyUvvonDkAjUVyoVuIppUSgVxeLHQStRKDNPBNIEzffkoTraGCvsLxOcGgIhEEUqj
        84, 0, NULL
        85, 0, initial-oCsZYEIlulbQNKtJlSHUOWLVusRJkKZJDvLNojCxUHwBlFADWCNrwmKlPSCdHXVZaIEgmgHfnacwlJznXbIcfVMTMbGW
        86, 0, NULL
        87, 0, initial-wjYgSkXxgaLPAGucqOXCZEnzcCcAXlIeuYomSSKLBNPMrtEDIZQUPaaSgCPaALkobblNGwBeJuCUkTaSTSkRIfOfeCGs
        88, 0, NULL
        89, 0, initial-pMUePDQPbKnPOFUAWggwidYedTPlJRUBlpgjRfYMsApEQTOgFkYRtZoiYqQZvTgrgujRNfeyoxhefuEYbjBAqKMKoSYU
        90, 0, NULL
        91, 0, initial-PItCzGwrwPrtdCrmWcReBjpXtObegdWaPQnqvQBqqKYYTVeLiODhlBXlBIFiLpDZPbrcAhDNPkSamKpHMwxikhdFySPU
        92, 0, NULL
        93, 0, initial-SBPeoIgiCtQaLtnmnKMDlWMmcOTgGlkZkiWxDbmPPbyJiCREurZdqWHZCTkSlUYTRYBHwkBucEkXOgZGSibbsgsfVBaN
        94, 0, NULL
        95, 0, initial-YjvQLgPpUJqiefoBMSUBQVWplreswHAlSitYUGXRKLrAIuoRIIzjWEQLtvBDlshdQIxoFPvlCRsbbgxtmASfUvExHQfg
        96, 0, NULL
        97, 0, initial-bKQsKVzjwCFTwJVXQppQixvYyUDeVIkCoNKzHIJQRvfJhDrOKWEnyzckfXCSdePCOkzKBfrQBIpCHJcKPhTPzVSYsXAA
        98, 0, NULL
        99, 0, initial-lUftKcoKfaGecVlunDSiKthvhVkhoeJwFgwDQgLNOibcWAcPxZMepcheoAmhSPhIKVzTsoLueVrJeHTHlOBhXklkdNnD
        
    --- FAIL: TestExportImportBank/null=NULL (4.28s)

Parameters: TAGS=bazel,gss,race

Help

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

Same failure on other branches

• sql/importer: TestExportImportBank failed #79420 sql/importer: TestExportImportBank failed [C-test-failure O-robot T-disaster-recovery branch-release-22.1]

/cc @cockroachdb/sql-sessions

This test on roachdash | Improve this report!

Jira issue: CRDB-25430

[rafiss]

The output is hard to read. The difference there is that the actual results should have had these rows, but did not:

        23, 0, initial-DUJWucQNdznFiBCdtRxVNFwEZPiCPDCmbfmZsAsoqeWdarZUknLOydTTwuEzjtoPkfspERwWEsQqkZSlGYZJnVmImTSo
        24, 0, NULL
        25, 0, initial-qFEqrQhkxmZRNyydpdXvSGkAgpcuIbhlxNfEtgAUzBYuOImsFpwvZCJJmnpqoVvqLTgaKmyrntVfdznyAhGyQlgkznpO
        26, 0, NULL
        27, 0, initial-eDGxgGooeqVIJkNsGMZIptKNdmnkdIcPuEShaByhqCEdBwHQiMwmMDLscnMmJVBANpvlSmtsVSxHPcVCIXWrNMqslKFV
        28, 0, NULL
        29, 0, initial-XmlOnMufzawBRrzaLFcQidiQcnZlUsTiozQkHgjHeYyXxUHhmkMgDljjdViBcparhSXvHNwPDpnPRkHWkbMMhKdRJpdO

[cockroach-teamcity]

sql/importer.TestExportImportBank failed with artifacts on master @ a65bca232dfde1862e5aff343e7b1f3a379d6cd6:

        52, 0, NULL
        53, 0, TNdafaUZrpaflNaNhTpHrwWkEEBaFlrVIoykdVkZOyPioCscYzwOeTxIpVCgxQWozooLVKFwRAmugtUVQPYXTChvNQCcWCrrNged
        54, 0, NULL
        55, 0, TiBprowCLIMDONqrhBcTSLfcoFLHWYCfMNwkTteQrJAfjqsilUMGBQVXnsomtHvupAJEcPLfjnmXavdumkJxmKBcHAcDhcylhWfC
        56, 0, NULL
        57, 0, kMPSlfzmtMvQNZNYUYtQqRHuyreGPXWCmYAtXjibQkdKszUkHSSmecEcejLlgFrNGndGEWMJvePudJRmpCINeFTCVXcTYfEKfbmu
        58, 0, NULL
        59, 0, xdvLoZWqqtsqDsSEUWDzKJbXewyZhnRrjaTyHvFlyZyracoqwmwOKodZecEcxJhyXUlRWBEUpaUyKrBnDJzXXTDUHoDvyLYfCKuj
        60, 0, NULL
        61, 0, UNwtENXlWsbAiTeihfhxzTqfkRBakOYsbSZCjvgnTKdJwzdenRKeddDlpAJzUbdQEuFYIKmBaJRYnaKqLySNYZWDXSZrnOvjshzZ
        62, 0, NULL
        63, 0, wilYntMLXZOnkyJDhIPRzGljmWeYZwcsWqtHPKeKWUCZoOcTNhPGjtnYPPeaIPuWRrSzCThfWGwtchRZqORcdOxwykrPoKwrjOYw
        64, 0, NULL
        65, 0, calgTDKfRmkDNPBKyQSqpBZaMplnVNdqwHVnwtEFtVbdDgWOiEBcCHSIhwUIFyMyMSVLCHjxKgPXXIymWiOhApSozwGHpuMFQpSP
        66, 0, NULL
        67, 0, EUZUWhTGIRfHjHWbHNoMHupBToIpjKYIQbgiGiTnwPTTtuDRVbMjjNfzccybtTxsKrvLJlwgiXoCzvskXIyJBmnLildcRUAxRKoz
        68, 0, NULL
        69, 0, lUOhWeqftudqRXUbnvCGnRcDLgFhyVpwTYmBMYSItGvgGyXdVGlfDNeyvHMhsJvfMTUJJlkmSvZwutSPMgvHpOIxmSWhvgezUHST
        70, 0, NULL
        71, 0, utrFkdhmjWWnhdZckRNLBHZyvCctSDLcedTFbKbXUEVyWlfIKWyNwSpsnpMwmgufgwMXyAAnjmbhhXYfUEBbNvivqByZDGZxHzcV
        72, 0, NULL
        73, 0, iLmwrzVwXfuNeRLEYWAxbfksYbvkdJRDvPSxJkpzYETGebOmYjplqrqFtEmyXThuGkAvSXyFozAoLhWFIYKOmUackBdrySEOsAle
        74, 0, NULL
        75, 0, YYuQJnVkiUUzclQDpoVzfgfbpReUKXkFPalKOcGWBPtxmHPHBfDFwHZgWVeDmXFRhrOXxLLGPMofjaUFFBXvszAJDUYGjpYWQgFr
        76, 0, NULL
        77, 0, UpKiKilXhCOEvSSzmHWmbQmiTdGyLRTauhEUMlddIAoiRcObHWrVlXHaUXPgudBacNvdNixEvJDDDCbnyAjVnIixAufwXnqkqPUq
        78, 0, NULL
        79, 0, VCovdctSRJkHRjYyyUCChdTdUSCebsvhxCrlHsDUvsWvkjrNDCMLXOYKyuttxvrxPFrkDaYqWJwljYqYtyChFzEvfDIINQxNuEfJ
        80, 0, NULL
        81, 0, EtnqPGVmABLVLWuwAWkASpmenczdccfgvZZoFhYVJQnaLsybkKXkRKhDWhHFjEZNDmxMbPKmUGqZQWCHOaRwWFwxNHKeqpXFSCiL
        82, 0, NULL
        83, 0, LSyFVJCSKUgUBCgpmfZzsYjJzpateLCeIxqEXThYAPqLAaJFpZkvUgrjtarsBcRUWCkIesgKTDaxPswRuorwiddhrLGrCWglEZUD
        84, 0, NULL
        85, 0, QePmrJnmnxTGwlpjZyPrrSHFmePXFSQhDlYwBMmfVdgavVAvTYBAyUgoSWzlnOFKTmjXuKiKXfVFavkYwKAmsAJvJiKVdEqICMjS
        86, 0, NULL
        87, 0, isWDBVGaxVqwIXyzwKqqKYEZRfFNDLJTkHyEMaYnBYZfRkSXyVinUevTwfTJfTPyAQbQIMUBxMCVDSEJMjrkSdjErVMtaMXuNyfx
        88, 0, NULL
        89, 0, eerBkvfZEHvuKLOLsJLVmXWumZtazwXQgPjXhreFPpcYFJtUIjRJwltKDZMxNGUBHWoQrNIZjmOAljjtJuQfMYjcpQcaIUVRpHpL
        90, 0, NULL
        91, 0, kSFqkatDaYnOnzJEBqOMKjHYcfYOnOGUsMzxEdXGyAznArbYxxohMDDggGpIxRcFcymmpucGGnkOwSfNesClacPRHCRiBQCYrZmY
        92, 0, NULL
        93, 0, ZEBXMPAwQCczbmWkLrbwDCcObOijkpJcVWjVqZXnvOYDASQxZYrybvxEhvJAXvaEfTcGSSoXwGrpywuumXGUWSqbKMBJRcReCnHb
        94, 0, NULL
        95, 0, JqQNlqTPHbToDSxuySYMfjPdUxHqAbVLZXgTMOZmELfSngZFwoeNxLjwnkrfKCAXmgHPnHuGRigqXYiUXKCGOTufRGveXVLoPIDx
        96, 0, NULL
        97, 0, dbkPFUoxoXbGTBvkprMfEluriFEPzZaIsWEgDEgUBGYiPgSrOoSHXCGDtHuxpFOYhSsTZhDMBotwdfcDQmUAlqNzLGMKfssXqjcP
        98, 0, NULL
        99, 0, crbcmKadxAySAGTUXLgqeHcwvlTBXvFEkGELyMQvmqQpXjeaWPHmGVIYbxDXFNhhsNAEACngBIEDfIjYmEmetCKOLpSJkkCKnXvQ
        
    --- FAIL: TestExportImportBank/null=NULL (4.38s)

Parameters: TAGS=bazel,gss,race

Help

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

This test on roachdash | Improve this report!

[msirek]

Ran this under stress for an hour and a half, without error:
dev test pkg/sql/importer --filter=TestExportImportBank --ignore-cache --stress

[cucaroach]

The missing data errors smell like something I saw in #102839

[cucaroach]

I bet what happened here is that the import hit a transient retryable KV error and we hit:

#108547

Once that fix lands I'll close this as a dupe.

[cucaroach]

Dupe of #108547