Bug 1416502 – Undercloud upgrade fails during aodh-db-sync: ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'ceilometer.alarm_change' doesn't exist") [SQL: u'ALTER TABLE alarm_change ADD COLUMN timestamp_ts DATETIME(6)']

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1416502 - Undercloud upgrade fails during aodh-db-sync: ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'ceilometer.alarm_change' doesn't exist") [SQL: u'ALTER TABLE alarm_change ADD COLUMN timestamp_ts DATETIME(6)']

Summary:	Undercloud upgrade fails during aodh-db-sync: ProgrammingError: (pymysql.err....

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat OpenStack
Classification:	Red Hat
Component:	instack-undercloud (Show other bugs)
Sub Component:
Version:	11.0 (Ocata)
Hardware:	Unspecified Unspecified

Priority	unspecified Severity urgent
Target Milestone:	rc
Target Release:	11.0 (Ocata)
Assigned To:	Pradeep Kilambi
QA Contact:	Omri Hochman
Docs Contact:

URL:
Whiteboard:
Keywords:	Triaged

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2017-01-25 11:12 EST by Marius Cornea
Modified:	2017-05-17 15:43 EDT (History)
CC List:	10 users (show)

See Also:
Fixed In Version:	instack-undercloud-6.0.0-0.20170120171137.c891931.el7ost
Doc Type:	If docs needed, set a value
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2017-05-17 15:43:26 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
OpenStack gerrit	424950	None	None	None	2017-01-25 11:12 EST
Red Hat Product Errata	RHEA-2017:1245	normal	SHIPPED_LIVE	Red Hat OpenStack Platform 11.0 Bug Fix and Enhancement Advisory	2017-05-17 19:01:50 EDT

Groups: None (edit)

Description Marius Cornea 2017-01-25 11:12:36 EST

Description of problem:
Undercloud upgrade fails during aodh-db-sync: ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'ceilometer.alarm_change' doesn't exist") [SQL: u'ALTER TABLE alarm_change ADD COLUMN timestamp_ts DATETIME(6)']

Version-Release number of selected component (if applicable):
instack-undercloud-6.0.0-0.20170120171137.c891931.el7ost.noarch

How reproducible:
100%

Steps to Reproduce:
1. Upgrade undercloud

Actual results:
Fails during aodh-db-sync:

2017-01-25 11:00:17,233 INFO: Error: /Stage[main]/Aodh::Db::Sync/Exec[aodh-db-sync]/returns: change from notrun to 0 failed: aodh-dbsync --config-file /etc/aodh/aodh.conf returned 1 instead of one of [0]
 

Expected results:
Upgrade completes ok.

Additional info:

Comment 1 Julien Danjou 2017-01-26 08:45:33 EST

The question is: why is Ceilometer database referenced here?

Comment 8 errata-xmlrpc 2017-05-17 15:43:26 EDT

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2017:1245

Note You need to log in before you can comment on or make changes to this bug.