ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help

Open Michael2008S opened this issue 1 year ago • 0 comments

When create mxk_userinfo table meet below issue:

MariaDB [maxkey]> SHOW VARIABLES LIKE 'innodb_page_size';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| innodb_page_size | 16384 |
+------------------+-------+
1 row in set (0.001 sec)

MariaDB [maxkey]> CREATE TABLE `mxk_userinfo` (
    ->   `ID` varchar(45) NOT NULL COMMENT 'ç¼å·',
    ->   `USERNAME` varchar(100) NOT NULL COMMENT 'ç»å½å',
    ->   `PASSWORD` varchar(500) NOT NULL COMMENT 'å¯ç ',
    ->   `DECIPHERABLE` varchar(500) NOT NULL COMMENT 'DEå¯ç ',
    ->   `AUTHNTYPE` tinyint unsigned DEFAULT '1' COMMENT 'è®¤è¯ç±»å',
    ->   `MOBILE` varchar(45) DEFAULT NULL COMMENT 'ææºå·ç ',
    ->   `MOBILEVERIFIED` varchar(45) DEFAULT NULL COMMENT 'ææºå·éªè¯',
    ->   `EMAIL` varchar(45) DEFAULT NULL COMMENT 'é®ç®±',
    ->   `EMAILVERIFIED` smallint unsigned DEFAULT NULL COMMENT 'é®ç®±éªè¯',
    ->   `DISPLAYNAME` varchar(45) DEFAULT NULL COMMENT 'æ¾ç¤ºåç§°',
    ->   `NICKNAME` varchar(45) DEFAULT NULL COMMENT 'æµç§°',
    ->   `PICTURE` longblob COMMENT 'å¤´å',
    ->   `TIMEZONE` varchar(45) DEFAULT 'Asia/Shanghai' COMMENT 'æ¶åº',
    ->   `LOCALE` varchar(45) DEFAULT 'zh_CN' COMMENT 'å°å',
    ->   `PREFERREDLANGUAGE` varchar(45) DEFAULT 'zh_CN' COMMENT 'è¯è¨åå¥½',
    ->   `PASSWORDQUESTION` varchar(45) DEFAULT NULL COMMENT 'å¯ç é®é¢',
    ->   `PASSWORDANSWER` varchar(45) DEFAULT NULL COMMENT 'å¯ç çæ¡',
    ->   `APPLOGINAUTHNTYPE` tinyint unsigned DEFAULT '0' COMMENT 'åºç¨ç»å½è®¤è¯ç±»å',
    ->   `APPLOGINPASSWORD` varchar(45) DEFAULT NULL COMMENT 'åºç¨ç»å½å¯ç ',
    ->   `PROTECTEDAPPS` varchar(450) DEFAULT NULL COMMENT 'åºç¨ç»å½å¯ç ä¿æ¤åºç¨',
    ->   `THEME` varchar(45) DEFAULT 'default' COMMENT 'ä¸»é¢',
    ->   `GRIDLIST` tinyint unsigned DEFAULT '0' COMMENT 'åºç¨åè¡¨ç±»å',
    ->   `LOGINCOUNT` int unsigned DEFAULT '0' COMMENT 'ç»å½æ¬¡æ°ç»è®¡',
    ->   `ONLINE` tinyint unsigned DEFAULT '0' COMMENT 'å¨çº¿ç¶æ',
    ->   `STATUS` tinyint unsigned DEFAULT '1' COMMENT 'ç¨æ·ç¶æ',
    ->   `ISLOCKED` tinyint unsigned DEFAULT '1' COMMENT 'éå®ç¶æ',
    ->   `UNLOCKTIME` datetime DEFAULT '2020-01-01 01:01:01' COMMENT 'è§£éæ¶é´',
    ->   `LASTLOGINIP` varchar(300) DEFAULT NULL COMMENT 'æè¿ç»å½IPå°å',
    ->   `LASTLOGINTIME` datetime DEFAULT '2020-01-01 01:01:01' COMMENT 'æè¿ç»å½æ¶é´',
    ->   `LASTLOGOFFTIME` datetime DEFAULT '2020-01-01 01:01:01' COMMENT 'æè¿æ³¨éæ¶é´',
    ->   `BADPASSWORDTIME` datetime DEFAULT '2020-01-01 01:01:01' COMMENT 'æè¿å¯ç éè¯¯æ¶é´',
    ->   `BADPASSWORDCOUNT` smallint unsigned DEFAULT NULL COMMENT 'å¯ç éè¯¯æ¬¡æ°',
    ->   `PASSWORDLASTSETTIME` datetime DEFAULT '2020-01-01 01:01:01' COMMENT 'æè¿å¯ç ä¿®æ¹æ¶é´',
    ->   `PASSWORDSETTYPE` tinyint unsigned DEFAULT '0' COMMENT 'å¯ç éç½®ç±»å',
    ->   `SHAREDSECRET` varchar(500) DEFAULT NULL COMMENT 'TIME-OPTå¯é¥',
    ->   `SHAREDCOUNTER` varchar(45) DEFAULT '0' COMMENT 'COUNTER-OPTå¯é¥',
    ->   `USERTYPE` varchar(45) DEFAULT 'Customer' COMMENT 'ç¨æ·ç±»å',
    ->   `USERSTATE` varchar(45) DEFAULT 'RESIDENT',
    ->   `EMPLOYEENUMBER` varchar(45) DEFAULT NULL COMMENT 'å·¥å·',
    ->   `WINDOWSACCOUNT` varchar(45) DEFAULT NULL COMMENT 'ADåè´¦å·',
    ->   `DIVISION` varchar(45) DEFAULT NULL COMMENT 'åæ¯',
    ->   `COSTCENTER` varchar(45) DEFAULT NULL COMMENT 'ææ¬ä¸å¿',
    ->   `ORGANIZATION` varchar(45) DEFAULT NULL COMMENT 'æºæ',
    ->   `DEPARTMENTID` varchar(45) DEFAULT NULL COMMENT 'é¨é¨ç¼å·',
    ->   `DEPARTMENT` varchar(45) DEFAULT NULL COMMENT 'é¨é¨',
    ->   `JOBTITLE` varchar(45) DEFAULT NULL COMMENT 'èå¡',
    ->   `JOBLEVEL` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½èçº§',
    ->   `MANAGERID` varchar(45) DEFAULT NULL COMMENT 'ç»çç¼å·',
    ->   `MANAGER` varchar(45) DEFAULT NULL COMMENT 'ç»çåå',
    ->   `ASSISTANTID` varchar(45) DEFAULT NULL COMMENT 'å©çç¼å·',
    ->   `ASSISTANT` varchar(45) DEFAULT NULL COMMENT 'å©çåå',
    ->   `ENTRYDATE` varchar(45) DEFAULT NULL COMMENT 'å¥å¸æ¶é´',
    ->   `STARTWORKDATE` varchar(45) DEFAULT NULL COMMENT 'å¼å§å·¥ä½æ¶é´',
    ->   `QUITDATE` varchar(45) DEFAULT NULL COMMENT 'ç¦»èæ¥æ',
    ->   `SORTORDER` tinyint unsigned DEFAULT '1' COMMENT 'é¨é¨åæåº',
    ->   `WORKEMAIL` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-é®ä»¶',
    ->   `WORKPHONENUMBER` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-çµè¯',
    ->   `WORKCOUNTRY` varchar(45) DEFAULT 'CHN' COMMENT 'å·¥ä½-å½å®¶',
    ->   `WORKREGION` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-ç/å¸',
    ->   `WORKLOCALITY` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-åå¸',
    ->   `WORKSTREETADDRESS` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-è¡é',
    ->   `WORKADDRESSFORMATTED` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-å°åå¨ç§°',
    ->   `WORKPOSTALCODE` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-é®ç¼',
    ->   `WORKFAX` varchar(45) DEFAULT NULL COMMENT 'å·¥ä½-ä¼ ç',
    ->   `WORKOFFICENAME` varchar(500) DEFAULT NULL,
    ->   `GIVENNAME` varchar(45) DEFAULT NULL COMMENT 'å',
    ->   `MIDDLENAME` varchar(45) DEFAULT NULL COMMENT 'ä¸é´å',
    ->   `FAMILYNAME` varchar(45) DEFAULT NULL COMMENT 'å§',
    ->   `HONORIFICPREFIX` varchar(45) DEFAULT NULL COMMENT 'åç¼',
    ->   `HONORIFICSUFFIX` varchar(45) DEFAULT NULL COMMENT 'åç¼',
    ->   `FORMATTEDNAME` varchar(400) DEFAULT NULL COMMENT 'ç¨æ·å¨å',
    ->   `IDTYPE` tinyint unsigned DEFAULT '0' COMMENT 'è¯ä»¶ç±»å',
    ->   `IDCARDNO` varchar(45) DEFAULT NULL COMMENT 'è¯ä»¶å·ç ',
    ->   `EDUCATION` varchar(200) DEFAULT NULL COMMENT 'å¦å',
    ->   `GRADUATEFROM` varchar(500) DEFAULT NULL COMMENT 'æ¯ä¸é¢æ ¡',
    ->   `GRADUATEDATE` varchar(45) DEFAULT NULL COMMENT 'æ¯ä¸æ¥æ',
    ->   `MARRIED` tinyint unsigned DEFAULT '0' COMMENT 'å©å§»ç¶æ',
    ->   `BIRTHDATE` varchar(45) DEFAULT NULL COMMENT 'çæ¥',
    ->   `NAMEZHSPELL` varchar(100) DEFAULT NULL COMMENT 'ååä¸ææ¼é³',
    ->   `NAMEZHSHORTSPELL` varchar(45) DEFAULT NULL COMMENT 'ååä¸ææ¼é³ç®ç§°',
    ->   `GENDER` tinyint unsigned DEFAULT NULL COMMENT 'æ§å«',
    ->   `WEBSITE` varchar(50) DEFAULT NULL COMMENT 'ä¸ªäººä¸»é¡µ',
    ->   `WEIXINFOLLOW` tinyint unsigned DEFAULT NULL COMMENT 'å¾®ä¿¡å³æ³¨',
    ->   `DEFINEIM` varchar(45) DEFAULT NULL COMMENT 'IMè´¦å·',
    ->   `HOMEEMAIL` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-é®ä»¶',
    ->   `HOMEPHONENUMBER` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-çµè¯',
    ->   `HOMECOUNTRY` varchar(45) DEFAULT 'CHN' COMMENT 'å®¶åº-ç/å¸',
    ->   `HOMEREGION` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-å¸',
    ->   `HOMELOCALITY` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-åº',
    ->   `HOMESTREETADDRESS` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-è¡é',
    ->   `HOMEADDRESSFORMATTED` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-å°åå¨ç§°',
    ->   `HOMEPOSTALCODE` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-é®ç¼',
    ->   `HOMEFAX` varchar(45) DEFAULT NULL COMMENT 'å®¶åº-ä¼ ç',
    ->   `EXTRAATTRIBUTE` varchar(4000) DEFAULT NULL COMMENT 'ç¨æ·æ©å±å±æ§',
    ->   `CREATEDBY` varchar(45) DEFAULT NULL COMMENT 'åå»ºäºº',
    ->   `CREATEDDATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'åå»ºæ¶é´',
    ->   `MODIFIEDBY` varchar(45) DEFAULT NULL COMMENT 'ä¿®æ¹äºº',
    ->   `MODIFIEDDATE` datetime DEFAULT NULL COMMENT 'ä¿®æ¹æ¶é´',
    ->   `DESCRIPTION` varchar(400) DEFAULT NULL COMMENT 'æè¿°',
    ->   `LDAPDN` varchar(1000) DEFAULT NULL,
    ->   `INSTID` varchar(45) NOT NULL,
    ->   `Regionhistory` text,
    ->   `passwordhistory` text,
    ->   PRIMARY KEY (`ID`),
    ->   UNIQUE KEY `USERNAME_UNIQUE` (`USERNAME`),
    ->   KEY `EMPLOYEENUMBER_UNIQUE` (`EMPLOYEENUMBER`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='USER INFO DEFINE';
ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

Jan 27 '24 09:01 Michael2008S