sql DB is not updated after record creation

Bug #1491348 reported by Alex Stafeyev
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Designate
Invalid
Undecided
Graham Hayes

Bug Description

We created a record but when we check mysql tables we saw that there is not relevant entry.

After some time the DB is updated ( we waited about half an hour may be more)

[root@controller system(keystone_admin)]# designate record-create --name server3.example.com. --type A --data 3.2.3.4 de641237-8e3f-4479-9b60-376122c43dbe
+-------------+--------------------------------------+
| Field | Value |
+-------------+--------------------------------------+
| description | None |
| type | A |
| created_at | 2015-09-02T18:07:22.000000 |
| updated_at | None |
| domain_id | de641237-8e3f-4479-9b60-376122c43dbe |
| priority | None |
| ttl | None |
| data | 3.2.3.4 |
| id | 811a8c12-7768-4849-9665-a19246ae01b9 |
| name | server3.example.com. |
+-------------+--------------------------------------+

sql DB:

MariaDB [designate_pdns]> select * from records;
+----+-----------+---------------------+------+------------------------------------------------------------------------+------+------+-------------+-----------+------+-------------+----------+
| id | domain_id | name | type | content | ttl | prio | change_date | ordername | auth | inherit_ttl | disabled |
+----+-----------+---------------------+------+------------------------------------------------------------------------+------+------+-------------+-----------+------+-------------+----------+
| 15 | 4 | example.com | SOA | controller.novalocal. root.example.com. 1441204705 3600 600 86400 3600 | 3600 | 0 | NULL | NULL | 1 | NULL | 0 |
| 16 | 4 | server2.example.com | A | 2.2.3.4 | 3600 | 0 | NULL | NULL | 1 | NULL | 0 |
| 17 | 4 | vm1.example.com | A | 192.168.1.9 | 3600 | 0 | NULL | NULL | 1 | NULL | 0 |
| 18 | 4 | example.com | NS | controller.novalocal | 3600 | 0 | NULL | NULL | 1 | NULL | 0 |
| 19 | 4 | vm2.example.com | A | 192.168.1.10 | 3600 | 0 | NULL | NULL | 1 | NULL | 0 |
| 20 | 4 | server1.example.com | A | 1.2.3.4 | 3600 | 0 | NULL | NULL | 1 | NULL | 0 |
+----+-----------+---------------------+------+------------------------------------------------------------------------+------+------+-------------+-----------+------+-------------+----------+
6 rows in set (0.00 sec)

MariaDB [designate_pdns]>

http://pastebin.com/gXLa64UN ---------------logs

openstack-designate-api-2015.1.0-1.el7ost.noarch
openstack-designate-agent-2015.1.0-1.el7ost.noarch
openstack-designate-sink-2015.1.0-1.el7ost.noarch
python-designate-2015.1.0-1.el7ost.noarch
openstack-designate-mdns-2015.1.0-1.el7ost.noarch
python-designateclient-1.2.0-1.el7ost.noarch
openstack-designate-common-2015.1.0-1.el7ost.noarch
openstack-designate-central-2015.1.0-1.el7ost.noarch
openstack-designate-pool-manager-2015.1.0-1.el7ost.noarch

Kiall Mac Innes (kiall)
Changed in designate:
assignee: nobody → Graham Hayes (grahamhayes)
Revision history for this message
Graham Hayes (grahamhayes) wrote :

I could not replicate

Changed in designate:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.