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

Manual installation fails when migrate #214

Open
marcoarthur opened this issue Oct 1, 2018 · 0 comments
Open

Manual installation fails when migrate #214

marcoarthur opened this issue Oct 1, 2018 · 0 comments

Comments

@marcoarthur
Copy link

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant