group.of.nepali.translators team mailing list archive

[Felipe Reyes <1880495@xxxxxxxxxxxxxxxxxx>]

I could reproduce this issue locally, and this is what I believe is
happening with this environment (and not for other upgrades) is that the
database has no domains defined for the interfaces related, so this
piece of code [0] is falling into the "else" section which calls
get_default_domain() method and internally ends up query the 'ttl'
column. So the migration step 0011 is relying on it and expecting that
it was created in step 0010 and it wasn't, it was added way later in
migration step 0023.

[0]
https://github.com/maas/maas/blob/2.3/src/maasserver/migrations/builtin/maasserver/0011_domain_data.py#L106-L109

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

** Also affects: maas (Ubuntu Xenial)
   Importance: Undecided
       Status: New

-- 
You received this bug notification because you are a member of नेपाली
भाषा समायोजकहरुको समूह, which is subscribed to Xenial.
Matching subscriptions: Ubuntu 16.04 Bugs
https://bugs.launchpad.net/bugs/1880495

Title:
  Upgrade from 1.95 to 2.35 failure because column maasserver_domain.ttl
  does not exist

Status in MAAS:
  New
Status in maas package in Ubuntu:
  New
Status in maas source package in Xenial:
  New

Bug description:
  Upgrading an older Trusty based Maas (1.9.5) to Xenial (2.3.5)
  resulted in a traceback during the do-release-upgrade procedure:

    Applying maasserver.0011_domain_data...Traceback (most recent call last):
    File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 64, in execute
      return self.cursor.execute(sql, params)
  psycopg2.ProgrammingError: column maasserver_domain.ttl does not exist
  LINE 1: ...ain"."name", "maasserver_domain"."authoritative", "maasserve...
                                                               ^

  
  The above exception was the direct cause of the following exception:

  Traceback (most recent call last):
    File "/usr/lib/python3.5/runpy.py", line 184, in _run_module_as_main
      "__main__", mod_spec)
    File "/usr/lib/python3.5/runpy.py", line 85, in _run_code
      exec(code, run_globals)
    File "/usr/lib/python3/dist-packages/maasserver/__main__.py", line 9, in <module>
      raise SystemExit(execute_from_command_line())
    File "/usr/lib/python3/dist-packages/maasserver/__init__.py", line 73, in execute_from_command_line
      management.execute_from_command_line()
    File "/usr/lib/python3/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
      utility.execute()
    File "/usr/lib/python3/dist-packages/django/core/management/__init__.py", line 346, in execute
      self.fetch_command(subcommand).run_from_argv(self.argv)
    File "/usr/lib/python3/dist-packages/django/core/management/base.py", line 394, in run_from_argv
      self.execute(*args, **cmd_options)
    File "/usr/lib/python3/dist-packages/django/core/management/base.py", line 445, in execute
      output = self.handle(*args, **options)
    File "/usr/lib/python3/dist-packages/maasserver/management/commands/dbupgrade.py", line 426, in handle
      fake_initial=self._south_was_performed(database))
    File "/usr/lib/python3/dist-packages/django/core/management/__init__.py", line 120, in call_command
      return command.execute(*args, **defaults)
    File "/usr/lib/python3/dist-packages/django/core/management/base.py", line 445, in execute
      output = self.handle(*args, **options)
    File "/usr/lib/python3/dist-packages/django/core/management/commands/migrate.py", line 222, in handle
      executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
    File "/usr/lib/python3/dist-packages/django/db/migrations/executor.py", line 110, in migrate
      self.apply_migration(states[migration], migration, fake=fake, fake_initial=fake_initial)
    File "/usr/lib/python3/dist-packages/django/db/migrations/executor.py", line 148, in apply_migration
      state = migration.apply(state, schema_editor)
    File "/usr/lib/python3/dist-packages/django/db/migrations/migration.py", line 115, in apply
      operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
    File "/usr/lib/python3/dist-packages/django/db/migrations/operations/special.py", line 183, in database_forwards
      self.code(from_state.apps, schema_editor)
    File "/usr/lib/python3/dist-packages/maasserver/migrations/builtin/maasserver/0011_domain_data.py", line 109, in migrate_staticipaddress_hostname
      domain_id = maasserver.models.dnsresource.get_default_domain()
    File "/usr/lib/python3/dist-packages/maasserver/models/dnsresource.py", line 57, in get_default_domain
      return Domain.objects.get_default_domain().id
    File "/usr/lib/python3/dist-packages/maasserver/models/domain.py", line 108, in get_default_domain
      'updated': now,
    File "/usr/lib/python3/dist-packages/django/db/models/manager.py", line 127, in manager_method
      return getattr(self.get_queryset(), name)(*args, **kwargs)
    File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 405, in get_or_create
      return self.get(**lookup), False
    File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 328, in get
      num = len(clone)
    File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 144, in __len__
      self._fetch_all()
    File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 965, in _fetch_all
      self._result_cache = list(self.iterator())
    File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 238, in iterator
      results = compiler.execute_sql()
    File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", line 840, in execute_sql
      cursor.execute(sql, params)
    File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 64, in execute
      return self.cursor.execute(sql, params)
    File "/usr/lib/python3/dist-packages/django/db/utils.py", line 98, in __exit__
      six.reraise(dj_exc_type, dj_exc_value, traceback)
    File "/usr/lib/python3/dist-packages/django/utils/six.py", line 685, in reraise
      raise value.with_traceback(tb)
    File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 64, in execute
      return self.cursor.execute(sql, params)
  django.db.utils.ProgrammingError: column maasserver_domain.ttl does not exist
  LINE 1: ...ain"."name", "maasserver_domain"."authoritative", "maasserve...
                                                               ^

  dpkg: error processing package maas-region-controller (--configure):
   subprocess installed post-installation script returned error exit status 1
  No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                            dpkg: dependency problems prevent configuration of maas:
   maas depends on maas-region-controller (= 2.3.5-6511-gf466fdb-0ubuntu1); however:
    Package maas-region-controller is not configured yet.

  To reproduce, install Maas on Trusty, with a working database, and run
  do-release-upgrade.

  I suspect there's some edge case in this particular database, working
  now on trying to identify it.  The particular database has been around
  for at least 3 years now.

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