<html><head><title></title></head><body><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);">Thanks. Now I am getting a different errors.<div><br></div><div> Applying rpm.0010_revision_null_redo... OK</div><div> Applying rpm.0011_rpmremote_sles_auth_token... OK</div><div> Applying rpm.0012_remove_pkg_group_env_cat_related_pkgs... OK</div><div> Applying rpm.0013_RAW_rpm_evr_extension...Traceback (most recent call last):</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 82, in _execute</div><div> return self.cursor.execute(sql)</div><div>psycopg2.errors.DuplicateFunction: function "pulp_evr_trigger" already exists with same argument types</div><div><br></div><div><br></div><div>The above exception was the direct cause of the following exception:</div><div><br></div><div>Traceback (most recent call last):</div><div> File "/opt/utils/venv/pulp/3.7.3/bin/django-admin", line 8, in <module></div><div> sys.exit(execute_from_command_line())</div><div> 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</div><div><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: ggainey@redhat.com At: 10/30/20 21:00:04" data-digest="From: ggainey@redhat.com At: 10/30/20 21:00:04" style=""><div class="bbg-rte-fold-summary">From: ggainey@redhat.com At: 10/30/20 21:00:04</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] 3.7.3 errors when reset external postgres db</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 dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Oct 30, 2020 at 8:31 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;">Hi,<div>I am testing 3.7.3 release with external postgres db. I want to reset the database first. After I drop all database tables and got the following errors when I run "django-admin migrate --noinput" </div><div>Please advice.</div><div> <div>File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 82, in _execute<div> return self.cursor.execute(sql)</div><div>psycopg2.errors.DuplicateObject: type "pulp_evr_array_item" already exists</div></div></div></div></blockquote><div><br></div><div>pulp_evr_array_item is a database <b>type</b>, installed/created by pulp_rpm/app/migrations/0013_RAW_rpm_evr_extension.py. If you're dropping all the tables and running the migrations, you'll also want to </div><div><br></div><div>DROP TYPE pulp_evr_array_item;</div><div>DROP TYPE pulp_evr_t;</div><div><br></div><div>See if that helps!</div><div><br></div><div>G</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><br></div><div><br></div><div>The above exception was the direct cause of the following exception:</div><div><br></div><div>Traceback (most recent call last):</div><div> File "/opt/utils/venv/pulp/3.7.3/bin/django-admin", line 8, in <module></div><div> sys.exit(execute_from_command_line())</div><div> 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</div><div> utility.execute()</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/__init__.py", line 375, in execute</div><div> self.fetch_command(subcommand).run_from_argv(self.argv)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/base.py", line 323, in run_from_argv</div><div> self.execute(*args, **cmd_options)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/base.py", line 364, in execute</div><div> output = self.handle(*args, **options)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/base.py", line 83, in wrapped</div><div> res = handle_func(*args, **kwargs)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/commands/migrate.py", line 234, in handle</div><div> fake_initial=fake_initial,</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/executor.py", line 117, in migrate</div><div> state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards</div><div> state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/executor.py", line 245, in apply_migration</div><div> state = migration.apply(state, schema_editor)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/migration.py", line 124, in apply</div><div> operation.database_forwards(self.app_label, schema_editor, old_state, project_state)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/operations/special.py", line 105, in database_forwards</div><div> self._run_sql(schema_editor, self.sql)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrations/operations/special.py", line 130, in _run_sql</div><div> schema_editor.execute(statement, params=None)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/base/schema.py", line 137, in execute</div><div> cursor.execute(sql, params)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 67, in execute</div><div> return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers</div><div> return executor(sql, params, many, context)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute</div><div> return self.cursor.execute(sql, params)</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/utils.py", line 89, in __exit__</div><div> raise dj_exc_value.with_traceback(traceback) from exc_value</div><div> File "/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/utils.py", line 82, in _execute</div><div> return self.cursor.execute(sql)</div><div>django.db.utils.ProgrammingError: type "pulp_evr_array_item" already exists</div><div><br></div><div><br></div><div>I am running</div><div>{</div><div> "versions": [</div><div> {</div><div> "component": "pulpcore",</div><div> "version": "3.7.3"</div><div> },</div><div> {</div><div> "component": "pulp_rpm",</div><div> "version": "3.7.0"</div><div> },</div><div> {</div><div> "component": "pulp_file",</div><div> "version": "1.3.0"</div><div> }</div><div><br></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><br><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div>Grant Gainey</div><div>Principal Software Engineer, Red Hat System Management Engineering</div></div></div></div></blockquote><br></div></div></div></div></div></body></html>