[SYNCOPE-1065] Failure deploying with mysql/mariadb as internal storage

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 2.0.3
• Component/s: core
• Environment: Real environment with MySQL/MariaDB as internal storage
• Assignee: Francesco Chicchiriccò
• Reporter: Fabio Martelli
• Created: 10/Apr/17 14:47
• Updated: 11/Apr/17 07:48
• Resolved: 11/Apr/17 07:48

Description

At DB initialization time the following exception is raised.

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:70) Specified key was too long; max key length is 767 bytes
Query is : CREATE TABLE AccessToken (id VARCHAR(255) NOT NULL, body TEXT, expiryTime DATETIME, owner VARCHAR(255), PRIMARY KEY (id)) ENGINE = innodb

{stmnt 131207471 CREATE TABLE AccessToken (id VARCHAR(255) NOT NULL, body TEXT, expiryTime DATETIME, owner VARCHAR(255), PRIMARY KEY (id)) ENGINE = innodb}

[code=1071, state=42000]