<html><head><title></title></head><body><!-- rte-version 0.2 9947551637294008b77bce25eb683dac --><div class="rte-style-maintainer rte-pre-wrap" data-color="global-default" bbg-color="default" data-bb-font-size="medium"bbg-font-size="medium" style="white-space: pre-wrap; font-size: small; font-family: "Courier New", Courier, "BB.FixedWidth";"style="white-space: pre-wrap; font-size: small; font-family: "Courier New", Courier, "BB.FixedWidth"; color: rgb(0, 0, 0);">Is there a workaround or I cannot upgrade before this is fixed?<div><br></div><div>Thanks<br><br><div class="rte-style-maintainer" data-color="global-default"bbg-color="default" data-bb-font-size="medium" bbg-font-size="medium" style="font-size: small; font-family: "Courier New", Courier, "BB.FixedWidth";"style="font-size: small; font-family: "Courier New", Courier, "BB.FixedWidth"; color: rgb(0, 0, 0);"><div><div class="bbg-rte-fold-content" data-header="From: dkliban@redhat.com At: 05/04/20 15:52:16" data-digest="From: dkliban@redhat.com At: 05/04/20 15:52:16" style=""><div class="bbg-rte-fold-summary">From: dkliban@redhat.com At: 05/04/20 15:52:16</div>To: <a spellcheck="false" bbg-destination="mailto:bli111@bloomberg.net" href="mailto:bli111@bloomberg.net"> Bin Li (BLOOMBERG/ 120 PARK ) </a><br>Cc: <a spellcheck="false"bbg-destination="mailto:pulp-list@redhat.com" href="mailto:pulp-list@redhat.com"> pulp-list@redhat.com</a><br>Subject: Re: [Pulp-list] pulp 3.3 db migration</div><br></div><div class="rte-internet-block-wrapper" style="background: white; color: black; font-family: Arial, "BB.Proportional"; font-size: small; white-space: normal;"><div class="rte-internet-block"><blockquote><div dir="ltr"><div>Please file a bug.</div><div><br></div><div>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. </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, May 4, 2020 at 3:09 PM Bin Li (BLOOMBERG/ 120 PARK) <<a spellcheck="false"bbg-destination="mailto:rte:bind" class="" href="mailto:bli111@bloomberg.net" data-destination="mailto:rte:bind">bli111@bloomberg.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="font-size: small; font-family: "Courier New", Courier, "BB.FixedWidth"; white-space: pre-wrap;"><div>Hi,</div><div><br></div><div>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?</div><div><br></div><div>Thanks</div><div><br></div><div><br></div>TASK [pulp-database : Run database migrations] **********************************************<div>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..."]}</div><div><br></div></div>_______________________________________________<br>Pulp-list mailing list<br><a spellcheck="false"bbg-destination="mailto:rte:bind" class="" href="mailto:Pulp-list@redhat.com" data-destination="mailto:rte:bind">Pulp-list@redhat.com</a><br><a spellcheck="false"bbg-destination="rte:bind" class="" href="https://www.redhat.com/mailman/listinfo/pulp-list"data-destination="rte:bind">https://www.redhat.com/mailman/listinfo/pulp-list</a></blockquote></div></blockquote><br></div></div></div></div></div></body></html>