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.

Sign up for GitHub

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

Jump to bottom

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

Closed
cockroach-teamcity opened this issue May 19, 2024 · 4 comments · Fixed by #124892
Closed

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

cockroach-teamcity opened this issue May 19, 2024 · 4 comments · Fixed by #124892
Assignees
@annrpom
Labels
branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. P-2 Issues/test failures with a fix SLA of 3 months T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Foundations

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented May 19, 2024 •
edited by cockroach-jira-scripts

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-38863
@cockroach-teamcity cockroach-teamcity added branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels May 19, 2024
@cockroach-teamcity cockroach-teamcity mentioned this issue May 21, 2024
Closed
@rafiss
Copy link
Collaborator

rafiss commented May 21, 2024 

  {
   "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 rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label May 21, 2024
@rafiss rafiss changed the title roachtest: schemachange/mixed-versions failed roachtest: schemachange/mixed-versions failed [functions cannot have more than 100 arguments] May 21, 2024
@rafiss rafiss added the P-2 Issues/test failures with a fix SLA of 3 months label May 21, 2024
@rafiss
Copy link
Collaborator

rafiss commented May 21, 2024

I think #117432 was supposed to address this. @annrpom I'll send this to you so you can check it out when you get some time.

@cockroach-teamcity
Copy link
Member Author

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!

This was referenced May 27, 2024
Open
Open
@cockroach-teamcity
Copy link
Member Author

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

This test on roachdash | Improve this report!

@cockroach-teamcity cockroach-teamcity mentioned this issue May 30, 2024
Closed
@rafiss rafiss mentioned this issue May 31, 2024
Merged
@craig craig bot closed this as completed in d523f75 May 31, 2024
SQL Foundations automation moved this from Triage to Done May 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@annrpom annrpom

Labels
branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. P-2 Issues/test failures with a fix SLA of 3 months T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Foundations
  
Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

workload/schemachange: avoid more than 99 UDF parameters rafiss/cockroach
3 participants
@rafiss @cockroach-teamcity @annrpom