Uploaded image for project: 'Hue'
  1. Hue
  2. HUE-2232

[search] Examples don't install with MySql

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.6.0
    • Fix Version/s: 3.7.0
    • Component/s: app.search
    • Labels:
      None

      Description

      [18/Jul/2014 11:35:18 -0700] views ERROR 'module' object has no attribute 'exc_value'
      Traceback (most recent call last):
      File "/opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/apps/search/src/search/views.py", line 485, in install_examples
      search_setup.Command().handle_noargs()
      File "/opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/apps/search/src/search/management/commands/search_setup.py", line 37, in handle_noargs
      management.call_command('loaddata', 'initial_search_examples.json', verbosity=2)
      File "/opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/_init_.py", line 150, in call_command
      return klass.execute(*args, **defaults)
      File "/opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py", line 232, in execute
      output = self.handle(*args, **options)
      File "/opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/loaddata.py", line 240, in handle
      sys.exc_value, sys.exc_traceback)))))
      AttributeError: 'module' object has no attribute 'exc_value'
      [18/Jul/2014 11:35:18 -0700] access INFO 54.83.196.143 hdfs - "POST /search/install_examples HTTP/1.1"
      [18/Jul/2014 11:35:17 -0700] middleware DEBUG No desktop_app known for request.

      Problem installing fixture 'initial_search_examples.json.bz2': Traceback (most recent call last):
      File "/opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/loaddata.py", line 226, in handle
      connection.check_constraints(table_names=table_names)
      File "/opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py", line 474, in check_constraints
      referenced_table_name, referenced_column_name))
      IntegrityError: The row in table 'search_collection' with primary key '20000001' has an invalid foreign key: search_collection.facets_id contains a value '31' that does not have a corresponding value in search_facet.id.

      sudo HUE_CONF_DIR=/var/run/cloudera-scm-agent/process/9679-hue-HUE_SERVER /opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/lib/hue/build/env/bin/hue dbshell
      mysql> delete from search_collection; delete from search_sorting ; delete from search_result ; delete from search_facet
      Query OK, 0 rows affected (0.00 sec)

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: