Another user filed an issue about this problem[0]. [0] https://pulp.plan.io/issues/6662
On Mon, May 4, 2020 at 4:29 PM Dennis Kliban <[email protected]> wrote: > You could manually add null=True (keyword argument) to the definition of > the last_sync_revision_number here[0]. > > [0] > https://github.com/pulp/pulp_rpm/blob/3.3.0/pulp_rpm/app/migrations/0005_optimize_sync.py#L28 > > On Mon, May 4, 2020 at 4:19 PM Bin Li (BLOOMBERG/ 120 PARK) < > [email protected]> wrote: > >> Is there a workaround or I cannot upgrade before this is fixed? >> >> Thanks >> >> From: [email protected] At: 05/04/20 15:52:16 >> To: Bin Li (BLOOMBERG/ 120 PARK ) <[email protected]> >> Cc: [email protected] >> Subject: Re: [Pulp-list] pulp 3.3 db migration >> >> Please file a bug. >> >> This is a problem with a migration that adds the ability to track when an >> RPM repository can skip syncing from the remote repository because the >> metadata is the same as it was during the previous sync. The migration is >> failing to provide a default value for databases that are being upgraded. >> >> On Mon, May 4, 2020 at 3:09 PM Bin Li (BLOOMBERG/ 120 PARK) < >> [email protected]> wrote: >> >>> Hi, >>> >>> Keep getting this error from ansible_install to upgrade from 3.2 to 3.3. >>> What could cause this and how can we fix it? >>> >>> Thanks >>> >>> >>> TASK [pulp-database : Run database migrations] >>> ********************************************** >>> fatal: [pulp3-1]: FAILED! => {"changed": true, "cmd": >>> ["/opt/utils/venv/pulp/3.7.3/bin/django -admin", "migrate", "--no-input"], >>> "delta": "0:00:03.879347", "end": "2020-05-04 14:54:18.580 273", "msg": >>> "non-zero return code", "rc": 1, "start": "2020-05-04 14:54:14.700926", >>> "stderr" : "Traceback (most recent call last):\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/si >>> te-packages/django/db/backends/utils.py\", line 84, in _execute\n return >>> self.cursor.execu te(sql, params)\npsycopg2.errors.NotNullViolation: column >>> \"last_sync_revision_number\" conta ins null values\n\n\nThe above >>> exception was the direct cause of the following exception:\n\n Traceback >>> (most recent call last):\n File >>> \"/opt/utils/venv/pulp/3.7.3/bin/django-admin\", l ine 8, in <module>\n >>> sys.exit(execute_from_command_line())\n File \"/opt/utils/venv/pulp/ >>> 3.7.3/lib64/python3.7/site-packages/django/core/management/__init__.py\", >>> line 381, in execut e_from_command_line\n utility.execute()\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3 >>> .7/site-packages/django/core/management/__init__.py\", line 375, in >>> execute\n self.fetch_c ommand(subcommand).run_from_argv(self.argv)\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python >>> 3.7/site-packages/django/core/management/base.py\", line 323, in >>> run_from_argv\n self.exec ute(*args, **cmd_options)\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/ >>> django/core/management/base.py\", line 364, in execute\n output = >>> self.handle(*args, **opt ions)\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/manageme >>> nt/base.py\", line 83, in wrapped\n res = handle_func(*args, **kwargs)\n >>> File \"/opt/util >>> s/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/commands/migrate.py\", >>> line 234, in handle\n fake_initial=fake_initial,\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib >>> 64/python3.7/site-packages/django/db/migrations/executor.py\", line 117, in >>> migrate\n stat e = self._migrate_all_forwards(state, plan, full_plan, >>> fake=fake, fake_initial=fake_initial)\ n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/execu >>> tor.py\", line 147, in _migrate_all_forwards\n state = >>> self.apply_migration(state, migrati on, fake=fake, >>> fake_initial=fake_initial)\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3. >>> 7/site-packages/django/db/migrations/executor.py\", line 245, in >>> apply_migration\n state = migration.apply(state, schema_editor)\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/s >>> ite-packages/django/db/migrations/migration.py\", line 124, in apply\n >>> operation.database_ forwards(self.app_label, schema_editor, old_state, >>> project_state)\n File \"/opt/utils/venv/p >>> ulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/operations/fields.py\", >>> line 112 , in database_forwards\n field,\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site- >>> packages/django/db/backends/base/schema.py\", line 447, in add_field\n >>> self.execute(sql, p arams)\n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/ >>> base/schema.py\", line 137, in execute\n cursor.execute(sql, params)\n File >>> \"/opt/utils/ >>> venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py\", >>> line 67, in exec ute\n return self._execute_with_wrappers(sql, params, >>> many=False, executor=self._execute)\ n File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.p >>> y\", line 76, in _execute_with_wrappers\n return executor(sql, params, >>> many, context)\n F ile >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py\", >>> line 84, in _execute\n return self.cursor.execute(sql, params)\n File >>> \"/opt/utils/venv/ >>> pulp/3.7.3/lib64/python3.7/site-packages/django/db/utils.py\", line 89, in >>> __exit__\n rais e dj_exc_value.with_traceback(traceback) from exc_value\n >>> File \"/opt/utils/venv/pulp/3.7.3/ >>> lib64/python3.7/site-packages/django/db/backends/utils.py\", line 84, in >>> _execute\n return self.cursor.execute(sql, >>> params)\ndjango.db.utils.IntegrityError: column \"last_sync_revisio >>> n_number\" contains null values", "stderr_lines": ["Traceback (most recent >>> call last):", " F ile >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py\", >>> line 84, in _execute", " return self.cursor.execute(sql, params)", >>> "psycopg2.errors.NotNu llViolation: column \"last_sync_revision_number\" >>> contains null values", "", "", "The above e xception was the direct cause >>> of the following exception:", "", "Traceback (most recent call last):", " >>> File \"/opt/utils/venv/pulp/3.7.3/bin/django-admin\", line 8, in <module>", >>> " sys.exit(execute_from_command_line())", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/ >>> site-packages/django/core/management/__init__.py\", line 381, in >>> execute_from_command_line", " utility.execute()", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/d >>> jango/core/management/__init__.py\", line 375, in execute", " >>> self.fetch_command(subcomman d).run_from_argv(self.argv)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packa >>> ges/django/core/management/base.py\", line 323, in run_from_argv", " >>> self.execute(*args, * *cmd_options)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/cor >>> e/management/base.py\", line 364, in execute", " output = >>> self.handle(*args, **options)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/bas >>> e.py\", line 83, in wrapped", " res = handle_func(*args, **kwargs)", " File >>> \"/opt/utils/ >>> venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/commands/migrate.py\", >>> l ine 234, in handle", " fake_initial=fake_initial,", " File >>> \"/opt/utils/venv/pulp/3.7.3/l >>> ib64/python3.7/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_initi al)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/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 \"/opt/utils/venv/pulp/3.7.3/lib6 >>> 4/python3.7/site-packages/django/db/migrations/executor.py\", line 245, in >>> apply_migration", " state = migration.apply(state, schema_editor)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib >>> 64/python3.7/site-packages/django/db/migrations/migration.py\", line 124, >>> in apply", " ope ration.database_forwards(self.app_label, schema_editor, >>> old_state, project_state)", " File \ >>> "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/operations/fie >>> lds.py\", line 112, in database_forwards", " field,", " File >>> \"/opt/utils/venv/pulp/3.7.3 >>> /lib64/python3.7/site-packages/django/db/backends/base/schema.py\", line >>> 447, in add_field", " self.execute(sql, params)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-pa >>> ckages/django/db/backends/base/schema.py\", line 137, in execute", " >>> cursor.execute(sql, p arams)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backend >>> s/utils.py\", line 67, in execute", " return >>> self._execute_with_wrappers(sql, params, many =False, >>> executor=self._execute)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-p >>> ackages/django/db/backends/utils.py\", line 76, in _execute_with_wrappers", >>> " return execu tor(sql, params, many, context)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-p >>> ackages/django/db/backends/utils.py\", line 84, in _execute", " return >>> self.cursor.execute (sql, params)", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/ >>> utils.py\", line 89, in __exit__", " raise >>> dj_exc_value.with_traceback(traceback) from exc _value", " File >>> \"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backend >>> s/utils.py\", line 84, in _execute", " return self.cursor.execute(sql, >>> params)", "django.d b.utils.IntegrityError: column >>> \"last_sync_revision_number\" contains null values"], "stdout" : >>> "Operations to perform:\n Apply all migrations: admin, auth, contenttypes, >>> core, file, rpm , sessions\nRunning migrations:\n Applying >>> core.0023_change_exporter_models... OK\n Applyin g >>> core.0024_use_local_storage_for_uploads... OK\n Applying >>> core.0025_task_parent_task... OK\ n Applying core.0026_task_group... OK\n >>> Applying core.0027_export_backend... OK\n Applying >>> core.0028_import_importer_pulpimporter_pulpimporterrepository... OK\n >>> Applying file.0006_de lete_filefilesystemexporter... OK\n Applying >>> file.0007_filefilesystemexporter... OK\n Apply ing >>> rpm.0004_add_metadata_signing_service_fk... OK\n Applying >>> rpm.0005_optimize_sync...", "s tdout_lines": ["Operations to perform:", " >>> Apply all migrations: admin, auth, contenttypes, core, file, rpm, >>> sessions", "Running migrations:", " Applying core.0023_change_exporter_mode >>> ls... OK", " Applying core.0024_use_local_storage_for_uploads... OK", " >>> Applying core.0025_ task_parent_task... OK", " Applying >>> core.0026_task_group... OK", " Applying core.0027_expor t_backend... OK", " >>> Applying core.0028_import_importer_pulpimporter_pulpimporterrepository.. . >>> OK", " Applying file.0006_delete_filefilesystemexporter... OK", " Applying >>> file.0007_file filesystemexporter... OK", " Applying >>> rpm.0004_add_metadata_signing_service_fk... OK", " Ap plying >>> rpm.0005_optimize_sync..."]} >>> >>> _______________________________________________ >>> Pulp-list mailing list >>> [email protected] >>> https://www.redhat.com/mailman/listinfo/pulp-list >> >> >>
_______________________________________________ Pulp-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/pulp-list
