Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Resolved
-
Trunk
-
None
-
None
-
windows / MYSQL
Description
Hi Team,
During tenant creation ( and I think during the defaut laod) , Mysql is throwinf this:
2016-08-31 15:41:49,279 |pool-5-thread-1 |DatabaseUtil |E| Could not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following: CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID, EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes 2016-08-31 15:42:11,169 |pool-3-thread-1 |DatabaseUtil |E| Could not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following: CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID, EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes 2016-08-31 15:42:43,160 |pool-7-thread-1 |DatabaseUtil |E| Could not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following: CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID, EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes 2016-08-31 15:51:46,356 |pool-3-thread-1 |DatabaseUtil |E| Could not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following: CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID, EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes 2016-08-31 15:51:57,493 |pool-7-thread-1 |DatabaseUtil |E| Could not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following: CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID, EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
Attachments
Issue Links
- relates to
-
OFBIZ-5426 mysql: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- Closed