[Bug 1667334] Fix proposed to aodh (stable/ocata)

[OpenStack Infra]

Fix proposed to branch: stable/ocata
Review: https://review.openstack.org/437417

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to Ubuntu Cloud Archive.
https://bugs.launchpad.net/bugs/1667334

Title:
  aodh-dbsync: newton->ocata upgrade fails

Status in Aodh:
  New
Status in Ubuntu Cloud Archive:
  Triaged
Status in aodh package in Ubuntu:
  Triaged

Bug description:
  the 367aadf5485f_precisetimestamp_to_datetime migration fails with:

  ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table
  'aodh.alarm_change' doesn't exist") [SQL: u'ALTER TABLE alarm_change
  ADD COLUMN timestamp_ts DATETIME(6)']

  needs pick to stable/ocata for:

  https://github.com/openstack/aodh/commit/23552b1c0769a56e8541221965eaf09efefff400

  ProblemType: Bug
  DistroRelease: Ubuntu 16.04
  Package: aodh-api 4.0.0-0ubuntu1~cloud0 [origin: Canonical]
  ProcVersionSignature: User Name 4.4.0-64.85-generic 4.4.44
  Uname: Linux 4.4.0-64-generic x86_64
  NonfreeKernelModules: xfs veth xt_CHECKSUM iptable_mangle ipt_MASQUERADE nf_nat_masquerade_ipv4 iptable_nat nf_conntrack_ipv4 nf_defrag_ipv4 nf_nat_ipv4 nf_nat nf_conntrack xt_tcpudp iptable_filter ip_tables x_tables bridge stp llc ppdev kvm_intel kvm irqbypass joydev input_leds parport_pc mac_hid serio_raw parport i2c_piix4 8250_fintek ib_iser rdma_cm iw_cm ib_cm ib_sa ib_mad ib_core ib_addr iscsi_tcp libiscsi_tcp libiscsi scsi_transport_iscsi autofs4 btrfs raid10 raid456 async_raid6_recov async_memcpy async_pq async_xor async_tx xor raid6_pq libcrc32c raid1 raid0 multipath linear cirrus ttm crct10dif_pclmul drm_kms_helper crc32_pclmul ghash_clmulni_intel syscopyarea sysfillrect sysimgblt fb_sys_fops aesni_intel aes_x86_64 lrw gf128mul glue_helper ablk_helper drm cryptd psmouse pata_acpi floppy
  ApportVersion: 2.20.1-0ubuntu2.5
  Architecture: amd64
  CrashDB:
   {
                  "impl": "launchpad",
                  "project": "cloud-archive",
                  "bug_pattern_url": "http://people.canonical.com/~ubuntu-archive/bugpatterns/bugpatterns.xml",
               }
  Date: Thu Feb 23 14:58:01 2017
  PackageArchitecture: all
  ProcEnviron:
   TERM=xterm-256color
   PATH=(custom, no user)
   XDG_RUNTIME_DIR=<set>
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: aodh
  UpgradeStatus: No upgrade log present (probably fresh install)

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