** Changed in: neutron
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1288681
Title:
Migration with alter_column function reset nullable parameter for
columns
Status in OpenStack Neutron (virtual network service):
Fix Released
Bug description:
Migrations 338d7508968c_vpnaas_peer_address_.py and
abc88c33f74f_lb_stats_needs_bigint.py correct columns' length and
types, but nullable=False parameter is lost after its upgrade() :
mysql> explain ipsec_site_connections;
+----------------+-------------------------------------------------------------+------+-----+---------+-------+
| Field | Type
| Null | Key | Default | Extra |
+----------------+-------------------------------------------------------------+------+-----+---------+-------+
| tenant_id | varchar(255)
| YES | | NULL | |
| id | varchar(36)
| NO | PRI | NULL | |
| name | varchar(255)
| YES | | NULL | |
| description | varchar(255)
| YES | | NULL | |
| peer_address | varchar(255)
| YES | | NULL | |
| peer_id | varchar(255)
| NO | | NULL | |
| route_mode | varchar(8)
| NO | | NULL | |
| mtu | int(11)
| NO | | NULL | |
| initiator | enum('bi-directional','response-only')
| NO | | NULL | |
| auth_mode | varchar(16)
| NO | | NULL | |
| psk | varchar(255)
| NO | | NULL | |
| dpd_action |
enum('hold','clear','restart','disabled','restart-by-peer') | NO | | NULL
| |
| dpd_interval | int(11)
| NO | | NULL | |
| dpd_timeout | int(11)
| NO | | NULL | |
| status | varchar(16)
| NO | | NULL | |
| admin_state_up | tinyint(1)
| NO | | NULL | |
| vpnservice_id | varchar(36)
| NO | MUL | NULL | |
| ipsecpolicy_id | varchar(36)
| NO | MUL | NULL | |
| ikepolicy_id | varchar(36)
| NO | MUL | NULL | |
+----------------+-------------------------------------------------------------+------+-----+---------+-------+
19 rows in set (0.00 sec)
mysql> explain poolstatisticss;
+--------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| pool_id | varchar(36) | NO | PRI | NULL | |
| bytes_in | bigint(20) | YES | | NULL | |
| bytes_out | bigint(20) | YES | | NULL | |
| active_connections | bigint(20) | YES | | NULL | |
| total_connections | bigint(20) | YES | | NULL | |
+--------------------+-------------+------+-----+---------+-------+
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1288681/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
