AT1vNEd2

1 INFO  akka.event.slf4j.Slf4jLogger    Slf4jLogger started
219:49:21.005UTC INFO  akka.remote.Remoting akka.remote.Remoting   Starting remoting
319:49:21.283UTC INFO  akka.remote.Remoting akka.remote.Remoting   Remoting started; listening on addresses :[akka.tcp://actor-server@31.187.70.88:2552]
419:49:21.288UTC INFO  akka.remote.Remoting akka.remote.Remoting   Remoting now listens on addresses: [akka.tcp://actor-server@31.187.70.88:2552]
519: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...
619: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]
719: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
819: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
919: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
1019: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)
1916select 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)
1943select 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)
1979select 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)
2006select 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
216819:49:25.849UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Going to a single-node cluster mode
216919: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 []
217019: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]
217119: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]
217219: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]
217319: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]
217419: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]
217519: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
217719: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
217919: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 
218319: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
218519:49:28.509UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-08-04-GroupsMigration started
218619: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
218819:49:28.622UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-08-20-LocalNamesMigration started
218919:49:28.622UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migrating local names
219019: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
219219:49:28.795UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-08-29-GroupCreatorMemberMigration started
219319: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
219519:49:28.888UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration PutHiddenGroupsToSQL started
219619:49:28.900UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration PutHiddenGroupsToSQL finished
219719:49:28.694UTC DEBUG com.zaxxer.hikari.pool.PoolElf akka.actor.ActorSystemImpl(actor-server)   main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
219819:49:28.968UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-11-03-LocalNamesFromKVMigration started
219919:49:28.968UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migrating local names from KV
220019: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
220219: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
220819: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
221119:49:28.981UTC DEBUG com.zaxxer.hikari.pool.PoolElf akka.actor.ActorSystemImpl(actor-server)   main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
221219:49:29.213UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-11-12-FixUserSequence started
221319:49:29.237UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-11-12-FixUserSequence finished
221419: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'.
221519: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]
221619: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]
221719: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)
221819: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'.
221919: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]
222019: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]
222119: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)
222219: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'.
222319: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]
222419: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]
222519: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)
222619: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'.
222719: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]
222819: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]
222919: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)
223019: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'.
223119: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]
223219: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]
223319: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
223619: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'.
223719: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]
223819: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]
223919: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
224119:49:29.822UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-08-21-IntegrationTokenMigration started
224219: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]
224319: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]
224419:49:29.834UTC INFO  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Migration 2015-08-21-IntegrationTokenMigration finished
224519: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
224719: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'.
224819: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]
224919: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]
225019: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
225219: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]
225319: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]
225419: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
225619: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'.
225719: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]
225819: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]
225919: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)
226019: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'.
226119:49:32.066UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Starting BotExtension
226219: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]
226319: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]
226419: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
226619:49:32.126UTC WARN  akka.actor.ActorSystemImpl akka.actor.ActorSystemImpl(actor-server)   Starting ActorBot
226719: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]
226819:49:32.143UTC INFO  a.c.s.ClusterSingletonManager akka.tcp://actor-server@31.187.70.88:2552/user/$a   ClusterSingletonManager state change [Start -> Oldest]
226919: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
227019: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
227219:49:32.279UTC WARN  im.actor.server.bot.ActorBot akka.tcp://actor-server@31.187.70.88:2552/user/$a/singleton   Creating user 10
227319: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]
227419: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]
227519: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
227719: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'.
227819: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]
227919: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]
228019: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)
228119: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]
228219:49:28.981UTC DEBUG com.zaxxer.hikari.pool.PoolElf akka.actor.ActorSystemImpl(actor-server)   main - Reset (nothing) on connection org.postgresql.jdbc4.Jdbc4Connection@62f311ac
228319: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
228419: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)