WARNING: Problem initializing database. Specified key was too long; max key length is 767 bytes.

Serhii Administrator
Added over 4 years ago

Hello. Can you help me solve this problem.The logs writes that. And the server will not start.

2014-11-04 13:52:26.089 [main] ClConSQLRepository.initRepository() WARNING: Problem initializing database:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

    at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(

    at java.lang.reflect.Constructor.newInstance(

    at com.mysql.jdbc.Util.handleNewInstance(

    at com.mysql.jdbc.Util.getInstance(

    at com.mysql.jdbc.SQLError.createSQLException(

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(

In init.propirities file I have that:

--user-db = mysql

--user-db-uri = jdbc:mysql://host:3306/name_database?user=user&password=password&autoCreateUser=true&useUnicode=true&characterEncoding=UTF-8

--data-repo-pool-size = 10

I use Tigase 5.2.

Replies (2)

Added by Serhii Administrator over 4 years ago

Can you suggest something.

Added by Igor Karjitski over 4 years ago

Plz check out the answers in other thread: