| *** TravT has quit IRC | 00:01 | |
| *** TravT_ has quit IRC | 00:04 | |
| *** fnaval has joined #osic | 00:08 | |
| *** adrian_otto has joined #osic | 00:09 | |
| *** mmalik4 has quit IRC | 00:11 | |
| *** sdake_ has quit IRC | 00:25 | |
| *** adrian_otto has quit IRC | 00:27 | |
| *** john-davidge has joined #osic | 00:33 | |
| *** john-davidge has quit IRC | 00:37 | |
| *** rloo has quit IRC | 00:51 | |
| *** sdake has joined #osic | 00:52 | |
| *** vinaypotluri has quit IRC | 01:02 | |
| *** nadeem has joined #osic | 01:10 | |
| *** sgundur has joined #osic | 01:29 | |
| *** sgundur has quit IRC | 01:29 | |
| *** nadeem has quit IRC | 01:30 | |
| *** rajpatel has joined #osic | 01:36 | |
| *** sgundur has joined #osic | 01:43 | |
| *** sgundur has quit IRC | 01:43 | |
| *** woodster_ has joined #osic | 01:51 | |
| *** sgundur has joined #osic | 02:06 | |
| *** sgundur has quit IRC | 02:13 | |
| *** sgundur has joined #osic | 02:13 | |
| *** knangia has quit IRC | 02:22 | |
| *** rajpatel has quit IRC | 02:27 | |
| *** rajpatel has joined #osic | 02:28 | |
| *** jorge_munoz has quit IRC | 02:36 | |
| *** di has quit IRC | 02:38 | |
| *** jorge_munoz has joined #osic | 02:40 | |
| *** sgundur has quit IRC | 02:47 | |
| *** sgundur has joined #osic | 02:51 | |
| *** sdake has quit IRC | 02:52 | |
| *** sgundur has quit IRC | 02:59 | |
| *** david-lyle has quit IRC | 03:04 | |
| *** sgundur has joined #osic | 03:05 | |
| *** di has joined #osic | 03:09 | |
| *** rajpatel has quit IRC | 03:14 | |
| *** sdake has joined #osic | 03:16 | |
| *** nadeem has joined #osic | 03:17 | |
| *** sgundur has quit IRC | 03:18 | |
| *** sdake has quit IRC | 03:19 | |
| *** valw has joined #osic | 03:27 | |
| *** sdake has joined #osic | 03:32 | |
| *** di has quit IRC | 03:46 | |
| *** diltram has quit IRC | 03:46 | |
| *** rromans has quit IRC | 03:47 | |
| *** cebreidian has quit IRC | 03:47 | |
| *** xek__ has quit IRC | 03:47 | |
| *** JRobinson__ is now known as JRobinson__afk | 03:49 | |
| *** diltram has joined #osic | 03:50 | |
| *** rromans has joined #osic | 03:53 | |
| *** diltram has quit IRC | 03:55 | |
| *** woodburn has quit IRC | 03:55 | |
| *** woodburn has joined #osic | 03:56 | |
| *** diltram has joined #osic | 03:56 | |
| *** cebreidian has joined #osic | 03:59 | |
| *** di has joined #osic | 04:00 | |
| *** fnaval_ has joined #osic | 04:01 | |
| *** fnaval has quit IRC | 04:02 | |
| *** nadeem has quit IRC | 04:12 | |
| *** valw has quit IRC | 04:15 | |
| *** valw has joined #osic | 04:16 | |
| *** JRobinson__afk is now known as JRobinson__ | 04:29 | |
| *** MikeA21 has quit IRC | 04:39 | |
| *** coolsvap has joined #osic | 04:41 | |
| *** valw has quit IRC | 04:47 | |
| *** GB21 has joined #osic | 04:52 | |
| *** sdake has quit IRC | 05:00 | |
| *** ccneill has quit IRC | 05:13 | |
| *** ccneill has joined #osic | 05:14 | |
| *** fnaval_ has quit IRC | 05:20 | |
| *** fnaval has joined #osic | 05:21 | |
| *** TravT has joined #osic | 05:37 | |
| *** nadeem has joined #osic | 05:40 | |
| *** ccneill has quit IRC | 05:43 | |
| *** nadeem has quit IRC | 05:43 | |
| *** nadeem has joined #osic | 05:44 | |
| *** xek has joined #osic | 05:59 | |
| *** woodster_ has quit IRC | 06:00 | |
| *** valw has joined #osic | 06:48 | |
| *** valw has quit IRC | 06:52 | |
| *** nadeem has quit IRC | 06:58 | |
| *** asettle has joined #osic | 07:39 | |
| *** valw has joined #osic | 07:49 | |
| *** valw has quit IRC | 07:53 | |
| *** john-davidge has joined #osic | 08:33 | |
| *** JRobinson__ has quit IRC | 08:37 | |
| *** john-davidge has quit IRC | 09:00 | |
| *** john-davidge has joined #osic | 09:01 | |
| *** bgmccollum has quit IRC | 09:10 | |
| *** sdake has joined #osic | 09:47 | |
| *** valw has joined #osic | 09:50 | |
| *** valw has quit IRC | 09:55 | |
| *** GB21 has quit IRC | 10:37 | |
| *** GB21 has joined #osic | 10:49 | |
| *** rrecio has joined #osic | 10:59 | |
| *** rrecio has quit IRC | 11:20 | |
| *** rrecio has joined #osic | 11:20 | |
| *** rrecio has quit IRC | 11:27 | |
| *** rrecio has joined #osic | 11:29 | |
| *** rrecio has quit IRC | 11:49 | |
| *** valw has joined #osic | 11:51 | |
| *** valw has quit IRC | 11:56 | |
| *** fnaval has quit IRC | 12:08 | |
| *** GB21 has quit IRC | 12:55 | |
| *** rloo has joined #osic | 12:55 | |
| *** david-lyle has joined #osic | 12:57 | |
| *** valw has joined #osic | 13:02 | |
| *** valw_ has joined #osic | 13:03 | |
| *** valw has quit IRC | 13:07 | |
| *** valw_ is now known as valw | 13:12 | |
| *** peristeri has joined #osic | 13:20 | |
| *** fnaval has joined #osic | 13:26 | |
| *** rajpatel has joined #osic | 13:31 | |
| *** fnaval_ has joined #osic | 13:31 | |
| *** fnaval has quit IRC | 13:31 | |
| *** TravT has quit IRC | 13:35 | |
| *** fnaval_ has quit IRC | 13:39 | |
| *** fnaval has joined #osic | 13:46 | |
| *** fnaval has quit IRC | 13:52 | |
| *** TxGirlGeek has joined #osic | 14:04 | |
| *** chris_hultin|AWA is now known as chris_hultin | 14:05 | |
| *** spotz_zzz is now known as spotz | 14:09 | |
| *** rajpatel1 has joined #osic | 14:09 | |
| *** ravelar has joined #osic | 14:10 | |
| *** rajpatel has quit IRC | 14:11 | |
| *** ravelar has quit IRC | 14:11 | |
| *** fnaval has joined #osic | 14:11 | |
| *** ravelar has joined #osic | 14:12 | |
| *** fnaval_ has joined #osic | 14:13 | |
| *** fnaval__ has joined #osic | 14:15 | |
| *** fnaval___ has joined #osic | 14:17 | |
| *** fnaval has quit IRC | 14:17 | |
| *** fnaval has joined #osic | 14:18 | |
| *** fnaval_ has quit IRC | 14:19 | |
| *** fnaval_ has joined #osic | 14:20 | |
| *** fnaval__ has quit IRC | 14:20 | |
| *** fnaval___ has quit IRC | 14:21 | |
| *** fnaval__ has joined #osic | 14:22 | |
| *** fnaval___ has joined #osic | 14:23 | |
| *** fnaval has quit IRC | 14:24 | |
| *** sdake has quit IRC | 14:24 | |
| *** fnaval_ has quit IRC | 14:25 | |
| *** fnaval has joined #osic | 14:25 | |
| *** sdake has joined #osic | 14:26 | |
| *** fnaval__ has quit IRC | 14:27 | |
| *** fnaval_ has joined #osic | 14:27 | |
| *** fnaval__ has joined #osic | 14:29 | |
| *** fnaval___ has quit IRC | 14:29 | |
| *** sgundur has joined #osic | 14:29 | |
| *** sgundur has quit IRC | 14:30 | |
| *** fnaval___ has joined #osic | 14:30 | |
| *** fnaval has quit IRC | 14:31 | |
| *** inc0 has joined #osic | 14:31 | |
| *** fnaval_ has quit IRC | 14:32 | |
| *** fnaval has joined #osic | 14:32 | |
| *** fnaval__ has quit IRC | 14:33 | |
| *** fnaval_ has joined #osic | 14:34 | |
| *** KLevenstein has joined #osic | 14:34 | |
| *** sdake_ has joined #osic | 14:34 | |
| *** Mudpuppy has joined #osic | 14:35 | |
| *** fnaval___ has quit IRC | 14:35 | |
| *** jorge_munoz_ has joined #osic | 14:35 | |
| *** fnaval__ has joined #osic | 14:36 | |
| *** sdake has quit IRC | 14:36 | |
| *** sgundur has joined #osic | 14:36 | |
| *** fnaval___ has joined #osic | 14:37 | |
| *** jorge_munoz has quit IRC | 14:37 | |
| *** jorge_munoz_ is now known as jorge_munoz | 14:37 | |
| *** Tamayo has joined #osic | 14:38 | |
| *** fnaval has quit IRC | 14:38 | |
| *** MikeA21 has joined #osic | 14:38 | |
| *** fnaval has joined #osic | 14:39 | |
| *** fnaval_ has quit IRC | 14:39 | |
| *** rrecio has joined #osic | 14:39 | |
| *** fnaval_ has joined #osic | 14:40 | |
| *** fnaval__ has quit IRC | 14:41 | |
| *** fnaval__ has joined #osic | 14:42 | |
| *** fnaval__ has quit IRC | 14:42 | |
| *** john-davidge has quit IRC | 14:42 | |
| *** fnaval___ has quit IRC | 14:43 | |
| *** fnaval__ has joined #osic | 14:43 | |
| *** fnaval__ has quit IRC | 14:43 | |
| *** fnaval__ has joined #osic | 14:44 | |
| *** fnaval has quit IRC | 14:45 | |
| *** chris_hultin is now known as chris_hultin|AWA | 14:45 | |
| *** fnaval__ has quit IRC | 14:45 | |
| *** sgundur has quit IRC | 14:45 | |
| *** fnaval_ has quit IRC | 14:46 | |
| *** fnaval has joined #osic | 14:46 | |
| *** rrecio_ has joined #osic | 14:48 | |
| *** fnaval has quit IRC | 14:48 | |
| *** sgundur has joined #osic | 14:48 | |
| *** fnaval has joined #osic | 14:48 | |
| *** TravT has joined #osic | 14:49 | |
| *** fnaval has quit IRC | 14:49 | |
| *** fnaval has joined #osic | 14:50 | |
| *** rrecio has quit IRC | 14:51 | |
| *** sdake_ is now known as sdake_dnd | 14:53 | |
| *** jovon has joined #osic | 14:56 | |
| *** homerp_ has joined #osic | 14:58 | |
| *** sdake has joined #osic | 14:59 | |
| *** sdake_dnd has quit IRC | 15:00 | |
| *** vinaypotluri has joined #osic | 15:03 | |
| *** MikeA21 has quit IRC | 15:05 | |
| *** chris_hultin|AWA is now known as chris_hultin | 15:07 | |
| *** sgundur has quit IRC | 15:13 | |
| *** sgundur has joined #osic | 15:17 | |
| *** di has quit IRC | 15:17 | |
| *** ravelar has quit IRC | 15:19 | |
| *** ravelar has joined #osic | 15:19 | |
| *** coolsvap has quit IRC | 15:22 | |
| rderose | abashmak: you free? | 15:24 |
|---|---|---|
| *** sdake is now known as sdake_dnd | 15:26 | |
| *** adrian_otto has joined #osic | 15:29 | |
| *** spotz is now known as spotz_zzz | 15:30 | |
| *** di has joined #osic | 15:50 | |
| *** KLevenstein has quit IRC | 15:59 | |
| abashmak | rderose: answered on direct chat | 16:00 |
| *** di1 has joined #osic | 16:00 | |
| *** chris_hultin is now known as chris_hultin|AWA | 16:01 | |
| *** di has quit IRC | 16:02 | |
| *** woodster_ has joined #osic | 16:03 | |
| *** di1 has quit IRC | 16:05 | |
| *** di has joined #osic | 16:05 | |
| *** sgundur has quit IRC | 16:05 | |
| *** sgundur has joined #osic | 16:07 | |
| *** knangia has joined #osic | 16:10 | |
| rderose | dolphm: you here? | 16:13 |
| dolphm | rderose: o/ | 16:20 |
| rderose | dolphm: was hoping to get abashmak and you together, he'll be back online in 20 | 16:21 |
| dolphm | rderose: ack | 16:22 |
| *** nadeem has joined #osic | 16:24 | |
| *** KLevenstein has joined #osic | 16:27 | |
| *** rajpatel1 has quit IRC | 16:27 | |
| *** sdake_dnd is now known as sdake | 16:27 | |
| * abashmak is back | 16:28 | |
| *** rrecio_ has quit IRC | 16:32 | |
| *** sgundur has quit IRC | 16:38 | |
| *** ravelar has quit IRC | 16:38 | |
| *** adrian_otto has quit IRC | 16:44 | |
| *** mmalik4 has joined #osic | 16:45 | |
| rderose | abashmak dolphm: so because column constraints are checked before the trigger is executed in older versions of mysql... | 16:47 |
| rderose | from lbragstad > "so (expand) apply the triggers -> make columns nullable (migrate) migrate data (contract) make columns non-nullable -> remove the triggers" | 16:48 |
| rderose | I think that would be the workaround | 16:48 |
| dolphm | rderose: ++ | 16:48 |
| lbragstad | abashmak glance current requires both visibility and is_public to be set right/ | 16:49 |
| lbragstad | abashmak according to the comment in your paste http://paste.openstack.org/show/583400/ (line 2 - line 5) | 16:49 |
| abashmak | Yes | 16:50 |
| lbragstad | abashmak does glance check those attributes before sending the reference to the backend? | 16:50 |
| abashmak | lbragstad, yes, the images model sets the default for the visibility column | 16:51 |
| lbragstad | abashmak so both the old code and the new code check to make sure those are set | 16:52 |
| lbragstad | cool | 16:52 |
| abashmak | Yep. So in theory it should be fine to make both nullable in the DB during the migration phase | 16:52 |
| lbragstad | only after the triggers are already in place, right? | 16:53 |
| abashmak | at the same time, essentially alter during the trigger installation, as I've done in my script | 16:53 |
| abashmak | during contract phase, remove the trigger and apply the constraints on the new column only | 16:54 |
| lbragstad | abashmak if you alter before you apply the triggers you could run into a race where a request happens to sneak through before the triggers are applied - right? | 16:54 |
| abashmak | that's true | 16:55 |
| abashmak | but if altered afterwards, there is the possibility the trigger won't function as expected | 16:57 |
| abashmak | that's probably more acceptable that the other situation though | 16:57 |
| lbragstad | does altering affect triggers? | 17:00 |
| *** craigs has joined #osic | 17:03 | |
| abashmak | Yes, it affects the behavior of the trigger. If the old column is not nullable, the trigger can never fire in the NEW->OLD direction, which means N services won't work | 17:03 |
| *** Tamayo has quit IRC | 17:03 | |
| *** rrecio has joined #osic | 17:04 | |
| abashmak | but that's ok, because triggers will be applied before any N (new) services are started | 17:04 |
| abashmak | s/will/SHOULD/ | 17:04 |
| *** KLevenstein has quit IRC | 17:04 | |
| abashmak | so we're good here. I'll move the alter statement(s) to after trigger creation | 17:05 |
| lbragstad | abashmak ah - got it | 17:05 |
| *** ravelar has joined #osic | 17:05 | |
| lbragstad | abashmak cool - hopefully it works! | 17:06 |
| abashmak | lbragstad, thanks for the feedback | 17:06 |
| lbragstad | abashmak anytime | 17:06 |
| *** sgundur has joined #osic | 17:09 | |
| *** claco is now known as jclaco | 17:22 | |
| *** jclaco is now known as jbreu | 17:23 | |
| *** jbreu is now known as jclaco | 17:24 | |
| *** asettle has quit IRC | 17:26 | |
| *** sgundur has quit IRC | 17:27 | |
| *** asettle has joined #osic | 17:34 | |
| *** asettle has quit IRC | 17:36 | |
| *** hemanthm is now known as hemanthm|lunch | 17:43 | |
| *** inc0_ has joined #osic | 17:45 | |
| *** inc0 has quit IRC | 17:48 | |
| *** ccneill has joined #osic | 17:51 | |
| *** ravelar has quit IRC | 17:55 | |
| *** ravelar has joined #osic | 17:55 | |
| *** lin_yang has joined #osic | 17:56 | |
| *** hemanthm|lunch is now known as hemanthm | 17:58 | |
| *** john-davidge has joined #osic | 18:06 | |
| *** john-davidge has quit IRC | 18:10 | |
| *** jclaco is now known as claco | 18:17 | |
| *** valw has quit IRC | 18:20 | |
| *** woodster_ has quit IRC | 18:20 | |
| *** siva_krishnan has joined #osic | 18:32 | |
| *** di has left #osic | 18:35 | |
| *** asettle has joined #osic | 18:40 | |
| *** sdake has quit IRC | 18:50 | |
| *** sdake has joined #osic | 18:50 | |
| *** chris_hultin|AWA is now known as chris_hultin | 19:01 | |
| *** asettle has quit IRC | 19:10 | |
| *** TxGirlGeek has quit IRC | 19:12 | |
| *** peristeri has quit IRC | 19:13 | |
| *** homerp_ has left #osic | 19:21 | |
| *** spotz_zzz is now known as spotz | 19:22 | |
| *** TxGirlGeek has joined #osic | 19:27 | |
| *** adrian_otto has joined #osic | 19:29 | |
| *** TxGirlGeek has quit IRC | 19:29 | |
| *** TxGirlGeek has joined #osic | 19:30 | |
| *** sgundur has joined #osic | 19:39 | |
| *** yarkot has quit IRC | 19:39 | |
| *** rajpatel has joined #osic | 19:40 | |
| *** lcastell_ has joined #osic | 19:42 | |
| *** yarkot has joined #osic | 19:42 | |
| *** cloudnull has quit IRC | 19:43 | |
| *** lcastell has quit IRC | 19:43 | |
| *** lcastell_ is now known as lcastell | 19:43 | |
| *** llu has quit IRC | 19:43 | |
| *** cloudnull has joined #osic | 19:43 | |
| *** jlwhite_ has joined #osic | 19:45 | |
| *** llu has joined #osic | 19:47 | |
| *** sulo_ has joined #osic | 19:47 | |
| *** jlwhite has quit IRC | 19:50 | |
| *** sulo has quit IRC | 19:50 | |
| *** jlwhite_ is now known as jlwhite | 19:50 | |
| *** sgundur has quit IRC | 19:53 | |
| *** jovon has quit IRC | 19:54 | |
| *** knangia has quit IRC | 19:54 | |
| *** woodster_ has joined #osic | 19:54 | |
| *** sgundur has joined #osic | 19:54 | |
| *** neillc has quit IRC | 19:54 | |
| *** jovon has joined #osic | 19:55 | |
| *** neillc has joined #osic | 19:56 | |
| *** knangia has joined #osic | 19:56 | |
| *** lin_yang has quit IRC | 19:59 | |
| *** lin_yang has joined #osic | 20:00 | |
| *** neillc has quit IRC | 20:03 | |
| *** neillc has joined #osic | 20:03 | |
| *** sgundur_ has joined #osic | 20:04 | |
| *** chrisspencer has quit IRC | 20:07 | |
| *** sgundur has quit IRC | 20:07 | |
| *** chrisspencer has joined #osic | 20:07 | |
| *** sdake has quit IRC | 20:08 | |
| *** sgundur_ has quit IRC | 20:09 | |
| *** sgundur has joined #osic | 20:09 | |
| *** asettle has joined #osic | 20:11 | |
| *** sgundur_ has joined #osic | 20:21 | |
| *** sgundur has quit IRC | 20:21 | |
| *** asettle has quit IRC | 20:21 | |
| *** csterret_ has joined #osic | 20:29 | |
| *** craigs has quit IRC | 20:33 | |
| *** Mudpuppy_ has joined #osic | 20:34 | |
| *** Mudpuppy_ has quit IRC | 20:35 | |
| *** Mudpuppy_ has joined #osic | 20:35 | |
| *** sgundur_ has quit IRC | 20:36 | |
| *** sgundur has joined #osic | 20:36 | |
| *** Mudpuppy has quit IRC | 20:38 | |
| *** sgundur_ has joined #osic | 20:38 | |
| *** lin_yang has quit IRC | 20:40 | |
| *** sgundur_ has quit IRC | 20:41 | |
| *** sgundur_ has joined #osic | 20:42 | |
| *** sgundur has quit IRC | 20:42 | |
| *** sgundur_ has quit IRC | 20:46 | |
| *** sgundur has joined #osic | 20:47 | |
| *** TravT has quit IRC | 20:49 | |
| *** Mudpuppy_ has quit IRC | 20:49 | |
| *** Mudpuppy has joined #osic | 20:50 | |
| *** sgundur has quit IRC | 20:50 | |
| *** sgundur has joined #osic | 20:51 | |
| *** sgundur has quit IRC | 20:53 | |
| *** sgundur has joined #osic | 20:53 | |
| *** Mudpuppy has quit IRC | 20:55 | |
| *** csterret__ has joined #osic | 20:58 | |
| *** csterret_ has quit IRC | 21:00 | |
| *** sgundur has quit IRC | 21:03 | |
| *** sgundur has joined #osic | 21:05 | |
| *** inc0_ has quit IRC | 21:07 | |
| *** csterret_ has joined #osic | 21:08 | |
| *** csterret__ has quit IRC | 21:12 | |
| *** sdake has joined #osic | 21:13 | |
| *** csterret__ has joined #osic | 21:21 | |
| *** KLevenstein has joined #osic | 21:21 | |
| *** csterret_ has quit IRC | 21:24 | |
| *** valw has joined #osic | 21:28 | |
| *** ravelar has quit IRC | 21:33 | |
| *** adrian_otto has quit IRC | 21:35 | |
| *** chris_hultin is now known as chris_hultin|AWA | 21:45 | |
| *** csterret__ has quit IRC | 21:46 | |
| *** onthecly has joined #osic | 21:55 | |
| *** woodster_ has quit IRC | 22:00 | |
| *** mmalik4 has quit IRC | 22:03 | |
| *** sgundur has quit IRC | 22:10 | |
| *** onthecly has quit IRC | 22:12 | |
| *** nadeem has quit IRC | 22:16 | |
| *** TxGirlGeek has quit IRC | 22:20 | |
| *** john-davidge has joined #osic | 22:23 | |
| *** john-davidge has quit IRC | 22:28 | |
| *** hemanthm is now known as hemanthm|pto | 22:30 | |
| *** ntpttr has quit IRC | 22:31 | |
| *** ntpttr has joined #osic | 22:31 | |
| *** rrecio has quit IRC | 22:41 | |
| *** inc0 has joined #osic | 22:45 | |
| *** rajpatel1 has joined #osic | 23:02 | |
| *** rajpatel has quit IRC | 23:02 | |
| *** rrecio has joined #osic | 23:07 | |
| *** sulo_ is now known as sulo | 23:11 | |
| *** sdake has quit IRC | 23:12 | |
| *** fnaval has quit IRC | 23:24 | |
| *** JRobinson__ has joined #osic | 23:26 | |
| *** asettle has joined #osic | 23:27 | |
| *** KLevenstein has quit IRC | 23:30 | |
| *** asettle has quit IRC | 23:32 | |
| *** valw has quit IRC | 23:43 | |
| *** sdake has joined #osic | 23:55 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!