| *** gyee has joined #openstack-barbican | 00:04 | |
| *** gyee has quit IRC | 00:14 | |
| *** jamielennox|away is now known as jamielennox | 00:28 | |
| *** jkf has quit IRC | 00:38 | |
| *** xek has quit IRC | 00:39 | |
| *** spotz_zzz is now known as spotz | 00:40 | |
| *** jamielennox is now known as jamielennox|away | 00:49 | |
| *** jamielennox|away is now known as jamielennox | 00:51 | |
| *** jhfeng has joined #openstack-barbican | 01:18 | |
| *** fredyx10 has joined #openstack-barbican | 01:25 | |
| *** jkf has joined #openstack-barbican | 01:37 | |
| *** zz_dimtruck is now known as dimtruck | 01:52 | |
| *** fredyx10 has quit IRC | 02:08 | |
| *** fredyx10 has joined #openstack-barbican | 02:08 | |
| *** fredyx10 has quit IRC | 02:43 | |
| *** fredyx10 has joined #openstack-barbican | 02:44 | |
| *** fredyx10 has quit IRC | 03:05 | |
| *** jhfeng has quit IRC | 03:10 | |
| *** jamielennox is now known as jamielennox|away | 03:21 | |
| *** dave-mccowan has quit IRC | 03:37 | |
| *** jhfeng has joined #openstack-barbican | 03:38 | |
| *** jhfeng has quit IRC | 03:49 | |
| *** Nirupama has joined #openstack-barbican | 04:40 | |
| *** jaosorior has joined #openstack-barbican | 05:07 | |
| *** ozialien has joined #openstack-barbican | 05:47 | |
| *** dimtruck is now known as zz_dimtruck | 06:14 | |
| *** spotz is now known as spotz_zzz | 06:15 | |
| *** ozialiendoze has joined #openstack-barbican | 06:22 | |
| *** scheuran has joined #openstack-barbican | 06:24 | |
| *** ozialien has quit IRC | 06:24 | |
| openstackgerrit | OpenStack Proposal Bot proposed openstack/barbican: Imported Translations from Zanata https://review.openstack.org/308777 | 06:32 |
|---|---|---|
| *** edtubill has quit IRC | 07:09 | |
| *** woodster_ has quit IRC | 07:18 | |
| *** permalac has quit IRC | 07:19 | |
| *** ozialien has joined #openstack-barbican | 07:29 | |
| *** ozialiendoze has quit IRC | 07:31 | |
| *** jaosorior has quit IRC | 08:22 | |
| *** jaosorior has joined #openstack-barbican | 08:30 | |
| -openstackstatus- NOTICE: OVH servers are down, we are working to solve it. This will cause that jobs queue is processed slowly, please have patience. | 10:36 | |
| *** jaosorior has quit IRC | 10:52 | |
| *** jaosorior has joined #openstack-barbican | 10:53 | |
| *** jorgem has quit IRC | 11:00 | |
| *** jorgem has joined #openstack-barbican | 11:00 | |
| *** arunkant_ has joined #openstack-barbican | 11:06 | |
| *** mmotiani_ has quit IRC | 11:08 | |
| *** arunkant has quit IRC | 11:08 | |
| *** mmotiani_ has joined #openstack-barbican | 11:08 | |
| *** ozialiendoze has joined #openstack-barbican | 11:12 | |
| *** ozialien has quit IRC | 11:13 | |
| *** spotz_zzz is now known as spotz | 11:49 | |
| *** spotz is now known as spotz_zzz | 11:53 | |
| openstackgerrit | Merged openstack/barbican: Imported Translations from Zanata https://review.openstack.org/308777 | 12:12 |
| *** krotscheck_dcm is now known as krotscheck | 12:15 | |
| *** alee has quit IRC | 12:29 | |
| *** dave-mccowan has joined #openstack-barbican | 12:32 | |
| *** Nirupama has quit IRC | 12:47 | |
| -openstackstatus- NOTICE: OVH provider is enabled again, please wait for the job queue to be processed | 12:47 | |
| *** ozialien has joined #openstack-barbican | 13:06 | |
| *** ozialiendoze has quit IRC | 13:06 | |
| *** ozialiendoze has joined #openstack-barbican | 13:12 | |
| *** ozialien has quit IRC | 13:13 | |
| *** alee has joined #openstack-barbican | 13:38 | |
| *** cheneydc has joined #openstack-barbican | 13:40 | |
| *** fredyx10 has joined #openstack-barbican | 13:45 | |
| *** jhfeng has joined #openstack-barbican | 14:05 | |
| *** zz_dimtruck is now known as dimtruck | 14:08 | |
| *** rhagarty has quit IRC | 14:11 | |
| *** spotz_zzz is now known as spotz | 14:23 | |
| *** nkinder has quit IRC | 14:35 | |
| *** asingh has joined #openstack-barbican | 14:37 | |
| *** nkinder has joined #openstack-barbican | 14:39 | |
| *** jaosorior has quit IRC | 14:56 | |
| *** edtubill has joined #openstack-barbican | 15:09 | |
| *** jaosorior has joined #openstack-barbican | 15:16 | |
| *** scheuran has quit IRC | 15:27 | |
| *** jhfeng has quit IRC | 15:28 | |
| *** jhfeng has joined #openstack-barbican | 15:32 | |
| *** sigmavirus24_awa is now known as sigmavirus24 | 15:33 | |
| *** rhagarty has joined #openstack-barbican | 15:40 | |
| *** cheneydc has quit IRC | 15:48 | |
| *** openstackgerrit has quit IRC | 15:48 | |
| *** jaosorior has quit IRC | 15:48 | |
| *** openstackgerrit has joined #openstack-barbican | 15:48 | |
| openstackgerrit | Merged openstack/barbican: use thread safe fnmatch https://review.openstack.org/308571 | 15:53 |
| *** rhagarty has quit IRC | 16:04 | |
| *** jhfeng has quit IRC | 16:10 | |
| *** rhagarty has joined #openstack-barbican | 16:10 | |
| *** diazjf has joined #openstack-barbican | 16:17 | |
| *** arun_kant has joined #openstack-barbican | 16:22 | |
| *** jhfeng has joined #openstack-barbican | 16:28 | |
| *** diazjf has quit IRC | 16:31 | |
| *** jhfeng has quit IRC | 16:39 | |
| *** tkelsey has joined #openstack-barbican | 16:54 | |
| *** rhagarty has quit IRC | 16:56 | |
| *** alee is now known as alee_lunch | 16:58 | |
| *** jhfeng has joined #openstack-barbican | 16:59 | |
| *** jhfeng has quit IRC | 17:01 | |
| *** dave-mccowan has quit IRC | 17:01 | |
| *** jhfeng has joined #openstack-barbican | 17:03 | |
| *** stevemar has quit IRC | 17:06 | |
| *** Kiall has quit IRC | 17:07 | |
| *** dave-mccowan has joined #openstack-barbican | 17:07 | |
| *** stevemar has joined #openstack-barbican | 17:08 | |
| *** lixiaoy1 has quit IRC | 17:08 | |
| *** rhagarty has joined #openstack-barbican | 17:08 | |
| *** lixiaoy1 has joined #openstack-barbican | 17:09 | |
| *** Kiall has joined #openstack-barbican | 17:10 | |
| *** tkelsey has quit IRC | 17:15 | |
| *** mathiasb_ has joined #openstack-barbican | 17:16 | |
| *** mmotiani- has joined #openstack-barbican | 17:19 | |
| *** mmotiani_ has quit IRC | 17:19 | |
| *** mathiasb has quit IRC | 17:19 | |
| *** a2hill has quit IRC | 17:19 | |
| *** ptoohill has joined #openstack-barbican | 17:20 | |
| *** 6JTAACLMH has joined #openstack-barbican | 17:24 | |
| *** fawadkhaliq has joined #openstack-barbican | 17:29 | |
| *** jhfeng has quit IRC | 17:52 | |
| *** jhfeng has joined #openstack-barbican | 17:54 | |
| *** sigmavirus24 is now known as sigmavirus24_awa | 17:55 | |
| openstackgerrit | Merged openstack/python-barbicanclient: Make Client test documentation similar to Barbican https://review.openstack.org/219135 | 18:08 |
| *** sigmavirus24_awa is now known as sigmavirus24 | 18:09 | |
| openstackgerrit | OpenStack Proposal Bot proposed openstack/barbican: Updated from global requirements https://review.openstack.org/307745 | 18:10 |
| openstackgerrit | OpenStack Proposal Bot proposed openstack/python-barbicanclient: Updated from global requirements https://review.openstack.org/303151 | 18:16 |
| *** peter-hamilton has joined #openstack-barbican | 18:33 | |
| *** woodster_ has joined #openstack-barbican | 18:34 | |
| *** alee_lunch is now known as alee | 18:46 | |
| *** tkelsey has joined #openstack-barbican | 18:50 | |
| *** tkelsey has quit IRC | 18:55 | |
| *** fredyx10 has left #openstack-barbican | 18:55 | |
| agrebennikov | redrobot, hi | 18:57 |
| agrebennikov | remember the question I was asking about yesterday? | 18:57 |
| agrebennikov | about the "db sync" issue | 18:57 |
| redrobot | agrebennikov hi | 18:58 |
| agrebennikov | woodster_, if you have a minute please^ | 18:58 |
| agrebennikov | so I was provided with the patch | 18:58 |
| agrebennikov | but the command still fails, and it actually fails when it applies very first migration | 18:58 |
| agrebennikov | 2016-04-21 18:59:36.621 23501 INFO alembic.runtime.migration [-] Will assume non-transactional DDL. | 19:00 |
| agrebennikov | 2016-04-21 18:59:36.829 23501 INFO alembic.runtime.migration [-] Running upgrade -> 1a0c2cdafb38, create test table | 19:00 |
| agrebennikov | 2016-04-21 18:59:36.835 23501 DEBUG alembic.runtime.migration [-] new branch insert 1a0c2cdafb38 update_to_step /usr/lib/python2.7/dist-packages/alembic/runtime/migration.py:476 | 19:00 |
| agrebennikov | 2016-04-21 18:59:36.848 23501 INFO alembic.runtime.migration [-] Running upgrade 1a0c2cdafb38 -> juno, juno_initial | 19:00 |
| agrebennikov | 2016-04-21 18:59:37.083 23501 ERROR barbican.cmd.db_manage [-] Problem seen trying to execute Alembic commands | 19:00 |
| agrebennikov | OperationalError: (_mysql_exceptions.OperationalError) (1709, 'Index column size too large. The maximum column size is 767 bytes.') [SQL: u'CREATE INDEX values_index ON container_consumer_metadata (container_id, name, `URL`)'] | 19:00 |
| agrebennikov | and the patch covered row size I believe | 19:00 |
| woodster_ | agrebennikov: so is that the issue redrobot mentioned yesterday (https://bugs.launchpad.net/barbican/+bug/1528774) that is fixed in mitaka but not liberty? | 19:02 |
| openstack | Launchpad bug 1528774 in Barbican "db creation fails with error "Specified key was too long"" [Critical,Fix released] - Assigned to Christopher Solis (cnsolis) | 19:02 |
| woodster_ | agrebennikov: so you were trying to apply that fix to liberty then? | 19:02 |
| agrebennikov | yeah | 19:03 |
| agrebennikov | I did | 19:03 |
| agrebennikov | URL = sa.Column(sa.String(255)) | 19:03 |
| agrebennikov | this was applied | 19:03 |
| woodster_ | agrebennikov: is it possible the old tables/schema were still in the db? | 19:03 |
| agrebennikov | hm.. I guess I re-created the db.. but let me verify once again... | 19:04 |
| agrebennikov | sec | 19:04 |
| agrebennikov | so same. And I believe this is nothing about that issue since I'm in the very beginning, while the patch covers something closer to the end | 19:09 |
| woodster_ | agrebennikov: it seems that something is still running with the 500 char size instead of 256 :\ | 19:13 |
| *** peter-hamilton has quit IRC | 19:30 | |
| agrebennikov | woodster_, you mean barbican code side or the db side? | 19:42 |
| woodster_ | agrebennikov: not sure. Haven't worked with packages much for barbican. something is still trying to set the column size to 500 instead of 256 it seems | 19:44 |
| agrebennikov | woodster_, but do you know exactly how that first migration works? 1a0c2cdafb38 -> juno, juno_initial | 19:48 |
| agrebennikov | I mean where I have to take a look at | 19:49 |
| agrebennikov | alternatively I can try to update my code to the latest liberty and see how it goes | 19:49 |
| *** gyee has joined #openstack-barbican | 20:00 | |
| *** sigmavirus24 is now known as sigmavirus24_awa | 20:09 | |
| *** fawadkhaliq has quit IRC | 20:11 | |
| *** fawadkhaliq has joined #openstack-barbican | 20:13 | |
| *** sigmavirus24_awa is now known as sigmavirus24 | 20:13 | |
| *** fawadkhaliq has quit IRC | 20:19 | |
| *** fawadkhaliq has joined #openstack-barbican | 20:20 | |
| *** fawadkhaliq has quit IRC | 20:24 | |
| *** fawadkhaliq has joined #openstack-barbican | 20:25 | |
| *** jamielennox|away is now known as jamielennox | 20:29 | |
| woodster_ | agrebennikov: this file starts the process up: https://github.com/openstack/barbican/blob/master/barbican/model/migration/alembic_migrations/versions/juno_initial.py (assuming the barbican.conf file has db_auto_create = False) | 20:47 |
| agrebennikov | woodster_, oh, no - the setting is true | 20:48 |
| *** krotscheck has quit IRC | 20:48 | |
| *** krotscheck has joined #openstack-barbican | 20:48 | |
| *** tkelsey has joined #openstack-barbican | 20:53 | |
| *** fawadk has joined #openstack-barbican | 20:54 | |
| *** fawadkhaliq has quit IRC | 20:54 | |
| *** tkelsey has quit IRC | 20:57 | |
| *** fawadk has quit IRC | 20:59 | |
| woodster_ | agrebennikov: so to use alembic and the patch, set that to false | 21:00 |
| *** fawadkhaliq has joined #openstack-barbican | 21:07 | |
| *** fawadkhaliq has quit IRC | 21:08 | |
| *** fawadkhaliq has joined #openstack-barbican | 21:08 | |
| *** fawadkhaliq has quit IRC | 21:08 | |
| agrebennikov | woodster_, so we found the root of the issue | 21:15 |
| agrebennikov | in the very first migration (juno_initial) URL column was created with the length 500 | 21:15 |
| woodster_ | agrebennikov: nice! | 21:15 |
| agrebennikov | and the migration failed on index creation | 21:16 |
| agrebennikov | when I changed the value in barbican/model/migration/alembic_migrations/container_init_ops.py | 21:16 |
| woodster_ | agrebennikov: I would have expected the gate to catch that :\ | 21:16 |
| agrebennikov | to sa.Column('URL', sa.String(length=255), nullable=True), | 21:16 |
| agrebennikov | everything works now | 21:17 |
| agrebennikov | seems the gate doesn't apply the migration | 21:17 |
| agrebennikov | and creates the latest schema right away | 21:17 |
| *** alee has quit IRC | 21:17 | |
| agrebennikov | but for some reason it doesn't work for me(( | 21:18 |
| woodster_ | agrebennikov: sounds like we need to revisit that at the summit next week | 21:18 |
| agrebennikov | woodster_, sounds like.... | 21:19 |
| agrebennikov | )) | 21:19 |
| zigo | I think it's really weird that Barbican doesn't include in its setup procedure to do a db-sync. | 21:29 |
| zigo | Every other services do... | 21:29 |
| woodster_ | zigo: I thought that was the role of alembic | 21:33 |
| zigo | woodster_: I've been told that db migration wasn't to be done at install time, and that Barbican would auto-create tables. | 21:33 |
| zigo | Is that wrong? | 21:33 |
| woodster_ | zigo: well it can work in two modes...one where sqlalchemy creates the tables from models, and one where alebic versions are applied | 21:34 |
| woodster_ | zigo: out of the box barbican runs in the sqlalchemy mode, but can be configured to do the alembic one | 21:35 |
| * zigo is now even more confused | 21:35 | |
| woodster_ | zigo: the problem was alembic didn't work with sqlite when I first wrote all of that stuff, and I wanted it to be easy for folks to run barbican out of the box and play with the api | 21:35 |
| zigo | Well, now SQLA is fixed for SQLite ... | 21:36 |
| zigo | It works pretty well with it, as much as I can tell. | 21:36 |
| woodster_ | zigo: so we deploy barbican with the auto-create mode (from sqlalchemy) set to false, to force alembic versioning stuff | 21:36 |
| zigo | Where's the switch? | 21:37 |
| zigo | In barbican.conf? | 21:37 |
| zigo | In the Debian package, I just get the alembic migration to start after the package is installed (well, if the user decided to use the dbconfig-common interface, which is optional). | 21:37 |
| zigo | And I noticed that barbican/model/migration/alembic_migrations/versions/1c0f328bfce0_fixing_composite_primary_keys_and_.py breaks. | 21:38 |
| zigo | Is this fixed? | 21:38 |
| woodster_ | zigo: its db_auto_create in the default section of the config file...set that to False to turn on alembic syncing | 21:38 |
| zigo | There's no such thing as db_auto_create in etc/barbican/barbican.conf ... | 21:39 |
| woodster_ | zigo: I think this is the fix?: https://bugs.launchpad.net/barbican/+bug/1528774 | 21:39 |
| openstack | Launchpad bug 1528774 in Barbican "db creation fails with error "Specified key was too long"" [Critical,Fix released] - Assigned to Christopher Solis (cnsolis) | 21:39 |
| woodster_ | zigo: well it defaults to True so not in the conf file (I prefer to have all conf fields in the conf file, but I think that got overruled a while ago) | 21:39 |
| woodster_ | zigo: used here: https://github.com/openstack/barbican/blob/master/barbican/model/repositories.py#L193 | 21:40 |
| woodster_ | zigo: ....the auto create conf setting that is | 21:40 |
| zigo | woodster_: So, should I patch the default config file and set it to false? | 21:42 |
| zigo | (since the default config file doesn't have it at all ...) | 21:42 |
| woodster_ | zigo: yes if you want to activate alembic db syncing | 21:42 |
| zigo | That's what the package does, so yes. | 21:43 |
| zigo | Though as I wrote, it has to be fixed, somehow. | 21:43 |
| zigo | The bug you pointed out was *one* of the issues, there's still the one I'm telling about that needs to be fixed. | 21:43 |
| woodster_ | zigo: ah ok. Would you be up for creating a LP bug for it by chance? | 21:45 |
| zigo | I can. | 21:45 |
| zigo | Though I need to re-attempt installing ... :P | 21:45 |
| zigo | Doing that one. | 21:45 |
| *** fawadkhaliq has joined #openstack-barbican | 21:52 | |
| zigo | Weird, it worked ... | 21:54 |
| zigo | Probably that one got fixed in Mitaka final too then. | 21:54 |
| woodster_ | zigo: I think redrobot mentioned a bug was fixed, I thought the one I posted | 21:54 |
| zigo | I just found it 1 issues working on this though: python-pymysql is missing as depends: | 21:55 |
| woodster_ | zigo: not in liberty though | 21:55 |
| zigo | Fixing it. | 21:55 |
| zigo | Liberty is the past for me. | 21:55 |
| zigo | I wont work on it again. :P | 21:55 |
| openstackgerrit | Merged openstack/barbican: migrate keystone_data to openstackclient https://review.openstack.org/307837 | 22:07 |
| *** spotz is now known as spotz_zzz | 22:16 | |
| *** fawadkhaliq has quit IRC | 22:16 | |
| *** fawadkhaliq has joined #openstack-barbican | 22:25 | |
| *** fawadkhaliq has quit IRC | 22:28 | |
| *** fawadkhaliq has joined #openstack-barbican | 22:30 | |
| *** krotscheck is now known as krotscheck_dcm | 22:32 | |
| *** sigmavirus24 is now known as sigmavirus24_awa | 22:35 | |
| *** fawadkhaliq has quit IRC | 22:40 | |
| *** edtubill has quit IRC | 22:45 | |
| *** tkelsey has joined #openstack-barbican | 22:54 | |
| *** tkelsey has quit IRC | 22:58 | |
| *** edtubill has joined #openstack-barbican | 23:05 | |
| *** dimtruck is now known as zz_dimtruck | 23:26 | |
| *** arun_kant has quit IRC | 23:36 | |
| *** zz_dimtruck is now known as dimtruck | 23:40 | |
| *** 6JTAACLMH has quit IRC | 23:43 | |
| *** asingh has quit IRC | 23:43 | |
| *** edtubill has quit IRC | 23:57 | |
| *** jhfeng has quit IRC | 23:57 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!