{"action":"created","issue":{"url":"https://api.github.com/repos/tananaev/traccar/issues/1643","labels_url":"https://api.github.com/repos/tananaev/traccar/issues/1643/labels{/name}","comments_url":"https://api.github.com/repos/tananaev/traccar/issues/1643/comments","events_url":"https://api.github.com/repos/tananaev/traccar/issues/1643/events","html_url":"https://github.com/tananaev/traccar/issues/1643","id":125229731,"number":1643,"title":"Clean install with mysql/mariadb","user":{"login":"1sthandy","id":3943413,"avatar_url":"https://avatars.githubusercontent.com/u/3943413?v=3","gravatar_id":"","url":"https://api.github.com/users/1sthandy","html_url":"https://github.com/1sthandy","followers_url":"https://api.github.com/users/1sthandy/followers","following_url":"https://api.github.com/users/1sthandy/following{/other_user}","gists_url":"https://api.github.com/users/1sthandy/gists{/gist_id}","starred_url":"https://api.github.com/users/1sthandy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/1sthandy/subscriptions","organizations_url":"https://api.github.com/users/1sthandy/orgs","repos_url":"https://api.github.com/users/1sthandy/repos","events_url":"https://api.github.com/users/1sthandy/events{/privacy}","received_events_url":"https://api.github.com/users/1sthandy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2016-01-06T18:04:02Z","updated_at":"2016-01-23T14:58:01Z","closed_at":null,"body":"Hi,\r\ni have this error on my synology with mariadb : \r\n- i want to build a new installation\r\n- update a old db works, only admin/password login fails \r\n```\r\nSTATUS | wrapper  | 2016/01/06 18:37:30 | --> Wrapper Started as Daemon\r\nSTATUS | wrapper  | 2016/01/06 18:37:30 | Java Service Wrapper Community Edition 64-bit 3.5.27\r\nSTATUS | wrapper  | 2016/01/06 18:37:30 |   Copyright (C) 1999-2015 Tanuki Software, Ltd. All Rights Reserved.\r\nSTATUS | wrapper  | 2016/01/06 18:37:30 |     http://wrapper.tanukisoftware.com\r\nSTATUS | wrapper  | 2016/01/06 18:37:30 | \r\nSTATUS | wrapper  | 2016/01/06 18:37:30 | Launching a JVM...\r\nINFO   | jvm 1    | 2016/01/06 18:37:30 | WrapperManager: Initializing...\r\nINFO   | jvm 1    | 2016/01/06 18:37:31 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.\r\nINFO   | jvm 1    | 2016/01/06 18:37:31 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]\r\nINFO   | jvm 1    | 2016/01/06 18:37:34 | INFO 1/6/16 6:37 PM: liquibase: Successfully acquired change log lock\r\nINFO   | jvm 1    | 2016/01/06 18:37:36 | INFO 1/6/16 6:37 PM: liquibase: Reading from traccar.DATABASECHANGELOG\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WARNING 1/6/16 6:37 PM: liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | SEVERE 1/6/16 6:37 PM: liquibase: /volume1/@appstore/traccar/data/db.changelog-master.xml: /volume1/@appstore/traccar/data/db.changelog-3.0.xml::changelog-3.0::author: Change Set /volume1/@appstore/traccar/data/db.changelog-3.0.xml::changelog-3.0::author failed.  Error: Specified key was too long; max key length is 767 bytes [Failed SQL: CREATE TABLE traccar.user (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(1024) NOT NULL, email VARCHAR(256) NOT NULL, hashedPassword VARCHAR(1024) NOT NULL, salt VARCHAR(1024) DEFAULT '' NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(1024) DEFAULT 'osm' NOT NULL, language VARCHAR(1024) DEFAULT 'en' NOT NULL, distanceUnit VARCHAR(1024) DEFAULT 'km' NOT NULL, speedUnit VARCHAR(1024) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USER PRIMARY KEY (id), UNIQUE (email))]\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: CREATE TABLE traccar.user (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(1024) NOT NULL, email VARCHAR(256) NOT NULL, hashedPassword VARCHAR(1024) NOT NULL, salt VARCHAR(1024) DEFAULT '' NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(1024) DEFAULT 'osm' NOT NULL, language VARCHAR(1024) DEFAULT 'en' NOT NULL, distanceUnit VARCHAR(1024) DEFAULT 'km' NOT NULL, speedUnit VARCHAR(1024) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USER PRIMARY KEY (id), UNIQUE (email))]\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:554)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.Liquibase.update(Liquibase.java:212)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.Liquibase.update(Liquibase.java:192)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.Liquibase.update(Liquibase.java:188)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:169)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat org.traccar.database.DataManager.<init>(DataManager.java:67)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat org.traccar.Context.init(Context.java:121)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat org.traccar.Main.main(Main.java:29)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat java.lang.reflect.Method.invoke(Method.java:497)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat java.lang.Thread.run(Thread.java:745)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat java.lang.reflect.Constructor.newInstance(Constructor.java:422)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.Util.handleNewInstance(Util.java:404)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.Util.getInstance(Util.java:387)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | \t... 20 more\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | INFO 1/6/16 6:37 PM: liquibase: /volume1/@appstore/traccar/data/db.changelog-3.0.xml::changelog-3.0::author: Successfully released change log lock\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp: \r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: Encountered an error running main:\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: liquibase.exception.MigrationFailedException: Migration failed for change set /volume1/@appstore/traccar/data/db.changelog-3.0.xml::changelog-3.0::author:\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error:      Reason: liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: CREATE TABLE traccar.user (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(1024) NOT NULL, email VARCHAR(256) NOT NULL, hashedPassword VARCHAR(1024) NOT NULL, salt VARCHAR(1024) DEFAULT '' NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(1024) DEFAULT 'osm' NOT NULL, language VARCHAR(1024) DEFAULT 'en' NOT NULL, distanceUnit VARCHAR(1024) DEFAULT 'km' NOT NULL, speedUnit VARCHAR(1024) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USER PRIMARY KEY (id), UNIQUE (email))]\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:590)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.Liquibase.update(Liquibase.java:212)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.Liquibase.update(Liquibase.java:192)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.Liquibase.update(Liquibase.java:188)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:169)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat org.traccar.database.DataManager.<init>(DataManager.java:67)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat org.traccar.Context.init(Context.java:121)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat org.traccar.Main.main(Main.java:29)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat java.lang.reflect.Method.invoke(Method.java:497)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat java.lang.Thread.run(Thread.java:745)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: Caused by: liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: CREATE TABLE traccar.user (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(1024) NOT NULL, email VARCHAR(256) NOT NULL, hashedPassword VARCHAR(1024) NOT NULL, salt VARCHAR(1024) DEFAULT '' NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(1024) DEFAULT 'osm' NOT NULL, language VARCHAR(1024) DEFAULT 'en' NOT NULL, distanceUnit VARCHAR(1024) DEFAULT 'km' NOT NULL, speedUnit VARCHAR(1024) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USER PRIMARY KEY (id), UNIQUE (email))]\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:554)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \t... 15 more\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat java.lang.reflect.Constructor.newInstance(Constructor.java:422)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.Util.handleNewInstance(Util.java:404)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.Util.getInstance(Util.java:387)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \tat liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)\r\nINFO   | jvm 1    | 2016/01/06 18:37:37 | WrapperSimpleApp Error: \t... 20 more\r\nSTATUS | wrapper  | 2016/01/06 18:37:39 | <-- Wrapper Stopped\r\n```"},"comment":{"url":"https://api.github.com/repos/tananaev/traccar/issues/comments/174192042","html_url":"https://github.com/tananaev/traccar/issues/1643#issuecomment-174192042","issue_url":"https://api.github.com/repos/tananaev/traccar/issues/1643","id":174192042,"user":{"login":"gmoscalu","id":13506022,"avatar_url":"https://avatars.githubusercontent.com/u/13506022?v=3","gravatar_id":"","url":"https://api.github.com/users/gmoscalu","html_url":"https://github.com/gmoscalu","followers_url":"https://api.github.com/users/gmoscalu/followers","following_url":"https://api.github.com/users/gmoscalu/following{/other_user}","gists_url":"https://api.github.com/users/gmoscalu/gists{/gist_id}","starred_url":"https://api.github.com/users/gmoscalu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gmoscalu/subscriptions","organizations_url":"https://api.github.com/users/gmoscalu/orgs","repos_url":"https://api.github.com/users/gmoscalu/repos","events_url":"https://api.github.com/users/gmoscalu/events{/privacy}","received_events_url":"https://api.github.com/users/gmoscalu/received_events","type":"User","site_admin":false},"created_at":"2016-01-23T14:58:01Z","updated_at":"2016-01-23T14:58:01Z","body":"Another option I saw on forums is to limit the length of the index - the email index was failing, so adding the 255 limit in the email length should cover 99% of use cases.\r\n\r\nMeaning, the create table DDL:\r\n   UNIQUE(email)\r\nshould be:\r\n   UNIQUE(email(255))"}}