roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on release-21.1 @ a69afba088b83f3375f72def0e8a2d59c50233ed:

The test failed on branch=release-21.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:205,sqlsmith.go:236,test_runner.go:733: error: pq: internal error: unable to vectorize execution plan: '14:50:45.460818+271674:45:36':::TIMETZ IN ('18:38:43.002095-08:39:00':::TIMETZ, '18:35:43.001673+04:25:00':::TIMETZ, '19:41:53.975915+02:56:00':::TIMETZ, current_time("$2"):::TIMETZ): unsupported comparison operator: '14:50:45.460818+271674:45:36':::TIMETZ IN ('18:38:43.002095-08:39:00':::TIMETZ, '18:35:43.001673+04:25:00':::TIMETZ, '19:41:53.975915+02:56:00':::TIMETZ, current_time("$2"):::TIMETZ): could not parse "1970-01-01 14:50:45.460818+271674:45:36" as TimeTZ
		stmt:
		SELECT
			tab_6174.col1_12 AS col_14125,
			'0107000000080000000104000000040000000101000000FAA177CBE450E0C1444C252B8F15E0C1010100000086913CFDED4AF3C180A468FA07F4F3410101000000A23573CC706AF6C1FC90343D3014F941010100000026603EEE969BF841C2415EB0313802420106000000040000000103000000010000000C00000090CA00769B0CF7C1302EEF9E3B89CEC1846A6A58D374F2C1D4A1FA0C1705EAC1004593EA8A1B95C170353167E1AFF4C1A0A2068710ABC0C18E3ED6E10C5DE6C18056A2B433CECC411C56735123D5EAC120F08D2F521FDC41708C81DACC43C5412A1E7E6631E0F44158547566147FFE410609F7761746EDC16CDEBC081BFC0042B83671C479D0ECC1B45538A36ED4FA416C62A545E84BEAC17C2B89B34F76E641AE9C7478878EF5C196C094DF1D19F04190CA00769B0CF7C1302EEF9E3B89CEC101030000000100000008000000B83512BD3450FDC152C63775D504F6C1C31FC4EEC227FAC19C0189DB8C0300C24000F9568E73B0C18071451B9790BE41503513B2D20AFD4158B5A7B35844FB417C2CB6057EC0F84190D9B975A9B0F841C062D26B1CFEA7C176506EC6A870F3416832C18C17CEFEC172DCC5CF7EC3F641B83512BD3450FDC152C63775D504F6C101030000000100000005000000AA7F1E5BD86AFCC18016DCB0608CD1C1487D8290C88DE9C1100A98286B7AD5C140C3AB6FBFD8ABC1007A14BF16A0B341754D1C6040EC00C2BC9AFABEE986F941AA7F1E5BD86AFCC18016DCB0608CD1C101030000000100000007000000561D853A88CBF9C13A9864811F40F1C1683D8A12BD98F041B6924700B31DE3C1B2002E464454024244C822A14ADAE8C1E4AD2D12399FFD411C7AEE4D6CC1FB4140793364D582C6C10C1A1A66E313F541B999768783A8FAC19C9D0DFC2761F441561D853A88CBF9C13A9864811F40F1C1010100000066D7436F11A0024260891108D250FEC10105000000090000000102000000050000005DDEB21A630DFBC12096FCBCC9E9DB417803B1D32C39D14120AFD8E74948C841B038EA08F996D841D04D7A84A322C2C15A27372C3CD80042200C6A19908EF3C154A9E48854A9FB41BC8541E33841D9C101020000000400000042FD193E4D12FEC12C5E2B96EC2E00C217888CEFCC8BFAC122E7350FD38BFAC1C5FDDBEA617AF2C11C6427E473EBF0C19C90D418F20BE1C1245BD92C9DB101C201020000000300000084402CBB8E7E024292F55A10C181F04114AE6CF43EA0F0C1D230901121E400425D6DDF92924101C2F00E4B2C7928F341010200000002000000F07884A0840BE641A079111FEBE9E0C1AD22042F92DEF1C102C91CD812890242010200000006000000CB6B5A42F9A8FAC1409A12E24A45BBC159D08C8944F701C2FFA82161420EFBC110F60F9A4844CFC1315B7F68A00EF8C1E8FFEA7885EDE541E0969ACE4C33CBC1CC655011EEA8E841489242717400D4416CFB2F4787E5E5C14C4588AD3920FE41010200000004000000802616094BFEF6C1300D47E24131C5C1DB5148B46F31F5C1A0B7FD1C3FFEEAC132A6ABA4D974E9C141451D7B219E00C2588A2C368529E241B4C4FCEFECDBD8C1010200000002000000162157E67EF7E4C1B468794216DAF641669BDEEE60A9EBC184C208D4449AFC41010200000003000000BA81BFA66F51E9C140B08AAA7B050242963E8A968FE6E2C1940D11C89BFCE741E6E71813A6D1F5C17CB0B4D099350042010200000004000000C0DDCB4DC1E9DF41142C40B838FCE841D4A7F3268D11DDC1309E10752F24EA412C967C516662F4C14833D0E28E31EE414E55424EFEB3F4C17C110DA69EB4E8410106000000080000000103000000010000000B000000F74FED69D82D02C2F7C424EAB53BF7C1195392B64A6802C2D37876E387DAFDC18898BE89FB62DF4168BBA56777A5F7C1520290208831F2418C158CDE1CB3F5C1D454024E6182F441605F950C512CE741880CA374DB74E941700FDCE8A158EC4148889EB3A772DC41261337B30931F141A2A7F6C59D77E6C1785653EC68C400427BA704415860F3C14A905144BD49FA41AD5CC99A347402C2F0897A7BF98FC641F74FED69D82D02C2F7C424EAB53BF7C1010300000001000000080000006BBE368F32DBF2C1F4D4E5B6EA99E3C19071ADF333C2CE4130B3EA81B334C5C1ACD940AD4BDDFA412C43F45E1C7EE441EC0E414B1A0FF1416CCA325266FFE841502251E73CFBDE414C382084B6ABF8412C53FEC36C37EEC1D20FE498E1D9F0411D95891E52D2FEC126DEAFBFB0CFF6416BBE368F32DBF2C1F4D4E5B6EA99E3C10103000000010000000D0000008135A80C8C9A01C2B0BB261CAC8AC6C11852B6E3F68AD1C17A022C5A6F87F4C14827417EC658F34134B83C95138BFAC1DCCBAE635878FE414712A060DF8B01C2B0FDEBD51A2AFF41B294B0ADA8BAE4C1EC05674EF0E8FB410037F7427DBCB041AC68980DB5F9ED41685EA0DEC272D94124CE18701947EE41DC5CCC876C5EE841D02803515A25C2C1663869AC6B5A02420032C24627F7D3C12412160F1E84FF41281227FD084ADDC10EB8AAAF8D5202426363256D2703F0C1301050DB6AC5F0418135A80C8C9A01C2B0BB261CAC8AC6C101030000000100000007000000C0975ACAF534A0C1F8BB7CCA5D4AD0410C0B4E12AD92D8C164D0FBAFF15601C2A0F8BBAFC17AD241BA393767E7ADEFC13892A55DE301E341F477154633BBE341A80F285325BBE241B8240A0B6755024240263D6C98C9D941C45AAA0FB8200242C0975ACAF534A0C1F8BB7CCA5D4AD0410103000000010000000A00000098F80D396422E1C1C6993A1C6887EFC130C58913944EEFC179C1D2258EBFF4C168BA0B8FE83FF2413E01B56409AEFEC136B90673CAE9F9411690F8DAD543FBC13451D0D974FEE841C84BB8F7A905F1C1D2A46E15143E01425957D83FC164F4C1F47B7967A9C6E441E08784591644C8C1CC1A973CFA7A01C298D591FCE9A7D241B13A7C5A05EEF9C120993E37726EE0C198F80D396422E1C1C6993A1C6887EFC10103000000010000000B00000073AA31C9B92102C226AEFEA3E2FDF9C1B96614A33833F6C14847647F64FEF1C19E230F8CFE3AE9C192487CCD8D76FFC188C8B282B489F7414DB247D0BF35F7C1E639AA787838F841656E538A68B1F0C17ABC1E0156F5F44100A73BDB571A8B412894A1186B18ED41105D71A7D6ADEE4140B604A17DE4E941ACBEEB7B381DFC41A053FF10315CDC41FE5D2304CCE201422654119E5829ECC158179C63EAA4DF4173AA31C9B92102C226AEFEA3E2FDF9C101030000000100000008000000FCA696062D62E9C1F5B2F3096799F9C100399D75B36DD6417BE928B7822E00C2BE6B805842B10142CF5131A0FF5402C22E1C22B6534BF441CECEEFD9FD1BE5C11A70EA207995F441FA941DC3914CF54198F8A5EA8461F14168563D8AE868FE416033D8D7949FD54180C23FCF7EFE9FC1FCA696062D62E9C1F5B2F3096799F9C10103000000010000000A000000620368771B04EBC1808D3A0D7AA9A141E8282714E46DDEC1645DFBDFDACDD6C1B59EE31E601FF2C18031AC487C2CFDC14AF5C9CE5C44F7414C034A0BF06BE1C15834EB32EDBDF441DEC569AE3651F0417A45ADD418C9F3411C1EB617D983F441C03D36EDDC45A5415C5C2DDAA43AFD41C0FDEEF6F3F5CAC198A82316142DE14169391309892402C20C3B05F6E678F141620368771B04EBC1808D3A0D7AA9A1410103000000010000000B000000248539C57723F9C1FCDDA1ADAB7FE2C15ADBF8577878FDC1F4BFF9294951E9C1C40A728C7910F8C1978D5DA4B18FF1C1B090D75F255FF6C1B6B9071A1D1DFCC1209B9035B821FF41B6956A721638F7C18CDD1C544C77FA4118D837366403E3413428B8167DE3D8C1D003F705EB0301429CEDF6BE6988E0C11C161EAEEE1AFC41BC31911CD90AF5C1F051083A8D27FE4124F13FAFE37CEEC1E0EEFBAA75A9E141248539C57723F9C1FCDDA1ADAB7FE2C1010500000008000000010200000002000000204411302D88BBC1A846C6B9E297D34194B856EB8175EA4110060D3E5587D9C101020000000B000000DEE2C81EC6F6FEC1F058F6E20634D141D297086ECAFCEAC1909B9A32EEF6C841DC8A0CE10D88EA41CC4C9CDE1B15FAC104216A26715AF441B2D10C02EA14F8C11C5A3944E9CCE7416074BE468E09B8C13AEA37E2758700428C0A95BFEF51E2413CA268FCE9A300428E9A72726A20F541CE0332790E7FF941486BA5FAAFE5FF41BC7109A96B82E441C0F79C3D1BACF44100E1B1D0BC6ECA41F4CEA304D25EF0419880626850C4D7C1C67282BCA480F0410102000000020000007C90283A538FE24124FFB6851368FC41D04929AA9C10EBC1BCD81063D21EEF4101020000000A00000070A314DF120101C20095FAB3DFC49CC1F6C7B7884D86FBC14E62CA3FD247EEC1CCDA49DC63D3EEC188E3AB7F4932DEC1A46736E9F007DFC1583855B21A51ECC19C7FC249D2C2FE415AD80BB3EF91F5C1E0079727D19DE3419829E2B6327CDC4100AF2F61CEB5FB41CCD1F829E326FF415069F4F96AE9D341180F1EFFB440E44148E0CAC23DC9D241444F61154B0DE941548F2B58B924E94118D41FAEF92F024201020000000300000070CD702E371DCB416C143B84C4D2ECC1983D83BB0C58024240CE0850B91DAAC1E0F85A7E790ED34192ABF734133A01420102000000050000006041C53FF8E9C9C170EA7C26EDA7E64122618816B25001C2D365449A2769F0C1F23D47AE6332F541B4E6138FFF09E5C1B8CD85FB38B200421CB7A07471D9FF41C04DA1A1D5F8C8C1A88A85560E53F841010200000006000000BEE7355F9FC9F1C110449993D16BD0C166BE110499EDF5C18415661960B8DBC1CB75269DC427F6C112BC7C0E6000E0C154D023FEF1DEE941D0BBC3E5F838ECC1E2F55A164FA0F241B02225D1517BE9C12804A7632E52FD415F961F2FC34BF2C10102000000030000000865FC46B47EDCC18D4DCE519C51FFC12C57E28132C0E841DAE5E8D9A786F4C13021DA8B0DE1F441AE712C6397D4EEC101060000000900000001030000000100000009000000525F6762545BF7C1725528A09486EEC12A696675DDE8E1C18E299EFCB831F6C1446F516F3932E1C11886DA4C2E8DFFC160660B064491C0C171DCE78E70CF01C260C5AEFAF4CEDC415C51DF128C04FCC110D98D554D2ACE413C1F8754B5ADECC18059CFEFBE7EB641206E820E0FB8D4C155B728571CCF01C2467A9136082B0042525F6762545BF7C1725528A09486EEC10103000000010000000B0000001F966E63F02CF0C18014824C3CF2AFC18E4596AAEC2FF1C164BFE601461CE0C148F8BF2B786ADDC12AB1A4D64E04EDC18CB3AFE921D2DCC1BD5E7118DA8202C2FE36877B1D46F5412849A8D0A83800C2B01EFD8957F7FC41E00DFE642B590042C4EB9A838900E141DE35EDDDDB6BF641B8C035A4D8E7E6417C4608A4D359FF41AE8700AB4F8F00C2FE61B667CA5FF8417477A981D74901C28C35D870156DEC411F966E63F02CF0C18014824C3CF2AFC10103000000010000000800000095C0D2468BFDF6C120009264665FF6C14E2618B6847CF3C15C72BF5004EDF7C1C0FF40A3DC9DFB411C9EB4C1F19BF24168E112260C76DF41B225BB4EFBBE0142B0C6941B294AC4C1F8DA4678D656F64124F5ADF3842EE7C1949886AE4069F74187B8C8F219BAF1C150C7F49C2D71F54195C0D2468BFDF6C120009264665FF6C101030000000100000006000000A01865A0A35EE6C1B80C7DEA3A32E64188CE4E9B399CF0C14029DA7C8E4BB8C144D7CBC13F94E7413A89EF7FBB82EAC130A980BC0541E74198F3202D0596FD4100362266087AA241BC59110EFD830242A01865A0A35EE6C1B80C7DEA3A32E64101030000000100000009000000C6DABEA4DA9DF0C1B2910AF5182DEEC180E6E88A86D9B541EB693C0DA4BFF5C1AEE6178185CAF1411CA448C45D59F1C1DA68320F3415004244E090EAE580FBC1C81470700A6E0242B6D0FFAC6EE1EFC17426114E19B000420248E0A84BEEF041208B56DE51D6C541D07B9BD25400CE41CC422092704DF3C1487BF330C23EF841C6DABEA4DA9DF0C1B2910AF5182DEEC1010300000001000000040000007C7E67343A51ECC1C8E71C782683E0C15818FD9D006DFA4126341158CB95FA41D68ABF74FD1B00422E1E9A56F14600427C7E67343A51ECC1C8E71C782683E0C1010300000001000000090000009799C6DEAA0AF4C12C37F6C63F6DF2C12C4FE7C9C909FBC14928221329EA01C2B02E91921C31CFC1EC7A23913040F1C134AF2E5AD251EC41824FEB27C33AE8C1ACDC0BB6C70BE041F002528D5646D0C126E38ED8586D024258331EEFF6A9D7418AFD9F067680F04164C56363F36DEE413973FD3D9450FEC1F42DC654C11FE7419799C6DEAA0AF4C12C37F6C63F6DF2C10103000000010000000B0000007641A2B48E38F8C11C8E2F101C34F0C1EBDFFA382397FAC1380A8D66FA66FCC160251D346FCBDD411472FDB34241D8C1E4373919FA08F8417AE9E98E51EBE6C196CC19428806F741766D139DC619E3C12095E0EE6879BB41002F02800818C24190DDC54716A2C3410839031CAE43DF410841A0D691A6DC41F474712F1BFCFB419CA73B94C7D3DDC148D96B17ADB80142D16385F2DA18F6C17AD72BDD6535F8417641A2B48E38F8C11C8E2F101C34F0C1010300000001000000090000008824BE84F2F5E5C1D148D465B78402C2C0FAACDDF37FA3C14D1743AA6846F4C17060EF194FB8C0C10AA9AD12F564E5C19025859FD381EE41D8E258D2E8DAE841D45D02E5FA3DE941740C8BE7B7A5E941811CCF200833F3C1C42B36EACC470142A91A7FFB567F02C264F53846EE91E44166FAF17CE59601C2A45F9DC69E71E1418824BE84F2F5E5C1D148D465B78402C2':::GEOMETRY
				AS col_14126
		FROM
			defaultdb.public.table1@[0] AS tab_6174
		WHERE
			timezone(('+':::STRING::STRING || 1599603643:::OID::OID)::STRING::STRING, '20:40:45.460818+10:50:00':::TIMETZ::TIMETZ)::TIMETZ::TIMETZ
			IN (
					'18:38:43.002095-08:39:00':::TIMETZ,
					'18:35:43.001673+04:25:00':::TIMETZ,
					'19:41:53.975915+02:56:00':::TIMETZ,
					current_time(tab_6174.col1_7::INT8):::TIMETZ::TIMETZ
				)
		LIMIT
			57:::INT8;

Reproduce

To reproduce, try:

# From https://go.crdb.dev/p/roachstress, perhaps edited lightly.
caffeinate ./roachstress.sh sqlsmith/setup=rand-tables/setting=no-ddl

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

[rytaft]

I cannot reproduce this. Does not seem like a release blocker. I'll leave it open in case anyone has an idea about how to reproduce.

[mgartner]

I could not reproduce either. Closing.