Skip to content

Instantly share code, notes, and snippets.

@alikins
Created February 3, 2020 20:48
Show Gist options
  • Save alikins/a024e44de428a343c151165a042cd85b to your computer and use it in GitHub Desktop.
Save alikins/a024e44de428a343c151165a042cd85b to your computer and use it in GitHub Desktop.
make docker/run-migrations error
(.venv) [newswoop:F31:galaxy-dev (pr-243 %)]$ make docker/run-migrations
docker-compose run --rm pulp-api manage migrate
Creating network "galaxy-dev_default" with the default driver
Creating galaxy-dev_redis_1 ... done
Creating galaxy-dev_postgres_1 ... done
Obtaining file:///code/pulp_ansible
Installing build dependencies ... done
Getting requirements to build wheel ... done
Preparing wheel metadata ... done
Requirement already satisfied: semantic-version in /venv/lib/python3.6/site-packages (from pulp-ansible==0.2.0b9.dev0) (2.8.4)
Requirement already satisfied: pulpcore>=3.0.<3.2 in /venv/lib/python3.6/site-packages (from pulp-ansible==0.2.0b9.dev0) (3.1.0)
Requirement already satisfied: packaging in /venv/lib/python3.6/site-packages (from pulp-ansible==0.2.0b9.dev0) (20.1)
Requirement already satisfied: galaxy-importer in /venv/lib/python3.6/site-packages (from pulp-ansible==0.2.0b9.dev0) (0.1.3)
Requirement already satisfied: PyYAML in /venv/lib/python3.6/site-packages (from pulp-ansible==0.2.0b9.dev0) (5.2)
Requirement already satisfied: gunicorn<20.1,>=19.9 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (20.0.4)
Requirement already satisfied: psycopg2<2.9,>=2.7 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.8.4)
Requirement already satisfied: aiofiles in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.4.0)
Requirement already satisfied: djangorestframework~=3.10.2 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.10.3)
Requirement already satisfied: python-gnupg~=0.4.0 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.4.5)
Requirement already satisfied: django-filter~=2.2.0 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.2.0)
Requirement already satisfied: redis~=3.1.0 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.1.0)
Requirement already satisfied: drf-nested-routers~=0.91.0 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.91)
Requirement already satisfied: dynaconf<2.3,>=2.2 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.2.2)
Requirement already satisfied: rq<1.3,>=1.1 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.2.2)
Requirement already satisfied: whitenoise<5.1.0,>=4.1.3 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (5.0.1)
Requirement already satisfied: aiohttp in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.6.2)
Requirement already satisfied: drf-yasg~=1.17.0 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.17.0)
Requirement already satisfied: Django~=2.2.3 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.2.10)
Requirement already satisfied: djangorestframework-queryfields~=1.0.0 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.0.0)
Requirement already satisfied: pygtrie~=2.3.2 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.3.2)
Requirement already satisfied: coreapi~=2.3.3 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.3.3)
Requirement already satisfied: setuptools>=39.2.0 in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (45.1.0)
Requirement already satisfied: backoff in /venv/lib/python3.6/site-packages (from pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.10.0)
Requirement already satisfied: six in /venv/lib/python3.6/site-packages (from packaging->pulp-ansible==0.2.0b9.dev0) (1.14.0)
Requirement already satisfied: pyparsing>=2.0.2 in /venv/lib/python3.6/site-packages (from packaging->pulp-ansible==0.2.0b9.dev0) (2.4.6)
Requirement already satisfied: bleach-whitelist<1,>=0.0.10 in /venv/lib/python3.6/site-packages (from galaxy-importer->pulp-ansible==0.2.0b9.dev0) (0.0.10)
Requirement already satisfied: attrs<20,>=18.2.0 in /venv/lib/python3.6/site-packages (from galaxy-importer->pulp-ansible==0.2.0b9.dev0) (19.3.0)
Requirement already satisfied: bleach<4,>=3.1.0 in /venv/lib/python3.6/site-packages (from galaxy-importer->pulp-ansible==0.2.0b9.dev0) (3.1.0)
Requirement already satisfied: ansible-lint<5.0,>=4.1.0 in /venv/lib/python3.6/site-packages (from galaxy-importer->pulp-ansible==0.2.0b9.dev0) (4.2.0)
Requirement already satisfied: markdown<4,>=3.1.1 in /venv/lib/python3.6/site-packages (from galaxy-importer->pulp-ansible==0.2.0b9.dev0) (3.1.1)
Requirement already satisfied: ansible in /venv/lib/python3.6/site-packages (from galaxy-importer->pulp-ansible==0.2.0b9.dev0) (2.9.4)
Requirement already satisfied: toml<=0.10.0 in /venv/lib/python3.6/site-packages (from dynaconf<2.3,>=2.2->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.10.0)
Requirement already satisfied: python-box<4.0.0 in /venv/lib/python3.6/site-packages (from dynaconf<2.3,>=2.2->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.4.6)
Requirement already satisfied: python-dotenv<=0.10.3 in /venv/lib/python3.6/site-packages (from dynaconf<2.3,>=2.2->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.10.3)
Requirement already satisfied: click<=7.0 in /venv/lib/python3.6/site-packages (from dynaconf<2.3,>=2.2->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (7.0)
Requirement already satisfied: chardet<4.0,>=2.0 in /venv/lib/python3.6/site-packages (from aiohttp->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.0.4)
Requirement already satisfied: typing-extensions>=3.6.5; python_version < "3.7" in /venv/lib/python3.6/site-packages (from aiohttp->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.7.4.1)
Requirement already satisfied: idna-ssl>=1.0; python_version < "3.7" in /venv/lib/python3.6/site-packages (from aiohttp->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.1.0)
Requirement already satisfied: async-timeout<4.0,>=3.0 in /venv/lib/python3.6/site-packages (from aiohttp->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.0.1)
Requirement already satisfied: multidict<5.0,>=4.5 in /venv/lib/python3.6/site-packages (from aiohttp->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (4.7.4)
Requirement already satisfied: yarl<2.0,>=1.0 in /venv/lib/python3.6/site-packages (from aiohttp->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.4.2)
Requirement already satisfied: uritemplate>=3.0.0 in /venv/lib/python3.6/site-packages (from drf-yasg~=1.17.0->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (3.0.1)
Requirement already satisfied: ruamel.yaml>=0.15.34 in /venv/lib/python3.6/site-packages (from drf-yasg~=1.17.0->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.16.7)
Requirement already satisfied: inflection>=0.3.1 in /venv/lib/python3.6/site-packages (from drf-yasg~=1.17.0->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.3.1)
Requirement already satisfied: coreschema>=0.0.4 in /venv/lib/python3.6/site-packages (from drf-yasg~=1.17.0->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.0.4)
Requirement already satisfied: pytz in /venv/lib/python3.6/site-packages (from Django~=2.2.3->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2019.3)
Requirement already satisfied: sqlparse in /venv/lib/python3.6/site-packages (from Django~=2.2.3->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.3.0)
Requirement already satisfied: requests in /venv/lib/python3.6/site-packages (from coreapi~=2.3.3->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.22.0)
Requirement already satisfied: itypes in /venv/lib/python3.6/site-packages (from coreapi~=2.3.3->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.1.0)
Requirement already satisfied: webencodings in /venv/lib/python3.6/site-packages (from bleach<4,>=3.1.0->galaxy-importer->pulp-ansible==0.2.0b9.dev0) (0.5.1)
Requirement already satisfied: jinja2 in /venv/lib/python3.6/site-packages (from ansible->galaxy-importer->pulp-ansible==0.2.0b9.dev0) (2.11.1)
Requirement already satisfied: cryptography in /venv/lib/python3.6/site-packages (from ansible->galaxy-importer->pulp-ansible==0.2.0b9.dev0) (2.8)
Requirement already satisfied: idna>=2.0 in /venv/lib/python3.6/site-packages (from idna-ssl>=1.0; python_version < "3.7"->aiohttp->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2.8)
Requirement already satisfied: ruamel.yaml.clib>=0.1.2; platform_python_implementation == "CPython" and python_version < "3.8" in /venv/lib/python3.6/site-packages (from ruamel.yaml>=0.15.34->drf-yasg~=1.17.0->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (0.2.0)
Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /venv/lib/python3.6/site-packages (from requests->coreapi~=2.3.3->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (1.25.8)
Requirement already satisfied: certifi>=2017.4.17 in /venv/lib/python3.6/site-packages (from requests->coreapi~=2.3.3->pulpcore>=3.0.<3.2->pulp-ansible==0.2.0b9.dev0) (2019.11.28)
Requirement already satisfied: MarkupSafe>=0.23 in /venv/lib/python3.6/site-packages (from jinja2->ansible->galaxy-importer->pulp-ansible==0.2.0b9.dev0) (1.1.1)
Requirement already satisfied: cffi!=1.11.3,>=1.8 in /venv/lib/python3.6/site-packages (from cryptography->ansible->galaxy-importer->pulp-ansible==0.2.0b9.dev0) (1.13.2)
Requirement already satisfied: pycparser in /venv/lib/python3.6/site-packages (from cffi!=1.11.3,>=1.8->cryptography->ansible->galaxy-importer->pulp-ansible==0.2.0b9.dev0) (2.19)
Installing collected packages: pulp-ansible
Attempting uninstall: pulp-ansible
Found existing installation: pulp-ansible 0.2.0b9.dev0
Uninstalling pulp-ansible-0.2.0b9.dev0:
Successfully uninstalled pulp-ansible-0.2.0b9.dev0
Running setup.py develop for pulp-ansible
Successfully installed pulp-ansible
[debug]: Waiting for port tcp://postgres:5432
[debug]: Waiting for port tcp://redis:6379
Operations to perform:
Apply all migrations: admin, ansible, auth, contenttypes, core, sessions
Running migrations:
Applying core.0013_repository_pulp_type...Traceback (most recent call last):
File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.NotNullViolation: column "pulp_type" contains null values
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/venv/bin/django-admin", line 8, in <module>
sys.exit(execute_from_command_line())
File "/venv/lib64/python3.6/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
utility.execute()
File "/venv/lib64/python3.6/site-packages/django/core/management/__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 323, in run_from_argv
self.execute(*args, **cmd_options)
File "/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 364, in execute
output = self.handle(*args, **options)
File "/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped
res = handle_func(*args, **kwargs)
File "/venv/lib64/python3.6/site-packages/django/core/management/commands/migrate.py", line 234, in handle
fake_initial=fake_initial,
File "/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 245, in apply_migration
state = migration.apply(state, schema_editor)
File "/venv/lib64/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/venv/lib64/python3.6/site-packages/django/db/migrations/operations/fields.py", line 112, in database_forwards
field,
File "/venv/lib64/python3.6/site-packages/django/db/backends/base/schema.py", line 447, in add_field
self.execute(sql, params)
File "/venv/lib64/python3.6/site-packages/django/db/backends/base/schema.py", line 137, in execute
cursor.execute(sql, params)
File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 99, in execute
return super().execute(sql, params)
File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/venv/lib64/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.IntegrityError: column "pulp_type" contains null values
make: *** [Makefile:51: docker/run-migrations] Error 1
@alikins
Copy link
Author

alikins commented Feb 3, 2020

The schema of my pulp_repository at the moment:

pulp@localhost:pulp> \d core_repository                                                                                                                                                                             
+-------------------+--------------------------+-------------+
| Column            | Type                     | Modifiers   |
|-------------------+--------------------------+-------------|
| pulp_id           | uuid                     |  not null   |
| pulp_created      | timestamp with time zone |  not null   |
| pulp_last_updated | timestamp with time zone |             |
| name              | character varying(255)   |  not null   |
| description       | text                     |             |
| last_version      | integer                  |  not null   |
| plugin_managed    | boolean                  |  not null   |
+-------------------+--------------------------+-------------+
Indexes:
    "core_repository_pkey" PRIMARY KEY, btree (pulp_id)
    "core_repository_name_key" UNIQUE CONSTRAINT, btree (name)
    "core_repository_name_d6094875_like" btree (name varchar_pattern_ops)
Check constraints:
    "core_repository_last_version_check" CHECK (last_version >= 0)
Referenced by:
    TABLE "core_repositoryversion" CONSTRAINT "core_repositoryversi_repository_id_3d4d8cee_fk_core_repo" FOREIGN KEY (repository_id) REFERENCES core_repository(pulp_id) DEFERRABLE INITIALLY DEFERRED
    TABLE "core_repositorycontent" CONSTRAINT "core_repositoryconte_repository_id_1946e61b_fk_core_repo" FOREIGN KEY (repository_id) REFERENCES core_repository(pulp_id) DEFERRABLE INITIALLY DEFERRED
    TABLE "ansible_ansibledistribution" CONSTRAINT "ansible_ansibledistr_repository_id_1795ee0a_fk_core_repo" FOREIGN KEY (repository_id) REFERENCES core_repository(pulp_id) DEFERRABLE INITIALLY DEFERRED

@alikins
Copy link
Author

alikins commented Feb 3, 2020

pulp@localhost:pulp> \d core_filesystemexporter                                                                                                                                                                     
+-------------------+--------------------------+-------------+
| Column            | Type                     | Modifiers   |
|-------------------+--------------------------+-------------|
| pulp_id           | uuid                     |  not null   |
| pulp_created      | timestamp with time zone |  not null   |
| pulp_last_updated | timestamp with time zone |             |
| pulp_type         | text                     |  not null   |
| name              | character varying(255)   |  not null   |
| path              | text                     |  not null   |
+-------------------+--------------------------+-------------+
Indexes:
    "core_filesystemexporter_pkey" PRIMARY KEY, btree (pulp_id)
    "core_filesystemexporter_name_key" UNIQUE CONSTRAINT, btree (name)
    "core_filesystemexporter_name_8e1cc472_like" btree (name varchar_pattern_ops)

Time: 0.048s
pulp@localhost:pulp> select * from core_filesystemexporter;                                                                                                                                                         
+-----------+----------------+---------------------+-------------+--------+--------+
| pulp_id   | pulp_created   | pulp_last_updated   | pulp_type   | name   | path   |
|-----------+----------------+---------------------+-------------+--------+--------|
+-----------+----------------+---------------------+-------------+--------+--------+
SELECT 0
Time: 0.036s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment