Skip to content
This repository was archived by the owner on Jun 11, 2024. It is now read-only.
This repository was archived by the owner on Jun 11, 2024. It is now read-only.

Manual installation fails when migrate #214

@marcoarthur

Description

@marcoarthur

Following the manual installation steps. Got this error:

  Rendering model states... DONE
  Applying inventory.0016_public_repos_cards...Traceback (most recent call last):
  File "src/manage.py", line 10, in 
    execute_from_command_line(sys.argv)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 338, in execute_from_command_line
    utility.execute()
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 330, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/base.py", line 390, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/base.py", line 441, in execute
    output = self.handle(*args, **options)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 221, in handle
    executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 110, in migrate
    self.apply_migration(states[migration], migration, fake=fake, fake_initial=fake_initial)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 147, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/migration.py", line 115, in apply
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/operations/special.py", line 183, in database_forwards
    self.code(from_state.apps, schema_editor)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/factory/django.py", line 345, in wrapper
    return callable_obj(*args, **kwargs)
  File "/srv/datahub/src/account/management/commands/createpublicanonuser.py", line 47, in create_public_user
    username=username, password=password, create_db=False)
  File "/srv/datahub/src/core/db/manager.py", line 1084, in create_user
    username=username, password=password, create_db=create_db)
  File "/srv/datahub/src/core/db/connection.py", line 157, in create_user
    return self.backend.create_user(username, password, create_db)
  File "/srv/datahub/src/core/db/backend/pg.py", line 605, in create_user
    self.execute_sql(query, params)
  File "/srv/datahub/src/core/db/backend/pg.py", line 568, in execute_sql
    _convert_pg_exception(e)
  File "/srv/datahub/src/core/db/backend/pg.py", line 83, in _convert_pg_exception
    raise e
psycopg2.ProgrammingError: unrecognized role option "nocreateuser"
LINE 1: ...ROLE dh_public WITH LOGIN NOCREATEDB NOCREATEROLE NOCREATEUS...
                                                             ^

The host I was trying to install is running postgresql 9.6 in search for this problem I saw this closed ansible/ansible-modules-core#4225 issue, regarding that postgresql 9.6 don't have this option anymore. Somehow the database handler used for deploy is creating a deprecated (not supported) SQL code for PostGresQL

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions