ERROR 1071 (42000) in upgrade CR09
Article ID: 116622
Updated On:
Products
CA API Developer Portal
CA API Gateway
Issue/Introduction
When trying to upgrade our CA Developer Portal from v3.5 CR00 to v3.5 CR09.
We have been following the instructions of the official guide. But we have a problem. When we execute the .sh file we receive this message in the prompt
"ERROR 1071 (42000) at line 1: Specified key was too long; max key length is 1000 bytes".
We have been following the instructions of the official guide. But we have a problem. When we execute the .sh file we receive this message in the prompt
"ERROR 1071 (42000) at line 1: Specified key was too long; max key length is 1000 bytes".
Environment
Release:
Component: APIPRD
Component: APIPRD
Cause
The key auditlog_path on the auditlog table is set to 1000 bytes and the switch to character set utf8mb4 and collation utf8mb4_unicode_ci required by the upgrade to Portal 3.5 CR9 is invalid.
Resolution
Run the following 2 alter commands against the lrs DB.
alter table auditlog drop key auditlog_path;
alter table auditlog add key auditlog_path (path(250));
alter table auditlog drop key auditlog_path;
alter table auditlog add key auditlog_path (path(250));
Additional Information
The auditlog_path is not used for any functionality and is safe to remove.
We will remove this key automatically in the next CR.
Planned for inclusion in CR10.
We will remove this key automatically in the next CR.
Planned for inclusion in CR10.
Feedback
Yes
No
Powered by
