cockroach icon indicating copy to clipboard operation
cockroach copied to clipboard
verified publisher icon cockroachdb

roachtest: schemachange/mixed-versions failed [functions cannot have more than 100 arguments]

Open cockroach-teamcity opened this issue 1 year ago • 3 comments

roachtest.schemachange/mixed-versions failed with artifacts on master @ 93ad913106b6f0f6ec98bc2cfa788ff6d8085bd4:

(mixedversion.go:594).Run: mixed-version test failure while running step 27 (run "run schemachange workload and validation after upgrade has finalized"): full command output in run_061326.218500776_n4_COCKROACHRANDOMSEED6.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=azure
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_metamorphicBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for azure clusters

Same failure on other branches

  • #123993 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.1 release-blocker]
/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-38863

cockroach-teamcity avatar May 19 '24 06:05 cockroach-teamcity 

  {
   "sql": "CREATE FUNCTION schema_w2_230.udf_w4_611(enum_0 public._enum_w2_137, enum_1 public._enum_w4_44, enum_2 public.enum_w2_137, enum_3 public.enum_w4_44, enum_4 schema_w4_2._enum_w1_368, enum_5 schema_w4_2.enum_w1_368, enum_6 schema_w3_11._enum_w2_300, enum_7 schema_w3_11.enum_w2_300, enum_8 schema_w3_55._enum_w3_193, enum_9 schema_w3_55.enum_w3_193, enum_10 schema_w3_73._enum_w4_142, enum_11 schema_w3_73.enum_w4_142, enum_12 schema_w3_106._enum_w3_118, enum_13 schema_w3_106.enum_w3_118, enum_14 schema_w3_117._enum_w3_204, enum_15 schema_w3_117.enum_w3_204, enum_16 schema_w2_118._enum_w1_144, enum_17 schema_w2_118.enum_w1_144, enum_18 schema_w3_141._enum_w0_140, enum_19 schema_w3_141.enum_w0_140, enum_20 schema_w2_176._enum_w4_170, enum_21 schema_w2_176.enum_w4_170, enum_22 schema_w4_144._enum_w0_430, enum_23 schema_w4_144._enum_w0_658, enum_24 schema_w4_144.enum_w0_430, enum_25 schema_w4_144.enum_w0_658, enum_26 schema_w2_181._enum_w4_211, enum_27 schema_w2_181.enum_w4_211, enum_28 schema_w2_211._enum_w0_269, enum_29 schema_w2_211.enum_w0_269, enum_30 schema_w4_212._enum_w0_402, enum_31 schema_w4_212.enum_w0_402, enum_32 schema_w1_262._enum_w4_284, enum_33 schema_w1_262.enum_w4_284, enum_34 schema_w4_232._enum_w1_321, enum_35 schema_w4_232.enum_w1_321, enum_36 schema_w1_311._enum_w4_487, enum_37 schema_w1_311.enum_w4_487, enum_38 schema_w1_317._enum_w0_529, enum_39 schema_w1_317.enum_w0_529, enum_40 schema_w2_433._enum_w4_610, enum_41 schema_w2_433.enum_w4_610, enum_42 schema_w4_426._enum_w3_648, enum_43 schema_w4_426.enum_w3_648, enum_44 schema_w4_503._enum_w0_574, enum_45 schema_w4_503.enum_w0_574, val_46 \"char\", val_48 BIT, val_49 BOOL, val_50 BOX2D, val_51 BYTES, val_52 CHAR, val_53 STRING, val_54 DATE, val_55 DECIMAL, val_56 FLOAT8, val_57 FLOAT4, val_58 GEOGRAPHY, val_59 GEOMETRY, val_60 INET, val_61 INT8, val_62 INT2, val_63 INT2VECTOR, val_64 INT8, val_65 INTERVAL, val_66 JSONB, val_67 NAME, val_69 OIDVECTOR, val_70 PG_LSN, val_71 REFCURSOR, val_77 STRING, val_78 TIME, val_79 TIMESTAMP, val_80 TIMESTAMPTZ, val_81 TIMETZ, val_82 TSQUERY, val_83 TSVECTOR, val_85 UUID, val_86 VARBIT, val_89 \"char\" DEFAULT e'\\x1b':::STRING, val_91 BIT DEFAULT B'0000000000000000000000000000000000000000000000000000000000000000', val_92 BOOL DEFAULT true, val_93 BOX2D DEFAULT 'BOX(0.4765225792511163 0.10089170863853969,1.4111091631378203 0.3684548344398503)':::BOX2D, val_94 BYTES DEFAULT e'\\\\x4b68c9':::BYTES, val_95 CHAR DEFAULT 'N':::STRING, val_96 STRING DEFAULT e'\\U000B2ADB\\U00047044\\U0003BBD4\\U00060786\\U0007707A\\U000DEE58' COLLATE en, val_97 DATE DEFAULT '5874897-12-31':::DATE, val_98 DECIMAL DEFAULT 27214933343203.90353:::DECIMAL, val_99 FLOAT8 DEFAULT (-0.6032116139252585):::FLOAT8, val_100 FLOAT4 DEFAULT NULL, val_101 GEOGRAPHY DEFAULT '0107000020E6100000070000000106000020E6100000080000000103000000010000000C000000102F0DD747293AC018349537A34745C0C8974516C90934C0091D53A439DE50C060D9FC7F37B264406105A6DB1A9C54C060CBFA839ABF5C406249DA951CA749C0907474E04F7451408C326E4DD5D239C0B4948854B7186340D4DB5B204A123CC0601C819590F1264064B9963BD35F4C40882BDFAAD33E53C024B61F798F524140E2A2DB8721555AC0FCA7CAC5D1803940EC82EE8B450D53C0D0E5DAE0D6C32AC02BC70B89153562C0ECBFD11A1E8530C0102F0DD747293AC018349537A34745C00103000000010000000600000070880F2A809123C008EA641A324B2DC08081C76FC0A124C0BCE51222CFD444C0D86ADB21A64E66402C360F09E47B51C000382E9ADE9D274040F2D9F9BFE74440F6135486DBBE4CC072BB773706D6414070880F2A809123C008EA641A324B2DC001030000000100000006000000407AE79EF83365C03C1AEC7C11D831C03C3611E70DFB56C0E2567DC292D543C0A8E362AF1B8C5D40853449B6BCF740C0A056B06178933940D82ECBCFAD294C4060282D4261CA54C0ACF8979CCF334F40407AE79EF83365C03C1AEC7C11D831C00103000000010000000C000000286769524AB55AC0102D176A97903CC08D19C7ABE96D56C02CAAE9BFBE4F39C01A00C90807E450C054DED95BAB8952C07660D4F0E0774EC02D237AFA32DD54C0F0F18500558E4340C2F2023B15AF53C040093B17B21724C0EC72BBDB900F36C00493A601AB11484074EC768DF59437C0E41CECBB50526640C05724CF98E43C40805B777079D027C0185D6015993F3740A482ABF3E47A49C04605B82D29D55340FB412ACDEF1966C0EEFBB3F0856A5640286769524AB55AC0102D176A97903CC001030000000100000008000000E83B808D03185EC050270550EB5B13403DFB71BDDD825FC060B07EFD49EA0440CADB66AFDACC55C090765F414E0021C0C0E89498F39658C0B85F2F5AC79849C004E04A0402A344C08EC1A2B3012741C0E0E0C5D26B5C5C40EAB30C0D0B295540F883EC1A5614344064A75C9EA76F5040E83B808D03185EC050270550EB5B13400103000000010000000C000000AC376C71CD315EC0CA50044A5F0042C0A89D9BFD3A9331C0AF629FE073B848C0404DB28DDE083C40DE9A1995CB4256C06879F8CF7C1B4A40DE682E9DC24E51C0408B131A4F3F5D400D8D823F6A9249C00C1BA684CDAE4A40D03734C45A0210C0667814A448E15240888B1AE3554D43405CE5B562B2025340141ED62AE4944740D0DB0175BC6E35407E6714F24F664240E015E220DDBD2F4000282C7CFF23FDBF76903E79340E5DC010D5F80A45401CC0AC376C71CD315EC0CA50044A5F0042C0010300000001000000070000000A02211C577450C04C720B3A409145C0C000DFE8F7C211C0AB75AD360B964EC034C14E10B31B5E405A2C8BEBD1C350C0DE354BE348A464407D3F3BC1BDD247C04F8F0D5AEFBB50C0FC06D917C4D53940F4498B3046CD62C026393FDE72293FC00A02211C577450C04C720B3A409145C001030000000100000009000000F458E54346254FC0D604E6ED41E64CC0C07F4759BB02124022489D2202274EC074A8E2ABA5385E4030AFD0D5B2242440D8C772B420C76440F6AF8D3A8A934240C4F26CF6A8C86340B0C1C9EE0B2F5540DCB727606DE744C0BCF8D7E340364F40E8711417DC4055C03826C124A6D65340413BCEDBBE9261C0B07C079856104E40F458E54346254FC0D604E6ED41E64CC00105000020E61000000700000001020000000200000010B0F284398737C01C3EF05318DA43409830FEE08A614340DC70284DDD154F40010200000002000000B8C3605781AE48C0D4ED9DF185263B40C143E67B181060C064873A9DEFC74540010200000006000000C4ED768BEE8B6040D5AC9EBD873755C0F4686A60612A5E400CBEEA397CC937C0CCAB6F787B675740C00670F6461230C0601E2C34E051644030A3270F6DBE29C0C49EE742283F47406806FF6BA6475340D24787CA02904CC0F03B775DD8204C40010200000008000000F47549509B194BC0703ABB11EF3B31C024DF0F2B616249C0CCDAFA8BDE3240C0C0AA39C2966709405CF9392D65E238C062263606A25D5240F8FF86428B744EC07CFAF4E2D4445D409674AFFC268A55C0ACE024E771DC5A4038720BFAEAC53FC068496469F125594090BC0CCF5C9D4740704EAF3906615A40D2AEE8ECE8655140010200000006000000C062AEABF3CB50C0720E545147F742C0D0BACB6A7F183440965EDCBE481756C0A4B015C485D255407342E286746A55C0F6037DE5C40D6140AEF2B52D1A4C56C0AC3A00DEA2785440D07D06E8EFFE2EC0C4A3BCC53A585340A6D57121C3BD4140010200000003000000E3678BA6D00361C0FF1C36382A4552C08CA4C69923EC48C0A1679BF7D32148C03ED5F78067366440C4EB32C3C62E4940010200000003000000BC4549F90A1E5B40CDC9BB939F6E44C084D21B28BFA75C405CC6619496F73BC024B6F50BBB385D4040FDCBB323531BC00106000020E6100000050000000103000000010000000C000000C814AAD07E3F3DC060D5BB190E8A24C00DC205D9309753C051103E9970C055C0D4940A1130F247C014A6CCD4CDB551C0F040FA75F4583C405C227062E10655C052D3A1FE1C386240936B46CD0CA341C0C8ACB6F71CC34640F0FB321D977A2AC010A7DFDF2EF9624030F43B3D3A5D56405637A44FA3834CC0B89564587F6754401CCC8C4A899B60C0F00E757842ED5040564EA8C5B10459C0D02DE0D50F63404010677014845654C0C4EA4B96CA973040C814AAD07E3F3DC060D5BB190E8A24C00103000000010000000B000000D846F17A50A745C000A34BEAE90C13C0F04C135BB31042C08E8F91999DE04EC080BDC40A45AD37C0E2508E7B172543C0E80FC49B7FF933C06082499763F207C04E95EE3B85AF6240CC9E511FEF3B51C0606DF7BC161F2C404050ABACD5AB034050EB1C98738645405C33B9A2898848404027EF0313FA1EC002831A4B74AF524063EF46DDE7CC57C08EC54FFA358942407D758DC9902B66C068E07472EB7B3A40D846F17A50A745C000A34BEAE90C13C001030000000100000007000000DA282DAD22CB58C047326EA1B1A847C085CB511426BC63C0434B455759AA54C0C2EC82A475CE4BC064945B27836248C0E49E25BB606D4940F99CB1F19C6A53C01CFB96FAB2CF5E40BAFB117197FD554040E812A5E72D21C0481CF0929A3C4440DA282DAD22CB58C047326EA1B1A847C00103000000010000000B000000A0B5F01D4A0053C0A8EC92DA3E9735C056771DA7780666C06B71E07AC23E51C01871C363E4133BC09E4B69D5824F4DC074836FB5398441C05D0D50EC784042C08035E2AC770F5240D9C9E4891BFB47C0F413F19D40A15040B45CC99C5DF030C00093E9C8D703004000A5060BBD9EE33F40D448DF46073CC0B0415D8431425540B12A1595185265C07833B9F358DE28C03892D630E37B5DC0A0D244C5A5DD2FC0A0B5F01D4A0053C0A8EC92DA3E9735C001030000000100000007000000207D4AC07442164049C8D4F0724956C06645E37EC808634070AF81EF346549C01C9DDD7F23C16340805E0608627907409CC23E2A30DB5F40701A6F0DE6FA14C0880997B9F2BD524098205BD8F4093E4028FA72629BE930C00004E0284966F4BF207D4AC07442164049C8D4F0724956C00106000020E6100000030000000103000000010000000B000000B446BED915BB45C01A1D0729C51E40C09EF7680DB5584BC09DDDDD7818AA4EC0F0F053B529D622408744037CBDC543C09C7B8F0655904940D9AA181B4F8553C04CDFA2D121FB4B408EEDF417553F52C09CCC109959005E405C2758AD272B54C02CD38F51AF4E5D40100508C170584BC0141F5074EDA84E40C2B3487C06053CC054CB50B147AD574030CD947F68F15140529EC72F624D5DC0FCF113E9A9B95440B446BED915BB45C01A1D0729C51E40C0010300000001000000090000007E630697A14663C020311ADEFA0A17C01EBDBD56FEF05FC0C1FF3D64FCB043C0343431EF952D6340892E38D8D1DF45C0A4DAF932CAC16340787A7D2E168527C0D6AE03C052F9524080AAA05F8C96F63F5085A3347FE85B404855FBFCBCC047401767664792A050C0584A84DD854A5340BBE028D4E1A463C068E64945684C4C407E630697A14663C020311ADEFA0A17C00103000000010000000700000000A3409CD3FC5BC0811F182D26D340C0D80385CC2270494088733524633B4BC026B0EC2B56F561400CC8D0794F8241C0C4537981DA6F634008D1F03666665440D82293F5D4914340FC71125A66D34E40FED94936C3FD5EC02292BA82CA28504000A3409CD3FC5BC0811F182D26D340C00101000020E6100000A05B6A193CEA5340AB7283FB80EF4BC00102000020E610000002000000A66D19659933654046D44B8941F74FC006FEF8453055624010CFF6DD82DE48400101000020E6100000ECD98CFE0E2A5840647CD677F6654AC0':::GEOGRAPHY, val_102 GEOMETRY DEFAULT '010500008006000000010200008007000000C08DFCAF783D02C2735284947BF9FEC180AC05177855EE41186B575FC57002429A9BF6362BE4F4C10034F5C3BEC6BA41CC93CDED610DFC411094FB517359EFC1AFF7D38721D2FDC17C1EF2A991FDFF4172D228C5F0B6E9C15A9406D7667AF3C138A03A536CF60142B8C8F283B5D1D4C194845A47DFBAFF41A209A8A0E97202421A09E7CBBE720042D81143452187FB4120D13195E1DDDDC1F4FAC20BF899F841BCF7845E0C660242010200008006000000D3C24B184CE1F1C1CEC73E6B1D13F3C1905160D5FBB0EC4144423C44C00002C2A82F8D1EAF9301C216FCD64C248A01C2B0C5111EBEDEF141C0CED7ECB85A01C286CE933D3196014200D7AFAFC32AB24116A65FAA835CE5C1CAA563EEEC12F44100E4A18B8EB789C15C75B5C9C35DE0C1EC52F85D960CF6C1B01D52906385DF419C875014AD6B024268A5DD0E377AF141010200008002000000129A3C20ABC500429CAE865787A3FE415CD1A9BEE178EBC1447DB1DFBB6DFCC1D6035A3B6695F3418C2C8ED244ECEC41010200008002000000B86B36FE62A8D0C130B5E48CADC9C041D1FD8AC6376201C24CEFAB4BE648ECC1D84AA7D3CB1FD04114C4AB09085AF7410102000080020000001EB435D06FC5EBC117EB66DBE1B2F6C1B218CE0F8EACF0418A000838EDDEE0C146FCDDCEE77800C2100A2555A56EC741010200008003000000029EB96827F5F7418A4E11EB1443F4C1DA6CF964197F0042B8860132C52C01423878DC5948ADDB4178AFC0957223FE41F8FCAD50A172DD4108FAC031C955D241089F1E7D7998F641':::GEOMETRY, val_103 INET DEFAULT '4ca5:f95f:30bb:ce92:bf0f:6a76:92b1:75e4/102':::INET, val_104 INT8 DEFAULT (-1457885236441114430):::INT8, val_105 INT2 DEFAULT NULL, val_106 INT2VECTOR DEFAULT ARRAY[(-128):::INT8, 27165:::INT8, 1674:::INT8], val_107 INT8 DEFAULT 1100890543:::INT8, val_108 INTERVAL DEFAULT '74 years 1 mon 660 days 08:31:06.618996':::INTERVAL, val_109 JSONB DEFAULT '[false, [false], 0.6210973491912, \"8lkq6Mih\"]':::JSONB, val_110 NAME DEFAULT e'7!\\b\\x02':::STRING:::NAME, val_112 OIDVECTOR DEFAULT ARRAY[1425615861:::OID, 0:::OID, 2964782859:::OID, 3746108893:::OID])\n\tRETURNS VARBIT\n\tLANGUAGE SQL\n\tAS $$ SELECT NULL WHERE TRUE $$"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: functions cannot have more than 100 arguments (SQLSTATE 54023)",

rafiss avatar May 21 '24 20:05 rafiss

I think https://github.com/cockroachdb/cockroach/pull/117432 was supposed to address this. @annrpom I'll send this to you so you can check it out when you get some time.

rafiss avatar May 21 '24 20:05 rafiss

roachtest.schemachange/mixed-versions failed with artifacts on master @ c7f16c96d4db6ef97085f972f094c7e4e7c1518f:

(mixedversion.go:594).Run: mixed-version test failure while running step 23 (run "run schemachange workload and validation after upgrade has finalized"): full command output in run_063356.224043953_n4_COCKROACHRANDOMSEED9.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

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

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

cockroach-teamcity avatar May 24 '24 06:05 cockroach-teamcity

roachtest.schemachange/mixed-versions failed with artifacts on master @ e5f5597b1c1570fff03ee6dfd4a1e8be65c0e008:

(mixedversion.go:612).Run: mixed-version test failure while running step 17 (run "run schemachange workload and validation in mixed version"): full command output in run_061315.885186028_n4_COCKROACHRANDOMSEED5.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=azure
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_metamorphicBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for azure clusters

Same failure on other branches

  • #124792 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.6-rc release-blocker]
  • #124722 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1.22-rc]

This test on roachdash | Improve this report!

cockroach-teamcity avatar May 30 '24 06:05 cockroach-teamcity