[Bug 1667334] [NEW] aodh-dbsync: newton->ocata upgrade fails

[James Page]

Public bug reported:

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)

** Affects: aodh
     Importance: Undecided
         Status: New

** Affects: cloud-archive
     Importance: High
         Status: Triaged

** Affects: aodh (Ubuntu)
     Importance: High
         Status: Triaged


** Tags: amd64 apport-bug third-party-packages uec-images xenial

** Also affects: aodh
   Importance: Undecided
       Status: New

** Also affects: aodh (Ubuntu)
   Importance: Undecided
       Status: New

** Changed in: aodh (Ubuntu)
   Importance: Undecided => High

** Changed in: aodh (Ubuntu)
       Status: New => Triaged

** Changed in: cloud-archive
       Status: New => Triaged

** Changed in: cloud-archive
   Importance: Undecided => High

-- 
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