While launching the FW(Vyos) in East-West, the provider Ptg creation failed due to DBError .
On debugging further observed that the issue is caused while updating DB (sc_instances). The error seen was "Data too long for column 'name'".
The 'name' field in sc_instances table is 50 characters long. The name that is given while createing PTG is less than 50 characters.
The problem is seen as gbp is pre-pending some extra characters to the ptg name before updating the DB.
MariaDB [neutron]> desc sc_instances;
+---------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------+------+-----+---------+-------+
| tenant_id | varchar(255) | YES | | NULL | |
| id | varchar(36) | NO | PRI | NULL | |
| name | varchar(50) | YES | | NULL | |
| description | varchar(255) | YES | | NULL | |
| config_param_values | varchar(4096) | YES | | NULL | |
| provider_ptg_id | varchar(36) | YES | | NULL | |
| consumer_ptg_id | varchar(36) | YES | | NULL | |
| classifier_id | varchar(36) | YES | | NULL | |
| management_ptg_id | varchar(36) | YES | | NULL | |
+---------------------+---------------+------+-----+---------+-------+
9 rows in set (0.00 sec)
Snapshot of neutron server log
--------------------------------
2015-11-25 01:58:10.531 26974 TRACE gbpservice.neutron.services.grouppolicy.policy_driver_manager self.errorhandler(self, exc, value)
2015-11-25 01:58:10.531 26974 TRACE gbpservice.neutron.services.grouppolicy.policy_driver_manager File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-11-25 01:58:10.531 26974 TRACE gbpservice.neutron.services.grouppolicy.policy_driver_manager raise errorclass, errorvalue
2015-11-25 01:58:10.531 26974 TRACE gbpservice.neutron.services.grouppolicy.policy_driver_manager DBError: (DataError) (1406, "Data too long for column 'name' at row 1") 'INSERT INTO sc_instances (tenant_id, id, name, description, config_param_values, provider_ptg_id, consumer_ptg_id, management_ptg_id, classifier_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)' ('1eeb8711c9e94db2b5864e7689c565a2', '738cc6da-be49-4464-9013-47d1917cd48b', 'gbp_sungard-project-test-prs_test-provider-policy-target-group', '', '{}', '793ed549-437a-4a7f-bdcb-c2e5c7e58b0e', 'N/A', None, '01561fcd-3f38-4f3f-95fd-0da0027b745b')
Note:
gbp is prefixing the following string format to names before updating db.
gbp_<prs-name>_<ptg-name>
Eg: In the above error 'gbp_sungard-project-test-prs_test-provider-policy-target-group' is the name of the ptg after modification by gbp.
In this case prs name is 'sungard-project-test-prs' and ptg name is 'test-provider-policy-target-group'
Fix proposed to branch: stable/kilo
Review: https:/