5.20.3: TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126)
After upgrade 5.18.2 --> 5.20.3 the following error is thrown:
Jan 02 12:04:20 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.]
[type] => DB_Error
[user_info] => TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.]"]
)
Jan 02 12:04:20 [debug] $backTrace = #0 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(208): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /usr/share/php/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 /usr/share/civicrm/packages/DB.php(986): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changi...")
#3 /usr/share/php/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changi...")
#4 /usr/share/php/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changi...", "DB_Error", TRUE)
#5 /usr/share/civicrm/packages/DB/common.php(1920): PEAR->__call("raiseError", (Array:7))
#6 /usr/share/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "TRUNCATE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changi...", "1118 ** Row size too large (> 8126). Changing some columns to TEXT or BLOB or...")
#7 /usr/share/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /usr/share/civicrm/packages/DB/common.php(1229): DB_mysqli->simpleQuery("TRUNCATE civicrm_menu")
#9 /usr/share/civicrm/packages/DB/DataObject.php(2416): DB_common->query("TRUNCATE civicrm_menu")
#10 /usr/share/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("TRUNCATE civicrm_menu")
#11 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(435): DB_DataObject->query("TRUNCATE civicrm_menu")
#12 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1428): CRM_Core_DAO->query("TRUNCATE civicrm_menu", TRUE)
#13 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Menu.php(304): CRM_Core_DAO::executeQuery("TRUNCATE civicrm_menu")
#14 /usr/share/civicrm/CRM/Upgrade/Page/Upgrade.php(105): CRM_Core_Menu::store()
#15 /usr/share/civicrm/CRM/Upgrade/Page/Upgrade.php(73): CRM_Upgrade_Page_Upgrade->runIntro()
#16 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(284): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#17 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#18 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#19 /usr/share/wordpress/wp-content/plugins/civicrm/civicrm.php(1466): CRM_Core_Invoke::invoke((Array:2))
#20 /usr/share/wordpress/wp-includes/class-wp-hook.php(286): CiviCRM_For_WordPress->invoke("")
#21 /usr/share/wordpress/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
#22 /usr/share/wordpress/wp-includes/plugin.php(453): WP_Hook->do_action((Array:1))
#23 /usr/share/wordpress/wp-admin/admin.php(224): do_action("toplevel_page_CiviCRM")
#24 {main}
Because of this problem I could not run DB schema upgrade as the web page show DB Error: unknown error
(Catch-22?).
The following StackExchange questions might be relevant:
What is the recommended remedy, if that's a known problem? Thanks.