| *** cjwilson has quit IRC | 00:02 | |
| *** slyphon has quit IRC | 00:04 | |
| *** spiffxp has quit IRC | 00:12 | |
| *** samkottler has quit IRC | 00:24 | |
| *** mdrnstm has quit IRC | 00:36 | |
| *** maplebed has quit IRC | 00:57 | |
| *** issackelly has quit IRC | 00:58 | |
| *** heckj has quit IRC | 00:59 | |
| *** roge has quit IRC | 00:59 | |
| *** mnewby has quit IRC | 01:00 | |
| *** littleidea has quit IRC | 01:02 | |
| *** Mandell has quit IRC | 01:13 | |
| *** reed has quit IRC | 01:13 | |
| *** mnewby has joined #openstack-dev | 01:16 | |
| *** rods has quit IRC | 01:22 | |
| *** paulstallworth has joined #openstack-dev | 01:28 | |
| *** winston-d has joined #openstack-dev | 01:29 | |
| *** novas0x2a|lapto1 has quit IRC | 01:32 | |
| *** littleidea has joined #openstack-dev | 01:34 | |
| *** roge has joined #openstack-dev | 01:40 | |
| *** mdrnstm has joined #openstack-dev | 01:42 | |
| *** mnewby has quit IRC | 01:52 | |
| *** Transformer has joined #openstack-dev | 02:00 | |
| *** mnewby has joined #openstack-dev | 02:01 | |
| *** Transformer has quit IRC | 02:04 | |
| *** pixelbeat has quit IRC | 02:06 | |
| *** winston-d has quit IRC | 02:08 | |
| *** Ryan_Lane has quit IRC | 02:10 | |
| *** mnewby has quit IRC | 02:11 | |
| *** deshantm__ has joined #openstack-dev | 02:14 | |
| *** mjfork has quit IRC | 02:16 | |
| *** deshantm_ has quit IRC | 02:18 | |
| *** Beryllium has quit IRC | 02:30 | |
| *** shiju has joined #openstack-dev | 02:37 | |
| *** vricci has joined #openstack-dev | 02:38 | |
| *** roge has quit IRC | 02:41 | |
| *** pengyong has quit IRC | 02:41 | |
| *** darkhorse has quit IRC | 02:54 | |
| *** darkhorse has joined #openstack-dev | 02:56 | |
| *** dtroyer_zzz is now known as dtroyer | 03:05 | |
| *** asalkeld has quit IRC | 03:14 | |
| *** deshantm__ is now known as deshantm | 03:22 | |
| *** Mandell has joined #openstack-dev | 03:52 | |
| *** infernix has quit IRC | 04:22 | |
| *** deshantm has quit IRC | 04:22 | |
| *** dtroyer is now known as dtroyer_zzz | 04:32 | |
| *** sleepsonzzz is now known as sleepsonthefloor | 04:33 | |
| *** mnewby has joined #openstack-dev | 04:42 | |
| *** paulstallworth_ has joined #openstack-dev | 04:58 | |
| *** paulstallworth has quit IRC | 04:59 | |
| *** paulstallworth_ is now known as paulstallworth | 04:59 | |
| *** darkhorse has quit IRC | 05:01 | |
| *** Ryan_Lane has joined #openstack-dev | 05:02 | |
| *** lloydde has joined #openstack-dev | 05:03 | |
| *** hattwick has quit IRC | 05:03 | |
| *** paulstallworth has quit IRC | 05:12 | |
| *** paulstallworth has joined #openstack-dev | 05:14 | |
| *** Mandell has quit IRC | 05:15 | |
| *** Mandell has joined #openstack-dev | 05:15 | |
| *** devananda has quit IRC | 05:17 | |
| *** devananda has joined #openstack-dev | 05:20 | |
| *** lloydde has quit IRC | 05:24 | |
| *** mnewby has quit IRC | 05:51 | |
| *** mnewby has joined #openstack-dev | 05:56 | |
| *** dubsquared1 has quit IRC | 06:04 | |
| *** littleidea has quit IRC | 06:17 | |
| *** andrewsben is now known as andrewsben_zz | 06:17 | |
| *** bepernoot has joined #openstack-dev | 06:22 | |
| *** dachary has joined #openstack-dev | 06:26 | |
| *** paulstallworth has quit IRC | 06:27 | |
| *** bepernoot has quit IRC | 06:43 | |
| *** jaypipes has quit IRC | 07:35 | |
| *** jaypipes has joined #openstack-dev | 07:35 | |
| *** bepernoot has joined #openstack-dev | 07:38 | |
| *** shiju has quit IRC | 07:50 | |
| *** hattwick has joined #openstack-dev | 07:59 | |
| *** bepernoot has quit IRC | 08:01 | |
| *** maploin has joined #openstack-dev | 09:18 | |
| *** maploin has quit IRC | 09:18 | |
| *** maploin has joined #openstack-dev | 09:18 | |
| *** negronjl has quit IRC | 09:23 | |
| *** maploin has quit IRC | 09:25 | |
| *** Mandell has quit IRC | 09:27 | |
| *** devananda has quit IRC | 09:30 | |
| *** devananda has joined #openstack-dev | 09:31 | |
| *** negronjl has joined #openstack-dev | 09:36 | |
| *** bepernoot has joined #openstack-dev | 10:15 | |
| *** bepernoot has quit IRC | 10:15 | |
| *** zigo has joined #openstack-dev | 10:31 | |
| *** bepernoot has joined #openstack-dev | 10:48 | |
| *** Ryan_Lane has quit IRC | 10:56 | |
| *** asalkeld has joined #openstack-dev | 11:01 | |
| *** maploin has joined #openstack-dev | 11:10 | |
| *** maploin has joined #openstack-dev | 11:10 | |
| *** pixelbeat has joined #openstack-dev | 11:15 | |
| *** rods has joined #openstack-dev | 11:16 | |
| *** maploin has quit IRC | 11:54 | |
| *** sannes has quit IRC | 11:55 | |
| *** sannes1 has joined #openstack-dev | 11:55 | |
| *** sannes1 has quit IRC | 12:08 | |
| *** sannes has joined #openstack-dev | 12:08 | |
| *** sannes has quit IRC | 12:10 | |
| *** sannes has joined #openstack-dev | 12:10 | |
| *** longhudou has joined #openstack-dev | 12:23 | |
| *** bepernoot has joined #openstack-dev | 12:27 | |
| *** asalkeld has quit IRC | 12:32 | |
| *** mjfork has joined #openstack-dev | 12:33 | |
| *** roge has joined #openstack-dev | 12:35 | |
| *** mjfork has quit IRC | 12:37 | |
| *** longhudou has quit IRC | 12:38 | |
| *** vricci has joined #openstack-dev | 12:54 | |
| *** mjfork has joined #openstack-dev | 12:56 | |
| *** pixelbeat has quit IRC | 12:56 | |
| *** maploin has joined #openstack-dev | 12:59 | |
| *** maploin has joined #openstack-dev | 12:59 | |
| *** ches has quit IRC | 13:29 | |
| *** ches has joined #openstack-dev | 13:29 | |
| *** maploin has quit IRC | 13:29 | |
| *** roge has quit IRC | 13:35 | |
| *** bepernoo1 has joined #openstack-dev | 13:40 | |
| *** bepernoot has quit IRC | 13:42 | |
| *** sleepsonthefloor is now known as sleepsonzzz | 13:44 | |
| *** bepernoot has joined #openstack-dev | 13:45 | |
| *** bepernoo1 has quit IRC | 13:45 | |
| *** dtroyer_zzz is now known as dtroyer | 13:49 | |
| *** bepernoo1 has joined #openstack-dev | 13:50 | |
| *** ncode has joined #openstack-dev | 13:50 | |
| *** ncode has joined #openstack-dev | 13:50 | |
| *** bepernoot has quit IRC | 13:51 | |
| *** dtroyer is now known as dtroyer_zzz | 13:55 | |
| *** lloydde has joined #openstack-dev | 13:58 | |
| *** roge has joined #openstack-dev | 14:20 | |
| *** dachary has quit IRC | 14:20 | |
| *** ncode_ has joined #openstack-dev | 14:20 | |
| *** ncode_ has joined #openstack-dev | 14:20 | |
| *** ncode_ has quit IRC | 14:20 | |
| *** Mandell has joined #openstack-dev | 14:22 | |
| *** ncode has quit IRC | 14:23 | |
| *** roge has quit IRC | 14:32 | |
| *** littleidea has joined #openstack-dev | 14:47 | |
| *** paulstallworth has joined #openstack-dev | 15:02 | |
| *** spiffxp has joined #openstack-dev | 15:07 | |
| *** paulstallworth has quit IRC | 15:12 | |
| *** Mandell has quit IRC | 15:13 | |
| *** roge has joined #openstack-dev | 15:18 | |
| *** lloydde has quit IRC | 15:19 | |
| *** roge has joined #openstack-dev | 15:21 | |
| *** lloydde has joined #openstack-dev | 15:26 | |
| *** Mandell has joined #openstack-dev | 15:27 | |
| *** roge has quit IRC | 15:35 | |
| *** bepernoo1 has quit IRC | 15:44 | |
| *** lloydde has quit IRC | 15:50 | |
| *** lloydde has joined #openstack-dev | 15:50 | |
| *** Mandell_ has joined #openstack-dev | 15:51 | |
| *** Mandell has quit IRC | 15:51 | |
| *** lloydde has quit IRC | 15:51 | |
| *** littleidea has quit IRC | 15:57 | |
| *** dachary has joined #openstack-dev | 16:02 | |
| *** paulstallworth has joined #openstack-dev | 16:27 | |
| *** paulstallworth has quit IRC | 16:34 | |
| *** bepernoot has joined #openstack-dev | 16:34 | |
| *** Mandell_ has quit IRC | 16:47 | |
| *** lloydde has joined #openstack-dev | 16:49 | |
| *** deshantm has joined #openstack-dev | 16:51 | |
| *** darkhorse has joined #openstack-dev | 16:56 | |
| *** lloydde has quit IRC | 17:00 | |
| *** dtroyer_zzz is now known as dtroyer | 17:15 | |
| *** dolphm has joined #openstack-dev | 17:15 | |
| *** bepernoot has quit IRC | 17:36 | |
| *** dolphm has quit IRC | 18:08 | |
| *** dtroyer is now known as dtroyer_zzz | 18:13 | |
| *** Radium has joined #openstack-dev | 18:22 | |
| *** mnewby has quit IRC | 18:23 | |
| *** Mandell has joined #openstack-dev | 18:24 | |
| *** mnewby has joined #openstack-dev | 18:25 | |
| *** ncode has joined #openstack-dev | 18:25 | |
| *** dwalleck has joined #openstack-dev | 18:29 | |
| *** ncode has quit IRC | 18:30 | |
| *** ncode has joined #openstack-dev | 18:33 | |
| *** ncode has joined #openstack-dev | 18:33 | |
| *** ncode has quit IRC | 18:42 | |
| *** bepernoot has joined #openstack-dev | 18:47 | |
| *** mnewby_ has joined #openstack-dev | 18:53 | |
| *** spiffxp has quit IRC | 18:55 | |
| *** mnewby__ has joined #openstack-dev | 18:56 | |
| *** mnewby has quit IRC | 18:57 | |
| *** mnewby__ is now known as mnewby | 18:57 | |
| *** mnewby_ has quit IRC | 18:58 | |
| *** bepernoot has quit IRC | 18:58 | |
| *** ncode has joined #openstack-dev | 19:02 | |
| *** ncode has joined #openstack-dev | 19:02 | |
| *** ncode has quit IRC | 19:02 | |
| *** bepernoot has joined #openstack-dev | 19:13 | |
| *** dolphm has joined #openstack-dev | 19:20 | |
| *** bepernoot has quit IRC | 19:20 | |
| *** hashar has joined #openstack-dev | 19:22 | |
| *** sleepsonzzz is now known as sleepsonthefloor | 19:34 | |
| *** sleepsonthefloor is now known as sleepsonzzz | 19:42 | |
| *** dolphm has quit IRC | 19:44 | |
| *** zigo has quit IRC | 19:44 | |
| *** mnewby_ has joined #openstack-dev | 19:51 | |
| *** mnewby has quit IRC | 19:55 | |
| *** mnewby_ is now known as mnewby | 19:55 | |
| *** roge has joined #openstack-dev | 20:18 | |
| *** bepernoot has joined #openstack-dev | 20:22 | |
| *** dtroyer_zzz is now known as dtroyer | 20:27 | |
| *** pixelbeat has joined #openstack-dev | 20:36 | |
| *** bepernoot has joined #openstack-dev | 20:38 | |
| *** bepernoot has quit IRC | 20:43 | |
| *** andrewsmedina has quit IRC | 20:55 | |
| *** deshantm_ has joined #openstack-dev | 21:15 | |
| *** andrewsmedina has joined #openstack-dev | 21:15 | |
| *** deshantm has quit IRC | 21:18 | |
| *** Ryan_Lane has joined #openstack-dev | 21:20 | |
| *** blamar has joined #openstack-dev | 23:02 | |
| *** mikal has joined #openstack-dev | 23:03 | |
| mikal | Anyone got any hot tips on how to debug sqlalchemy migrations? | 23:05 |
|---|---|---|
| mikal | Specifically, I keep getting: | 23:05 |
| mikal | File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 1527, in _requires_quotes | 23:05 |
| mikal | lc_value = value.lower() | 23:05 |
| mikal | AttributeError: 'int' object has no attribute 'lower' | 23:05 |
| mikal | From deep down in the sqlalchemy goo | 23:06 |
| blamar | mikal: Yeah, that's never pretty. Are you trying to drop columns? | 23:12 |
| mikal | Yeah, I thought what I was doing was relatively simple... | 23:12 |
| blamar | Believe me, it should be. | 23:12 |
| mikal | I'm just trying to update the block_device_mapping table to using instance UUIDs instead of instance IDs. | 23:12 |
| mikal | There is a drop of an int column in there at the end of the update | 23:12 |
| mikal | The best bit is the code is largely copied from a previous migration, which just works | 23:13 |
| blamar | migrate has been the biggest pain in my side…hours of unnecessary debugging only to end up doing raw SQL migrations in the end | 23:13 |
| mikal | I couldn't find an example of that in the existing migrations | 23:15 |
| blamar | mikal: You'll see that every once and a while we'll have .sql files in the migrate_repo directory (I'm assuming you're talking about Nova)…that means that we couldn't do the migration with the migration lib so we resorted to raw SQL | 23:15 |
| mikal | I'm basically copying 064_change_instance_id_to_uuid_in_instance_actions.py | 23:15 |
| mikal | Ahhh, ok | 23:15 |
| mikal | They seem to mostly be for sqlite? Which is what I am using when I run the unit tests. | 23:16 |
| blamar | mikal: Right, sqlite has issues dropping columns from what I remember | 23:17 |
| blamar | Like, it doesn't support it | 23:17 |
| mikal | Heh | 23:17 |
| mikal | So... this might all be a sqlite problem? | 23:17 |
| blamar | Well, the accepted strategy is to recreate the table without the column and then migrate all the data over. | 23:18 |
| mikal | 076_sqlite_upgrade.sql is kind of funny to read | 23:18 |
| blamar | python-migrate is supposed to do that for you, but it fails miserably | 23:18 |
| mikal | With a .sql file, right? | 23:18 |
| mikal | Not in python? | 23:18 |
| blamar | Yeah, we end up doing it with sql, create the table and then export/import into the new one. Rename and you're done. | 23:19 |
| mikal | Ok. I'll give that a try then | 23:19 |
| mikal | Anything has to be better that what I am trying to do now | 23:19 |
| mikal | Reading 076 as an example... | 23:20 |
| mikal | So the migration is provided in python, and then the .sql overrides that for specific migrations? | 23:20 |
| *** littleidea has joined #openstack-dev | 23:23 | |
| blamar | mikal: I *believe* what happens is the python one is used for mysql migrations and .sql is used for sqlite…but I could be mistaken. | 23:24 |
| mikal | Hmmm, the engine name is in the sql file, so I am hoping it depends on what overrides you provide | 23:24 |
| blamar | mikal: Actually no, you're right…it'll override the upgrade. | 23:24 |
| mikal | Is there a guide somewhere for how to write these? Or do people just learn this stuff the hard way? | 23:25 |
| blamar | Not sure why the python file for that one has an upgrade section though... | 23:25 |
| blamar | mikal: Yeah, sorry :\ hard mode for now | 23:25 |
| mikal | NP, just making sure I'm not doing this the hard way unnessesarily | 23:25 |
| *** mikal has quit IRC | 23:26 | |
| blamar | mikal: Migrations have always been something we're always looking to improve, but no results yet | 23:26 |
| blamar | complicated | 23:26 |
| *** spiffxp has joined #openstack-dev | 23:27 | |
| *** mikal has joined #openstack-dev | 23:28 | |
| *** mikal has quit IRC | 23:28 | |
| *** mikal has joined #openstack-dev | 23:32 | |
| mikal | Sorry about that. I need to find an IRC client which doesn't suck so much. | 23:34 |
| *** spiffxp has quit IRC | 23:40 | |
| *** dachary has quit IRC | 23:45 | |
| *** andrewsmedina has quit IRC | 23:50 | |
| *** andrewsmedina has joined #openstack-dev | 23:57 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!