powerdns database records table missing 'disabled' column

Bug #1409629 reported by stanzgy
6
This bug affects 1 person
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://doc.powerdns.com/md/authoritative/installation/

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;

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to designate (master)

Fix proposed to branch: master
Review: https://review.openstack.org/146391

Changed in designate:
assignee: nobody → stanzgy (stanzgy)
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to designate (master)

Reviewed: https://review.openstack.org/146391
Committed: https://git.openstack.org/cgit/openstack/designate/commit/?id=e2e609aec055a6e81a0ca7cb747809081ade81b1
Submitter: Jenkins
Branch: master

commit e2e609aec055a6e81a0ca7cb747809081ade81b1
Author: stanzgy <email address hidden>
Date: Mon Jan 12 10:40:54 2015 +0800

    Fix powerdns db table records missing column disabled

    Fix powerdns db table 'records' missing column 'disabled', which makes powerdns
    service unable to start.

    Change-Id: I3b4c056ca68c44b7e42d20faba555471171b661f
    Closes-Bug: 1409629

Changed in designate:
status: In Progress → Fix Committed
Kiall Mac Innes (kiall)
Changed in designate:
importance: Undecided → Medium
milestone: none → kilo-2
Thierry Carrez (ttx)
Changed in designate:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in designate:
milestone: kilo-2 → 2015.1.0
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.