Re: [Openstack] [Neutron] LBaaS not working after Grizzly -> Havana update (DB error)

2014-01-13 Thread Jonathan Proulx
I went a head and created the colum it was complaining about , no doubt this will come back to haunt me: mysql> ALTER TABLE pools ADD COLUMN status_description varchar(255) DEFAULT NULL AFTER status; but at least neutron-server will run with the lbaas agent enabled while I try and figure out why

Re: [Openstack] [Neutron] LBaaS not working after Grizzly -> Havana update (DB error)

2014-01-13 Thread Jonathan Proulx
Hi Eugene, I did have an upgrade issue on my end that could well have impacted the DB migration. Just after upgrade and when the Ubuntu packed migration scripts ran the database connection in neutron.conf pointed to a local sqllite location. So first thing I did was correct that to point at the

Re: [Openstack] [Neutron] LBaaS not working after Grizzly -> Havana update (DB error)

2014-01-13 Thread Eugene Nikanorov
Hi Jonathan, It really looks as migration issue. I wonder how did you perform the migration. Devstack usually runs migration during the setup and everything works fine with the current code. Could you provide more details about how you run the migration. Thanks, Eugene. On Mon, Jan 13, 2014 a

[Openstack] [Neutron] LBaaS not working after Grizzly -> Havana update (DB error)

2014-01-12 Thread Jonathan Proulx
Hi all, neutron-lbass-agent is failing with: neutron.service OperationalError: (OperationalError) (1054, "Unknown column 'pools.status_description' in 'field list'") 'SELECT pools.tenant_id AS pools_tenant_id, pools.id AS pools_id, pools.status AS pools_status, pools.status_description AS pools_s