Insert missing login roles and assure it will be always set for newly created users.: Successful Oct 25 2017

https://login-role-set.staging.clippings.com

Nikolay Tumbalev
By Nikolay Tumbalev

What is this about?

Implements https://trello.com/c/aNMLqc9d/846-why-are-some-brand-users-passwords-not-working

Checklist

  • [x] Set role login to new users
  • [x] Create migration which inserts missing login roles
  • [x] Assigned people to review
  • [ ] Asked stakeholders for feedback

Staging to review

https://login-role-set.staging.clippings.com

Creating database staging_login-role-set
Warning: Using a password on the command line interface can be insecure.
Populating database login-role-set
Warning: Using a password on the command line interface can be insecure.
 124MiB 0:00:30 [4.13MiB/s] [>                                 ]  1% ETA 0:26:56
 215MiB 0:01:00 [3.04MiB/s] [>                                 ]  3% ETA 0:30:39
 309MiB 0:01:30 [3.14MiB/s] [>                                 ]  4% ETA 0:31:32
 404MiB 0:02:00 [3.15MiB/s] [>                                 ]  5% ETA 0:31:44
 499MiB 0:02:30 [3.18MiB/s] [=>                                ]  7% ETA 0:31:35
 592MiB 0:03:00 [3.09MiB/s] [=>                                ]  8% ETA 0:31:30
 683MiB 0:03:30 [3.04MiB/s] [==>                               ] 10% ETA 0:31:24
 779MiB 0:04:00 [3.21MiB/s] [==>                               ] 11% ETA 0:30:58
 912MiB 0:04:30 [ 4.4MiB/s] [===>                              ] 13% ETA 0:29:08
1010MiB 0:05:00 [3.28MiB/s] [===>                              ] 14% ETA 0:28:44
1.18GiB 0:05:30 [6.34MiB/s] [====>                             ] 17% ETA 0:25:39
1.24GiB 0:06:00 [2.38MiB/s] [=====>                            ] 18% ETA 0:26:06
1.32GiB 0:06:31 [2.35MiB/s] [=====>                            ] 19% ETA 0:26:28
1.38GiB 0:07:00 [ 2.4MiB/s] [=====>                            ] 20% ETA 0:26:42
1.45GiB 0:07:30 [2.41MiB/s] [======>                           ] 21% ETA 0:26:50
1.52GiB 0:08:00 [2.38MiB/s] [======>                           ] 22% ETA 0:26:57
1.59GiB 0:08:30 [ 2.4MiB/s] [======>                           ] 23% ETA 0:27:00
1.66GiB 0:09:00 [ 2.1MiB/s] [=======>                          ] 24% ETA 0:27:11
1.72GiB 0:09:30 [2.17MiB/s] [=======>                          ] 25% ETA 0:27:18
1.78GiB 0:10:00 [2.14MiB/s] [=======>                          ] 26% ETA 0:27:22
1.84GiB 0:10:30 [ 2.1MiB/s] [========>                         ] 27% ETA 0:27:25
1.91GiB 0:11:00 [2.17MiB/s] [========>                         ] 28% ETA 0:27:24
1.97GiB 0:11:31 [2.15MiB/s] [========>                         ] 29% ETA 0:27:21
2.03GiB 0:12:00 [2.15MiB/s] [=========>                        ] 30% ETA 0:27:17
2.09GiB 0:12:30 [2.07MiB/s] [=========>                        ] 31% ETA 0:27:15
2.16GiB 0:13:00 [2.15MiB/s] [=========>                        ] 32% ETA 0:27:07
2.22GiB 0:13:30 [2.02MiB/s] [==========>                       ] 33% ETA 0:27:03
2.27GiB 0:14:00 [   2MiB/s] [==========>                       ] 34% ETA 0:26:58
2.33GiB 0:14:30 [2.03MiB/s] [==========>                       ] 35% ETA 0:26:52
 2.4GiB 0:15:00 [2.13MiB/s] [==========>                       ] 35% ETA 0:26:40
2.46GiB 0:15:30 [2.12MiB/s] [===========>                      ] 36% ETA 0:26:28
2.52GiB 0:16:00 [2.05MiB/s] [===========>                      ] 37% ETA 0:26:17
2.58GiB 0:16:30 [2.06MiB/s] [===========>                      ] 38% ETA 0:26:05
2.64GiB 0:17:00 [2.19MiB/s] [============>                     ] 39% ETA 0:25:50
2.71GiB 0:17:30 [2.23MiB/s] [============>                     ] 40% ETA 0:25:31
2.77GiB 0:18:00 [2.15MiB/s] [============>                     ] 41% ETA 0:25:15
2.84GiB 0:18:30 [2.28MiB/s] [=============>                    ] 42% ETA 0:24:54
 2.9GiB 0:19:00 [2.27MiB/s] [=============>                    ] 43% ETA 0:24:33
2.97GiB 0:19:30 [2.41MiB/s] [=============>                    ] 44% ETA 0:24:08
3.04GiB 0:20:00 [2.06MiB/s] [==============>                   ] 45% ETA 0:23:52
 3.1GiB 0:20:30 [2.02MiB/s] [==============>                   ] 46% ETA 0:23:35
3.15GiB 0:21 00 [2.03MiB/s] [==============>                   ] 47% ETA 0:23:20
3.21GiB 0:21:30 [2.09MiB/s] [===============>                  ] 48% ETA 0:23:02
3.28GiB 0:22:00 [2.06MiB/s] [===============>                  ] 49% ETA 0:22:43
3.34GiB 0:22:30 [2.17MiB/s] [================>                 ] 50% ETA 0:22:21
 3.4GiB 0:23:00 [2.05MiB/s] [================>                 ] 51% ETA 0:22:03
3.46GiB 0:23:30 [ 2.1MiB/s] [================>                 ] 51% ETA 0:21:43
3.52GiB 0:24:00 [2.01MiB/s] [================>                 ] 52% ETA 0:21:24
3.58GiB 0:24:30 [2.05MiB/s] [=================>                ] 53% ETA 0:21:04
3.64GiB 0:25:00 [2.08MiB/s] [=================>                ] 54% ETA 0:20:43
 3.7GiB 0:25:30 [2.09MiB/s] [=================>                ] 55% ETA 0:20:22
3.76GiB 0:26:00 [2.11MiB/s] [==================>               ] 56% ETA 0:20:00
3.82GiB 0:26:30 [2.06MiB/s] [==================>               ] 57% ETA 0:19:39
3.88GiB 0:27:00 [2.05MiB/s] [==================>               ] 58% ETA 0:19:16
3.95GiB 0:27:30 [2.09MiB/s] [===================>              ] 59% ETA 0:18:54
4.01GiB 0:28:00 [2.09MiB/s] [===================>              ] 60% ETA 0:18:31
4.07GiB 0:28:30 [2.02MiB/s] [===================>              ] 61% ETA 0:18:10
4.13GiB 0:29:00 [2.05MiB/s] [===================>              ] 61% ETA 0:17:48
4.19GiB 0:29:30 [ 2.1MiB/s] [====================>             ] 62% ETA 0:17:24
4.25GiB 0:30:01 [2.06MiB/s] [====================>             ] 63% ETA 0:17:00
4.32GiB 0:30:30 [2.32MiB/s] [====================>             ] 64% ETA 0:16:32
4.39GiB 0:31:00 [2.49MiB/s] [=====================>            ] 65% ETA 0:16:02
4.48GiB 0:31:30 [2.99MiB/s] [=====================>            ] 67% ETA 0:15:22
4.57GiB 0:32:00 [3.08MiB/s] [======================>           ] 68% ETA 0:14:39
4.65GiB 0:32:30 [ 2.9MiB/s] [======================>           ] 69% ETA 0:14:01
4.73GiB 0:33:00 [2.84MiB/s] [=======================>          ] 71% ETA 0:13:25
4.82GiB 0:33:30 [2.99MiB/s] [=======================>          ] 72% ETA 0:12:45
4.91GiB 0:34:00 [2.88MiB/s] [=======================>          ] 73% ETA 0:12:08
   5GiB 0:34:30 [3.06MiB/s] [========================>         ] 75% ETA 0:11:29
5.09GiB 0:35:00 [3.21MiB/s] [========================>         ] 76% ETA 0:10:47
5.19GiB 0:35:30 [ 3.3MiB/s] [=========================>        ] 77% ETA 0:10:03
5.29GiB 0:36:00 [ 3.5MiB/s] [=========================>        ] 79% ETA 0:09:19
5.38GiB 0:36:30 [3.24MiB/s] [==========================>       ] 80% ETA 0:08:38
5.49GiB 0:37:00 [3.46MiB/s] [==========================>       ] 82% ETA 0:07:54
5.59GiB 0:37:30 [ 3.6MiB/s] [===========================>      ] 83% ETA 0:07:09
 5.7GiB 0:38:00 [3.52MiB/s] [===========================>      ] 85% ETA 0:06:25
5.79GiB 0:38:30 [3.38MiB/s] [============================>     ] 86% ETA 0:05:45
5.88GiB 0:39:00 [3.03MiB/s] [============================>     ] 88% ETA 0:05:09
5.96GiB 0:39:30 [ 2.8MiB/s] [=============================>    ] 89% ETA 0:04:36
6.04GiB 0:40:00 [2.69MiB/s] [=============================>    ] 90% ETA 0:04:04
6.12GiB 0:40:30 [2.72MiB/s] [=============================>    ] 91% ETA 0:03:32
 6.2GiB 0:41:00 [2.74MiB/s] [==============================>   ] 93% ETA 0:03:00
6.28GiB 0:41:30 [2.72MiB/s] [==============================>   ] 94% ETA 0:02:28
6.36GiB 0:42:00 [2.79MiB/s] [===============================>  ] 95% ETA 0:01:56
6.45GiB 0:42:30 [2.84MiB/s] [===============================>  ] 96% ETA 0:01:23
6.55GiB 0:43:01 [3.48MiB/s] [================================> ] 98% ETA 0:00:41
6.64GiB 0:43:30 [2.92MiB/s] [================================> ] 99% ETA 0:00:09
6.66GiB 0:43:42 [ 2.6MiB/s] [================================>] 100%            
Set umask to 002
Cloning git repository origin/login-role-set
Updating permissions
Installing composer dependencies
Installing javascript dependencies
yarn install v1.1.0
[1/4] Resolving packages...
[2/4] Fetching packages...
[3/4] Linking dependencies...
[4/4] Rebuilding all packages...
success Saved lockfile.
Done in 22.39s.
Compiling assets
[13:53:33] Using gulpfile ~/staging-sites/login-role-set/gulpfile.js
[13:53:33] Starting 'build-production'...
[13:53:33] Starting 'scss'...
[13:53:33] Starting 'babel'...
[13:53:33] Starting 'browserify-production'...
[13:53:33] Finished 'build-production' after 57 ms
[13:53:34] Finished 'babel' after 816 ms
[13:53:49] Finished 'browserify-production' after 16 s
[13:53:50] Finished 'scss' after 17 s
[13:53:50] Starting 'useref'...
[13:54:35] Finished 'useref' after 45 s
Updating composer permissions
Fixing Directories
Configuring secrets
Migrating
1508936055 Insert_Missing_Roles_Users : migrating up
-- execute( ↵ INSERT INTO roles_users(user_id, role_id)↵ SELECT↵ users.id,↵ 1↵ FROM users↵ L… )
   --> 0.1034s, affected rows: 163
1508936055 Insert_Missing_Roles_Users : migrated (0.1062s)
Saving structure of database "staging_login-role-set" to APPPATH/migrations/schema.sql
Warning: Using a password on the command line interface can be insecure.
Trello card aNMLqc9d notified