Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

roachtest: unoptimized-query-oracle/disable-rules=half/rand-multi-region failed #133661

Closed
cockroach-teamcity opened this issue Oct 29, 2024 · 1 comment
Labels
branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team X-duplicate Closed as a duplicate of another issue.

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Oct 29, 2024

roachtest.unoptimized-query-oracle/disable-rules=half/rand-multi-region failed with artifacts on release-24.2 @ ee625f92aaca9a68ff53706626b2c5050a91a6f4:

	(-19616):::INT8 AS col_5880,
	tab_1934.col4_4 AS col_5881,
	(-159513665):::INT8 AS col_5882,
	'15:48:19.308636':::TIME AS col_5883,
	CASE WHEN false THEN B'11010110110001111011000000000110' ELSE tab_1934."col4\\x44_8" END AS col_5884,
	tab_1934."coL4_2" AS col_5885,
	tab_1934.col4_6 AS col_5886,
	(-112):::INT8 AS col_5887,
	tab_1934.tableoid AS col_5888,
	'01060000E0E61000000700000001030000C0010000000C000000EA5EDDEFD2B263C0DA1D65C5FEDB4BC000608E8BBC433F41AC45435FB7ABE9C1C8941613601147C0446D782001034DC01070A82BB9F0E3414819B9AF4D94FCC14066FA0F7F39524028D3959D55A053C060AA48F34994D941544C0509D087FFC1B005CBDB32535340E6DEEECE1EC84DC04081E3961C2BED417C84C110681AE0C1C00894259B545D403C34F6536C7251C04C52B5881F11ED41A0A5D1F753E3F7C10C42E28956135D40E2CF296238B348C0DC49E54D5066014255BB02F3F9EC00C29641F75FBDCA6440047C94649B5D45C09070126C5753C741D4318312B22BE241D4B4089782BF6140DCDFCE36296838C0C0AC44BF6EA7E9417C374F480DC7004250243C41A90C5440CAAE7191F4B3424073AE14906167F0C194B0F19F0230F341A4391FC9D61A44C058D522F54AF0494073BE6716C030FBC1DEFD366BE71CF841222FE6A6B31A63C0B8B081B32E9D4D4028C147823E8E01C2ACAFEDB09CAAFB41EA5EDDEFD2B263C0DA1D65C5FEDB4BC000608E8BBC433F41AC45435FB7ABE9C101030000C001000000040000000542A156FFEC60C0E84A65ADCA382CC0B057AD91D20EF941C09FA98ACEB4C54100656BB96EFE104044442A702F674F4000F2DD38B9D6FEC1497D385610FCFFC1FBB55576FCF863C0F8646AD1FF4C5040D60B65C116C7E5C140ED9360E8BEADC10542A156FFEC60C0E84A65ADCA382CC0B057AD91D20EF941C09FA98ACEB4C54101030000C0010000000C0000006ED7D7A1A6DB63C01581AC9D8F1A43C04C75E244FCC3F6C144DD42B6D1E5F3414CADC0C1973C61C09E786EC387F255C0441484BCA087E1C1EE0FC1E58928E2C119CF3A066D1358C09A7B7348A33650C019A55A501AB7F4C1ACBF5D8D0D8EE041B09ECEEBFCB825C01CD0C284B2EE3AC0FE55DBCB9410F041349BF8625EA9F041A044E6AB92496040147C1802AE1853407E3562C5B6A4F4C194E847CAC3830042B4FD9A44F35C5040306660B519445140B260B081A0E2E1C1606928E2ED35C5C180B9C66CD9A2F63F34A5B7D5931843401A2FE2A4CE5CF8C1C099203550F3DA41A0B0C5D913A93FC006632208FE5A4140AA7D00E7FB8E02428CF8D0CF82970142482A7A5D7E0146C0D4199D0F87883A40849010F016B9FE4126080D1AFC79F541120A62193D304EC0C873D7F64F2F454042DAF97BAF9E0242A01F76D16F31D9C1DCCCA1FE417542C05098F22F275520400662780215B9F04180291F84AC0391416ED7D7A1A6DB63C01581AC9D8F1A43C04C75E244FCC3F6C144DD42B6D1E5F34101030000C0010000000C0000005444AFAF024660C0B0C4CF7F9C5C124010466D6533C1FB414EAB531D1016FDC13725C9D8149163C079959854F31841C04AD23C42D63A01427067B6A0D9AD00420836D66BDF2A50C05D812166E02553C034F45398217501C2C46BDB93A0860242F0CB77158E7D3A4096673B9ECA4850C028B07D7EE15AEE419896B80477C6004264166EFCC74E4A4088E12DC8CD6B24C08094EF5207BABE41A48D08C373F1EEC130629ED19F905940F0870184D66E1240429EB52FC1F9F041C03B73B9547C0142A8EFE5BBC8CB5C4040897D04C4B01D40605700BCE858D841327DFCB3390EF741C46F8588A976564074A73810C65E52404C8AB6113037EE4144B99CA192DCFD413465664751F752C0D26F65E194765540DC5513D43F20E041A6FECB075D64F6C10DA43F11B16853C0C4868DC2D00A54409D4972708532F3C1AEA5C6729C1AFEC10CA5A573DE0852C0A24B23BF7F2141402C5C24E91BAE014256373FB1D330FCC15444AFAF024660C0B0C4CF7F9C5C124010466D6533C1FB414EAB531D1016FDC101030000C0010000000C0000002A7F1F8FC90562C066533DEF1AFC3BC040A8D207A10CC8416A7131AF12AEE8C1ACE1AE0537115FC00C6E08E6FBA537C0E4BBFBE0269BE141D88E9573D384EAC1AA5FAECA8DC057C070DEDC878B3C30C0A83E8F2D1E4ED8C10742FDAB5736F4C131459CB9AD4F60C020D1FB71A11940C0157D57384BE200C28497414F937DE9414EDAD79980AB6340E0B36F0B3E652040F09321DD4282C4C168BE04D0D968D24140B06DCC49711E40F877BF43942C27407094E4AB153BFBC156DAC0B52E7FEFC154C7511D2AAE6540A4A19F45BCEE3740B0B83E30493FC341210535BA577D02C27CF77BD66BF5594088F6ECBD9D083840323D4ACF7C4DF8C1A00462CE74C0E0C1E493DC664569554080100B47B9FB4B40689CB6ACDE3CE4C144EF2783B7D5F0C134C94681B3C344407AA01F36292D5140888D0C26D136FB41C0F4987C54B6F341889D96C80CE035C0ACE72F12E1554140F999BEDC702302C24C58642066A8FB412A7F1F8FC90562C066533DEF1AFC3BC040A8D207A10CC8416A7131AF12AEE8C101030000C0010000000D000000F4DA6E7ED4E042C0301E191DC00D15C0EA6880F3C341F341F40081C8FA76FCC130A87A1F170344400C8C84D9ED1847C09812117C63B0FF41426004D06705FCC1EC8BFC98CCCD5840342C0315ADC255C038FEAB1D3693DEC110A65A081D9EC24156BDF9576E3B60404BE1795EA32951C0A052C9FFE931B0C1508EDF8570A9C541E8B63D65A4506540890FBB20375A4CC07A206AC2FD30FDC1E23260B8DA9DF9C1AEC13178CA466540E48BED76FD4138C03E6311E914CEEAC15C138FAD3130F4C1F2AE0FCD3F616640604E689118AF3D407E6FB6C3049DF5C1CCE75534F8FE00C28008900284BE494068FC720914704540B8152F0901E9DE41D435BDCD198BE8C1904D8DD0E1D43940661C3EEAD26D5140B87EC6E1DF52FCC192DCB3683B4FF3C1181D132B252848C06ACD80564661564048E71A2EF660D341C0B9964CC780E74124E4987EC64145C0C0C4DC80E0F74E405067F6C668D5FC4140AA45A5300600C2006FA69A4C8E14C0A01051B89B343E40FA0593D75FC7F441B2E719F8F90AF641F4DA6E7ED4E042C0301E191DC00D15C0EA6880F3C341F341F40081C8FA76FCC101030000C0010000000B000000B83566FF079753C0A0F6A51DF95339C09825B0485AFDEA419CC59566F137F3412502FEDA0DAB53C0B4DA85C902C843C05C4E49AEB2C400C234F89C86B8CAF94100666F22B5E010C0C4C0E0222C714FC0FC6F78B27F4CE341E87C212683E4014200C2AD320809F2BFA0AEEE1765E81BC060C644826A59FE41001F565E638501C2CE5F2E4C70BE5040D46B088F6F8832C012A22C9C5F6E024278C7AA8A1E8BE44182454C3277B36240F641E8655DD04140F6D8A022ACF00042C05F6F6FDF5DE4C1F8457F18EA023940FC1B6D79A1DB3040546C49731911F6C19489EA119907F141B0C6D693519044C02478BC52726F4F40966BE4AF572BEEC16C4A0235A402F34141019CF7DEFF60C09842E2B812925440825091275D46EEC19C73D2B31435F841773AE27FF92E65C0BE584FA2FDD94240D1BD315D2AC6FFC1B85ABC96705201C2B83566FF079753C0A0F6A51DF95339C09825B0485AFDEA419CC59566F137F341':::GEOGRAPHY
		AS col_5889,
	tab_1934."c""ol4_11" AS col_5890,
	'EEA9D1BA/22E5B99E':::PG_LSN AS col_5891,
	tab_1934.c😛ol4_3 AS col_5892,
	'':::STRING AS col_5893
FROM
	defaultdb.public.table_4 AS tab_1934
ORDER BY
	col_5882 DESC NULLS FIRST,
	tab_1934."col""4_12" DESC,
	tab_1934."cOl4_1" DESC,
	tab_1934."col4\\x44_8" DESC NULLS LAST,
	col_5889 NULLS FIRST,
	tab_1934."c""ol4_11" ASC NULLS FIRST,
	col_5883 DESC NULLS LAST,
	col_5886 DESC NULLS LAST,
	tab_1934.col4_6 ASC NULLS LAST,
	tab_1934.crdb_internal_mvcc_timestamp DESC,
	col_5888 ASC,
	tab_1934."co%vl4_7" ASC NULLS LAST,
	col_5881 ASC NULLS FIRST,
	col_5892,
	tab_1934.col4_9 NULLS FIRST,
	tab_1934.tableoid ASC NULLS LAST,
	tab_1934." col🙁4%v_10" ASC NULLS LAST,
	tab_1934.c😛ol4_3 DESC NULLS LAST,
	col_5891 ASC NULLS LAST,
	tab_1934."coL4_2" DESC NULLS LAST,
	tab_1934.col4_4 DESC NULLS LAST,
	col_5884 ASC NULLS FIRST,
	tab_1934.col4_0 DESC NULLS LAST,
	col_5880 DESC,
	tab_1934."Col4_5" ASC NULLS FIRST,
	col_5890 ASC NULLS FIRST,
	col_5893 DESC NULLS FIRST,
	col_5887 NULLS LAST,
	col_5885
LIMIT
	8:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-multi-region/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=gce
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_runtimeAssertionsBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-43722

@cockroach-teamcity cockroach-teamcity added branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team labels Oct 29, 2024
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Oct 29, 2024
@mgartner mgartner added the X-duplicate Closed as a duplicate of another issue. label Oct 29, 2024
@mgartner
Copy link
Collaborator

Duplicate of #131346.

@github-project-automation github-project-automation bot moved this from Triage to Done in SQL Queries Oct 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team X-duplicate Closed as a duplicate of another issue.
Projects
Archived in project
Development

No branches or pull requests

2 participants