CiviCRM 5.13.4 - Specified key was too long; max key length is 767 bytes
Since CiviCRM 5.13.4 the following error is being reported on standard CPanel, Plesk and CentOS 6, CentOS 7 hosts using MariaDB 10.1.
May 20 10:26:22 [info] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler )
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(255))) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC ENGINE=INNODB [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
[type] => DB_Error
[user_info] => CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(255))) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC ENGINE=INNODB [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(255))) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC ENGINE=INNODB [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]"])
May 20 10:26:22 [info] $backTrace = #0 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php(952): CRM_Core_Error::backtrace("backTrace", TRUE) #1 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #3 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #4 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", "DB_Error", TRUE) #5 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7)) #6 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", "1071 ** Specified key was too long; max key length is 767 bytes") #7 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError() #8 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #9 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #10 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #11 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #12 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", TRUE) #13 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component/Env.php(914): CRM_Core_DAO::executeQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #14 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component.php(55): CRM_Utils_Check_Component_Env->checkMysqlUtf8mb4() #15 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check.php(209): CRM_Utils_Check_Component->checkAll() #16 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/api/v3/System.php(153): CRM_Utils_Check::checkAll() #17 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm_api3_system_check((Array:3)) #18 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9)) #19 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9)) #20 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("System", "check", (Array:3), NULL) #21 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/REST.php(316): civicrm_api("System", "check", (Array:3)) #22 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/REST.php(566): CRM_Utils_REST::process((Array:3), (Array:3)) #23 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(277): CRM_Utils_REST::ajax() #24 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:12)) #25 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3)) #26 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:3)) #27 /var/www/vhosts/websiteorgau.org.au/httpdocs/includes/menu.inc(527): civicrm_invoke("ajax", "rest") #28 /var/www/vhosts/websiteorgau.org.au/httpdocs/index.php(21): menu_execute_active_handler() #29 (closed) {main}
And another example.
May 21 11:40:13 [info] $backTrace = #0 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php(952): CRM_Core_Error::backtrace("backTrace", TRUE) #1 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4 _test (id VARCHAR(255), PRIMARY KEY(id(...") #3 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_t est (id VARCHAR(255), PRIMARY KEY(id(...") #4 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "CREATE TEMPORARY TA BLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", "DB_Error", TRUE) #5 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7)) #6 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), P RIMARY KEY(id(...", "1071 ** Specified key was too long; max key length is 767 bytes") #7 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError() #8 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id( ...") #9 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(.. .") #10 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY (id(...") #11 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #12 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", TR UE) #13 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component/Env.php(914): CRM_Core_DAO::executeQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #14 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component.php(55): CRM_Utils_Check_Component_Env->checkMysqlUtf8mb4() #15 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check.php(209): CRM_Utils_Check_Component->checkAll() #16 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check.php(93): CRM_Utils_Check::checkAll() #17 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Page.php(218): CRM_Utils_Check->showPeriodicAlerts() #18 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Contact/Page/DashBoard.php(69): CRM_Core_Page->run() #19 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Contact_Page_DashBoard->run((Array:1), NULL) #20 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:13)) #21 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:1)) #22 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:1)) #23 (closed) /var/www/vhosts/websiteorgau/httpdocs/includes/menu.inc(527): civicrm_invoke() #24 /var/www/vhosts/websiteorgau/httpdocs/index.php(21): menu_execute_active_handler() #25 (closed) {main}
Agileware Ref: CIVICRM-1213