Upgrade 3.7 to 3.8 windows + MSSQL

brant.felix8 years ago

Are there steps for performing the upgrade form 3.7 to 3.8. I tried installing 3.8 a few times and get this everytime.

WARNING|wrapper|Service traccar|16-11-30 04:23:30|YAJSW: yajsw-beta-12.07
WARNING|wrapper|Service traccar|16-11-30 04:23:30|OS   : Windows Server 2012 R2/6.3/amd64
WARNING|wrapper|Service traccar|16-11-30 04:23:30|JVM  : Oracle Corporation/1.8.0_91/C:\Program Files\Java\jre1.8.0_91/64
INFO|wrapper|Service traccar|16-11-30 04:23:30|start delay: 0
INFO|wrapper|Service traccar|16-11-30 04:23:30|started process with pid 2852
INFO|2852/0|Service traccar|16-11-30 04:23:30|[INFO] StandardFileSystemManager - Using "C:\Windows\TEMP\vfs_cache" as temporary files store.
INFO|2852/0|Service traccar|16-11-30 04:23:31|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started.
INFO|2852/0|Service traccar|16-11-30 04:23:31|[main] INFO com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Driver does not support get/set network timeout for connections. (This operation is not supported.)
INFO|2852/0|Service traccar|16-11-30 04:23:32|INFO 11/30/16 4:23 AM: liquibase: Clearing database change log checksums
INFO|2852/0|Service traccar|16-11-30 04:23:32|INFO 11/30/16 4:23 AM: liquibase: Successfully acquired change log lock
INFO|2852/0|Service traccar|16-11-30 04:23:32|INFO 11/30/16 4:23 AM: liquibase: Successfully released change log lock
INFO|2852/0|Service traccar|16-11-30 04:23:32|INFO 11/30/16 4:23 AM: liquibase: Successfully acquired change log lock
INFO|2852/0|Service traccar|16-11-30 04:23:33|INFO 11/30/16 4:23 AM: liquibase: Reading from [dbo].[DATABASECHANGELOG]
INFO|2852/0|Service traccar|16-11-30 04:23:33|INFO 11/30/16 4:23 AM: liquibase: Reading from [dbo].[DATABASECHANGELOG]
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Table attribute_aliases created
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Foreign key constraint added to attribute_aliases (deviceid)
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Unique constraint added to attribute_aliases(deviceid, attribute)
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Data updated in users
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Data updated in users
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Data updated in users
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Table statistics created
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: server.mapurl datatype was changed to VARCHAR(512)
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns forcesettings(BOOLEAN) added to server
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns coordinateformat(VARCHAR(128)) added to users
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns coordinateformat(VARCHAR(128)) added to server
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Null constraint dropped from positions.attributes
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: positions.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:34|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Null constraint dropped from events.attributes
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: events.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Null constraint dropped from geofences.attributes
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: geofences.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Null constraint dropped from notifications.attributes
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: notifications.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: users.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: devices.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: groups.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: server.attributes datatype was changed to VARCHAR(4000)
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns phone(VARCHAR(128)) added to devices
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns model(VARCHAR(128)) added to devices
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns contact(VARCHAR(512)) added to devices
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns category(VARCHAR(128)) added to devices
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns disabled(BOOLEAN) added to users
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns expirationtime(TIMESTAMP) added to users
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns devicelimit(INT) added to users
INFO|2852/0|Service traccar|16-11-30 04:23:36|INFO 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns token(VARCHAR(128)) added to users
INFO|2852/0|Service traccar|16-11-30 04:23:38|SEVERE 11/30/16 4:23 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Change Set changelog-3.8::changelog-3.8::author failed.  Error: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.users' and the index name 'uk_user_token'. The duplicate key value is (<NULL>). [Failed SQL: ALTER TABLE [dbo].[users] ADD CONSTRAINT [uk_user_token] UNIQUE ([token])]
INFO|2852/0|Service traccar|16-11-30 04:23:38|INFO 11/30/16 4:23 AM: liquibase: changelog-3.8::changelog-3.8::author: Successfully released change log lock
INFO|2852/0|Service traccar|16-11-30 04:23:38|java.lang.reflect.InvocationTargetException
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at java.lang.reflect.Method.invoke(Unknown Source)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2852/0|Service traccar|16-11-30 04:23:38|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.8::changelog-3.8::author:
INFO|2852/0|Service traccar|16-11-30 04:23:38|     Reason: liquibase.exception.DatabaseException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.users' and the index name 'uk_user_token'. The duplicate key value is (<NULL>). [Failed SQL: ALTER TABLE [dbo].[users] ADD CONSTRAINT [uk_user_token] UNIQUE ([token])]
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.Liquibase.update(Liquibase.java:214)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.Liquibase.update(Liquibase.java:192)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.Liquibase.update(Liquibase.java:188)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:142)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at org.traccar.database.DataManager.<init>(DataManager.java:68)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at org.traccar.Context.init(Context.java:167)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at org.traccar.Main.main(Main.java:35)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
... 6 more
INFO|2852/0|Service traccar|16-11-30 04:23:38|Caused by: liquibase.exception.DatabaseException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.users' and the index name 'uk_user_token'. The duplicate key value is (<NULL>). [Failed SQL: ALTER TABLE [dbo].[users] ADD CONSTRAINT [uk_user_token] UNIQUE ([token])]
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
... 15 more
INFO|2852/0|Service traccar|16-11-30 04:23:38|Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.users' and the index name 'uk_user_token'. The duplicate key value is (<NULL>).
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1672)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:903)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:796)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:769)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
INFO|2852/0|Service traccar|16-11-30 04:23:38|
... 20 more
INFO|wrapper|Service traccar|16-11-30 04:23:38|calling onStop
INFO|wrapper|Service traccar|16-11-30 04:23:38|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|16-11-30 04:23:38|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|16-11-30 04:23:38|Win service stop - after shutdown
INFO|wrapper|Service traccar|16-11-30 04:23:38|Win service stop - before notify
INFO|wrapper|Service traccar|16-11-30 04:23:38|Win service terminated
WARNING|wrapper|Service traccar|16-11-30 04:23:41|YAJSW: yajsw-beta-12.07
WARNING|wrapper|Service traccar|16-11-30 04:23:41|OS   : Windows Server 2012 R2/6.3/amd64
WARNING|wrapper|Service traccar|16-11-30 04:23:41|JVM  : Oracle Corporation/1.8.0_91/C:\Program Files\Java\jre1.8.0_91/64
...
Anton Tananaev8 years ago