yahoo-eng-team team mailing list archive

[Rui Chen <chenrui.momo@xxxxxxxxx>]

Public bug reported:

We downgrade our OpenStack deployment from Juno to Havana, nova-compute
process can't start because of DB schema issue, the 'compute_node_stats'
table was created when DB downgrade, see details in
233_add_stats_in_compute_nodes.py, but it didn't set the 'id' colume as
primary key, this would result in nova-compute booting failed.

raise result RemoteError: Remote error: DBError (IntegrityError) null value in column "ID" violates not-null constraint DETAIL:  
Failing row contains (2014-12-29 07:37:18.211288, null, null, 0, null, num_task_None, 1, 1).  'INSERT INTO compute_node_stats (created_at, updated_at, deleted_at, deleted, key, value, compute_node_id) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(key)s, %(value)s, %(compute_node_id)s) RETURNING compute_node_stats.id' {'deleted': 0, 'created_at': datetime.datetime(2014, 12, 29, 7, 37, 18, 211288), 'updated_at': None, 'value': 1, 'compute_node_id': 1, 'key': u'num_task_None', 'deleted_at': None}

** Affects: nova
     Importance: Undecided
     Assignee: Rui Chen (kiwik-chenrui)
         Status: New

** Changed in: nova
     Assignee: (unassigned) => Rui Chen (kiwik-chenrui)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1410706

Title:
  Nova-compute can't start after DB downgrade from juno to havana

Status in OpenStack Compute (Nova):
  New

Bug description:
  We downgrade our OpenStack deployment from Juno to Havana, nova-
  compute process can't start because of DB schema issue, the
  'compute_node_stats' table was created when DB downgrade, see details
  in 233_add_stats_in_compute_nodes.py, but it didn't set the 'id'
  colume as primary key, this would result in nova-compute booting
  failed.

  raise result RemoteError: Remote error: DBError (IntegrityError) null value in column "ID" violates not-null constraint DETAIL:  
  Failing row contains (2014-12-29 07:37:18.211288, null, null, 0, null, num_task_None, 1, 1).  'INSERT INTO compute_node_stats (created_at, updated_at, deleted_at, deleted, key, value, compute_node_id) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(key)s, %(value)s, %(compute_node_id)s) RETURNING compute_node_stats.id' {'deleted': 0, 'created_at': datetime.datetime(2014, 12, 29, 7, 37, 18, 211288), 'updated_at': None, 'value': 1, 'compute_node_id': 1, 'key': u'num_task_None', 'deleted_at': None}

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1410706/+subscriptions