[
https://issues.apache.org/jira/browse/OFBIZ-8098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux updated OFBIZ-8098:
-----------------------------------
Description:
Hi Team,
During tenant creation ( and I think during the defaut laod) , Mysql is
throwinf this:
{code}
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
{code}
was:
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
> CREATE TABLE PRODUCT_PROMO_CODE_EMAIL generate error during tenant creation
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-8098
> URL: https://issues.apache.org/jira/browse/OFBIZ-8098
> Project: OFBiz
> Issue Type: Bug
> Components: ALL APPLICATIONS
> Affects Versions: Trunk
> Environment: windows / MYSQL
> Reporter: Hani Hankir
>
> Hi Team,
> During tenant creation ( and I think during the defaut laod) , Mysql is
> throwinf this:
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
