Hi Anton – installed 3.3 from scratch on a new machine using MySQL backend. However when service starts it does not create all the tables, just “databasechangelog” and “databasechangeloglock”. Can you please advise?
-Dave
INFO | jvm 1 | 2016/01/26 11:27:23 | INFO 1/26/16 11:27 AM: liquibase: C:/Program Files (x86)/Traccar/data/db.changelog-3.0.xml::changelog-3.0::author: Successfully released change log lock
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp:
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: Encountered an error running main:
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: liquibase.exception.MigrationFailedException: Migration failed for change set C:/Program Files (x86)/Traccar/data/db.changelog-3.0.xml::changelog-3.0::author:
INFO | jvm 1 | 2016/01/26 11:27:23 | 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))]
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.changelog.ChangeSet.execute(ChangeSet.java:590)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.Liquibase.update(Liquibase.java:212)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.Liquibase.update(Liquibase.java:192)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.Liquibase.update(Liquibase.java:188)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:169)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at org.traccar.database.DataManager.<init>(DataManager.java:67)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at org.traccar.Context.init(Context.java:121)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at org.traccar.Main.main(Main.java:29)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at java.lang.reflect.Method.invoke(Unknown Source)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2016/01/26 11:27:23 | 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))]
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.changelog.ChangeSet.execute(ChangeSet.java:554)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: ... 15 more
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at java.lang.reflect.Constructor.newInstance(Unknown Source)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.Util.getInstance(Util.java:387)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
INFO | jvm 1 | 2016/01/26 11:27:23 | WrapperSimpleApp Error: ... 20 more
STATUS | wrapper | 2016/01/26 11:27:26 | <-- Wrapper Stopped
ok - changing to latin1 fixed it
Hi Anton – installed 3.3 from scratch on a new machine using MySQL backend. However when service starts it does not create all the tables, just “databasechangelog” and “databasechangeloglock”. Can you please advise?
-Dave