Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-2249

[jobsub] DB migration problems from 2 to 3.6

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.5.0, 3.6.0
    • Fix Version/s: 3.7.0
    • Component/s: app.editor
    • Labels:
    • Environment:

      Redhat 2.6.32-358.14.1.el6.x86_64

      Description

      When migrating Hue database from version 2 to 3.6, during the migration of default database SQLite, the data migration '0005_unify_with_oozie.py' is conflicting with the current schema (it is expecting the 'data' member).

      Below errors may come up when trying to access Hue UI:
      File "/opt/cloudera/parcels/CDH-5.0.2-1.cdh5.0.2.p0.13/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/backends/sqlite3/base.py", line 344, in execute
      return Database.Cursor.execute(self, query, params)
      DatabaseError: no such table: search_collection

      If manually run syncdb and migrate, may run into errors like this:
      "/opt/cloudera/parcels/CDH/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/backends/sqlite3/base.py", line 344, in execute
      return Database.Cursor.execute(self, query, params)
      django.db.utils.DatabaseError: no such column: oozie_node.data

        Attachments

          Activity

            People

            • Assignee:
              romain Romain Rigaux
              Reporter:
              lwang Li
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: