Specified key was too long; max key length is 3072 bytes

[hawkingrei]

 2022/02/15 13:44:28 ddl.go:96: [fatal] [error] [instance 2] ERROR: Error when executing SQL: ALTER TABLE `dcf1b71b-19ab-4580-9b4c-78386d80b5bd` ADD INDEX `99da2b23-e887-4e5d-aa6f-86baac8c3f53` (`e36be50e-2d1f-4536-b54d-be2426c21bff`, `d341b614-a15e-4b7f-9395-da11ae0ae0c8`, `e542ea6d-f151-403d-8992-fb80172a5c3b`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, `1f8e476a-0da6-4093-8ef0-7bec823589f6`, `6602e231-f9aa-416a-ad5d-b0c06f4bca97`, `d975de0e-5af7-4454-b91b-c0712001bd6e`, `4c0873f3-4737-4ded-8aca-f2892d39331e`, `260eaf83-d153-44fd-a851-607ff86493a6`, `b9c7a268-3f64-4980-a561-6f9016d2a69b`)
 remote tidb Err: &mysql.MySQLError{Number:0x42f, Message:"Specified key was too long; max key length is 3072 bytes"}
======== DEBUG BEGIN  ========
Dumping expected contents for table `dcf1b71b-19ab-4580-9b4c-78386d80b5bd`:
Comment: 8c777b38-f4a7-4bbc-8e7d-c66a82139997
Charset: utf8mb4, Collate: utf8mb4_bin
ShardRowId: 6
AutoID: 0
## Non-Primary Indexes: 
Index #0: Name = `02255e23-9092-4008-9c45-37372e5cde82`, Columnns = [`edba1d77-27de-434d-be75-b0c8e0779178`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, ]
Index #1: Name = `f9a8789d-227f-477a-a4cd-35e0367c7376`, Columnns = [`edba1d77-27de-434d-be75-b0c8e0779178`, ]
Index #2: Name = `fc8531d4-a092-4369-93a1-7eb6078d25ca`, Columnns = [`edba1d77-27de-434d-be75-b0c8e0779178`, `62d867e1-b35b-436d-b36c-381f37e62f3b`, `84e657cd-3942-45a4-a574-d0ae499c0486`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, ]
Index #3: Name = `4922eddb-d3f1-4313-aee9-5d69f0d4f6ec`, Columnns = [`99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, ]
Index #4: Name = `b224a0e9-99cc-4710-a8ce-32be71945845`, Columnns = [`62d867e1-b35b-436d-b36c-381f37e62f3b`, ]
Index #5: Name = `17eaf286-b885-4e02-a836-133314eb1b26`, Columnns = [`7861afe5-6781-4e89-85ba-f6091e96fc39`, ]
Index #6: Name = `2c05728c-2676-4f58-a8ea-16eda9fa77c4`, Columnns = [`288b43a9-5b9f-4bf9-849f-8407f9821084`, ]
Index #7: Name = `7f8d374a-9940-41ea-ad91-74476e3bdc3c`, Columnns = [`e542ea6d-f151-403d-8992-fb80172a5c3b`, ]
Index #8: Name = `22cbe9b2-7ee6-43c6-ab76-a60f036df5a5`, Columnns = [`7861afe5-6781-4e89-85ba-f6091e96fc39`, `e542ea6d-f151-403d-8992-fb80172a5c3b`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, `62d867e1-b35b-436d-b36c-381f37e62f3b`, `260eaf83-d153-44fd-a851-607ff86493a6`, ]
Index #9: Name = `6f3b2d74-d4fc-4b67-8a0c-da1d7a3caa39`, Columnns = [`7861afe5-6781-4e89-85ba-f6091e96fc39`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, `288b43a9-5b9f-4bf9-849f-8407f9821084`, ]
Index #10: Name = `34933cdc-4376-4e65-bfbb-d59293cb1935`, Columnns = [`e542ea6d-f151-403d-8992-fb80172a5c3b`, `d975de0e-5af7-4454-b91b-c0712001bd6e`, `260eaf83-d153-44fd-a851-607ff86493a6`, `1fb5e9a2-edc6-443f-b928-17e67755a0f3`, ]
Index #11: Name = `a0c79947-38be-4911-87e0-72bfa3951c08`, Columnns = [`1f8e476a-0da6-4093-8ef0-7bec823589f6`, ]
Index #12: Name = `3976ddaa-3bc5-4368-854f-e6f22ba8905a`, Columnns = [`16c1d70c-b371-457a-b907-37e1686b0169`, ]
Index #13: Name = `16684cdb-1e74-4e90-bff0-b26b78041b1b`, Columnns = [`288b43a9-5b9f-4bf9-849f-8407f9821084`, `16c1d70c-b371-457a-b907-37e1686b0169`, `6602e231-f9aa-416a-ad5d-b0c06f4bca97`, `d975de0e-5af7-4454-b91b-c0712001bd6e`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, `1f8e476a-0da6-4093-8ef0-7bec823589f6`, `62d867e1-b35b-436d-b36c-381f37e62f3b`, `260eaf83-d153-44fd-a851-607ff86493a6`, `1fb5e9a2-edc6-443f-b928-17e67755a0f3`, `e542ea6d-f151-403d-8992-fb80172a5c3b`, ]
Index #14: Name = `52e1f8f6-656f-4078-abd4-55800b243ec0`, Columnns = [`1fb5e9a2-edc6-443f-b928-17e67755a0f3`, `260eaf83-d153-44fd-a851-607ff86493a6`, `62d867e1-b35b-436d-b36c-381f37e62f3b`, `6602e231-f9aa-416a-ad5d-b0c06f4bca97`, `288b43a9-5b9f-4bf9-849f-8407f9821084`, `e542ea6d-f151-403d-8992-fb80172a5c3b`, `16c1d70c-b371-457a-b907-37e1686b0169`, `d975de0e-5af7-4454-b91b-c0712001bd6e`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, ]
Index #15: Name = `563f8074-190c-4865-96e0-dc77b3f8399e`, Columnns = [`de03f96a-54ed-419e-8cc3-3c88457ddc6a`, ]
Index #16: Name = `01a795ee-2d81-42f9-bcdf-76d7aa3c0cad`, Columnns = [`e36be50e-2d1f-4536-b54d-be2426c21bff`, `4c0873f3-4737-4ded-8aca-f2892d39331e`, `d341b614-a15e-4b7f-9395-da11ae0ae0c8`, `62d867e1-b35b-436d-b36c-381f37e62f3b`, `d975de0e-5af7-4454-b91b-c0712001bd6e`, `de03f96a-54ed-419e-8cc3-3c88457ddc6a`, `16c1d70c-b371-457a-b907-37e1686b0169`, `e542ea6d-f151-403d-8992-fb80172a5c3b`, `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, `1f8e476a-0da6-4093-8ef0-7bec823589f6`, ]
Index #17: Name = `7da3bf25-f553-42a4-b009-8f9a6060efa5`, Columnns = [`62d867e1-b35b-436d-b36c-381f37e62f3b`, `e36be50e-2d1f-4536-b54d-be2426c21bff`, `16c1d70c-b371-457a-b907-37e1686b0169`, `d975de0e-5af7-4454-b91b-c0712001bd6e`, `e542ea6d-f151-403d-8992-fb80172a5c3b`, `4c0873f3-4737-4ded-8aca-f2892d39331e`, `1fb5e9a2-edc6-443f-b928-17e67755a0f3`, `de03f96a-54ed-419e-8cc3-3c88457ddc6a`, `1f8e476a-0da6-4093-8ef0-7bec823589f6`, ]
Index #18: Name = `44d28173-8a63-4b5e-9ca4-d635f2ccfcd8`, Columnns = [`e36be50e-2d1f-4536-b54d-be2426c21bff`, ]
Index #19: Name = `c7a69313-9f11-4389-885e-dd13cef1fad3`, Columnns = [`b9c7a268-3f64-4980-a561-6f9016d2a69b`, ]
Index #20: Name = `60bc2063-ba88-423c-9fe9-d89c8313972c`, Columnns = [`e36be50e-2d1f-4536-b54d-be2426c21bff`, `4c0873f3-4737-4ded-8aca-f2892d39331e`, `16c1d70c-b371-457a-b907-37e1686b0169`, `b9c7a268-3f64-4980-a561-6f9016d2a69b`, `1f8e476a-0da6-4093-8ef0-7bec823589f6`, `d975de0e-5af7-4454-b91b-c0712001bd6e`, `260eaf83-d153-44fd-a851-607ff86493a6`, `288b43a9-5b9f-4bf9-849f-8407f9821084`, `e542ea6d-f151-403d-8992-fb80172a5c3b`, `de03f96a-54ed-419e-8cc3-3c88457ddc6a`, ]
## Columns: 
Column #0: Name = `e36be50e-2d1f-4536-b54d-be2426c21bff`, Definition = VARCHAR(220) NULL DEFAULT 'yktwosdalt6gg7zit9l0j5u4jlyunhd1jqfpa8iv7509v3ucvdx69uglxdci', isPrimaryKey = false, used in 9 indexes
Column #1: Name = `1f8e476a-0da6-4093-8ef0-7bec823589f6`, Definition = DATETIME NULL DEFAULT '3781-12-13 00:20:19', isPrimaryKey = false, used in 4 indexes
Column #2: Name = `16c1d70c-b371-457a-b907-37e1686b0169`, Definition = SMALLINT NULL DEFAULT '-9951', isPrimaryKey = false, used in 6 indexes
Column #3: Name = `62d867e1-b35b-436d-b36c-381f37e62f3b`, Definition = DOUBLE NULL DEFAULT '1.8691002715233689', isPrimaryKey = false, used in 6 indexes
Column #4: Name = `4c0873f3-4737-4ded-8aca-f2892d39331e`, Definition = YEAR NULL DEFAULT '2090', isPrimaryKey = false, used in 3 indexes
Column #5: Name = `d975de0e-5af7-4454-b91b-c0712001bd6e`, Definition = CHAR(240) NULL DEFAULT 'jomzvbnah1iyhvx55i2hhbrfwnv6rcznpltux', isPrimaryKey = false, used in 6 indexes
Column #6: Name = `288b43a9-5b9f-4bf9-849f-8407f9821084`, Definition = DATE NULL DEFAULT '1937-12-30', isPrimaryKey = false, used in 5 indexes
Column #7: Name = `99688b10-1c7e-45b2-bfa2-7a0cc206fb6f`, Definition = SET("hzw", "nmdvu", "en", "xku51", "4qf", "uz8", "aiw2", "xgvaf", "jlbr", "pujp", "yq") NULL DEFAULT 'nmdvu,xku51,4qf,uz8,aiw2,jlbr,yq', isPrimaryKey = false, used in 8 indexes
Column #8: Name = `260eaf83-d153-44fd-a851-607ff86493a6`, Definition = CHAR(222) NULL DEFAULT '43hy3r0f9u160fpky3nclvik79fm0v5gc3dxjda3pruesbwrcp0w30lyjsshjwbbtrz755z44saftoxrgh', isPrimaryKey = false, used in 5 indexes
Column #9: Name = `d341b614-a15e-4b7f-9395-da11ae0ae0c8`, Definition = DATE NULL DEFAULT '4699-09-17', isPrimaryKey = false, used in 1 indexes
Column #10: Name = `de03f96a-54ed-419e-8cc3-3c88457ddc6a`, Definition = BIGINT NULL DEFAULT '-7733994444691196906', isPrimaryKey = false, used in 8 indexes
Column #11: Name = `1fb5e9a2-edc6-443f-b928-17e67755a0f3`, Definition = YEAR NULL DEFAULT '2107', isPrimaryKey = false, used in 3 indexes
Column #12: Name = `6602e231-f9aa-416a-ad5d-b0c06f4bca97`, Definition = CHAR(170) NULL DEFAULT '', isPrimaryKey = false, used in 2 indexes
Column #13: Name = `e542ea6d-f151-403d-8992-fb80172a5c3b`, Definition = BIGINT NULL DEFAULT '-8520556191327034042', isPrimaryKey = false, used in 8 indexes
Column #14: Name = `b9c7a268-3f64-4980-a561-6f9016d2a69b`, Definition = FLOAT NULL DEFAULT '1.4471784', isPrimaryKey = false, used in 2 indexes
## Values (number of rows = 0): 
======== DEBUG END ========