API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 22nd, 2016
129
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 245.62 KB | None | 0 0
raw download clone embed print report
  1. INFO  akka.event.slf4j.Slf4jLogger  Slf4jLogger started
  2. 19:49:21.005UTC INFO  akka.remote.Remoting akka.remote.Remoting Starting remoting
  3. 19:49:21.283UTC INFO  akka.remote.Remoting akka.remote.Remoting Remoting started; listening on addresses :[akka.tcp://actor-server@31.187.70.88:2552]
  4. 19:49:21.288UTC INFO  akka.remote.Remoting akka.remote.Remoting Remoting now listens on addresses: [akka.tcp://actor-server@31.187.70.88:2552]
  5. 19:49:21.311UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - Starting up...
  6. 19:49:21.515UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - Registered cluster JMX MBean [akka:type=Cluster]
  7. 19:49:21.516UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - Started up successfully
  8. 19:49:21.534UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - Metrics will be retreived from MBeans, and may be incorrect on some platforms. To increase metric accuracy add the 'sigar.jar' to the classpath and the appropriate platform-specific native libary to 'java.library.path'. Reason: java.lang.ClassNotFoundException: org.hyperic.sigar.Sigar
  9. 19:49:21.540UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - Metrics collection has started successfully
  10. 19:49:21.563UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - No seed-nodes configured, manual cluster join required
  11. DEBUG com.zaxxer.hikari.HikariConfig  main - configuration:
  12. DEBUG com.zaxxer.hikari.HikariConfig  allowPoolSuspension.............false
  13. DEBUG com.zaxxer.hikari.HikariConfig  autoCommit......................true
  14. DEBUG com.zaxxer.hikari.HikariConfig  catalog.........................
  15. DEBUG com.zaxxer.hikari.HikariConfig  connectionInitSql...............
  16. DEBUG com.zaxxer.hikari.HikariConfig  connectionTestQuery.............
  17. DEBUG com.zaxxer.hikari.HikariConfig  connectionTimeout...............1000
  18. DEBUG com.zaxxer.hikari.HikariConfig  dataSource......................
  19. DEBUG com.zaxxer.hikari.HikariConfig  dataSourceClassName.............
  20. DEBUG com.zaxxer.hikari.HikariConfig  dataSourceJNDI..................
  21. DEBUG com.zaxxer.hikari.HikariConfig  dataSourceProperties............{password=<masked>}
  22. DEBUG com.zaxxer.hikari.HikariConfig  driverClassName.................org.postgresql.Driver
  23. DEBUG com.zaxxer.hikari.HikariConfig  healthCheckProperties...........{}
  24. DEBUG com.zaxxer.hikari.HikariConfig  healthCheckRegistry.............
  25. DEBUG com.zaxxer.hikari.HikariConfig  idleTimeout.....................600000
  26. DEBUG com.zaxxer.hikari.HikariConfig  initializationFailFast..........false
  27. DEBUG com.zaxxer.hikari.HikariConfig  isolateInternalQueries..........false
  28. DEBUG com.zaxxer.hikari.HikariConfig  jdbc4ConnectionTest.............false
  29. DEBUG com.zaxxer.hikari.HikariConfig  jdbcUrl.........................jdbc:postgresql://localhost:5432/new
  30. DEBUG com.zaxxer.hikari.HikariConfig  leakDetectionThreshold..........0
  31. DEBUG com.zaxxer.hikari.HikariConfig  maxLifetime.....................1800000
  32. DEBUG com.zaxxer.hikari.HikariConfig  maximumPoolSize.................16
  33. DEBUG com.zaxxer.hikari.HikariConfig  metricRegistry..................
  34. DEBUG com.zaxxer.hikari.HikariConfig  metricsTrackerFactory...........
  35. DEBUG com.zaxxer.hikari.HikariConfig  minimumIdle.....................8
  36. DEBUG com.zaxxer.hikari.HikariConfig  password........................<masked>
  37. DEBUG com.zaxxer.hikari.HikariConfig  poolName........................main
  38. DEBUG com.zaxxer.hikari.HikariConfig  readOnly........................false
  39. DEBUG com.zaxxer.hikari.HikariConfig  registerMbeans..................false
  40. DEBUG com.zaxxer.hikari.HikariConfig  scheduledExecutorService........
  41. DEBUG com.zaxxer.hikari.HikariConfig  threadFactory...................
  42. DEBUG com.zaxxer.hikari.HikariConfig  transactionIsolation............
  43. DEBUG com.zaxxer.hikari.HikariConfig  username........................new
  44. DEBUG com.zaxxer.hikari.HikariConfig  validationTimeout...............1000
  45. INFO  com.zaxxer.hikari.HikariDataSource  main - is starting.
  46. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Connection.setNetworkTimeout() is not supported (Method org.postgresql.jdbc4.Jdbc4Connection.getNetworkTimeout() is not yet implemented.)
  47. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  48. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@4930f9f8
  49. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@5595bf91
  50. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@47b5e0cb
  51. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@3d31f7e0
  52. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@73803687
  53. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@b916651
  54. DEBUG com.zaxxer.hikari.pool.HikariPool  main - Added connection org.postgresql.jdbc4.Jdbc4Connection@634a6c50
  55. DEBUG com.zaxxer.hikari.pool.HikariPool  After fill pool main stats (total=8, active=0, idle=8, waiting=0)
  56. INFO  o.f.c.i.dbsupport.DbSupportFactory  Database: jdbc:postgresql://localhost:5432/new (PostgreSQL 9.5)
  57. DEBUG org.flywaydb.core.Flyway  DDL Transactions Supported: true
  58. DEBUG org.flywaydb.core.Flyway  Schema: public
  59. DEBUG o.f.c.internal.util.FeatureDetector  Spring Jdbc available: false
  60. DEBUG o.f.core.internal.command.DbValidate  Validating migrations ...
  61. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Scanning for classpath resources at 'sql/migration' (Prefix: 'V', Suffix: '.sql')
  62. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Scanning URL: jar:file:/usr/share/actor/lib/im.actor.server.actor-core-1.0.152.jar!/sql/migration
  63. DEBUG o.f.c.internal.util.FeatureDetector  JBoss VFS v2 available: false
  64. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Scanning URL: jar:file:/usr/share/actor/lib/im.actor.server.actor-persist-1.0.152.jar!/sql/migration
  65. DEBUG o.f.c.internal.util.FeatureDetector  JBoss VFS v2 available: false
  66. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/ (filename: )
  67. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150520123900__InitGroupsBots$$anon$1.class (filename: V20150520123900__InitGroupsBots$$anon$1.class)
  68. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150520123900__InitGroupsBots$$anon$2.class (filename: V20150520123900__InitGroupsBots$$anon$2.class)
  69. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150520123900__InitGroupsBots.class (filename: V20150520123900__InitGroupsBots.class)
  70. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence$$anonfun$34.class (filename: V20151108011300__FillUserSequence$$anonfun$34.class)
  71. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence$.class (filename: V20151108011300__FillUserSequence$.class)
  72. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence$New$.class (filename: V20151108011300__FillUserSequence$New$.class)
  73. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence$New.class (filename: V20151108011300__FillUserSequence$New.class)
  74. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence$Obsolete$.class (filename: V20151108011300__FillUserSequence$Obsolete$.class)
  75. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence$Obsolete.class (filename: V20151108011300__FillUserSequence$Obsolete.class)
  76. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence$UserSequenceTable.class (filename: V20151108011300__FillUserSequence$UserSequenceTable.class)
  77. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151108011300__FillUserSequence.class (filename: V20151108011300__FillUserSequence.class)
  78. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160128142000__AkkaPersistence.class (filename: V20160128142000__AkkaPersistence.class)
  79. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20142412173600__Init.sql
  80. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150315081300__CreateSeqUpdatesNgen.sql
  81. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150417101800__CreateSessionInfos.sql
  82. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150419155700__CreateUserPresences.sql
  83. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150421163900__RemovePublicKeysFromAuthSessions.sql
  84. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150421185400__CreateManagers.sql
  85. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150422120100__CreateFiles.sql
  86. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150422185500__CreateParameters.sql
  87. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150423011000__CreateSocialRelations.sql
  88. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150428181900__AddSizeToFiles.sql
  89. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150429112900__AddUserDeletedAt.sql
  90. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150502124700__CreateDepartments.sql
  91. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150506191800__ChangeApnsTokenToBinary.sql
  92. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150510194000__AddFileNameToFiles.sql
  93. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150511051700__AddNameToUnregisteredContacts.sql
  94. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150511214600__CreateVoxUsers.sql
  95. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150512234700__AddOwnerReadReceivedAt.sql
  96. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150519163700__RecreateUserEmails.sql
  97. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150520222329__AddUserIsBot.sql
  98. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150520222336__CreateGroupsBots.sql
  99. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150521141854__AddInterest.sql
  100. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150521141905__AddUsersInterests.sql
  101. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150521150716__AddIlectroUser.sql
  102. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150522142247__IncreaseDeviceTitleTo255.sql
  103. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150526031815__CreateGroupInviteToken.sql
  104. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150604180231__AddJoinedAtToGroupUsers.sql
  105. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150604220751__SetUserJoinedToInvitedAt.sql
  106. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150605160833__AddHistoryMessageIndex.sql
  107. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150615205201__rename_ilectro_to_llectro.sql
  108. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150616000533__CreateLlectroDevices.sql
  109. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150618174638__CreateOAuth2Tokens.sql
  110. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150618201809__CreateAuthTransactions.sql
  111. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150618204803__CreateAuthCodes.sql
  112. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150618204804__RenameAuthSmsCodes.sql
  113. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150619125433__AlterUnregisteredContacts.sql
  114. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150621064349__AlterUserContacts.sql
  115. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150627010404__PublicGroups.sql
  116. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150630025815__AddGroupDescription.sql
  117. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150702021401__AddAuthCodeAttempts.sql
  118. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150703211853__AddAuthSmsCodeIsDeleted.sql
  119. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150707210259__AddUserCreatedAt.sql
  120. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150707220259__UserCreatedAtNotNull.sql
  121. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150712032247__CreateGateAuthCode.sql
  122. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150715050545__RenameJournalSnapshot.sql
  123. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150727191745__AddAppleTokenIndex.sql
  124. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150731002716__AddUserNicknameAndAbout.sql
  125. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150731004315__AddGroupUserIsAdmin.sql
  126. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150731134010__GroupAddTopic.sql
  127. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150731152013__MigrateGroupAdmins.sql
  128. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150820183625__UpdateReadDateGroups.sql
  129. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150821183625__UpdateReadDateGroupsFix.sql
  130. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20150928165628__AddUserExternal.sql
  131. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151013221624__AddIsHiddenToDialogs.sql
  132. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151014194156__AddIsHiddenToGroups.sql
  133. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151020041600__RemoveAccessSaltFromContacts.sql
  134. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151021013035__LongAvatarSizes.sql
  135. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151027223908__AddCreatedAtToDialogs.sql
  136. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151028080853__AddIndexOnAuthIds.sql
  137. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151029213151__AddUserDataToAuthTransaction.sql
  138. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151030003749__RenameUserDataToDeviceData.sql
  139. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151030163409__AddIndexToContacts.sql
  140. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151030173704__SetDefaultDeviceInfoToEmpty.sql
  141. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151030195855__AddIsHiddenToDialogs.sql
  142. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151105010136__CreateUserSequence.sql
  143. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151112033332__AddShownAtToDialogs.sql
  144. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151113191756__FixDialogsOrder.sql
  145. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151113233633__CreateReactions.sql
  146. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151207212343__AddStickers.sql
  147. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151217161100__FilesRenameUploadKey.sql
  148. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151221164145__AddIsFavouriteToDialogs.sql
  149. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151222034230__AddStickerWH.sql
  150. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151223215842__CreateApiTokens.sql
  151. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151224051919__RemoveConfigParametersValueNotNull.sql
  152. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151224225330__CreateUserPasswords.sql
  153. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20151225015119__CreateUsernameAuthTransactions.sql
  154. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160107153720__CreateMasterKeys.sql
  155. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160112161110__BinaryPasswordHashes.sql
  156. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160112234110__CreateFeatures.sql
  157. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160112234231__CreateWebrtcCalls.sql
  158. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160117171824__CreateIndexOnGoogleRegId.sql
  159. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160119175838__CreateEncryption.sql
  160. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160121182140__CreateReduceKey.sql
  161. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160122065245__CreateActorPushCredentials.sql
  162. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160125185107__DialogMigration.sql
  163. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160127074506__AddIndexOnUnregPhoneContacts.sql
  164. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160128094919__NewPersistence.sql
  165. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160203202648__PinPresenceToAuthId.sql
  166. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160203202749__PinPresenceToAuthId.sql
  167. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160204195902__PresencesPKEY.sql
  168. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160205215901__AddArchivedAtToDialogs.sql
  169. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160228174726__AddIsVoipToAppleCreds.sql
  170. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found resource: sql/migration/V20160311221657__AddClientStats.sql
  171. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Scanning for classes at 'sql/migration' (Implementing: 'org.flywaydb.core.api.migration.jdbc.JdbcMigration')
  172. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Scanning URL: jar:file:/usr/share/actor/lib/im.actor.server.actor-core-1.0.152.jar!/sql/migration
  173. DEBUG o.f.c.internal.util.FeatureDetector  JBoss VFS v2 available: false
  174. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Scanning URL: jar:file:/usr/share/actor/lib/im.actor.server.actor-persist-1.0.152.jar!/sql/migration
  175. DEBUG o.f.c.internal.util.FeatureDetector  JBoss VFS v2 available: false
  176. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/ (filename: )
  177. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20142412173600__Init.sql (filename: V20142412173600__Init.sql)
  178. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150315081300__CreateSeqUpdatesNgen.sql (filename: V20150315081300__CreateSeqUpdatesNgen.sql)
  179. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150417101800__CreateSessionInfos.sql (filename: V20150417101800__CreateSessionInfos.sql)
  180. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150419155700__CreateUserPresences.sql (filename: V20150419155700__CreateUserPresences.sql)
  181. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150421163900__RemovePublicKeysFromAuthSessions.sql (filename: V20150421163900__RemovePublicKeysFromAuthSessions.sql)
  182. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150421185400__CreateManagers.sql (filename: V20150421185400__CreateManagers.sql)
  183. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150422120100__CreateFiles.sql (filename: V20150422120100__CreateFiles.sql)
  184. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150422185500__CreateParameters.sql (filename: V20150422185500__CreateParameters.sql)
  185. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150423011000__CreateSocialRelations.sql (filename: V20150423011000__CreateSocialRelations.sql)
  186. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150428181900__AddSizeToFiles.sql (filename: V20150428181900__AddSizeToFiles.sql)
  187. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150429112900__AddUserDeletedAt.sql (filename: V20150429112900__AddUserDeletedAt.sql)
  188. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150502124700__CreateDepartments.sql (filename: V20150502124700__CreateDepartments.sql)
  189. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150506191800__ChangeApnsTokenToBinary.sql (filename: V20150506191800__ChangeApnsTokenToBinary.sql)
  190. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150510194000__AddFileNameToFiles.sql (filename: V20150510194000__AddFileNameToFiles.sql)
  191. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150511051700__AddNameToUnregisteredContacts.sql (filename: V20150511051700__AddNameToUnregisteredContacts.sql)
  192. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150511214600__CreateVoxUsers.sql (filename: V20150511214600__CreateVoxUsers.sql)
  193. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150512234700__AddOwnerReadReceivedAt.sql (filename: V20150512234700__AddOwnerReadReceivedAt.sql)
  194. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150519163700__RecreateUserEmails.sql (filename: V20150519163700__RecreateUserEmails.sql)
  195. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150520222329__AddUserIsBot.sql (filename: V20150520222329__AddUserIsBot.sql)
  196. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150520222336__CreateGroupsBots.sql (filename: V20150520222336__CreateGroupsBots.sql)
  197. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150521141854__AddInterest.sql (filename: V20150521141854__AddInterest.sql)
  198. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150521141905__AddUsersInterests.sql (filename: V20150521141905__AddUsersInterests.sql)
  199. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150521150716__AddIlectroUser.sql (filename: V20150521150716__AddIlectroUser.sql)
  200. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150522142247__IncreaseDeviceTitleTo255.sql (filename: V20150522142247__IncreaseDeviceTitleTo255.sql)
  201. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150526031815__CreateGroupInviteToken.sql (filename: V20150526031815__CreateGroupInviteToken.sql)
  202. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150604180231__AddJoinedAtToGroupUsers.sql (filename: V20150604180231__AddJoinedAtToGroupUsers.sql)
  203. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150604220751__SetUserJoinedToInvitedAt.sql (filename: V20150604220751__SetUserJoinedToInvitedAt.sql)
  204. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150605160833__AddHistoryMessageIndex.sql (filename: V20150605160833__AddHistoryMessageIndex.sql)
  205. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150615205201__rename_ilectro_to_llectro.sql (filename: V20150615205201__rename_ilectro_to_llectro.sql)
  206. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150616000533__CreateLlectroDevices.sql (filename: V20150616000533__CreateLlectroDevices.sql)
  207. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150618174638__CreateOAuth2Tokens.sql (filename: V20150618174638__CreateOAuth2Tokens.sql)
  208. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150618201809__CreateAuthTransactions.sql (filename: V20150618201809__CreateAuthTransactions.sql)
  209. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150618204803__CreateAuthCodes.sql (filename: V20150618204803__CreateAuthCodes.sql)
  210. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150618204804__RenameAuthSmsCodes.sql (filename: V20150618204804__RenameAuthSmsCodes.sql)
  211. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150619125433__AlterUnregisteredContacts.sql (filename: V20150619125433__AlterUnregisteredContacts.sql)
  212. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150621064349__AlterUserContacts.sql (filename: V20150621064349__AlterUserContacts.sql)
  213. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150627010404__PublicGroups.sql (filename: V20150627010404__PublicGroups.sql)
  214. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150630025815__AddGroupDescription.sql (filename: V20150630025815__AddGroupDescription.sql)
  215. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150702021401__AddAuthCodeAttempts.sql (filename: V20150702021401__AddAuthCodeAttempts.sql)
  216. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150703211853__AddAuthSmsCodeIsDeleted.sql (filename: V20150703211853__AddAuthSmsCodeIsDeleted.sql)
  217. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150707210259__AddUserCreatedAt.sql (filename: V20150707210259__AddUserCreatedAt.sql)
  218. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150707220259__UserCreatedAtNotNull.sql (filename: V20150707220259__UserCreatedAtNotNull.sql)
  219. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150712032247__CreateGateAuthCode.sql (filename: V20150712032247__CreateGateAuthCode.sql)
  220. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150715050545__RenameJournalSnapshot.sql (filename: V20150715050545__RenameJournalSnapshot.sql)
  221. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150727191745__AddAppleTokenIndex.sql (filename: V20150727191745__AddAppleTokenIndex.sql)
  222. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150731002716__AddUserNicknameAndAbout.sql (filename: V20150731002716__AddUserNicknameAndAbout.sql)
  223. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150731004315__AddGroupUserIsAdmin.sql (filename: V20150731004315__AddGroupUserIsAdmin.sql)
  224. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150731134010__GroupAddTopic.sql (filename: V20150731134010__GroupAddTopic.sql)
  225. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150731152013__MigrateGroupAdmins.sql (filename: V20150731152013__MigrateGroupAdmins.sql)
  226. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150820183625__UpdateReadDateGroups.sql (filename: V20150820183625__UpdateReadDateGroups.sql)
  227. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150821183625__UpdateReadDateGroupsFix.sql (filename: V20150821183625__UpdateReadDateGroupsFix.sql)
  228. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20150928165628__AddUserExternal.sql (filename: V20150928165628__AddUserExternal.sql)
  229. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151013221624__AddIsHiddenToDialogs.sql (filename: V20151013221624__AddIsHiddenToDialogs.sql)
  230. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151014194156__AddIsHiddenToGroups.sql (filename: V20151014194156__AddIsHiddenToGroups.sql)
  231. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151020041600__RemoveAccessSaltFromContacts.sql (filename: V20151020041600__RemoveAccessSaltFromContacts.sql)
  232. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151021013035__LongAvatarSizes.sql (filename: V20151021013035__LongAvatarSizes.sql)
  233. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151027223908__AddCreatedAtToDialogs.sql (filename: V20151027223908__AddCreatedAtToDialogs.sql)
  234. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151028080853__AddIndexOnAuthIds.sql (filename: V20151028080853__AddIndexOnAuthIds.sql)
  235. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151029213151__AddUserDataToAuthTransaction.sql (filename: V20151029213151__AddUserDataToAuthTransaction.sql)
  236. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151030003749__RenameUserDataToDeviceData.sql (filename: V20151030003749__RenameUserDataToDeviceData.sql)
  237. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151030163409__AddIndexToContacts.sql (filename: V20151030163409__AddIndexToContacts.sql)
  238. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151030173704__SetDefaultDeviceInfoToEmpty.sql (filename: V20151030173704__SetDefaultDeviceInfoToEmpty.sql)
  239. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151030195855__AddIsHiddenToDialogs.sql (filename: V20151030195855__AddIsHiddenToDialogs.sql)
  240. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151105010136__CreateUserSequence.sql (filename: V20151105010136__CreateUserSequence.sql)
  241. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151112033332__AddShownAtToDialogs.sql (filename: V20151112033332__AddShownAtToDialogs.sql)
  242. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151113191756__FixDialogsOrder.sql (filename: V20151113191756__FixDialogsOrder.sql)
  243. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151113233633__CreateReactions.sql (filename: V20151113233633__CreateReactions.sql)
  244. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151207212343__AddStickers.sql (filename: V20151207212343__AddStickers.sql)
  245. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151217161100__FilesRenameUploadKey.sql (filename: V20151217161100__FilesRenameUploadKey.sql)
  246. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151221164145__AddIsFavouriteToDialogs.sql (filename: V20151221164145__AddIsFavouriteToDialogs.sql)
  247. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151222034230__AddStickerWH.sql (filename: V20151222034230__AddStickerWH.sql)
  248. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151223215842__CreateApiTokens.sql (filename: V20151223215842__CreateApiTokens.sql)
  249. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151224051919__RemoveConfigParametersValueNotNull.sql (filename: V20151224051919__RemoveConfigParametersValueNotNull.sql)
  250. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151224225330__CreateUserPasswords.sql (filename: V20151224225330__CreateUserPasswords.sql)
  251. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20151225015119__CreateUsernameAuthTransactions.sql (filename: V20151225015119__CreateUsernameAuthTransactions.sql)
  252. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160107153720__CreateMasterKeys.sql (filename: V20160107153720__CreateMasterKeys.sql)
  253. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160112161110__BinaryPasswordHashes.sql (filename: V20160112161110__BinaryPasswordHashes.sql)
  254. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160112234110__CreateFeatures.sql (filename: V20160112234110__CreateFeatures.sql)
  255. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160112234231__CreateWebrtcCalls.sql (filename: V20160112234231__CreateWebrtcCalls.sql)
  256. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160117171824__CreateIndexOnGoogleRegId.sql (filename: V20160117171824__CreateIndexOnGoogleRegId.sql)
  257. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160119175838__CreateEncryption.sql (filename: V20160119175838__CreateEncryption.sql)
  258. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160121182140__CreateReduceKey.sql (filename: V20160121182140__CreateReduceKey.sql)
  259. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160122065245__CreateActorPushCredentials.sql (filename: V20160122065245__CreateActorPushCredentials.sql)
  260. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160125185107__DialogMigration.sql (filename: V20160125185107__DialogMigration.sql)
  261. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160127074506__AddIndexOnUnregPhoneContacts.sql (filename: V20160127074506__AddIndexOnUnregPhoneContacts.sql)
  262. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160128094919__NewPersistence.sql (filename: V20160128094919__NewPersistence.sql)
  263. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160203202648__PinPresenceToAuthId.sql (filename: V20160203202648__PinPresenceToAuthId.sql)
  264. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160203202749__PinPresenceToAuthId.sql (filename: V20160203202749__PinPresenceToAuthId.sql)
  265. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160204195902__PresencesPKEY.sql (filename: V20160204195902__PresencesPKEY.sql)
  266. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160205215901__AddArchivedAtToDialogs.sql (filename: V20160205215901__AddArchivedAtToDialogs.sql)
  267. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160228174726__AddIsVoipToAppleCreds.sql (filename: V20160228174726__AddIsVoipToAppleCreds.sql)
  268. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Filtering out resource: sql/migration/V20160311221657__AddClientStats.sql (filename: V20160311221657__AddClientStats.sql)
  269. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found class: sql.migration.V20150520123900__InitGroupsBots
  270. DEBUG o.f.c.i.u.s.c.ClassPathScanner  Found class: sql.migration.V20160128142000__AkkaPersistence
  271. INFO  o.f.core.internal.command.DbValidate  Validated 94 migrations (execution time 00:00.297s)
  272. DEBUG o.f.core.internal.command.DbSchemas  Schema "public" already exists. Skipping schema creation.
  273. INFO  o.f.c.i.m.MetaDataTableImpl  Creating Metadata table: "public"."schema_version"
  274. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 17: CREATE TABLE "public"."schema_version" (
  275. "version_rank" INT NOT NULL,
  276. "installed_rank" INT NOT NULL,
  277. "version" VARCHAR(50) NOT NULL,
  278. "description" VARCHAR(200) NOT NULL,
  279. "type" VARCHAR(20) NOT NULL,
  280. "script" VARCHAR(1000) NOT NULL,
  281. "checksum" INTEGER,
  282. "installed_by" VARCHAR(100) NOT NULL,
  283. "installed_on" TIMESTAMP NOT NULL DEFAULT now(),
  284. "execution_time" INTEGER NOT NULL,
  285. "success" BOOLEAN NOT NULL
  286. ) WITH (
  287. OIDS=FALSE
  288. )
  289. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 32: ALTER TABLE "public"."schema_version" ADD CONSTRAINT "schema_version_pk" PRIMARY KEY ("version")
  290. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 34: CREATE INDEX "schema_version_vr_idx" ON "public"."schema_version" ("version_rank")
  291. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 35: CREATE INDEX "schema_version_ir_idx" ON "public"."schema_version" ("installed_rank")
  292. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 36: CREATE INDEX "schema_version_s_idx" ON "public"."schema_version" ("success")
  293. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE "public"."schema_version" (
  294. "version_rank" INT NOT NULL,
  295. "installed_rank" INT NOT NULL,
  296. "version" VARCHAR(50) NOT NULL,
  297. "description" VARCHAR(200) NOT NULL,
  298. "type" VARCHAR(20) NOT NULL,
  299. "script" VARCHAR(1000) NOT NULL,
  300. "checksum" INTEGER,
  301. "installed_by" VARCHAR(100) NOT NULL,
  302. "installed_on" TIMESTAMP NOT NULL DEFAULT now(),
  303. "execution_time" INTEGER NOT NULL,
  304. "success" BOOLEAN NOT NULL
  305. ) WITH (
  306. OIDS=FALSE
  307. )
  308. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE "public"."schema_version" ADD CONSTRAINT "schema_version_pk" PRIMARY KEY ("version")
  309. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX "schema_version_vr_idx" ON "public"."schema_version" ("version_rank")
  310. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX "schema_version_ir_idx" ON "public"."schema_version" ("installed_rank")
  311. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX "schema_version_s_idx" ON "public"."schema_version" ("success")
  312. DEBUG o.f.c.i.m.MetaDataTableImpl  Metadata table "public"."schema_version" created.
  313. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  314. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  315. INFO  o.f.core.internal.command.DbMigrate  Current version of schema "public": << Empty Schema >>
  316. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20142412173600
  317. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE history_messages (
  318. user_id int NOT NULL,
  319. peer_type int NOT NULL,
  320. peer_id int NOT NULL,
  321. date timestamp NOT NULL,
  322. sender_user_id int NOT NULL,
  323. random_id bigint NOT NULL,
  324. message_content_header int NOT NULL,
  325. message_content_data bytea NOT NULL,
  326. deleted_at timestamp,
  327. PRIMARY KEY(user_id, peer_type, peer_id, date, sender_user_id, random_id)
  328. )
  329. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 14: CREATE TABLE dialogs (
  330. user_id int NOT NULL,
  331. peer_type int NOT NULL,
  332. peer_id int NOT NULL,
  333. last_message_date timestamp NOT NULL,
  334. last_received_at timestamp NOT NULL,
  335. last_read_at timestamp NOT NULL,
  336. PRIMARY KEY(user_id, peer_type, peer_id)
  337. )
  338. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 24: CREATE TABLE google_push_credentials (
  339. auth_id bigint NOT NULL,
  340. project_id bigint NOT NULL,
  341. reg_id varchar(255) NOT NULL,
  342. PRIMARY KEY (auth_id)
  343. )
  344. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 31: CREATE INDEX idx_google_push_credentials_reg_id on google_push_credentials(reg_id)
  345. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 33: CREATE TABLE log_events (
  346. id serial not null,
  347. auth_id bigint not null,
  348. phone_number bigint not null,
  349. email varchar(255) NOT NULL,
  350. klass smallint NOT NULL,
  351. json_body text NOT NULL,
  352. created_at TIMESTAMP NOT NULL DEFAULT now(),
  353. PRIMARY KEY (id)
  354. )
  355. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 44: CREATE INDEX idx_log_events_auth_id ON log_events (auth_id)
  356. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 45: CREATE INDEX idx_log_events_phone_number ON log_events (phone_number)
  357. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 46: CREATE INDEX idx_log_events_email ON log_events (email)
  358. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 48: CREATE TABLE apple_push_credentials (
  359. auth_id bigint NOT NULL,
  360. apns_key int NOT NULL,
  361. token varchar(128) NOT NULL,
  362. PRIMARY KEY (auth_id)
  363. )
  364. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 55: CREATE INDEX idx_apple_push_credentials_token on apple_push_credentials(token)
  365. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 57: CREATE TABLE groups (
  366. id int NOT NULL,
  367. creator_user_id int NOT NULL,
  368. access_hash bigint NOT NULL,
  369. title varchar(255) NOT NULL,
  370. created_at timestamp NOT NULL,
  371. title_changer_user_id int NOT NULL,
  372. title_changed_at timestamp NOT NULL,
  373. title_change_random_id bigint NOT NULL,
  374. avatar_changer_user_id int NOT NULL,
  375. avatar_changed_at timestamp NOT NULL,
  376. avatar_change_random_id bigint NOT NULL,
  377. PRIMARY KEY (id)
  378. )
  379. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 72: CREATE TABLE group_users (
  380. group_id int NOT NULL,
  381. user_id int NOT NULL,
  382. inviter_user_id int NOT NULL,
  383. invited_at timestamp NOT NULL,
  384. PRIMARY KEY (group_id, user_id)
  385. )
  386. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 80: CREATE INDEX idx_group_users_user_id on group_users (user_id)
  387. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 82: CREATE TABLE unregistered_contacts (
  388. phone_number bigint,
  389. owner_user_id int,
  390. PRIMARY KEY (phone_number, owner_user_id)
  391. )
  392. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 88: CREATE TABLE user_contacts (
  393. owner_user_id int NOT NULL,
  394. contact_user_id int NOT NULL,
  395. phone_number bigint NOT NULL,
  396. name varchar(255),
  397. access_salt varchar(255) NOT NULL,
  398. is_deleted boolean NOT NULL default false,
  399. PRIMARY KEY (owner_user_id, contact_user_id)
  400. )
  401. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 98: CREATE INDEX idx_user_contacts_owner_user_id_is_deleted on user_contacts(owner_user_id, is_deleted)
  402. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 100: CREATE TABLE file_datas (
  403. id bigint NOT NULL,
  404. access_salt varchar(255) NOT NULL,
  405. uploaded_blocks_count int NOT NULL default 0,
  406. length bigint NOT NULL default 0,
  407. PRIMARY KEY (id)
  408. )
  409. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 108: CREATE TABLE IF NOT EXISTS akka_journal (
  410. persistence_id VARCHAR(255) NOT NULL,
  411. sequence_number BIGINT NOT NULL,
  412. marker VARCHAR(255) NOT NULL,
  413. message TEXT NOT NULL,
  414. created TIMESTAMP NOT NULL,
  415. PRIMARY KEY(persistence_id, sequence_number)
  416. )
  417. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 117: CREATE TABLE IF NOT EXISTS akka_snapshot (
  418. persistence_id VARCHAR(255) NOT NULL,
  419. sequence_nr BIGINT NOT NULL,
  420. snapshot TEXT NOT NULL,
  421. created BIGINT NOT NULL,
  422. PRIMARY KEY (persistence_id, sequence_nr)
  423. )
  424. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 125: CREATE TABLE user_emails (
  425. id int NOT NULL,
  426. user_id int NOT NULL,
  427. email varchar(255) NOT NULL,
  428. access_salt varchar(255) NOT NULL,
  429. title varchar(255) NOT NULL,
  430. PRIMARY KEY (id)
  431. )
  432. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 134: CREATE UNIQUE INDEX idx_user_emails_email ON user_emails (email)
  433. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 135: CREATE INDEX idx_user_emails_user_id ON user_emails (user_id)
  434. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 137: CREATE TABLE plain_mails (
  435. id serial not null,
  436. random_id bigint not null,
  437. mail_from varchar(255) NOT NULL,
  438. recipients text NOT NULL,
  439. message text NOT NULL,
  440. created_at TIMESTAMP NOT NULL DEFAULT now(),
  441. PRIMARY KEY (id)
  442. )
  443. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 147: CREATE TABLE file_blocks (
  444. file_id bigint NOT NULL,
  445. offset_ bigint NOT NULL,
  446. length bigint NOT NULL,
  447. PRIMARY KEY (file_id, offset_, length)
  448. )
  449. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 154: CREATE TABLE auth_ids (
  450. id bigint NOT NULL,
  451. public_key_hash bigint,
  452. user_id int,
  453. deleted_at timestamp,
  454. PRIMARY KEY (id)
  455. )
  456. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 162: CREATE TABLE users (
  457. id int NOT NULL,
  458. access_salt text NOT NULL,
  459. name varchar(255) NOT NULL,
  460. country_code varchar(2) NOT NULL,
  461. sex int NOT NULL,
  462. state int NOT NULL,
  463. PRIMARY KEY (id)
  464. )
  465. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 172: CREATE TABLE avatar_datas (
  466. entity_id bigint NOT NULL,
  467. entity_type int NOT NULL,
  468. small_avatar_file_id bigint,
  469. small_avatar_file_hash bigint,
  470. small_avatar_file_size int,
  471. large_avatar_file_id bigint,
  472. large_avatar_file_hash bigint,
  473. large_avatar_file_size int,
  474. full_avatar_file_id bigint,
  475. full_avatar_file_hash bigint,
  476. full_avatar_file_size int,
  477. full_avatar_width int,
  478. full_avatar_height int,
  479. PRIMARY KEY (entity_id, entity_type)
  480. )
  481. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 189: CREATE TABLE public_keys (
  482. user_id int NOT NULL,
  483. hash bigint NOT NULL,
  484. data bytea NOT NULL,
  485. deleted_at timestamp,
  486. PRIMARY KEY (user_id, hash)
  487. )
  488. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 197: CREATE TABLE auth_sessions (
  489. user_id int NOT NULL,
  490. id int NOT NULL,
  491. app_id int NOT NULL,
  492. app_title varchar(64) NOT NULL,
  493. auth_id bigint NOT NULL,
  494. public_key_hash bigint NOT NULL,
  495. device_hash bytea NOT NULL,
  496. device_title varchar(64) NOT NULL,
  497. auth_time timestamp NOT NULL,
  498. auth_location varchar(255),
  499. latitude double precision,
  500. longitude double precision,
  501. deleted_at timestamp,
  502. PRIMARY KEY (user_id, id)
  503. )
  504. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 214: CREATE UNIQUE INDEX ON auth_sessions(user_id, id, device_hash)
  505. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 216: CREATE TABLE user_phones (
  506. user_id int NOT NULL,
  507. id int NOT NULL,
  508. access_salt varchar(255) NOT NULL,
  509. number bigint NOT NULL,
  510. title varchar(64) NOT NULL,
  511. PRIMARY KEY (user_id, id)
  512. )
  513. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 225: CREATE TABLE auth_sms_codes (
  514. phone_number bigint NOT NULL,
  515. sms_hash varchar(64) NOT NULL,
  516. sms_code varchar(8) NOT NULL,
  517. PRIMARY KEY (phone_number)
  518. )
  519. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 232: CREATE UNIQUE INDEX user_phones_number_idx ON user_phones (number)
  520. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE history_messages (
  521. user_id int NOT NULL,
  522. peer_type int NOT NULL,
  523. peer_id int NOT NULL,
  524. date timestamp NOT NULL,
  525. sender_user_id int NOT NULL,
  526. random_id bigint NOT NULL,
  527. message_content_header int NOT NULL,
  528. message_content_data bytea NOT NULL,
  529. deleted_at timestamp,
  530. PRIMARY KEY(user_id, peer_type, peer_id, date, sender_user_id, random_id)
  531. )
  532. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE dialogs (
  533. user_id int NOT NULL,
  534. peer_type int NOT NULL,
  535. peer_id int NOT NULL,
  536. last_message_date timestamp NOT NULL,
  537. last_received_at timestamp NOT NULL,
  538. last_read_at timestamp NOT NULL,
  539. PRIMARY KEY(user_id, peer_type, peer_id)
  540. )
  541. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE google_push_credentials (
  542. auth_id bigint NOT NULL,
  543. project_id bigint NOT NULL,
  544. reg_id varchar(255) NOT NULL,
  545. PRIMARY KEY (auth_id)
  546. )
  547. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_google_push_credentials_reg_id on google_push_credentials(reg_id)
  548. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE log_events (
  549. id serial not null,
  550. auth_id bigint not null,
  551. phone_number bigint not null,
  552. email varchar(255) NOT NULL,
  553. klass smallint NOT NULL,
  554. json_body text NOT NULL,
  555. created_at TIMESTAMP NOT NULL DEFAULT now(),
  556. PRIMARY KEY (id)
  557. )
  558. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_log_events_auth_id ON log_events (auth_id)
  559. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_log_events_phone_number ON log_events (phone_number)
  560. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_log_events_email ON log_events (email)
  561. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE apple_push_credentials (
  562. auth_id bigint NOT NULL,
  563. apns_key int NOT NULL,
  564. token varchar(128) NOT NULL,
  565. PRIMARY KEY (auth_id)
  566. )
  567. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_apple_push_credentials_token on apple_push_credentials(token)
  568. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE groups (
  569. id int NOT NULL,
  570. creator_user_id int NOT NULL,
  571. access_hash bigint NOT NULL,
  572. title varchar(255) NOT NULL,
  573. created_at timestamp NOT NULL,
  574. title_changer_user_id int NOT NULL,
  575. title_changed_at timestamp NOT NULL,
  576. title_change_random_id bigint NOT NULL,
  577. avatar_changer_user_id int NOT NULL,
  578. avatar_changed_at timestamp NOT NULL,
  579. avatar_change_random_id bigint NOT NULL,
  580. PRIMARY KEY (id)
  581. )
  582. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE group_users (
  583. group_id int NOT NULL,
  584. user_id int NOT NULL,
  585. inviter_user_id int NOT NULL,
  586. invited_at timestamp NOT NULL,
  587. PRIMARY KEY (group_id, user_id)
  588. )
  589. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_group_users_user_id on group_users (user_id)
  590. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE unregistered_contacts (
  591. phone_number bigint,
  592. owner_user_id int,
  593. PRIMARY KEY (phone_number, owner_user_id)
  594. )
  595. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_contacts (
  596. owner_user_id int NOT NULL,
  597. contact_user_id int NOT NULL,
  598. phone_number bigint NOT NULL,
  599. name varchar(255),
  600. access_salt varchar(255) NOT NULL,
  601. is_deleted boolean NOT NULL default false,
  602. PRIMARY KEY (owner_user_id, contact_user_id)
  603. )
  604. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_user_contacts_owner_user_id_is_deleted on user_contacts(owner_user_id, is_deleted)
  605. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE file_datas (
  606. id bigint NOT NULL,
  607. access_salt varchar(255) NOT NULL,
  608. uploaded_blocks_count int NOT NULL default 0,
  609. length bigint NOT NULL default 0,
  610. PRIMARY KEY (id)
  611. )
  612. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE IF NOT EXISTS akka_journal (
  613. persistence_id VARCHAR(255) NOT NULL,
  614. sequence_number BIGINT NOT NULL,
  615. marker VARCHAR(255) NOT NULL,
  616. message TEXT NOT NULL,
  617. created TIMESTAMP NOT NULL,
  618. PRIMARY KEY(persistence_id, sequence_number)
  619. )
  620. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE IF NOT EXISTS akka_snapshot (
  621. persistence_id VARCHAR(255) NOT NULL,
  622. sequence_nr BIGINT NOT NULL,
  623. snapshot TEXT NOT NULL,
  624. created BIGINT NOT NULL,
  625. PRIMARY KEY (persistence_id, sequence_nr)
  626. )
  627. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_emails (
  628. id int NOT NULL,
  629. user_id int NOT NULL,
  630. email varchar(255) NOT NULL,
  631. access_salt varchar(255) NOT NULL,
  632. title varchar(255) NOT NULL,
  633. PRIMARY KEY (id)
  634. )
  635. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX idx_user_emails_email ON user_emails (email)
  636. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_user_emails_user_id ON user_emails (user_id)
  637. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE plain_mails (
  638. id serial not null,
  639. random_id bigint not null,
  640. mail_from varchar(255) NOT NULL,
  641. recipients text NOT NULL,
  642. message text NOT NULL,
  643. created_at TIMESTAMP NOT NULL DEFAULT now(),
  644. PRIMARY KEY (id)
  645. )
  646. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE file_blocks (
  647. file_id bigint NOT NULL,
  648. offset_ bigint NOT NULL,
  649. length bigint NOT NULL,
  650. PRIMARY KEY (file_id, offset_, length)
  651. )
  652. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE auth_ids (
  653. id bigint NOT NULL,
  654. public_key_hash bigint,
  655. user_id int,
  656. deleted_at timestamp,
  657. PRIMARY KEY (id)
  658. )
  659. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE users (
  660. id int NOT NULL,
  661. access_salt text NOT NULL,
  662. name varchar(255) NOT NULL,
  663. country_code varchar(2) NOT NULL,
  664. sex int NOT NULL,
  665. state int NOT NULL,
  666. PRIMARY KEY (id)
  667. )
  668. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE avatar_datas (
  669. entity_id bigint NOT NULL,
  670. entity_type int NOT NULL,
  671. small_avatar_file_id bigint,
  672. small_avatar_file_hash bigint,
  673. small_avatar_file_size int,
  674. large_avatar_file_id bigint,
  675. large_avatar_file_hash bigint,
  676. large_avatar_file_size int,
  677. full_avatar_file_id bigint,
  678. full_avatar_file_hash bigint,
  679. full_avatar_file_size int,
  680. full_avatar_width int,
  681. full_avatar_height int,
  682. PRIMARY KEY (entity_id, entity_type)
  683. )
  684. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE public_keys (
  685. user_id int NOT NULL,
  686. hash bigint NOT NULL,
  687. data bytea NOT NULL,
  688. deleted_at timestamp,
  689. PRIMARY KEY (user_id, hash)
  690. )
  691. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE auth_sessions (
  692. user_id int NOT NULL,
  693. id int NOT NULL,
  694. app_id int NOT NULL,
  695. app_title varchar(64) NOT NULL,
  696. auth_id bigint NOT NULL,
  697. public_key_hash bigint NOT NULL,
  698. device_hash bytea NOT NULL,
  699. device_title varchar(64) NOT NULL,
  700. auth_time timestamp NOT NULL,
  701. auth_location varchar(255),
  702. latitude double precision,
  703. longitude double precision,
  704. deleted_at timestamp,
  705. PRIMARY KEY (user_id, id)
  706. )
  707. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX ON auth_sessions(user_id, id, device_hash)
  708. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_phones (
  709. user_id int NOT NULL,
  710. id int NOT NULL,
  711. access_salt varchar(255) NOT NULL,
  712. number bigint NOT NULL,
  713. title varchar(64) NOT NULL,
  714. PRIMARY KEY (user_id, id)
  715. )
  716. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE auth_sms_codes (
  717. phone_number bigint NOT NULL,
  718. sms_hash varchar(64) NOT NULL,
  719. sms_code varchar(8) NOT NULL,
  720. PRIMARY KEY (phone_number)
  721. )
  722. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX user_phones_number_idx ON user_phones (number)
  723. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20142412173600
  724. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  725. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  726. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  727. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150315081300
  728. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE seq_updates_ngen (
  729. auth_id bigint NOT NULL,
  730. timestamp bigint NOT NULL,
  731. seq int NOT NULL,
  732. header int NOT NULL,
  733. serialized_data bytea NOT NULL,
  734. user_ids_str text NOT NULL,
  735. group_ids_str text NOT NULL,
  736. PRIMARY KEY (auth_id, timestamp)
  737. )
  738. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE seq_updates_ngen (
  739. auth_id bigint NOT NULL,
  740. timestamp bigint NOT NULL,
  741. seq int NOT NULL,
  742. header int NOT NULL,
  743. serialized_data bytea NOT NULL,
  744. user_ids_str text NOT NULL,
  745. group_ids_str text NOT NULL,
  746. PRIMARY KEY (auth_id, timestamp)
  747. )
  748. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150315081300
  749. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  750. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  751. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  752. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150417101800
  753. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE session_infos (
  754. auth_id bigint NOT NULL,
  755. session_id bigint NOT NULL,
  756. user_id int,
  757. PRIMARY KEY (auth_id, session_id)
  758. )
  759. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150417101800
  760. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  761. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  762. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  763. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150419155700
  764. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_presences (
  765. user_id int NOT NULL,
  766. last_seen_at timestamp,
  767. PRIMARY KEY(user_id)
  768. )
  769. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150419155700
  770. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  771. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  772. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  773. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150421163900
  774. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE auth_sessions DROP COLUMN public_key_hash
  775. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE auth_sessions DROP COLUMN public_key_hash
  776. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150421163900
  777. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  778. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  779. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  780. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150421185400
  781. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE managers (
  782. id int NOT NULL PRIMARY KEY,
  783. name varchar(256) not null,
  784. last_name varchar(256) not null,
  785. domain varchar(256) not null,
  786. auth_token varchar(256) not null,
  787. email varchar(256) not null
  788. )
  789. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 9: CREATE UNIQUE INDEX manager_email_idx ON managers (email)
  790. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE managers (
  791. id int NOT NULL PRIMARY KEY,
  792. name varchar(256) not null,
  793. last_name varchar(256) not null,
  794. domain varchar(256) not null,
  795. auth_token varchar(256) not null,
  796. email varchar(256) not null
  797. )
  798. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX manager_email_idx ON managers (email)
  799. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150421185400
  800. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  801. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  802. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  803. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150422120100
  804. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE files (
  805. id bigint NOT NULL,
  806. access_salt text NOT NULL,
  807. s3_upload_key text NOT NULL,
  808. is_uploaded boolean default false NOT NULL,
  809. PRIMARY KEY (id)
  810. )
  811. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 9: CREATE INDEX on files(s3_upload_key)
  812. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE files (
  813. id bigint NOT NULL,
  814. access_salt text NOT NULL,
  815. s3_upload_key text NOT NULL,
  816. is_uploaded boolean default false NOT NULL,
  817. PRIMARY KEY (id)
  818. )
  819. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX on files(s3_upload_key)
  820. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE file_parts (
  821. file_id bigint NOT NULL,
  822. number int NOT NULL,
  823. size int NOT NULL,
  824. s3_upload_key text NOT NULL,
  825. PRIMARY KEY (file_id, number)
  826. )
  827. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150422120100
  828. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  829. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  830. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  831. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150422185500
  832. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE config_parameters (
  833. user_id int NOT NULL,
  834. key text NOT NULL,
  835. value text NOT NULL,
  836. PRIMARY KEY (user_id, key)
  837. )
  838. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150422185500
  839. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  840. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  841. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  842. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150423011000
  843. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE social_relations (
  844. user_id int NOT NULL,
  845. related_to int NOT NULL,
  846. PRIMARY KEY (user_id, related_to)
  847. )
  848. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150423011000
  849. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  850. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  851. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  852. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150428181900
  853. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE files ADD COLUMN size bigint NOT NULL DEFAULT 0
  854. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE files ADD COLUMN size bigint NOT NULL DEFAULT 0
  855. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150428181900
  856. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  857. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  858. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  859. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150429112900
  860. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE users ADD COLUMN deleted_at TIMESTAMP
  861. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE users ADD COLUMN deleted_at TIMESTAMP
  862. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150429112900
  863. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  864. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  865. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  866. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150502124700
  867. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE extension IF NOT EXISTS ltree
  868. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: CREATE TABLE departments (
  869. id int NOT NULL PRIMARY KEY,
  870. name varchar(255) NOT NULL,
  871. struct ltree NOT NULL,
  872. deleted_at TIMESTAMP
  873. )
  874. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: CREATE UNIQUE INDEX departments_struct_idx ON departments (struct)
  875. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 9: CREATE TABLE user_department(
  876. user_id int NOT NULL,
  877. department_id int NOT NULL,
  878. PRIMARY KEY(user_id, department_id)
  879. )
  880. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE extension IF NOT EXISTS ltree
  881. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE departments (
  882. id int NOT NULL PRIMARY KEY,
  883. name varchar(255) NOT NULL,
  884. struct ltree NOT NULL,
  885. deleted_at TIMESTAMP
  886. )
  887. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX departments_struct_idx ON departments (struct)
  888. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_department(
  889. user_id int NOT NULL,
  890. department_id int NOT NULL,
  891. PRIMARY KEY(user_id, department_id)
  892. )
  893. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150502124700
  894. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  895. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  896. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  897. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150506191800
  898. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: DELETE from apple_push_credentials
  899. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE apple_push_credentials DROP COLUMN token
  900. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: ALTER TABLE apple_push_credentials ADD COLUMN token BYTEA NOT NULL
  901. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: DELETE from apple_push_credentials
  902. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE apple_push_credentials DROP COLUMN token
  903. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE apple_push_credentials ADD COLUMN token BYTEA NOT NULL
  904. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150506191800
  905. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  906. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  907. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  908. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150510194000
  909. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE files ADD COLUMN name text NOT NULL default ''
  910. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE files ADD COLUMN name text NOT NULL default ''
  911. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150510194000
  912. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  913. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  914. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  915. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150511051700
  916. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE unregistered_contacts ADD COLUMN name text
  917. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150511051700
  918. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  919. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  920. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  921. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150511214600
  922. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE vox_users (
  923. user_id INT NOT NULL,
  924. vox_user_id BIGINT NOT NULL,
  925. user_name VARCHAR(255) NOT NULL,
  926. display_name VARCHAR(255) NOT NULL,
  927. salt VARCHAR(255) NOT NULL,
  928. PRIMARY KEY(user_id)
  929. )
  930. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 10: CREATE UNIQUE INDEX on vox_users(vox_user_id)
  931. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE vox_users (
  932. user_id INT NOT NULL,
  933. vox_user_id BIGINT NOT NULL,
  934. user_name VARCHAR(255) NOT NULL,
  935. display_name VARCHAR(255) NOT NULL,
  936. salt VARCHAR(255) NOT NULL,
  937. PRIMARY KEY(user_id)
  938. )
  939. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX on vox_users(vox_user_id)
  940. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150511214600
  941. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  942. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  943. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  944. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150512234700
  945. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE dialogs
  946. ADD COLUMN owner_last_received_at timestamp,
  947. ADD COLUMN owner_last_read_at timestamp
  948. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 5: UPDATE dialogs SET owner_last_received_at = last_received_at
  949. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 6: UPDATE dialogs SET owner_last_read_at = last_read_at
  950. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: ALTER TABLE dialogs
  951. ALTER COLUMN owner_last_received_at SET NOT NULL,
  952. ALTER COLUMN owner_last_read_at SET NOT NULL
  953. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs
  954. ADD COLUMN owner_last_received_at timestamp,
  955. ADD COLUMN owner_last_read_at timestamp
  956. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: UPDATE dialogs SET owner_last_received_at = last_received_at
  957. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: UPDATE dialogs SET owner_last_read_at = last_read_at
  958. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs
  959. ALTER COLUMN owner_last_received_at SET NOT NULL,
  960. ALTER COLUMN owner_last_read_at SET NOT NULL
  961. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150512234700
  962. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  963. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  964. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  965. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150519163700
  966. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: DROP TABLE user_emails
  967. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: CREATE TABLE user_emails (
  968. id int NOT NULL,
  969. user_id int NOT NULL,
  970. email varchar(255) NOT NULL,
  971. access_salt varchar(255) NOT NULL,
  972. title varchar(255) NOT NULL,
  973. PRIMARY KEY (user_id, id)
  974. )
  975. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: DROP TABLE user_emails
  976. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_emails (
  977. id int NOT NULL,
  978. user_id int NOT NULL,
  979. email varchar(255) NOT NULL,
  980. access_salt varchar(255) NOT NULL,
  981. title varchar(255) NOT NULL,
  982. PRIMARY KEY (user_id, id)
  983. )
  984. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150519163700
  985. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  986. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  987. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  988. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150520123900
  989. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150520123900
  990. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  991. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  992. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  993. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150520222329
  994. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE users ADD COLUMN is_bot boolean NOT NULL default false
  995. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE users ADD COLUMN is_bot boolean NOT NULL default false
  996. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150520222329
  997. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  998. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  999. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1000. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150520222336
  1001. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE groups_bots (
  1002. group_id int NOT NULL,
  1003. user_id int NOT NULL,
  1004. token varchar(64) NOT NULL,
  1005. PRIMARY KEY (group_id, user_id)
  1006. )
  1007. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 7: CREATE UNIQUE INDEX bot_token_idx ON groups_bots (token)
  1008. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE groups_bots (
  1009. group_id int NOT NULL,
  1010. user_id int NOT NULL,
  1011. token varchar(64) NOT NULL,
  1012. PRIMARY KEY (group_id, user_id)
  1013. )
  1014. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX bot_token_idx ON groups_bots (token)
  1015. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150520222336
  1016. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1017. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1018. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1019. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150521141854
  1020. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE ilectro_interests (
  1021. id int NOT NULL,
  1022. name varchar(255) NOT NULL,
  1023. parent_id int NOT NULL,
  1024. full_path varchar(255) NOT NULL,
  1025. level int NOT NULL,
  1026. PRIMARY KEY (id)
  1027. )
  1028. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 10: CREATE INDEX ON ilectro_interests(level)
  1029. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 11: CREATE INDEX ON ilectro_interests(parent_id)
  1030. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE ilectro_interests (
  1031. id int NOT NULL,
  1032. name varchar(255) NOT NULL,
  1033. parent_id int NOT NULL,
  1034. full_path varchar(255) NOT NULL,
  1035. level int NOT NULL,
  1036. PRIMARY KEY (id)
  1037. )
  1038. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON ilectro_interests(level)
  1039. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON ilectro_interests(parent_id)
  1040. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150521141854
  1041. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1042. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1043. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1044. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150521141905
  1045. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE ilectro_users_interests (
  1046. user_id int NOT NULL,
  1047. interest_id int NOT NULL,
  1048. PRIMARY KEY (user_id, interest_id)
  1049. )
  1050. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE ilectro_users_interests (
  1051. user_id int NOT NULL,
  1052. interest_id int NOT NULL,
  1053. PRIMARY KEY (user_id, interest_id)
  1054. )
  1055. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150521141905
  1056. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1057. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1058. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1059. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150521150716
  1060. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE ilectro_users (
  1061. user_id int NOT NULL,
  1062. uuid UUID NOT NULL,
  1063. name varchar(255) NOT NULL,
  1064. PRIMARY KEY (user_id)
  1065. )
  1066. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: CREATE UNIQUE INDEX on ilectro_users(uuid)
  1067. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE ilectro_users (
  1068. user_id int NOT NULL,
  1069. uuid UUID NOT NULL,
  1070. name varchar(255) NOT NULL,
  1071. PRIMARY KEY (user_id)
  1072. )
  1073. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX on ilectro_users(uuid)
  1074. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150521150716
  1075. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1076. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1077. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1078. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150522142247
  1079. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE auth_sessions
  1080. ALTER COLUMN device_title TYPE VARCHAR(255)
  1081. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE auth_sessions
  1082. ALTER COLUMN device_title TYPE VARCHAR(255)
  1083. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150522142247
  1084. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1085. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1086. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1087. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150526031815
  1088. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE group_invite_tokens (
  1089. group_id INT NOT NULL,
  1090. creator_id INT NOT NULL,
  1091. token VARCHAR(255) NOT NULL,
  1092. revoked_at timestamp,
  1093. PRIMARY KEY(group_id, creator_id, token)
  1094. )
  1095. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: CREATE UNIQUE INDEX ON group_invite_tokens (revoked_at)
  1096. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 9: CREATE UNIQUE INDEX ON group_invite_tokens (token)
  1097. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE group_invite_tokens (
  1098. group_id INT NOT NULL,
  1099. creator_id INT NOT NULL,
  1100. token VARCHAR(255) NOT NULL,
  1101. revoked_at timestamp,
  1102. PRIMARY KEY(group_id, creator_id, token)
  1103. )
  1104. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX ON group_invite_tokens (revoked_at)
  1105. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX ON group_invite_tokens (token)
  1106. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150526031815
  1107. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1108. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1109. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1110. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150604180231
  1111. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE group_users ADD COLUMN joined_at timestamp DEFAULT NULL
  1112. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE group_users ADD COLUMN joined_at timestamp DEFAULT NULL
  1113. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150604180231
  1114. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1115. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1116. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1117. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150604220751
  1118. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: UPDATE group_users SET joined_at = invited_at
  1119. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150604220751
  1120. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1121. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1122. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1123. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150605160833
  1124. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE INDEX ON history_messages(message_content_header)
  1125. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON history_messages(message_content_header)
  1126. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150605160833
  1127. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1128. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1129. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1130. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150615205201
  1131. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE ilectro_users RENAME TO llectro_users
  1132. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE ilectro_interests RENAME TO llectro_interests
  1133. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: ALTER TABLE ilectro_users_interests RENAME TO llectro_users_interests
  1134. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE ilectro_users RENAME TO llectro_users
  1135. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE ilectro_interests RENAME TO llectro_interests
  1136. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE ilectro_users_interests RENAME TO llectro_users_interests
  1137. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150615205201
  1138. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1139. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1140. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1141. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150616000533
  1142. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE llectro_devices(
  1143. auth_id BIGINT,
  1144. screen_width INT,
  1145. screen_height INT,
  1146. PRIMARY KEY (auth_id)
  1147. )
  1148. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150616000533
  1149. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1150. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1151. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1152. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150618174638
  1153. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: create table oauth2_tokens (
  1154. id bigint not null,
  1155. user_id varchar(255) not null,
  1156. access_token varchar(255) not null,
  1157. token_type varchar(255) not null,
  1158. expires_in bigint not null,
  1159. refresh_token varchar(255),
  1160. created_at timestamp not null,
  1161. primary key(id, user_id)
  1162. )
  1163. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table oauth2_tokens (
  1164. id bigint not null,
  1165. user_id varchar(255) not null,
  1166. access_token varchar(255) not null,
  1167. token_type varchar(255) not null,
  1168. expires_in bigint not null,
  1169. refresh_token varchar(255),
  1170. created_at timestamp not null,
  1171. primary key(id, user_id)
  1172. )
  1173. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150618174638
  1174. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1175. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1176. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1177. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150618201809
  1178. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: create table auth_transactions (
  1179. transaction_hash varchar(255) not null,
  1180. app_id int not null,
  1181. api_key varchar(255) not null,
  1182. device_hash bytea not null,
  1183. device_title varchar(255) not null,
  1184. access_salt varchar(255) not null,
  1185. is_checked boolean not null,
  1186. deleted_at timestamp,
  1187. primary key(transaction_hash)
  1188. )
  1189. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 13: create table auth_phone_transactions (
  1190. phone_number bigint not null,
  1191. primary key(transaction_hash)
  1192. ) inherits(auth_transactions)
  1193. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 18: create table auth_email_transactions (
  1194. email varchar(255) not null,
  1195. redirect_uri varchar(255),
  1196. primary key(transaction_hash)
  1197. ) inherits(auth_transactions)
  1198. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table auth_transactions (
  1199. transaction_hash varchar(255) not null,
  1200. app_id int not null,
  1201. api_key varchar(255) not null,
  1202. device_hash bytea not null,
  1203. device_title varchar(255) not null,
  1204. access_salt varchar(255) not null,
  1205. is_checked boolean not null,
  1206. deleted_at timestamp,
  1207. primary key(transaction_hash)
  1208. )
  1209. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table auth_phone_transactions (
  1210. phone_number bigint not null,
  1211. primary key(transaction_hash)
  1212. ) inherits(auth_transactions)
  1213. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table auth_email_transactions (
  1214. email varchar(255) not null,
  1215. redirect_uri varchar(255),
  1216. primary key(transaction_hash)
  1217. ) inherits(auth_transactions)
  1218. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150618201809
  1219. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1220. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1221. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1222. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150618204803
  1223. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: create table auth_codes (
  1224. transaction_hash varchar(255) not null,
  1225. code varchar(8) not null,
  1226. created_at timestamp not null,
  1227. primary key(transaction_hash)
  1228. )
  1229. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table auth_codes (
  1230. transaction_hash varchar(255) not null,
  1231. code varchar(8) not null,
  1232. created_at timestamp not null,
  1233. primary key(transaction_hash)
  1234. )
  1235. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150618204803
  1236. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1237. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1238. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1239. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150618204804
  1240. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table auth_sms_codes rename to auth_sms_codes_obsolete
  1241. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_sms_codes rename to auth_sms_codes_obsolete
  1242. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150618204804
  1243. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1244. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1245. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1246. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150619125433
  1247. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table unregistered_contacts rename to unregistered_phone_contacts
  1248. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: alter table unregistered_phone_contacts drop constraint unregistered_contacts_pkey
  1249. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: alter table unregistered_phone_contacts add primary key(phone_number, owner_user_id)
  1250. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 5: create table unregistered_contacts (
  1251. owner_user_id int not null,
  1252. name text,
  1253. primary key (owner_user_id)
  1254. )
  1255. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 11: alter table unregistered_phone_contacts inherit unregistered_contacts
  1256. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 13: create table unregistered_email_contacts (
  1257. email varchar(255),
  1258. primary key (owner_user_id, email)
  1259. ) inherits(unregistered_contacts)
  1260. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table unregistered_contacts rename to unregistered_phone_contacts
  1261. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table unregistered_phone_contacts drop constraint unregistered_contacts_pkey
  1262. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table unregistered_phone_contacts add primary key(phone_number, owner_user_id)
  1263. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table unregistered_contacts (
  1264. owner_user_id int not null,
  1265. name text,
  1266. primary key (owner_user_id)
  1267. )
  1268. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table unregistered_phone_contacts inherit unregistered_contacts
  1269. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table unregistered_email_contacts (
  1270. email varchar(255),
  1271. primary key (owner_user_id, email)
  1272. ) inherits(unregistered_contacts)
  1273. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150619125433
  1274. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1275. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1276. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1277. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150621064349
  1278. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table user_contacts rename to user_phone_contacts
  1279. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: drop index idx_user_contacts_owner_user_id_is_deleted
  1280. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: alter table user_phone_contacts drop constraint user_contacts_pkey
  1281. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 4: alter table user_phone_contacts add primary key (owner_user_id, contact_user_id)
  1282. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 6: create table user_contacts (
  1283. owner_user_id int not null,
  1284. contact_user_id int not null,
  1285. name varchar(255),
  1286. access_salt varchar(255) not null,
  1287. is_deleted boolean not null default false,
  1288. primary key (owner_user_id, contact_user_id)
  1289. )
  1290. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 14: create INDEX idx_user_contacts_owner_user_id_is_deleted on user_contacts(owner_user_id, is_deleted)
  1291. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 16: alter table user_phone_contacts inherit user_contacts
  1292. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 18: create table user_email_contacts (
  1293. email varchar(255),
  1294. primary key(owner_user_id, contact_user_id)
  1295. ) inherits(user_contacts)
  1296. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table user_contacts rename to user_phone_contacts
  1297. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: drop index idx_user_contacts_owner_user_id_is_deleted
  1298. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table user_phone_contacts drop constraint user_contacts_pkey
  1299. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table user_phone_contacts add primary key (owner_user_id, contact_user_id)
  1300. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table user_contacts (
  1301. owner_user_id int not null,
  1302. contact_user_id int not null,
  1303. name varchar(255),
  1304. access_salt varchar(255) not null,
  1305. is_deleted boolean not null default false,
  1306. primary key (owner_user_id, contact_user_id)
  1307. )
  1308. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create INDEX idx_user_contacts_owner_user_id_is_deleted on user_contacts(owner_user_id, is_deleted)
  1309. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table user_phone_contacts inherit user_contacts
  1310. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table user_email_contacts (
  1311. email varchar(255),
  1312. primary key(owner_user_id, contact_user_id)
  1313. ) inherits(user_contacts)
  1314. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150621064349
  1315. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1316. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1317. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1318. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150627010404
  1319. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE groups ADD COLUMN is_public BOOLEAN NOT NULL DEFAULT false
  1320. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: CREATE INDEX ON groups(is_public)
  1321. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE groups ADD COLUMN is_public BOOLEAN NOT NULL DEFAULT false
  1322. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON groups(is_public)
  1323. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150627010404
  1324. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1325. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1326. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1327. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150630025815
  1328. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE groups ADD COLUMN description varchar(1024) NOT NULL DEFAULT ''
  1329. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE groups ADD COLUMN description varchar(1024) NOT NULL DEFAULT ''
  1330. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150630025815
  1331. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1332. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1333. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1334. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150702021401
  1335. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table auth_codes add column attempts int not null default 0
  1336. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_codes add column attempts int not null default 0
  1337. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150702021401
  1338. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1339. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1340. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1341. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150703211853
  1342. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table auth_codes add column is_deleted boolean not null default false
  1343. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: create index on auth_codes(transaction_hash, is_deleted)
  1344. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 4: alter table auth_sms_codes_obsolete add column is_deleted boolean not null default false
  1345. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 5: create sequence tmp_seq
  1346. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 6: alter table auth_sms_codes_obsolete add column id bigint not null default nextval('tmp_seq')
  1347. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 7: alter table auth_sms_codes_obsolete alter column id drop default
  1348. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: drop sequence tmp_seq
  1349. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 9: alter table auth_sms_codes_obsolete drop constraint auth_sms_codes_pkey
  1350. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 10: alter table auth_sms_codes_obsolete add primary key(id)
  1351. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 11: create index on auth_sms_codes_obsolete(phone_number, is_deleted)
  1352. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_codes add column is_deleted boolean not null default false
  1353. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create index on auth_codes(transaction_hash, is_deleted)
  1354. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_sms_codes_obsolete add column is_deleted boolean not null default false
  1355. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create sequence tmp_seq
  1356. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_sms_codes_obsolete add column id bigint not null default nextval('tmp_seq')
  1357. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_sms_codes_obsolete alter column id drop default
  1358. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: drop sequence tmp_seq
  1359. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_sms_codes_obsolete drop constraint auth_sms_codes_pkey
  1360. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table auth_sms_codes_obsolete add primary key(id)
  1361. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create index on auth_sms_codes_obsolete(phone_number, is_deleted)
  1362. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150703211853
  1363. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1364. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1365. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1366. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150707210259
  1367. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table users add column created_at timestamp
  1368. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: with sess as (select user_id, min(auth_time) as created_at from auth_sessions group by user_id) update users set created_at = (select created_at from sess where sess.user_id = id)
  1369. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: update users set created_at = now() where is_bot = true
  1370. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table users add column created_at timestamp
  1371. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: with sess as (select user_id, min(auth_time) as created_at from auth_sessions group by user_id) update users set created_at = (select created_at from sess where sess.user_id = id)
  1372. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update users set created_at = now() where is_bot = true
  1373. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150707210259
  1374. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1375. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1376. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1377. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150707220259
  1378. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: update users set created_at = '2015-04-01 12:00:00' where created_at is null
  1379. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: alter table users alter column created_at set not null
  1380. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update users set created_at = '2015-04-01 12:00:00' where created_at is null
  1381. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table users alter column created_at set not null
  1382. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150707220259
  1383. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1384. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1385. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1386. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150712032247
  1387. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: create table gate_auth_codes (
  1388. transaction_hash varchar(255) not null,
  1389. code_hash varchar(255) not null,
  1390. is_deleted boolean not null,
  1391. primary key(transaction_hash)
  1392. )
  1393. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table gate_auth_codes (
  1394. transaction_hash varchar(255) not null,
  1395. code_hash varchar(255) not null,
  1396. is_deleted boolean not null,
  1397. primary key(transaction_hash)
  1398. )
  1399. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150712032247
  1400. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1401. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1402. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1403. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150715050545
  1404. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE akka_snapshot RENAME TO snapshot
  1405. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE akka_journal RENAME TO journal
  1406. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE akka_snapshot RENAME TO snapshot
  1407. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE akka_journal RENAME TO journal
  1408. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150715050545
  1409. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1410. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1411. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1412. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150727191745
  1413. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE INDEX idx_apple_push_credentials_token on apple_push_credentials(token)
  1414. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_apple_push_credentials_token on apple_push_credentials(token)
  1415. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150727191745
  1416. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1417. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1418. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1419. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150731002716
  1420. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table users add column nickname varchar(255)
  1421. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: create unique index on users(nickname)
  1422. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: alter table users add column about varchar(255)
  1423. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table users add column nickname varchar(255)
  1424. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create unique index on users(nickname)
  1425. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table users add column about varchar(255)
  1426. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150731002716
  1427. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1428. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1429. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1430. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150731004315
  1431. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table group_users add column is_admin boolean default false
  1432. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table group_users add column is_admin boolean default false
  1433. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150731004315
  1434. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1435. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1436. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1437. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150731134010
  1438. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table groups add column topic varchar(255)
  1439. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: alter table groups rename column description to about
  1440. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: alter table groups alter column about drop not null
  1441. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 4: alter table groups alter column about drop default
  1442. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 5: update groups set about = null where about = ''
  1443. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table groups add column topic varchar(255)
  1444. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table groups rename column description to about
  1445. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table groups alter column about drop not null
  1446. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table groups alter column about drop default
  1447. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update groups set about = null where about = ''
  1448. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150731134010
  1449. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1450. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1451. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1452. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150731152013
  1453. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: update group_users gu set is_admin = true where gu.user_id = (select g.creator_user_id from groups g where g.id = gu.group_id)
  1454. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update group_users gu set is_admin = true where gu.user_id = (select g.creator_user_id from groups g where g.id = gu.group_id)
  1455. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150731152013
  1456. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1457. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1458. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1459. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150820183625
  1460. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: update dialogs d set last_read_at = now(), owner_last_received_at = now() where d.peer_type = 2 and d.peer_id not in (select group_id from group_users gu where gu.user_id = d.user_id)
  1461. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update dialogs d set last_read_at = now(), owner_last_received_at = now() where d.peer_type = 2 and d.peer_id not in (select group_id from group_users gu where gu.user_id = d.user_id)
  1462. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150820183625
  1463. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1464. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1465. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1466. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150821183625
  1467. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: update dialogs d set last_read_at = now(), owner_last_read_at = now() where d.peer_type = 2 and d.peer_id not in (select group_id from group_users gu where gu.user_id = d.user_id)
  1468. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update dialogs d set last_read_at = now(), owner_last_read_at = now() where d.peer_type = 2 and d.peer_id not in (select group_id from group_users gu where gu.user_id = d.user_id)
  1469. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150821183625
  1470. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1471. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1472. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1473. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20150928165628
  1474. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table users add column external varchar(255)
  1475. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table users add column external varchar(255)
  1476. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20150928165628
  1477. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1478. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1479. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1480. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151013221624
  1481. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE dialogs ADD COLUMN is_hidden BOOLEAN NOT NULL DEFAULT FALSE
  1482. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs ADD COLUMN is_hidden BOOLEAN NOT NULL DEFAULT FALSE
  1483. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151013221624
  1484. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1485. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1486. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1487. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151014194156
  1488. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE groups ADD COLUMN is_hidden BOOLEAN DEFAULT FALSE
  1489. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE dialogs DROP COLUMN is_hidden
  1490. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: ALTER TABLE dialogs ADD COLUMN is_archived BOOLEAN DEFAULT FALSE
  1491. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 4: CREATE INDEX idx_groups_id_is_hidden ON groups (id, is_hidden)
  1492. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 5: CREATE INDEX idx_dialogs_user_id_is_archived ON dialogs (user_id, is_archived)
  1493. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE groups ADD COLUMN is_hidden BOOLEAN DEFAULT FALSE
  1494. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs DROP COLUMN is_hidden
  1495. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs ADD COLUMN is_archived BOOLEAN DEFAULT FALSE
  1496. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_groups_id_is_hidden ON groups (id, is_hidden)
  1497. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX idx_dialogs_user_id_is_archived ON dialogs (user_id, is_archived)
  1498. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151014194156
  1499. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1500. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1501. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1502. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151020041600
  1503. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE user_contacts DROP COLUMN access_salt
  1504. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE user_phone_contacts DROP COLUMN access_salt
  1505. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_contacts DROP COLUMN access_salt
  1506. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_phone_contacts DROP COLUMN access_salt
  1507. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151020041600
  1508. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1509. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1510. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1511. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151021013035
  1512. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE avatar_datas ALTER COLUMN small_avatar_file_size TYPE bigint
  1513. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE avatar_datas ALTER COLUMN large_avatar_file_size TYPE bigint
  1514. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: ALTER TABLE avatar_datas ALTER COLUMN full_avatar_file_size TYPE bigint
  1515. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE avatar_datas ALTER COLUMN small_avatar_file_size TYPE bigint
  1516. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE avatar_datas ALTER COLUMN large_avatar_file_size TYPE bigint
  1517. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE avatar_datas ALTER COLUMN full_avatar_file_size TYPE bigint
  1518. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151021013035
  1519. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1520. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1521. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1522. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151027223908
  1523. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE dialogs ADD COLUMN created_at TIMESTAMP NOT NULL DEFAULT NOW()
  1524. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: CREATE INDEX ON dialogs(user_id, created_at)
  1525. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs ADD COLUMN created_at TIMESTAMP NOT NULL DEFAULT NOW()
  1526. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON dialogs(user_id, created_at)
  1527. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151027223908
  1528. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1529. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1530. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1531. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151028080853
  1532. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE INDEX auth_ids_user_id_deleted_at_idx ON auth_ids(user_id, deleted_at)
  1533. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX auth_ids_user_id_deleted_at_idx ON auth_ids(user_id, deleted_at)
  1534. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151028080853
  1535. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1536. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1537. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1538. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151029213151
  1539. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE auth_transactions ADD COLUMN user_data BYTEA
  1540. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE auth_transactions ADD COLUMN user_data BYTEA
  1541. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151029213151
  1542. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1543. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1544. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1545. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151030003749
  1546. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE auth_transactions RENAME user_data TO device_info
  1547. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151030003749
  1548. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1549. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1550. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1551. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151030163409
  1552. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE INDEX ON unregistered_email_contacts(email)
  1553. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: CREATE INDEX ON unregistered_phone_contacts(phone_number)
  1554. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON unregistered_email_contacts(email)
  1555. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON unregistered_phone_contacts(phone_number)
  1556. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151030163409
  1557. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1558. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1559. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1560. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151030173704
  1561. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: UPDATE auth_transactions SET device_info = ''
  1562. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE auth_transactions ALTER COLUMN device_info SET NOT NULL
  1563. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: ALTER TABLE auth_transactions ALTER COLUMN device_info SET DEFAULT ''
  1564. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: UPDATE auth_transactions SET device_info = ''
  1565. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE auth_transactions ALTER COLUMN device_info SET NOT NULL
  1566. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE auth_transactions ALTER COLUMN device_info SET DEFAULT ''
  1567. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151030173704
  1568. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1569. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1570. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1571. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151030195855
  1572. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE dialogs ADD COLUMN is_hidden BOOLEAN default false
  1573. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: CREATE INDEX on dialogs(is_hidden)
  1574. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs ADD COLUMN is_hidden BOOLEAN default false
  1575. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX on dialogs(is_hidden)
  1576. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151030195855
  1577. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1578. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1579. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1580. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151105010136
  1581. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE user_sequence(
  1582. user_id INT NOT NULL,
  1583. seq INT NOT NULL,
  1584. timestamp BIGINT NOT NULL,
  1585. mapping BYTEA NOT NULL,
  1586. PRIMARY KEY (user_id, seq)
  1587. )
  1588. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_sequence(
  1589. user_id INT NOT NULL,
  1590. seq INT NOT NULL,
  1591. timestamp BIGINT NOT NULL,
  1592. mapping BYTEA NOT NULL,
  1593. PRIMARY KEY (user_id, seq)
  1594. )
  1595. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151105010136
  1596. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1597. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1598. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1599. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151112033332
  1600. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE dialogs ADD COLUMN shown_at TIMESTAMP DEFAULT now()
  1601. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE dialogs DROP COLUMN is_hidden
  1602. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: CREATE INDEX dialogs_user_id_shown_at_idx ON dialogs(user_id, shown_at)
  1603. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs ADD COLUMN shown_at TIMESTAMP DEFAULT now()
  1604. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs DROP COLUMN is_hidden
  1605. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX dialogs_user_id_shown_at_idx ON dialogs(user_id, shown_at)
  1606. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151112033332
  1607. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1608. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1609. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1610. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151113191756
  1611. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: UPDATE dialogs SET shown_at = shown_at + ((RANDOM()*1000)::INT::TEXT || ' seconds')::INTERVAL WHERE shown_at IS NOT NULL
  1612. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: UPDATE dialogs SET shown_at = shown_at + ((RANDOM()*1000)::INT::TEXT || ' seconds')::INTERVAL WHERE shown_at IS NOT NULL
  1613. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151113191756
  1614. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1615. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1616. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1617. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151113233633
  1618. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE reactions (
  1619. dialog_type INT NOT NULL,
  1620. dialog_id VARCHAR NOT NULL,
  1621. random_id BIGINT NOT NULL,
  1622. code VARCHAR NOT NULL,
  1623. user_id INT NOT NULL,
  1624. PRIMARY KEY (dialog_type, dialog_id, random_id, code, user_id)
  1625. )
  1626. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE reactions (
  1627. dialog_type INT NOT NULL,
  1628. dialog_id VARCHAR NOT NULL,
  1629. random_id BIGINT NOT NULL,
  1630. code VARCHAR NOT NULL,
  1631. user_id INT NOT NULL,
  1632. PRIMARY KEY (dialog_type, dialog_id, random_id, code, user_id)
  1633. )
  1634. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151113233633
  1635. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1636. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1637. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1638. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151207212343
  1639. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: create table sticker_packs (
  1640. id int not null,
  1641. access_salt varchar(255) not null,
  1642. owner_user_id int not null,
  1643. is_default boolean not null default false,
  1644. primary key(id)
  1645. )
  1646. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 9: create table own_sticker_packs (
  1647. user_id int not null,
  1648. pack_id int not null,
  1649. primary key(user_id, pack_id)
  1650. )
  1651. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 15: create table sticker_data (
  1652. id int not null,
  1653. pack_id int not null,
  1654. emoji varchar(16),
  1655. image_128_file_id bigint not null,
  1656. image_128_file_hash bigint not null,
  1657. image_128_file_size bigint not null,
  1658. image_256_file_id bigint,
  1659. image_256_file_hash bigint,
  1660. image_256_file_size bigint,
  1661. image_512_file_id bigint,
  1662. image_512_file_hash bigint,
  1663. image_512_file_size bigint,
  1664. primary key(id, pack_id)
  1665. )
  1666. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table sticker_packs (
  1667. id int not null,
  1668. access_salt varchar(255) not null,
  1669. owner_user_id int not null,
  1670. is_default boolean not null default false,
  1671. primary key(id)
  1672. )
  1673. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table own_sticker_packs (
  1674. user_id int not null,
  1675. pack_id int not null,
  1676. primary key(user_id, pack_id)
  1677. )
  1678. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table sticker_data (
  1679. id int not null,
  1680. pack_id int not null,
  1681. emoji varchar(16),
  1682. image_128_file_id bigint not null,
  1683. image_128_file_hash bigint not null,
  1684. image_128_file_size bigint not null,
  1685. image_256_file_id bigint,
  1686. image_256_file_hash bigint,
  1687. image_256_file_size bigint,
  1688. image_512_file_id bigint,
  1689. image_512_file_hash bigint,
  1690. image_512_file_size bigint,
  1691. primary key(id, pack_id)
  1692. )
  1693. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151207212343
  1694. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1695. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1696. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1697. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151217161100
  1698. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table files rename column s3_upload_key to upload_key
  1699. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: alter table file_parts rename column s3_upload_key to upload_key
  1700. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table files rename column s3_upload_key to upload_key
  1701. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table file_parts rename column s3_upload_key to upload_key
  1702. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151217161100
  1703. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1704. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1705. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1706. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151221164145
  1707. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE dialogs ADD COLUMN is_favourite BOOLEAN NOT NULL DEFAULT FALSE
  1708. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151221164145
  1709. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1710. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1711. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1712. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151222034230
  1713. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table sticker_data add column image_128_width int not null default 128
  1714. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: alter table sticker_data add column image_128_height int not null default 128
  1715. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 4: alter table sticker_data add column image_256_width int default 256
  1716. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 5: alter table sticker_data add column image_256_height int default 256
  1717. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 7: alter table sticker_data add column image_512_width int default 512
  1718. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: alter table sticker_data add column image_512_height int default 512
  1719. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table sticker_data add column image_128_width int not null default 128
  1720. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table sticker_data add column image_128_height int not null default 128
  1721. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table sticker_data add column image_256_width int default 256
  1722. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table sticker_data add column image_256_height int default 256
  1723. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table sticker_data add column image_512_width int default 512
  1724. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table sticker_data add column image_512_height int default 512
  1725. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151222034230
  1726. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1727. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1728. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1729. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151223215842
  1730. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE http_api_tokens (
  1731. token text NOT NULL,
  1732. is_admin BOOL NOT NULL DEFAULT FALSE,
  1733. PRIMARY KEY(token)
  1734. )
  1735. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE http_api_tokens (
  1736. token text NOT NULL,
  1737. is_admin BOOL NOT NULL DEFAULT FALSE,
  1738. PRIMARY KEY(token)
  1739. )
  1740. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151223215842
  1741. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1742. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1743. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1744. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151224051919
  1745. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: alter table config_parameters alter COLUMN value drop not null
  1746. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table config_parameters alter COLUMN value drop not null
  1747. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151224051919
  1748. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1749. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1750. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1751. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151224225330
  1752. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_passwords (
  1753. user_id INT NOT NULL,
  1754. salt BYTEA NOT NULL,
  1755. hash TEXT NOT NULL,
  1756. PRIMARY KEY (user_id)
  1757. )
  1758. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151224225330
  1759. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1760. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1761. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1762. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20151225015119
  1763. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE auth_username_transactions (
  1764. username TEXT NOT NULL,
  1765. user_id INT,
  1766. PRIMARY KEY (transaction_hash)
  1767. ) INHERITS(auth_transactions)
  1768. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20151225015119
  1769. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1770. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1771. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1772. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160107153720
  1773. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE master_keys (
  1774. auth_id BIGINT NOT NULL,
  1775. body BYTEA NOT NULL,
  1776. PRIMARY KEY (auth_id)
  1777. )
  1778. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE master_keys (
  1779. auth_id BIGINT NOT NULL,
  1780. body BYTEA NOT NULL,
  1781. PRIMARY KEY (auth_id)
  1782. )
  1783. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160107153720
  1784. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1785. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1786. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1787. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160112161110
  1788. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: DROP TABLE user_passwords
  1789. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: CREATE TABLE user_passwords (
  1790. user_id INT NOT NULL,
  1791. hash BYTEA NOT NULL,
  1792. salt BYTEA NOT NULL,
  1793. PRIMARY KEY (user_id)
  1794. )
  1795. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: DROP TABLE user_passwords
  1796. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE user_passwords (
  1797. user_id INT NOT NULL,
  1798. hash BYTEA NOT NULL,
  1799. salt BYTEA NOT NULL,
  1800. PRIMARY KEY (user_id)
  1801. )
  1802. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160112161110
  1803. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1804. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1805. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1806. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160112234110
  1807. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE device_features (
  1808. auth_id BIGINT NOT NULL,
  1809. name TEXT NOT NULL,
  1810. args BYTEA NOT NULL,
  1811. PRIMARY KEY (auth_id)
  1812. )
  1813. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160112234110
  1814. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1815. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1816. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1817. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160112234231
  1818. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE webrtc_calls (
  1819. id BIGINT NOT NULL,
  1820. initiator_user_id INT NOT NULL,
  1821. receiver_user_id INT NOT NULL,
  1822. PRIMARY KEY (id)
  1823. )
  1824. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160112234231
  1825. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1826. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1827. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1828. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160117171824
  1829. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE INDEX ON google_push_credentials(reg_id)
  1830. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON google_push_credentials(reg_id)
  1831. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160117171824
  1832. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1833. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1834. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1835. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160119175838
  1836. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE encryption_key_groups (
  1837. user_id INT NOT NULL,
  1838. id BIGINT NOT NULL,
  1839. body BYTEA NOT NULL,
  1840. PRIMARY KEY (user_id, id)
  1841. )
  1842. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: CREATE INDEX ON encryption_key_groups(user_id)
  1843. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 10: CREATE TABLE ephermal_public_keys (
  1844. user_id INT NOT NULL,
  1845. key_group_id INT NOT NULL,
  1846. key_id BIGINT NOT NULL,
  1847. body BYTEA,
  1848. PRIMARY KEY (user_id, key_group_id, key_id)
  1849. )
  1850. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 18: CREATE INDEX ON ephermal_public_keys(user_id, key_group_id)
  1851. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE encryption_key_groups (
  1852. user_id INT NOT NULL,
  1853. id BIGINT NOT NULL,
  1854. body BYTEA NOT NULL,
  1855. PRIMARY KEY (user_id, id)
  1856. )
  1857. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON encryption_key_groups(user_id)
  1858. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE ephermal_public_keys (
  1859. user_id INT NOT NULL,
  1860. key_group_id INT NOT NULL,
  1861. key_id BIGINT NOT NULL,
  1862. body BYTEA,
  1863. PRIMARY KEY (user_id, key_group_id, key_id)
  1864. )
  1865. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON ephermal_public_keys(user_id, key_group_id)
  1866. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160119175838
  1867. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1868. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1869. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1870. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160121182140
  1871. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE user_sequence ADD COLUMN reduce_key TEXT
  1872. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: CREATE INDEX on user_sequence(user_id, reduce_key, seq)
  1873. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_sequence ADD COLUMN reduce_key TEXT
  1874. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX on user_sequence(user_id, reduce_key, seq)
  1875. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160121182140
  1876. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1877. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1878. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1879. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160122065245
  1880. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE actor_push_credentials (
  1881. auth_id BIGINT NOT NULL,
  1882. topic TEXT NOT NULL,
  1883. PRIMARY KEY (auth_id)
  1884. )
  1885. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 7: CREATE UNIQUE INDEX ON actor_push_credentials (topic)
  1886. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE actor_push_credentials (
  1887. auth_id BIGINT NOT NULL,
  1888. topic TEXT NOT NULL,
  1889. PRIMARY KEY (auth_id)
  1890. )
  1891. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE UNIQUE INDEX ON actor_push_credentials (topic)
  1892. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160122065245
  1893. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  1894. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  1895. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  1896. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160125185107
  1897. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: create table dialog_commons(
  1898. dialog_id varchar(255) not null,
  1899. last_message_date timestamp not null,
  1900. last_received_at timestamp not null,
  1901. last_read_at timestamp not null,
  1902. primary key(dialog_id)
  1903. )
  1904. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 10: delete from dialogs where peer_type = 1 and peer_id = user_id
  1905. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 13: delete from dialogs where peer_type = 1 and peer_id not in(select id from users)
  1906. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 14: delete from dialogs where peer_type = 1 and user_id not in(select id from users)
  1907. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 17: delete from dialogs where peer_type = 2 and peer_id not in(select id from groups)
  1908. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 20: create table max_dates(
  1909. dialog_id varchar(255),
  1910. last_message_date timestamp,
  1911. last_received_at timestamp ,
  1912. last_read_at timestamp,
  1913. primary key(dialog_id)
  1914. )
  1915. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 29: insert into max_dates(dialog_id)
  1916. select distinct on(id) (concat(peer_type, '_', (case
  1917. when peer_type = 1 then (case
  1918. when user_id < peer_id then
  1919. concat(user_id, '_', peer_id)
  1920. else concat(peer_id, '_', user_id)
  1921. end)
  1922. when peer_type = 2 then peer_id::varchar
  1923. end))) as id from dialogs
  1924. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 40: with lmd as (select concat('2', '_', peer_id) as dialog_id, max(last_message_date) as last_message_date from dialogs where peer_type = 2 group by peer_id)
  1925. update max_dates md set last_message_date = (select last_message_date from lmd where lmd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lmd)
  1926. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 43: with lrc as (select concat('2', '_', peer_id) as dialog_id, max(last_received_at) as last_received_at from dialogs where peer_type = 2 group by peer_id)
  1927. update max_dates md set last_received_at = (select last_received_at from lrc where lrc.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrc)
  1928. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 46: with lrd as (select concat('2', '_', peer_id) as dialog_id, max(last_read_at) as last_read_at from dialogs where peer_type = 2 group by peer_id)
  1929. update max_dates md set last_read_at = (select last_read_at from lrd where lrd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrd)
  1930. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 49: with lmd as (
  1931. select distinct on(dialog_id) concat('1_', (case when user_id < peer_id then concat(user_id, '_', peer_id) else concat(peer_id, '_', user_id) end)) as dialog_id,
  1932. max(last_message_date) as last_message_date from dialogs where peer_type = 1 group by dialog_id)
  1933. update max_dates md set last_message_date = (select last_message_date from lmd where lmd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lmd)
  1934. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 54: with lrc as (
  1935. select distinct on(dialog_id) concat('1_', (case when user_id < peer_id then concat(user_id, '_', peer_id) else concat(peer_id, '_', user_id) end)) as dialog_id,
  1936. max(last_received_at) as last_received_at from dialogs where peer_type = 1 group by dialog_id)
  1937. update max_dates md set last_received_at = (select last_received_at from lrc where lrc.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrc)
  1938. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 59: with lrd as (
  1939. select distinct on(dialog_id) concat('1_', (case when user_id < peer_id then concat(user_id, '_', peer_id) else concat(peer_id, '_', user_id) end)) as dialog_id,
  1940. max(last_read_at) as last_read_at from dialogs where peer_type = 1 group by dialog_id)
  1941. update max_dates md set last_read_at = (select last_read_at from lrd where lrd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrd)
  1942. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 65: insert into dialog_commons(dialog_id, last_message_date, last_received_at, last_read_at)
  1943. select distinct on(id) (concat(peer_type, '_', (case
  1944. when peer_type = 1 then (case
  1945. when user_id < peer_id then
  1946. concat(user_id, '_', peer_id)
  1947. else concat(peer_id, '_', user_id)
  1948. end)
  1949. when peer_type = 2 then peer_id::varchar
  1950. end))) as id, last_message_date, last_received_at, last_read_at
  1951. from dialogs
  1952. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 77: update dialog_commons dc set last_message_date = (select md.last_message_date from max_dates md where md.dialog_id = dc.dialog_id)
  1953. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 78: update dialog_commons dc set last_received_at = (select md.last_received_at from max_dates md where md.dialog_id = dc.dialog_id)
  1954. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 79: update dialog_commons dc set last_read_at = (select md.last_read_at from max_dates md where md.dialog_id = dc.dialog_id)
  1955. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 82: alter table dialogs alter column last_message_date drop not null
  1956. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 83: alter table dialogs alter column last_received_at drop not null
  1957. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 84: alter table dialogs alter column last_read_at drop not null
  1958. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 85: alter table dialogs alter column created_at drop not null
  1959. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 87: alter table dialogs rename to user_dialogs
  1960. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table dialog_commons(
  1961. dialog_id varchar(255) not null,
  1962. last_message_date timestamp not null,
  1963. last_received_at timestamp not null,
  1964. last_read_at timestamp not null,
  1965. primary key(dialog_id)
  1966. )
  1967. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: delete from dialogs where peer_type = 1 and peer_id = user_id
  1968. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: delete from dialogs where peer_type = 1 and peer_id not in(select id from users)
  1969. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: delete from dialogs where peer_type = 1 and user_id not in(select id from users)
  1970. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: delete from dialogs where peer_type = 2 and peer_id not in(select id from groups)
  1971. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table max_dates(
  1972. dialog_id varchar(255),
  1973. last_message_date timestamp,
  1974. last_received_at timestamp ,
  1975. last_read_at timestamp,
  1976. primary key(dialog_id)
  1977. )
  1978. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: insert into max_dates(dialog_id)
  1979. select distinct on(id) (concat(peer_type, '_', (case
  1980. when peer_type = 1 then (case
  1981. when user_id < peer_id then
  1982. concat(user_id, '_', peer_id)
  1983. else concat(peer_id, '_', user_id)
  1984. end)
  1985. when peer_type = 2 then peer_id::varchar
  1986. end))) as id from dialogs
  1987. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: with lmd as (select concat('2', '_', peer_id) as dialog_id, max(last_message_date) as last_message_date from dialogs where peer_type = 2 group by peer_id)
  1988. update max_dates md set last_message_date = (select last_message_date from lmd where lmd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lmd)
  1989. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: with lrc as (select concat('2', '_', peer_id) as dialog_id, max(last_received_at) as last_received_at from dialogs where peer_type = 2 group by peer_id)
  1990. update max_dates md set last_received_at = (select last_received_at from lrc where lrc.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrc)
  1991. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: with lrd as (select concat('2', '_', peer_id) as dialog_id, max(last_read_at) as last_read_at from dialogs where peer_type = 2 group by peer_id)
  1992. update max_dates md set last_read_at = (select last_read_at from lrd where lrd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrd)
  1993. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: with lmd as (
  1994. select distinct on(dialog_id) concat('1_', (case when user_id < peer_id then concat(user_id, '_', peer_id) else concat(peer_id, '_', user_id) end)) as dialog_id,
  1995. max(last_message_date) as last_message_date from dialogs where peer_type = 1 group by dialog_id)
  1996. update max_dates md set last_message_date = (select last_message_date from lmd where lmd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lmd)
  1997. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: with lrc as (
  1998. select distinct on(dialog_id) concat('1_', (case when user_id < peer_id then concat(user_id, '_', peer_id) else concat(peer_id, '_', user_id) end)) as dialog_id,
  1999. max(last_received_at) as last_received_at from dialogs where peer_type = 1 group by dialog_id)
  2000. update max_dates md set last_received_at = (select last_received_at from lrc where lrc.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrc)
  2001. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: with lrd as (
  2002. select distinct on(dialog_id) concat('1_', (case when user_id < peer_id then concat(user_id, '_', peer_id) else concat(peer_id, '_', user_id) end)) as dialog_id,
  2003. max(last_read_at) as last_read_at from dialogs where peer_type = 1 group by dialog_id)
  2004. update max_dates md set last_read_at = (select last_read_at from lrd where lrd.dialog_id = md.dialog_id) where dialog_id in (select dialog_id from lrd)
  2005. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: insert into dialog_commons(dialog_id, last_message_date, last_received_at, last_read_at)
  2006. select distinct on(id) (concat(peer_type, '_', (case
  2007. when peer_type = 1 then (case
  2008. when user_id < peer_id then
  2009. concat(user_id, '_', peer_id)
  2010. else concat(peer_id, '_', user_id)
  2011. end)
  2012. when peer_type = 2 then peer_id::varchar
  2013. end))) as id, last_message_date, last_received_at, last_read_at
  2014. from dialogs
  2015. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update dialog_commons dc set last_message_date = (select md.last_message_date from max_dates md where md.dialog_id = dc.dialog_id)
  2016. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update dialog_commons dc set last_received_at = (select md.last_received_at from max_dates md where md.dialog_id = dc.dialog_id)
  2017. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: update dialog_commons dc set last_read_at = (select md.last_read_at from max_dates md where md.dialog_id = dc.dialog_id)
  2018. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table dialogs alter column last_message_date drop not null
  2019. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table dialogs alter column last_received_at drop not null
  2020. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table dialogs alter column last_read_at drop not null
  2021. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table dialogs alter column created_at drop not null
  2022. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: alter table dialogs rename to user_dialogs
  2023. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160125185107
  2024. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2025. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2026. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2027. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160127074506
  2028. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE INDEX ON unregistered_phone_contacts(phone_number)
  2029. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON unregistered_phone_contacts(phone_number)
  2030. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160127074506
  2031. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2032. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2033. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2034. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160128094919
  2035. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: CREATE TABLE IF NOT EXISTS public.persistence_journal (
  2036. persistence_id VARCHAR(255) NOT NULL,
  2037. sequence_number BIGINT NOT NULL,
  2038. created BIGINT NOT NULL,
  2039. tags VARCHAR(255) DEFAULT NULL,
  2040. message BYTEA NOT NULL,
  2041. PRIMARY KEY(persistence_id, sequence_number)
  2042. )
  2043. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 10: DROP TABLE IF EXISTS public.persistence_deleted_to
  2044. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 12: CREATE TABLE IF NOT EXISTS public.persistence_deleted_to (
  2045. persistence_id VARCHAR(255) NOT NULL,
  2046. deleted_to BIGINT NOT NULL
  2047. )
  2048. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 17: CREATE TABLE IF NOT EXISTS public.persistence_snapshot (
  2049. persistence_id VARCHAR(255) NOT NULL,
  2050. sequence_number BIGINT NOT NULL,
  2051. created BIGINT NOT NULL,
  2052. snapshot BYTEA NOT NULL,
  2053. PRIMARY KEY(persistence_id, sequence_number)
  2054. )
  2055. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE IF NOT EXISTS public.persistence_journal (
  2056. persistence_id VARCHAR(255) NOT NULL,
  2057. sequence_number BIGINT NOT NULL,
  2058. created BIGINT NOT NULL,
  2059. tags VARCHAR(255) DEFAULT NULL,
  2060. message BYTEA NOT NULL,
  2061. PRIMARY KEY(persistence_id, sequence_number)
  2062. )
  2063. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: DROP TABLE IF EXISTS public.persistence_deleted_to
  2064. INFO  o.f.c.i.dbsupport.JdbcTemplate  DB: table "persistence_deleted_to" does not exist, skipping
  2065. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE IF NOT EXISTS public.persistence_deleted_to (
  2066. persistence_id VARCHAR(255) NOT NULL,
  2067. deleted_to BIGINT NOT NULL
  2068. )
  2069. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE TABLE IF NOT EXISTS public.persistence_snapshot (
  2070. persistence_id VARCHAR(255) NOT NULL,
  2071. sequence_number BIGINT NOT NULL,
  2072. created BIGINT NOT NULL,
  2073. snapshot BYTEA NOT NULL,
  2074. PRIMARY KEY(persistence_id, sequence_number)
  2075. )
  2076. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160128094919
  2077. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2078. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2079. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2080. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160128142000
  2081. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160128142000
  2082. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2083. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2084. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2085. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160203202648
  2086. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE user_presences ADD COLUMN auth_id BIGINT NOT NULL DEFAULT 0
  2087. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: CREATE INDEX ON user_presences (user_id, last_seen_at)
  2088. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: CREATE INDEX ON user_presences (user_id, auth_id)
  2089. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_presences ADD COLUMN auth_id BIGINT NOT NULL DEFAULT 0
  2090. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON user_presences (user_id, last_seen_at)
  2091. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON user_presences (user_id, auth_id)
  2092. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160203202648
  2093. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2094. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2095. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2096. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160203202749
  2097. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160203202749
  2098. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2099. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2100. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2101. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160204195902
  2102. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE user_presences DROP CONSTRAINT user_presences_pkey
  2103. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: DROP INDEX user_presences_user_id_auth_id_idx
  2104. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: ALTER TABLE user_presences ADD PRIMARY KEY (user_id, auth_id)
  2105. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_presences DROP CONSTRAINT user_presences_pkey
  2106. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: DROP INDEX user_presences_user_id_auth_id_idx
  2107. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_presences ADD PRIMARY KEY (user_id, auth_id)
  2108. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160204195902
  2109. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2110. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2111. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2112. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160205215901
  2113. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE user_dialogs ADD COLUMN archived_at TIMESTAMP DEFAULT NULL
  2114. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 2: ALTER TABLE user_dialogs DROP COLUMN is_archived
  2115. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 3: CREATE INDEX ON user_dialogs(user_id, archived_at)
  2116. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 4: UPDATE user_dialogs SET archived_at = (
  2117. CASE shown_at
  2118. WHEN NULL THEN NOW() + ((RANDOM()*1000)::INT::TEXT || ' seconds')::INTERVAL
  2119. ELSE NULL
  2120. END
  2121. )
  2122. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_dialogs ADD COLUMN archived_at TIMESTAMP DEFAULT NULL
  2123. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE user_dialogs DROP COLUMN is_archived
  2124. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: CREATE INDEX ON user_dialogs(user_id, archived_at)
  2125. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: UPDATE user_dialogs SET archived_at = (
  2126. CASE shown_at
  2127. WHEN NULL THEN NOW() + ((RANDOM()*1000)::INT::TEXT || ' seconds')::INTERVAL
  2128. ELSE NULL
  2129. END
  2130. )
  2131. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160205215901
  2132. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2133. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2134. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2135. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160228174726
  2136. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: ALTER TABLE apple_push_credentials ADD COLUMN is_voip BOOL NOT NULL DEFAULT FALSE
  2137. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: ALTER TABLE apple_push_credentials ADD COLUMN is_voip BOOL NOT NULL DEFAULT FALSE
  2138. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160228174726
  2139. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2140. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2141. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2142. INFO  o.f.core.internal.command.DbMigrate  Migrating schema "public" to version 20160311221657
  2143. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 1: create table client_stats(
  2144. id bigint not null,
  2145. user_id int not null,
  2146. auth_id bigint not null,
  2147. event varchar(1024) not null,
  2148. primary key(id)
  2149. )
  2150. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 8: create index on client_stats(user_id)
  2151. DEBUG o.f.c.internal.dbsupport.SqlScript  Found statement at line 9: create index on client_stats(auth_id)
  2152. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create table client_stats(
  2153. id bigint not null,
  2154. user_id int not null,
  2155. auth_id bigint not null,
  2156. event varchar(1024) not null,
  2157. primary key(id)
  2158. )
  2159. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create index on client_stats(user_id)
  2160. DEBUG o.f.c.internal.dbsupport.SqlScript  Executing SQL: create index on client_stats(auth_id)
  2161. DEBUG o.f.core.internal.command.DbMigrate  Successfully completed and committed migration of schema "public" to version 20160311221657
  2162. DEBUG o.f.c.i.m.MetaDataTableImpl  MetaData table "public"."schema_version" successfully updated to reflect changes
  2163. DEBUG o.f.core.internal.dbsupport.Table  Locking table "public"."schema_version"...
  2164. DEBUG o.f.core.internal.dbsupport.Table  Lock acquired for table "public"."schema_version"
  2165. INFO  o.f.core.internal.command.DbMigrate  Successfully applied 94 migrations to schema "public" (execution time 00:02.999s).
  2166. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@4930f9f8
  2167. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2168. 19:49:25.849UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Going to a single-node cluster mode
  2169. 19:49:25.862UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - Node [akka.tcp://actor-server@31.187.70.88:2552] is JOINING, roles []
  2170. 19:49:25.875UTC INFO  a.c.Cluster(akka://actor-server) akka.cluster.Cluster(akka://actor-server) Cluster Node [akka.tcp://actor-server@31.187.70.88:2552] - Leader is moving node [akka.tcp://actor-server@31.187.70.88:2552] to [Up]
  2171. 19:49:25.960UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/shardakka-kv-MigrationsCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/shardakka-kv-MigrationsCoordinator/singleton]
  2172. 19:49:25.964UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/shardakka-kv-MigrationsCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2173. 19:49:25.974UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-Migrations Singleton manager starting singleton actor [akka://actor-server/user/SimpleKeyValueRoot-Migrations/singleton]
  2174. 19:49:25.975UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-Migrations ClusterSingletonManager state change [Start -> Oldest]
  2175. 19:49:26.018UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/shardakka-kv-MigrationsCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2176. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2177. 19:49:26.926UTC INFO  a.c.singleton.ClusterSingletonProxy akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-Migrations-Proxy Singleton identified at [akka://actor-server/user/SimpleKeyValueRoot-Migrations/singleton]
  2178. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2179. 19:49:28.077UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-04-UsersMigration started
  2180. INFO  i.a.server.db.ActorPostgresDriver   >>> binding uuid -> java.util.UUID 
  2181. INFO  i.a.server.db.ActorPostgresDriver   >>> binding text -> java.lang.String 
  2182. INFO  i.a.server.db.ActorPostgresDriver   >>> binding bool -> Boolean 
  2183. 19:49:28.247UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-04-UsersMigration finished
  2184. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2185. 19:49:28.509UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-04-GroupsMigration started
  2186. 19:49:28.541UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-04-GroupsMigration finished
  2187. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2188. 19:49:28.622UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-20-LocalNamesMigration started
  2189. 19:49:28.622UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migrating local names
  2190. 19:49:28.694UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-20-LocalNamesMigration finished
  2191. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2192. 19:49:28.795UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-29-GroupCreatorMemberMigration started
  2193. 19:49:28.803UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-29-GroupCreatorMemberMigration finished
  2194. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2195. 19:49:28.888UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration PutHiddenGroupsToSQL started
  2196. 19:49:28.900UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration PutHiddenGroupsToSQL finished
  2197. 19:49:28.694UTC DEBUG com.zaxxer.hikari.pool.PoolElf akka.actor.ActorSystemImpl(actor-server) main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2198. 19:49:28.968UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-11-03-LocalNamesFromKVMigration started
  2199. 19:49:28.968UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migrating local names from KV
  2200. 19:49:28.981UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-11-03-LocalNamesFromKVMigration finished
  2201. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2202. 19:49:29.081UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-11-11-FillUserSequence started
  2203. WARN  s.m.V20151108011300__FillUserSequence  Starting filling user sequence
  2204. DEBUG s.backend.DatabaseComponent.stream  Signaling onSubscribe(slick.jdbc.JdbcBackend$JdbcStreamingActionContext@73d7ddf4)
  2205. DEBUG s.backend.DatabaseComponent.stream  Starting initial streaming action, realDemand = 16
  2206. DEBUG s.backend.DatabaseComponent.stream  Signaling onComplete()
  2207. WARN  s.m.V20151108011300__FillUserSequence  Migration complete! Moved 0 updates
  2208. 19:49:29.129UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-11-11-FillUserSequence finished
  2209. DEBUG s.backend.DatabaseComponent.stream  Sent up to 16 elements - Stream completely delivered
  2210. DEBUG s.backend.DatabaseComponent.stream  Finished streaming action
  2211. 19:49:28.981UTC DEBUG com.zaxxer.hikari.pool.PoolElf akka.actor.ActorSystemImpl(actor-server) main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2212. 19:49:29.213UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-11-12-FixUserSequence started
  2213. 19:49:29.237UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-11-12-FixUserSequence finished
  2214. 19:49:29.293UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/WeakUpdatesManagerCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/WeakUpdatesManager#-564937552] to Actor[akka://actor-server/system/sharding/WeakUpdatesManagerCoordinator/singleton/coordinator] was not delivered. [1] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2215. 19:49:29.295UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/WeakUpdatesManagerCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/WeakUpdatesManagerCoordinator/singleton]
  2216. 19:49:29.295UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/WeakUpdatesManagerCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2217. 19:49:29.295UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/WeakUpdatesManagerCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2218. 19:49:29.306UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/PresenceManagerCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/PresenceManager#1518746641] to Actor[akka://actor-server/system/sharding/PresenceManagerCoordinator/singleton/coordinator] was not delivered. [2] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2219. 19:49:29.308UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/PresenceManagerCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/PresenceManagerCoordinator/singleton]
  2220. 19:49:29.308UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/PresenceManagerCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2221. 19:49:29.309UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/PresenceManagerCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2222. 19:49:29.323UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/GroupPresenceManagerCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/GroupPresenceManager#1911276833] to Actor[akka://actor-server/system/sharding/GroupPresenceManagerCoordinator/singleton/coordinator] was not delivered. [3] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2223. 19:49:29.323UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/GroupPresenceManagerCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/GroupPresenceManagerCoordinator/singleton]
  2224. 19:49:29.324UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/GroupPresenceManagerCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2225. 19:49:29.324UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/GroupPresenceManagerCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2226. 19:49:29.349UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/SocialManagerCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/SocialManager#472183097] to Actor[akka://actor-server/system/sharding/SocialManagerCoordinator/singleton/coordinator] was not delivered. [4] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2227. 19:49:29.351UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/SocialManagerCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/SocialManagerCoordinator/singleton]
  2228. 19:49:29.351UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/SocialManagerCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2229. 19:49:29.352UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/SocialManagerCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2230. 19:49:29.385UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/UserProcessorCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/UserProcessor#202541814] to Actor[akka://actor-server/system/sharding/UserProcessorCoordinator/singleton/coordinator] was not delivered. [5] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2231. 19:49:29.387UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/UserProcessorCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/UserProcessorCoordinator/singleton]
  2232. 19:49:29.387UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/UserProcessorCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2233. 19:49:29.387UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/UserProcessorCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2234. DEBUG im.actor.hook.SyncHooksStorage0  Registered hook groups
  2235. DEBUG im.actor.hook.SyncHooksStorage0  Registered hook localstorage
  2236. 19:49:29.781UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/GroupProcessorCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/GroupProcessor#270385506] to Actor[akka://actor-server/system/sharding/GroupProcessorCoordinator/singleton/coordinator] was not delivered. [6] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2237. 19:49:29.783UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/GroupProcessorCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/GroupProcessorCoordinator/singleton]
  2238. 19:49:29.783UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/GroupProcessorCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2239. 19:49:29.784UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/GroupProcessorCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2240. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2241. 19:49:29.822UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-21-IntegrationTokenMigration started
  2242. 19:49:29.826UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-IntegrationTokens Singleton manager starting singleton actor [akka://actor-server/user/SimpleKeyValueRoot-IntegrationTokens/singleton]
  2243. 19:49:29.826UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-IntegrationTokens ClusterSingletonManager state change [Start -> Oldest]
  2244. 19:49:29.834UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Migration 2015-08-21-IntegrationTokenMigration finished
  2245. 19:49:29.882UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Starting session region
  2246. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2247. 19:49:29.897UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/SessionCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/Session#-18266030] to Actor[akka://actor-server/system/sharding/SessionCoordinator/singleton/coordinator] was not delivered. [7] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2248. 19:49:29.898UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/SessionCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/SessionCoordinator/singleton]
  2249. 19:49:29.898UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/SessionCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2250. 19:49:29.898UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/SessionCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2251. DEBUG im.actor.hook.SyncHooksStorage0  Registered hook webhooks
  2252. 19:49:30.834UTC INFO  a.c.singleton.ClusterSingletonProxy akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-IntegrationTokens-Proxy Singleton identified at [akka://actor-server/user/SimpleKeyValueRoot-IntegrationTokens/singleton]
  2253. 19:49:31.949UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-WebactionHashUserId Singleton manager starting singleton actor [akka://actor-server/user/SimpleKeyValueRoot-WebactionHashUserId/singleton]
  2254. 19:49:31.950UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-WebactionHashUserId ClusterSingletonManager state change [Start -> Oldest]
  2255. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2256. 19:49:32.016UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/WebrtcCallCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/WebrtcCall#1960494507] to Actor[akka://actor-server/system/sharding/WebrtcCallCoordinator/singleton/coordinator] was not delivered. [8] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2257. 19:49:32.019UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/WebrtcCallCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/WebrtcCallCoordinator/singleton]
  2258. 19:49:32.019UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/WebrtcCallCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2259. 19:49:32.020UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/WebrtcCallCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2260. 19:49:32.065UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/EventBusMediatorCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/EventBusMediator#462315118] to Actor[akka://actor-server/system/sharding/EventBusMediatorCoordinator/singleton/coordinator] was not delivered. [9] dead letters encountered. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2261. 19:49:32.066UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Starting BotExtension
  2262. 19:49:32.067UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/EventBusMediatorCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/EventBusMediatorCoordinator/singleton]
  2263. 19:49:32.067UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/EventBusMediatorCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2264. 19:49:32.067UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/EventBusMediatorCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2265. DEBUG im.actor.hook.SyncHooksStorage0  Registered hook bots
  2266. 19:49:32.126UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server) Starting ActorBot
  2267. 19:49:32.143UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/$a Singleton manager starting singleton actor [akka://actor-server/user/$a/singleton]
  2268. 19:49:32.143UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/$a ClusterSingletonManager state change [Start -> Oldest]
  2269. 19:49:32.144UTC WARN  im.actor.server.bot.ActorBot akka.tcp://actor-server@31.187.70.88:2552/user/$a/singleton Initiating bot 10 actor Actor Bot
  2270. 19:49:28.694UTC DEBUG com.zaxxer.hikari.pool.PoolElf akka.actor.ActorSystemImpl(actor-server) main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2271. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2272. 19:49:32.279UTC WARN  im.actor.server.bot.ActorBot akka.tcp://actor-server@31.187.70.88:2552/user/$a/singleton Creating user 10
  2273. 19:49:32.374UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-BotsTokens Singleton manager starting singleton actor [akka://actor-server/user/SimpleKeyValueRoot-BotsTokens/singleton]
  2274. 19:49:32.374UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-BotsTokens ClusterSingletonManager state change [Start -> Oldest]
  2275. 19:49:32.381UTC INFO  a.c.singleton.ClusterSingletonProxy akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-BotsTokens-Proxy Singleton identified at [akka://actor-server/user/SimpleKeyValueRoot-BotsTokens/singleton]
  2276. DEBUG com.zaxxer.hikari.pool.PoolElf  main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2277. 19:49:32.408UTC INFO  akka.actor.EmptyLocalActorRef akka://actor-server/system/sharding/shardakka-kv-BotsTokensCoordinator/singleton/coordinator Message [akka.cluster.sharding.ShardCoordinator$Internal$Register] from Actor[akka://actor-server/system/sharding/shardakka-kv-BotsTokens#38438393] to Actor[akka://actor-server/system/sharding/shardakka-kv-BotsTokensCoordinator/singleton/coordinator] was not delivered. [10] dead letters encountered, no more dead letters will be logged. This logging can be turned off or adjusted with configuration settings 'akka.log-dead-letters' and 'akka.log-dead-letters-during-shutdown'.
  2278. 19:49:32.411UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/shardakka-kv-BotsTokensCoordinator Singleton manager starting singleton actor [akka://actor-server/system/sharding/shardakka-kv-BotsTokensCoordinator/singleton]
  2279. 19:49:32.411UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/system/sharding/shardakka-kv-BotsTokensCoordinator ClusterSingletonManager state change [Start -> Oldest]
  2280. 19:49:32.412UTC INFO  a.c.sharding.DDataShardCoordinator akka.tcp://actor-server@31.187.70.88:2552/system/sharding/shardakka-kv-BotsTokensCoordinator/singleton/coordinator Sharding Coordinator was moved to the active state State(Map(),Map(),Set(),Set(),false)
  2281. 19:49:32.954UTC INFO  a.c.singleton.ClusterSingletonProxy akka.tcp://actor-server@31.187.70.88:2552/user/SimpleKeyValueRoot-WebactionHashUserId-Proxy Singleton identified at [akka://actor-server/user/SimpleKeyValueRoot-WebactionHashUserId/singleton]
  2282. 19:49:28.981UTC DEBUG com.zaxxer.hikari.pool.PoolElf akka.actor.ActorSystemImpl(actor-server) main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
  2283. 19:49:34.731UTC ERROR im.actor.server.user.UserProcessor akka.tcp://actor-server@31.187.70.88:2552/system/sharding/UserProcessor/10/10 AuthSession for 8740709960047043303 was not found
  2284. 19:49:34.751UTC WARN  im.actor.server.bot.ActorBot akka.tcp://actor-server@31.187.70.88:2552/user/$a/singleton Initialized bot 10 actor Actor Bot
  2285. DEBUG com.zaxxer.hikari.pool.HikariPool  Before cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
  2286. DEBUG com.zaxxer.hikari.pool.HikariPool  After cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
  2287. DEBUG com.zaxxer.hikari.pool.HikariPool  Before cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
  2288. DEBUG com.zaxxer.hikari.pool.HikariPool  After cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
  2289. DEBUG com.zaxxer.hikari.pool.HikariPool  Before cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
  2290. DEBUG com.zaxxer.hikari.pool.HikariPool  After cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
  2291. DEBUG com.zaxxer.hikari.pool.HikariPool  Before cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
  2292. DEBUG com.zaxxer.hikari.pool.HikariPool  After cleanup pool main stats (total=8, active=0, idle=8, waiting=0)
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!