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

hue init mysqldb error : if mysql port is 3306,no problem. if port is 8806, error is fllowing

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 3.10.0
    • Fix Version/s: None
    • Component/s: app.editor
    • Labels:
    • Environment:

      centos 6.7 (64) mysql 5.5

      Description

      when init mysqldb in /gomeo2o/software/hue-mysql/desktop/conf/pseudo-distributed.ini
      if mysql port is 3306,no problem. if port is 8806, error is fllowing :
      [root@10.125.31.52 bin]# pwd
      /gomeo2o/software/hue-mysql/build/env/bin
      [root@10.125.31.52 bin]# ./hue syncdb
      [05/Jul/2016 18:28:03 +0000] settings DEBUG DESKTOP_DB_TEST_NAME SET: /gomeo2o/software/hue-mysql/desktop/desktop-test.db
      [05/Jul/2016 18:28:03 +0000] settings DEBUG DESKTOP_DB_TEST_USER SET: hue_test
      /gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/cryptography-1.3.1-py2.6-linux-x86_64.egg/cryptography/_init_.py:26: DeprecationWarning: Python 2.6 is no longer supported by the Python core team, please upgrade your Python. A future version of cryptography will drop support for Python 2.6
      DeprecationWarning
      [05/Jul/2016 03:28:04 +0000] _init_ WARNING Couldn't import snappy. Support for snappy compression disabled.
      Syncing...
      Creating tables ...
      Creating table auth_permission
      Creating table auth_group_permissions
      Creating table auth_group
      Creating table auth_user_groups
      Creating table auth_user_user_permissions
      Creating table auth_user
      Creating table django_openid_auth_nonce
      Creating table django_openid_auth_association
      Creating table django_openid_auth_useropenid
      Creating table django_content_type
      Creating table django_session
      Creating table django_site
      Creating table django_admin_log
      Creating table south_migrationhistory
      Creating table axes_accessattempt
      Creating table axes_accesslog
      Traceback (most recent call last):
      File "./hue", line 9, in <module>
      load_entry_point('desktop==3.10.0', 'console_scripts', 'hue')()
      File "/gomeo2o/software/hue-mysql/desktop/core/src/desktop/manage_entry.py", line 59, in entry
      execute_from_command_line(sys.argv)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/_init_.py", line 399, in execute_from_command_line
      utility.execute()
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/_init_.py", line 392, in execute
      self.fetch_command(subcommand).run_from_argv(self.argv)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/base.py", line 242, in run_from_argv
      self.execute(*args, **options._dict_)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/base.py", line 285, in execute
      output = self.handle(*args, **options)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/base.py", line 415, in handle
      return self.handle_noargs(**options)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/South-1.0.2-py2.6.egg/south/management/commands/syncdb.py", line 92, in handle_noargs
      syncdb.Command().execute(**options)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/base.py", line 285, in execute
      output = self.handle(*args, **options)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/base.py", line 415, in handle
      return self.handle_noargs(**options)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/commands/syncdb.py", line 112, in handle_noargs
      emit_post_sync_signal(created_models, verbosity, interactive, db)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/management/sql.py", line 216, in emit_post_sync_signal
      interactive=interactive, db=db)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/dispatch/dispatcher.py", line 185, in send
      response = receiver(signal=self, sender=sender, **named)
      File "/gomeo2o/software/hue-mysql/apps/useradmin/src/useradmin/models.py", line 216, in get_default_user_group
      group.save()
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 545, in save
      force_update=force_update, update_fields=update_fields)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 573, in save_base
      updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 654, in _save_table
      result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 687, in _do_insert
      using=using, raw=raw)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/manager.py", line 232, in _insert
      return insert_query(self.model, objs, fields, **kwargs)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py", line 1514, in insert_query
      return query.get_compiler(using=using).execute_sql(return_id)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/sql/compiler.py", line 903, in execute_sql
      cursor.execute(sql, params)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/backends/util.py", line 53, in execute
      return self.cursor.execute(sql, params)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/utils.py", line 99, in _exit_
      six.reraise(dj_exc_type, dj_exc_value, traceback)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/backends/util.py", line 53, in execute
      return self.cursor.execute(sql, params)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/backends/mysql/base.py", line 124, in execute
      return self.cursor.execute(query, args)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/MySQL_python-1.2.5-py2.6-linux-x86_64.egg/MySQLdb/cursors.py", line 205, in execute
      self.errorhandler(self, exc, value)
      File "/gomeo2o/software/hue-mysql/build/env/lib/python2.6/site-packages/MySQL_python-1.2.5-py2.6-linux-x86_64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
      raise errorclass, errorvalue
      django.db.utils.IntegrityError: (1062, "Duplicate entry '1' for key 'PRIMARY'")
      [root@10.125.31.52 bin]#

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhaoshanchuan zhaoshanchuan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: