Aodh is not getting installed with packstack

Bug #1855443 reported by Manik Sidana
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Packstack
Fix Released
High
Javier Peña

Bug Description

Aodh doesnot gets installed with packstack (centos-release-openstack-train)
I enabled CONFIG_AODH_INSTALL=y and CONFIG_CEILOMETER_INSTALL=y

[root@manik ~(keystone_admin)]# aodh alarm list
(pymysql.err.ProgrammingError) (1146, u"Table 'aodh.alarm' doesn't exist") [SQL: u'SELECT alarm.alarm_id AS alarm_alarm_id, alarm.enabled AS alarm_enabled, alarm.name AS alarm_name, alarm.type AS alarm_type, alarm.severity AS alarm_severity, alarm.description AS alarm_description, alarm.timestamp AS alarm_timestamp, alarm.user_id AS alarm_user_id, alarm.project_id AS alarm_project_id, alarm.state AS alarm_state, alarm.state_reason AS alarm_state_reason, alarm.state_timestamp AS alarm_state_timestamp, alarm.ok_actions AS alarm_ok_actions, alarm.alarm_actions AS alarm_alarm_actions, alarm.insufficient_data_actions AS alarm_insufficient_data_actions, alarm.repeat_actions AS alarm_repeat_actions, alarm.rule AS alarm_rule, alarm.time_constraints AS alarm_time_constraints \nFROM alarm ORDER BY alarm.timestamp DESC'] (Background on this error at: http://sqlalche.me/e/f405) (HTTP 500) (Request-ID: req-7715bda9-05b9-4401-bfb9-da348d438305)
[root@manik ~(keystone_admin)]#

No tables are getting created for Aodh.

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| aodh |
| cinder |
| glance |
| gnocchi |
| heat |
| information_schema |
| keystone |
| mysql |
| neutron |
| nova |
| nova_api |
| nova_cell0 |
| panko |
| performance_schema |
| placement |
| test |
+--------------------+
16 rows in set (0.005 sec)

MariaDB [(none)]> use aodh
Database changed
MariaDB [aodh]> show tables
    -> ;
Empty set (0.000 sec)

MariaDB [aodh]>

Revision history for this message
Javier Peña (jpena-c) wrote :

I have reproduced the issue with stable/stein code. We have to add sync_db => true to the aodh::api class at https://github.com/redhat-openstack/packstack/blob/master/packstack/puppet/modules/packstack/manifests/aodh.pp#L20-L23

I'll sent a patch asap.

Changed in packstack:
importance: Undecided → High
status: New → Confirmed
assignee: nobody → Javier Peña (jpena-c)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to packstack (master)

Fix proposed to branch: master
Review: https://review.opendev.org/698453

Changed in packstack:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to packstack (master)

Reviewed: https://review.opendev.org/698453
Committed: https://git.openstack.org/cgit/x/packstack/commit/?id=1f64071f5a17dd3d66033edd5c3786d67459c293
Submitter: Zuul
Branch: master

commit 1f64071f5a17dd3d66033edd5c3786d67459c293
Author: Javier Pena <email address hidden>
Date: Wed Dec 11 13:15:58 2019 +0100

    Ensure the Aodh DB is synced

    We were lacking the "sync_db => true" parameter when calling aodh::api,
    so the database was not initialized, and API calls were failing.

    Change-Id: Idbc4f5a3310c0776ba4973b45dbaf554d8372b8e
    Closes-Bug: #1855443

Changed in packstack:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to packstack (stable/train)

Fix proposed to branch: stable/train
Review: https://review.opendev.org/698541

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to packstack (stable/stein)

Fix proposed to branch: stable/stein
Review: https://review.opendev.org/698542

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to packstack (stable/rocky)

Fix proposed to branch: stable/rocky
Review: https://review.opendev.org/698543

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to packstack (stable/queens)

Fix proposed to branch: stable/queens
Review: https://review.opendev.org/698544

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to packstack (stable/rocky)

Reviewed: https://review.opendev.org/698543
Committed: https://git.openstack.org/cgit/x/packstack/commit/?id=c024700d60b30f0a858effd16ab625fd4a269b6c
Submitter: Zuul
Branch: stable/rocky

commit c024700d60b30f0a858effd16ab625fd4a269b6c
Author: Javier Pena <email address hidden>
Date: Wed Dec 11 13:15:58 2019 +0100

    Ensure the Aodh DB is synced

    We were lacking the "sync_db => true" parameter when calling aodh::api,
    so the database was not initialized, and API calls were failing.

    Change-Id: Idbc4f5a3310c0776ba4973b45dbaf554d8372b8e
    Closes-Bug: #1855443
    (cherry picked from commit 1f64071f5a17dd3d66033edd5c3786d67459c293)

tags: added: in-stable-rocky
tags: added: in-stable-queens
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to packstack (stable/queens)

Reviewed: https://review.opendev.org/698544
Committed: https://git.openstack.org/cgit/x/packstack/commit/?id=53617e23547c6a2987471500ae4666fb57b2642c
Submitter: Zuul
Branch: stable/queens

commit 53617e23547c6a2987471500ae4666fb57b2642c
Author: Javier Pena <email address hidden>
Date: Wed Dec 11 13:15:58 2019 +0100

    Ensure the Aodh DB is synced

    We were lacking the "sync_db => true" parameter when calling aodh::api,
    so the database was not initialized, and API calls were failing.

    Change-Id: Idbc4f5a3310c0776ba4973b45dbaf554d8372b8e
    Closes-Bug: #1855443
    (cherry picked from commit 1f64071f5a17dd3d66033edd5c3786d67459c293)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to packstack (stable/train)

Reviewed: https://review.opendev.org/698541
Committed: https://git.openstack.org/cgit/x/packstack/commit/?id=c32f8cb9988b6509ad522e4f4aaff2a057c6fb88
Submitter: Zuul
Branch: stable/train

commit c32f8cb9988b6509ad522e4f4aaff2a057c6fb88
Author: Javier Pena <email address hidden>
Date: Wed Dec 11 13:15:58 2019 +0100

    Ensure the Aodh DB is synced

    We were lacking the "sync_db => true" parameter when calling aodh::api,
    so the database was not initialized, and API calls were failing.

    Change-Id: Idbc4f5a3310c0776ba4973b45dbaf554d8372b8e
    Closes-Bug: #1855443
    (cherry picked from commit 1f64071f5a17dd3d66033edd5c3786d67459c293)

tags: added: in-stable-train
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to packstack (stable/stein)

Reviewed: https://review.opendev.org/698542
Committed: https://git.openstack.org/cgit/x/packstack/commit/?id=b0906362b439473cb09e63a85d623d9bff338e29
Submitter: Zuul
Branch: stable/stein

commit b0906362b439473cb09e63a85d623d9bff338e29
Author: Javier Pena <email address hidden>
Date: Wed Dec 11 13:15:58 2019 +0100

    Ensure the Aodh DB is synced

    We were lacking the "sync_db => true" parameter when calling aodh::api,
    so the database was not initialized, and API calls were failing.

    Change-Id: Idbc4f5a3310c0776ba4973b45dbaf554d8372b8e
    Closes-Bug: #1855443
    (cherry picked from commit 1f64071f5a17dd3d66033edd5c3786d67459c293)

tags: added: in-stable-stein
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.