API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 30th, 2018
283
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.75 KB | None | 0 0
raw download clone embed print report
  1. INFO|3508/0|Service traccar|18-05-30 20:08:06|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
  2. INFO|3508/0|Service traccar|18-05-30 20:08:20|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
  3. INFO|3508/0|Service traccar|18-05-30 20:08:20|[main] INFO liquibase.Liquibase - Clearing database change log checksums
  4. INFO|3508/0|Service traccar|18-05-30 20:08:20|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
  5. INFO|3508/0|Service traccar|18-05-30 20:08:20|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
  6. INFO|3508/0|Service traccar|18-05-30 20:08:20|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
  7. INFO|3508/0|Service traccar|18-05-30 20:08:20|[main] INFO liquibase.lockservice.StandardLockService - Successfully acquired change log lock
  8. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL
  9. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = NULL
  10. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = NULL
  11. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.lockservice.StandardLockService - Successfully released change log lock
  12. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
  13. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
  14. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
  15. INFO|3508/0|Service traccar|18-05-30 20:08:21|[main] INFO liquibase.lockservice.StandardLockService - Successfully acquired change log lock
  16. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL
  17. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOG
  18. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.StandardChangeLogHistoryService - Reading from PUBLIC.DATABASECHANGELOG
  19. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
  20. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.3'
  21. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:194e3ae7ec6d201917136e04a26e237b' WHERE ID = 'changelog-3.5' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.5'
  22. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:1ec7941b03749f24e365bc6126b07e1a' WHERE ID = 'changelog-3.6' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.6'
  23. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:2e444e379f31d0b8e09273ec7ffe87a0' WHERE ID = 'changelog-3.7' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
  24. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:974c33d2fb399ef6477c3897450fb078' WHERE ID = 'changelog-3.7-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
  25. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:74d68027951f8d2ae6bb2e24df8365bc' WHERE ID = 'changelog-3.8' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.8'
  26. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:34822842d65deb843a7d16f857d52ecc' WHERE ID = 'changelog-3.9' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.9'
  27. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:e1ddbe83e1ecf856a912755fc118f82e' WHERE ID = 'changelog-3.10' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
  28. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:191c21d8f0f921845cf93bbc9d0639b9' WHERE ID = 'changelog-3.10-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
  29. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:ad1f63566e8d08812fbf0b93a118ef6e' WHERE ID = 'changelog-3.10-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
  30. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:127b36b9d32a9d236df51d19b18c3766' WHERE ID = 'changelog-3.7-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
  31. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:7800f890b9706a480bd5a79b591b6ca7' WHERE ID = 'changelog-3.11' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.11'
  32. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:5ce520811d626ad325a014b9fcbb1a13' WHERE ID = 'changelog-3.12' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
  33. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:a3bf7fabcde29e106fe2f89829a76a84' WHERE ID = 'changelog-3.12-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
  34. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:cfc881bd2dadb561aa9c1a467bc8cc1c' WHERE ID = 'changelog-3.12-pgsql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
  35. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.DATABASECHANGELOG SET MD5SUM = '8:1be7e6c0520f8be53ef1b099d96afba5' WHERE ID = 'changelog-3.14' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.14'
  36. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOG
  37. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.StandardChangeLogHistoryService - Reading from PUBLIC.DATABASECHANGELOG
  38. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
  39. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.attribute_aliases DROP CONSTRAINT fk_attribute_aliases_deviceid
  40. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key fk_attribute_aliases_deviceid dropped
  41. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.attribute_aliases DROP CONSTRAINT uk_deviceid_attribute
  42. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Unique constraint uk_deviceid_attribute dropped from attribute_aliases
  43. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - DROP TABLE PUBLIC.attribute_aliases
  44. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table attribute_aliases dropped
  45. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.servers DROP COLUMN timezone
  46. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Column servers.timezone dropped
  47. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.servers DROP COLUMN speedunit
  48. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Column servers.speedunit dropped
  49. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.servers DROP COLUMN distanceunit
  50. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Column servers.distanceunit dropped
  51. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users DROP COLUMN timezone
  52. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Column users.timezone dropped
  53. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users DROP COLUMN speedunit
  54. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Column users.speedunit dropped
  55. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users DROP COLUMN distanceunit
  56. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Column users.distanceunit dropped
  57. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.commands (id INT AUTO_INCREMENT NOT NULL, description VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, textchannel BOOLEAN DEFAULT FALSE NOT NULL, attributes VARCHAR(4000) NOT NULL, CONSTRAINT PK_COMMANDS PRIMARY KEY (id))
  58. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table commands created
  59. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.user_command (userid INT NOT NULL, commandid INT NOT NULL)
  60. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table user_command created
  61. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.user_command ADD CONSTRAINT fk_user_command_userid FOREIGN KEY (userid) REFERENCES PUBLIC.users (id) ON DELETE CASCADE
  62. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to user_command (userid)
  63. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.user_command ADD CONSTRAINT fk_user_command_commandid FOREIGN KEY (commandid) REFERENCES PUBLIC.commands (id) ON DELETE CASCADE
  64. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to user_command (commandid)
  65. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.group_command (groupid INT NOT NULL, commandid INT NOT NULL)
  66. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table group_command created
  67. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.group_command ADD CONSTRAINT fk_group_command_groupid FOREIGN KEY (groupid) REFERENCES PUBLIC.groups (id) ON DELETE CASCADE
  68. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to group_command (groupid)
  69. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.group_command ADD CONSTRAINT fk_group_command_commandid FOREIGN KEY (commandid) REFERENCES PUBLIC.commands (id) ON DELETE CASCADE
  70. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to group_command (commandid)
  71. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.device_command (deviceid INT NOT NULL, commandid INT NOT NULL)
  72. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table device_command created
  73. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.device_command ADD CONSTRAINT fk_device_command_deviceid FOREIGN KEY (deviceid) REFERENCES PUBLIC.devices (id) ON DELETE CASCADE
  74. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to device_command (deviceid)
  75. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.device_command ADD CONSTRAINT fk_device_command_commandid FOREIGN KEY (commandid) REFERENCES PUBLIC.commands (id) ON DELETE CASCADE
  76. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to device_command (commandid)
  77. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.servers ADD limitcommands BOOLEAN DEFAULT FALSE
  78. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Columns limitcommands(BOOLEAN) added to servers
  79. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users ADD limitcommands BOOLEAN DEFAULT FALSE
  80. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Columns limitcommands(BOOLEAN) added to users
  81. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.notifications ADD always BOOLEAN DEFAULT FALSE NOT NULL
  82. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE PUBLIC.notifications SET always = TRUE
  83. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Columns always(BOOLEAN) added to notifications
  84. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.user_notification (userid INT NOT NULL, notificationid INT NOT NULL)
  85. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table user_notification created
  86. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.user_notification ADD CONSTRAINT fk_user_notification_userid FOREIGN KEY (userid) REFERENCES PUBLIC.users (id) ON DELETE CASCADE
  87. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to user_notification (userid)
  88. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - INSERT INTO user_notification (notificationid, userid) SELECT id AS notificationid, userid FROM notifications
  89. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Custom SQL executed
  90. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.notifications DROP CONSTRAINT fk_notifications_userid
  91. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key fk_notifications_userid dropped
  92. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.notifications DROP COLUMN userid
  93. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Column notifications.userid dropped
  94. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.user_notification ADD CONSTRAINT fk_user_notification_notificationid FOREIGN KEY (notificationid) REFERENCES PUBLIC.notifications (id) ON DELETE CASCADE
  95. INFO|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to user_notification (notificationid)
  96. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.group_notification (groupid INT NOT NULL, notificationid INT NOT NULL)
  97. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table group_notification created
  98. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.group_notification ADD CONSTRAINT fk_group_notification_groupid FOREIGN KEY (groupid) REFERENCES PUBLIC.groups (id) ON DELETE CASCADE
  99. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to group_notification (groupid)
  100. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.group_notification ADD CONSTRAINT fk_group_notification_notificationid FOREIGN KEY (notificationid) REFERENCES PUBLIC.notifications (id) ON DELETE CASCADE
  101. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to group_notification (notificationid)
  102. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.device_notification (deviceid INT NOT NULL, notificationid INT NOT NULL)
  103. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Table device_notification created
  104. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.device_notification ADD CONSTRAINT fk_device_notification_deviceid FOREIGN KEY (deviceid) REFERENCES PUBLIC.devices (id) ON DELETE CASCADE
  105. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to device_notification (deviceid)
  106. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.device_notification ADD CONSTRAINT fk_device_notification_notificationid FOREIGN KEY (notificationid) REFERENCES PUBLIC.notifications (id) ON DELETE CASCADE
  107. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to device_notification (notificationid)
  108. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users ALTER COLUMN hashedpassword SET NULL
  109. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Null constraint dropped from users.hashedpassword
  110. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users ALTER COLUMN salt SET NULL
  111. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Null constraint dropped from users.salt
  112. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users ADD login VARCHAR(128)
  113. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - Columns login(VARCHAR(128)) added to users
  114. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.changelog.ChangeSet - ChangeSet changelog-3.15::changelog-3.15::author ran successfully in 211ms
  115. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT MAX(ORDEREXECUTED) FROM PUBLIC.DATABASECHANGELOG
  116. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-3.15', 'author', 'changelog-3.15', NOW(), 17, '8:ac8ccec176027e98bbf45dc6c15d9b05', 'dropForeignKeyConstraint baseTableName=attribute_aliases, constraintName=fk_attribute_aliases_deviceid; dropUniqueConstraint constraintName=uk_deviceid_attribute, tableName=attribute_aliases; dropTable tableName=attribute_aliases; dropColumn colum...', '', 'EXECUTED', NULL, NULL, '3.6.1', '7700104649')
  117. FINEST|3508/0|Service traccar|18-05-30 20:08:24|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.devices ADD disabled BOOLEAN DEFAULT FALSE
  118. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - Columns disabled(BOOLEAN) added to devices
  119. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users ADD poilayer VARCHAR(512)
  120. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - Columns poilayer(VARCHAR(512)) added to users
  121. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.servers ADD poilayer VARCHAR(512)
  122. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - Columns poilayer(VARCHAR(512)) added to servers
  123. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.notifications ADD calendarid INT
  124. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - Columns calendarid(INT) added to notifications
  125. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.notifications ADD CONSTRAINT fk_notification_calendar_calendarid FOREIGN KEY (calendarid) REFERENCES PUBLIC.calendars (id) ON UPDATE RESTRICT ON DELETE SET NULL
  126. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to notifications (calendarid)
  127. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - ChangeSet changelog-3.16::changelog-3.16::author ran successfully in 57ms
  128. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-3.16', 'author', 'changelog-3.16', NOW(), 18, '8:b59407d70bfe9bf57bc9968adfbbdf1c', 'addColumn tableName=devices; addColumn tableName=users; addColumn tableName=servers; addColumn tableName=notifications; addForeignKeyConstraint baseTableName=notifications, constraintName=fk_notification_calendar_calendarid, referencedTableName=ca...', '', 'EXECUTED', NULL, NULL, '3.6.1', '7700104649')
  129. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.users ALTER COLUMN admin RENAME TO administrator
  130. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - Column users.admin renamed to administrator
  131. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.changelog.ChangeSet - ChangeSet changelog-3.17::changelog-3.3-admin::author ran successfully in 27ms
  132. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-3.3-admin', 'author', 'changelog-3.17', NOW(), 19, '8:3f14c3b08068eb7628d0d3e2941eb2d3', 'renameColumn newColumnName=administrator, oldColumnName=admin, tableName=users', '', 'EXECUTED', NULL, NULL, '3.6.1', '7700104649')
  133. FINEST|3508/0|Service traccar|18-05-30 20:08:25|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.events ADD maintenanceid INT
  134. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Columns maintenanceid(INT) added to events
  135. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.maintenances (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, start DOUBLE DEFAULT 0 NOT NULL, period DOUBLE DEFAULT 0 NOT NULL, attributes VARCHAR(4000) NOT NULL, CONSTRAINT PK_MAINTENANCES PRIMARY KEY (id))
  136. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Table maintenances created
  137. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.user_maintenance (userid INT NOT NULL, maintenanceid INT NOT NULL)
  138. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Table user_maintenance created
  139. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.user_maintenance ADD CONSTRAINT fk_user_maintenance_userid FOREIGN KEY (userid) REFERENCES PUBLIC.users (id) ON DELETE CASCADE
  140. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to user_maintenance (userid)
  141. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.user_maintenance ADD CONSTRAINT fk_user_maintenance_maintenanceid FOREIGN KEY (maintenanceid) REFERENCES PUBLIC.maintenances (id) ON DELETE CASCADE
  142. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to user_maintenance (maintenanceid)
  143. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.group_maintenance (groupid INT NOT NULL, maintenanceid INT NOT NULL)
  144. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Table group_maintenance created
  145. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.group_maintenance ADD CONSTRAINT fk_group_maintenance_groupid FOREIGN KEY (groupid) REFERENCES PUBLIC.groups (id) ON DELETE CASCADE
  146. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to group_maintenance (groupid)
  147. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.group_maintenance ADD CONSTRAINT fk_group_maintenance_maintenanceid FOREIGN KEY (maintenanceid) REFERENCES PUBLIC.maintenances (id) ON DELETE CASCADE
  148. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to group_maintenance (maintenanceid)
  149. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE PUBLIC.device_maintenance (deviceid INT NOT NULL, maintenanceid INT NOT NULL)
  150. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Table device_maintenance created
  151. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.device_maintenance ADD CONSTRAINT fk_device_maintenance_deviceid FOREIGN KEY (deviceid) REFERENCES PUBLIC.devices (id) ON DELETE CASCADE
  152. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to device_maintenance (deviceid)
  153. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE PUBLIC.device_maintenance ADD CONSTRAINT fk_device_maintenance_maintenanceid FOREIGN KEY (maintenanceid) REFERENCES PUBLIC.maintenances (id) ON DELETE CASCADE
  154. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - Foreign key constraint added to device_maintenance (maintenanceid)
  155. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.changelog.ChangeSet - ChangeSet changelog-3.17::changelog-3.17::author ran successfully in 1658ms
  156. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.executor.jvm.JdbcExecutor - INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-3.17', 'author', 'changelog-3.17', NOW(), 20, '8:8aa3e56afe6ba86cd004fa801507bc28', 'addColumn tableName=events; createTable tableName=maintenances; createTable tableName=user_maintenance; addForeignKeyConstraint baseTableName=user_maintenance, constraintName=fk_user_maintenance_userid, referencedTableName=users; addForeignKeyCons...', '', 'EXECUTED', NULL, NULL, '3.6.1', '7700104649')
  157. FINEST|3508/0|Service traccar|18-05-30 20:08:26|[main] INFO liquibase.lockservice.StandardLockService - Successfully released change log lock
  158. FINEST|3508/0|Service traccar|18-05-30 20:08:27|[main] INFO org.eclipse.jetty.util.log - Logging initialized @28274ms
  159. FINEST|3508/0|Service traccar|18-05-30 20:08:29|[main] INFO org.eclipse.jetty.server.Server - jetty-9.2.24.v20180105
  160. FINEST|3508/0|Service traccar|18-05-30 20:08:32|[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@69a024a0{/api,null,AVAILABLE}
  161. FINEST|3508/0|Service traccar|18-05-30 20:08:32|[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.t.w.@64502326{/,null,AVAILABLE}
  162. FINEST|3508/0|Service traccar|18-05-30 20:08:32|[main] INFO org.eclipse.jetty.server.ServerConnector - Started ServerConnector@4b56b031{HTTP/1.1}{0.0.0.0:8082}
  163. FINEST|3508/0|Service traccar|18-05-30 20:08:32|[main] INFO org.eclipse.jetty.server.Server - Started @32978ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!