powerdns database records table missing 'disabled' column
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Designate |
Fix Released
|
Medium
|
stanzgy |
Bug Description
system: debian jessie
designate: 2d20f0f#master
powerdns: 3.4.1
When trying to use powerdns-mysql as backend to run designate with devstack, I found following error log in /var/log/syslog.
25727 Jan 12 15:55:11 localhost pdns_server[17351]: Jan 12 15:55:11 Exiting because communicator thread died with error: GSQLBackend lookup query:Failed to execute mysql_query , perhaps connection died? Err=1: Unknown column 'disabled' in 'field list'
25728 Jan 12 15:55:11 localhost pdns[17372]: Exiting because communicator thread died with error: GSQLBackend lookup query:Failed to execute mysql_query, perhaps connection di ed? Err=1: Unknown column 'disabled' in 'field list'
After checking powerdns docs, I thinks this is due to table 'records' missing column 'disabled'.
https:/
CREATE TABLE records (
id INT AUTO_INCREMENT,
domain_id INT DEFAULT NULL,
name VARCHAR(255) DEFAULT NULL,
type VARCHAR(10) DEFAULT NULL,
content VARCHAR(64000) DEFAULT NULL,
ttl INT DEFAULT NULL,
prio INT DEFAULT NULL,
change_date INT DEFAULT NULL,
disabled TINYINT(1) DEFAULT 0,
ordername VARCHAR(255) BINARY DEFAULT NULL,
auth TINYINT(1) DEFAULT 1,
PRIMARY KEY (id)
) Engine=InnoDB;
Changed in designate: | |
importance: | Undecided → Medium |
milestone: | none → kilo-2 |
Changed in designate: | |
status: | Fix Committed → Fix Released |
Changed in designate: | |
milestone: | kilo-2 → 2015.1.0 |
Fix proposed to branch: master /review. openstack. org/146391
Review: https:/