CREATE TABLE Cache (
Id varchar(449) CHARACTER SET utf8mb4 NOT NULL,
Value longblob NULL,
ExpiresAtTime datetime(6) NOT NULL,
SlidingExpirationInSeconds bigint NULL,
AbsoluteExpiration datetime(6) NULL,
CONSTRAINT PK_Cache PRIMARY KEY (Id)
) CHARACTER SET=utf8mb4;
MySqlConnector.MySqlException (0x80004005): Specified key was too long; max key length is 1000 bytes
when migrating from 2024.6.2 to 2024.8.2 on a qnap nas x86 using mariadb 10
Failed executing DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
CREATE TABLE
Cache(Idvarchar(449) CHARACTER SET utf8mb4 NOT NULL,Valuelongblob NULL,ExpiresAtTimedatetime(6) NOT NULL,SlidingExpirationInSecondsbigint NULL,AbsoluteExpirationdatetime(6) NULL, CONSTRAINTPK_CachePRIMARY KEY (Id) ) CHARACTER SET=utf8mb4;MySqlConnector.MySqlException (0x80004005): Specified key was too long; max key length is 1000 bytes