roachtest: sqlsmith/setup=empty/setting=no-ddl failed

[cockroach-teamcity]

roachtest.sqlsmith/setup=empty/setting=no-ddl failed with artifacts on master @ db229cad354c2776ea35c9dc4f78e6ce66b9437c:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:224,sqlsmith.go:257,test_runner.go:777: error: pq: internal error: unexpected error from the vectorized engine: error decoding 464 bytes: couldn't decode type anyelement
		stmt:
		SELECT
			ARRAY[(1886859287:::INT8, '{"bar": {}, "baz": [[false], [], true], "c": [{"b": null, "baz": {}}], "uvw?*O": []}':::JSONB, '01010000E0E6100000BC1F34AAC8284B40A069F645E0982AC0B826714D92ABF7C148DFE74DF5E8FDC1':::GEOGRAPHY),(2098862009:::INT8, e'{"foo": {"baz": {"-NLuOmYS": false}, "c": {"EoqA\\\\R_*dv?u": [], "shD4s-_A": [[null, {}]]}}}':::JSONB, '0104000060E6100000040000000101000040DC0E0FAC63295C4000DAF34B4F9E0640904925C6FA44E1410101000040D026E11A5EBC2640403AEDCB2D583540E8275F253C20D5C101010000406AC04A1CFDFF644018F82A7059BB4EC070CEB61E51CEF0410101000040F83C860255AF4B404466467DB5F53140B2FAE677D158EBC1':::GEOGRAPHY),((-1269394882):::INT8, e'[{"6G(K4J_": {"$K:l": {"c": [false], "v06": null}, "O#\\"": {}}, "EWA\\\\\\\\c-]onnM": [[null], []]}, {"n^3I": {" l}E": {}, "a": true}}]':::JSONB, '0106000020E6100000040000000103000000010000000C0000002B0195D1C8DF60C00D185804720341C01400BADC352360C0F4532861C92D51C0403ADB53CD0D2C4092F09C4D9F4154C0E45DCC71E28B4F403F02505F487C4DC0C88B9DB637164140BC5D26A9870B39C078B364C5C8436640B2EEC0D1D4F350C078B4FCB6411F634090AC3F4C341A3840C8790BE233554240CED4461F78095440F2B9499660824DC06C25AAD6F9B750401ADEA3B3849F62C0B0D0C35FECAB4E40C023FAD97F305BC070C86CD500BD22C02B0195D1C8DF60C00D185804720341C001030000000100000008000000D07455F4AA0561C0D3C8EA36137047C062E0D0864EA957C02A5CA16AA5A350C0A0E84027C4F42C40A138EA8D614351C0501FAE0416EE56409E834B7CBF0154C0A815802F8F105B408052B71833331BC0808CB78D828D4340B29D209527425440304263E16B2760C0D61E2DD827F35440D07455F4AA0561C0D3C8EA36137047C0010300000001000000070000006658E2C4A04158C0F0909E60864B14C05053A79B50E43C40F682556C6EE13FC0AC1F34D7B3514F40A540A32BFCEE40C016FBD7BB52456640808DEFD67E834DC0E04411B553C459C0EA3A3F8CBBF25040261C0F91892D61C0AC596F0FEDA14F406658E2C4A04158C0F0909E60864B14C00103000000010000000C000000A284C6BB433365C00B4D606574D347C096D7E3B8E57856C059684936DED34FC0A002548B4AEB4CC0412C3637092355C05C6834120B5043C0BAC0745A4ECC51C0B464E867148352405B3EA9B472F554C030276692517F504049D575F6424D4AC0445510CF1D3F63403A0081EA248B50C063802B4258D952C04A5F9D585186504069EB16B8747357C090D733C5DFDE4540F1388932077654C0E43853618D5635C0DE3CD1DC7D9A65C040F2AEAEAC9816C0A284C6BB433365C00B4D606574D347C0':::GEOGRAPHY),((-27008995):::INT8, '{"%C%*rNi~B^": [{"H%1pgr$rB": {"b": [], "baz": null}, "Rw>juuY:0": [[]], "b": [], "c": [], "upb*8]A;@``1": {}}, [{}], [], {}], "foobar": {}}':::JSONB, '01070000A0E61000000400000001020000A0E610000004000000E44C4258CC2D61C0C07A055170180C40DE99CC06C060FAC160E7C69C6F0545404048FB8227654540A93DE278DCBDF0C150B6C6BE4321584028DE8517D0B75140582F8E366A63E541B8D6ED4442B955C050BF72F3D8354A40187DDCB9D385004201040000A0E61000000400000001010000807CA9F57CD91A5C40BA6410166CB25140D98C2F915734FFC101010000802CFB3225312A624048833A6148EA3E4030CDEDE926FBDF410101000080907E9D5E115C21C0F0FD47D0AC741CC098F4BA983AD4D0410101000080F49C65CAC9475EC0026EDF98E34C4140941662C75A1CD9C101050000A0E61000000800000001020000800300000058D421AB48CC5AC0DE62C11A5DB553C0E4BFCF1CD8B4FB41418D17CC1ACC5CC09EBADC688CDD55C0F7B193F2EBE1FEC1E0664B89EA3F4AC086CC7792554854C0E6E509D78329FA4101020000800300000054FEC672C2594CC0186A8996F8E031C058871B0A235CFE419491BAB750DE4E40FC21BE72B4B032C0D888A38FE3DEF4418DFA4D7ABF2C63C0A4B5F0D888F74E40B058E1C6DBE6C541010200008004000000446C383786DD57407C92371993AE4DC0201AA7C2B716C14190364EA3F34255403493A5324EB1444078656C749E83EEC190358F55FBA733C010A8CB0F5CFA324098CC0C1F70E7D241788C4F62C9CC3AC0FC45926CC4F83040508CD29389B7014201020000800600000080770C1428B339408E0EFA6C51BC44C01C5F13C2DA4DF9C114740C4468605440FC2E05BBA11A46C0D053275AE41DCCC124DC1224C7D26440A562FC769D4B44C0429E19C862B90042C8DE2EF1FFB26340C021BA04F3FB3CC031AAF25C6D6DFEC11C414924B768534074EA0100E7C45240E8A6A8645095014200BAE663506E4CC084A8D05A996C464064B1C05F28CCFA410102000080020000003CC595B861194D406CD3405F633E38C04066237C4421C7C19A3BAB326B606440E0CB59FB1D9B2F40C00695AA71DEAA41010200008006000000D3B7D43283B25DC0A1D086498BB849C082A264F86F58F0C100D0FEBE48131940D89E0F9ED44953C0649AE645FFFBFC41C0CA099E23AD0F4000DF043EA80137C07A82D7EB5A20F6411C42A303C22647405C1BDAA0DFD04F40AD412E214B9D01C26C354135409C48C0742BE595C52D45404C37A11689DAEC41B2E7A2B945245EC01C56BFB6E0D53040B8462CE553B1EBC1010200008006000000503804924EAB3C40E262E53A90864AC0183FBAEC5A42E8C1DEC1F3F8C7F46240066379C9D3AB3BC074CEF52E8D34E5C14C13F5DAD0BB5940C0A187A4BC514140B5DD07AE563BF1C1A03855A5D87B284098F562F103625440D8BF7DD652BDD3C13A570B784D6C4FC02843BD77C833524026B2A39A6EB7014244F39F12966A65C0620708EA243F514060DE7DAC0E7BF94101020000800700000000EF768EE0084DC040FBC76B606A35C0AEDC5C3FA91DFFC1C4C5A43AB96D42C0C2E243E98F0A4FC0F889AC622613FA41B424DC05E4CC65400C4F4F834A874DC03008F929A2A8F641D8B70BAFD59E574018DE178130282CC0C0C32F4BF312D4413C48504F04285940C017115438454A40E8333F3F274BF34170B7A79E5EE94340D48D7CE4CEF84C4030AA422EC78BCAC1F0DB36BB720651C0580FAC70E9E452402E40C1DBDFCC014201060000A0E61000000400000001030000800100000008000000E0748AB066FB61C0D4584397569649C04E24092977F1EFC16BCB71AB75A459C06F483A98767651C09420CEF0084402C29EA4CE93E266514034EE3346108F36C05D394D9098E8F3C1184465B9F83C3F4090AD037ED0C73040ECB0614DC96FF8C108FA5A1CBBEA4440A2B8935072725640C058B2661191F9C1380E4DEE429440C0501870406DA21B406C4786E319F1E7C1C698F9AFC74453C056ACB840EB66424090463C5D485DDE41E0748AB066FB61C0D4584397569649C04E24092977F1EFC101030000800100000008000000BE6EEE0964B95BC069F2503A15A754C0C610F0ACF20DE9C1100E7DFE8F0139405C05C73263433EC050C42FFEF945D0C1785D6D1A8AF35C40C4885996018F47C010D83BC909CDEFC18468D10E258F6340C017B50A0CE615C013F77123C64F00C2BC5BD5417AE749C0142FACE09FBD4F400E08F7CF24E6F741B8C0D7E30FBB50C002F65C163151424084955FEED055F5413855E7101D045EC05CAFEFAABA7D4D401883A75822CCD3C1BE6EEE0964B95BC069F2503A15A754C0C610F0ACF20DE9C10103000080010000000B0000007CCF0F01B999634073D1FCDAD91C56C076AD34116D5FF2C1D45E2765898657401C2C7A4FD30833C09676744F0B9FF2412806856A957C5840AC1FCB05A1B831C00C77B2E7BC2CEE4186BD69E20E27624000006323E4A3703F1C976E21F466F5C1BC02F4F320466140D47CF226717F3D40DC4DC070C7D500C2CC1C7BE7848840409CE12BE0E40E354068207515CC51EF4140808884360B2BC0C062FCD07BF93740F4A7EA029F27D9C1C24C33FE6AFB65C014B447884D264A40C8C9969DA05EFE413CD990DA6D5D66C0B084BED0117C484014025833845DFCC1B76A2D780AF660C0C4262F878DCB3B40DCA20CB41A6CFFC17CCF0F01B999634073D1FCDAD91C56C076AD34116D5FF2C101030000800100000009000000A298157EADA55CC04C37863B686830C0B65C036BF31EE9C174775F613DB655C07EC6A000DB1356C01E96F41C7DCC00429034CEBFC092254019BD20BCD3B340C0B474F4840CB6E4C1D0EE9E207A8C64401664CCEADDD645C00808FA59B245D0C1F0C1944A788E5D4010A00353149F2BC0D007A8080D4DE241FA99C924B702614050558442ED2C5540F6E750E469FDE2C1C9BFB7D6F52B63C0DA382356460F40407ADCC6A6E526F541AC5521B8F9BB62C080DF628669232040D47246D265310042A298157EADA55CC04C37863B686830C0B65C036BF31EE9C1':::GEOGRAPHY)]
				AS col_260758,
			tab_151494.col_260756 AS col_260759,
			tab_151492.col_260753 AS col_260760
		FROM
			(VALUES (0.8703668785018939:::FLOAT8)) AS tab_151492 (col_260753),
			(
				VALUES
					(
						(-5055233.838529904598):::DECIMAL,
						(
							SELECT
								ARRAY[]:::RECORD[] AS col_260755
							FROM
								(VALUES (NULL), ((-7496):::INT8)) AS tab_151493 (col_260754)
							WHERE
								true
							ORDER BY
								tab_151493.col_260754 DESC, tab_151493.col_260754
							LIMIT
								1:::INT8
						)
					),
					(
						9.069038452344957360E+30:::DECIMAL,
						ARRAY[(1579007854:::INT8, '{"test": "json"}':::JSONB, '01040000E0E61000000500000001010000C060D7A31303464CC0983A8C80D96F22C0600D1837F1CADD4160F6A75F0AE6DE4101010000C03C6186BAD7FE57407CD4113279004F40A05C702B70CA014240863634D3A4E44101010000C0EEFA1FC5629B52402A5A2C560AAB5240E0C512BE862CD241AA226317593D00C201010000C0F6B6E6492E185240A07AA3F3AF6333C06C77C5AF1BB3FCC10C7D6B01CE5BF5C101010000C09ED91BF004925AC0C2B44A3D018254C060EF6605EB4B004280D47F401DB5F3C1':::GEOGRAPHY),((-7508037):::INT8, e'[[[{"1c3GJ79Sj;m": {}, "a": null, "foo": {}}]], [[], null, [[]]], {}, "muZPe\\"[", []]':::JSONB, '0106000020E610000000000000':::GEOGRAPHY)]
					),
					(
						(-3.402978415244919058E+20):::DECIMAL,
						ARRAY[(556427139:::INT8, 'false':::JSONB, '0104000020E6100000030000000101000000BCC793F918BC604080E21FC3DF7331400101000000A8669D26083646408B5D0F1B578B52C001010000007EA4798A5D5C6340347800F1F8584FC0':::GEOGRAPHY),(944083298:::INT8, e'{";pD\\"nr": {"a": {"[.%l?>Y[K<*4": true}, "c": "Gl8y"}, "Aw2bC!r": {"![C$W``or": [], "bar": [], "faXU_i]Hi": [[[{"]ptsUV9": {}}]]]}, "baz": null, "foo": {"#}t(@": [], "c": {}}}':::JSONB, '0107000020E610000000000000':::GEOGRAPHY),(1441590695:::INT8, '[{"a": {"]K=8Mo": {}, "foo": {"WJ,*A": 2.041958284913912}}, "bar": true, "c": {"5,?Wg_eA": false, "foobar": [[], false]}}, {}, {}]':::JSONB, '01030000A0E61000000100000009000000BE66BDFBE20063C0806A8460A641E03F3026A272B404FCC130EFAA7508F64DC00DEA67FA17E54BC0502C328B2349C3C16CAAEA2ABFE85240D41186086A5D3CC0A8A2EDC18FDDE54136864D7E876C6040B85BEF79838521C0627EB7FB30CE0142081883285EEB6540207C45C94AB71440DE2933CE83FD01C258233851172A4340A46275BDDA6A414072B8F3A3A798E4C1C86FD9EB8BF13640AC1562CF57F93A40009F347B425A9B414C77C22EFB2A5EC0B411ED35FC6051401F0B4355E09DF2C1BE66BDFBE20063C0806A8460A641E03F3026A272B404FCC1':::GEOGRAPHY)]
					)
			)
				AS tab_151494 (col_260756, col_260757)
		WHERE
			true
		ORDER BY
			tab_151494.col_260757 ASC, tab_151492.col_260753;

Help

See: roachtest README

|

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

[yuzefovich]

dup of #70767