<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 href="mailto:bli111@bloomberg.net">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><div style="white-space:pre-wrap;font-size:small;font-family:"Courier New",Courier,"BB.FixedWidth"">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></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><div style="white-space:pre-wrap;font-size:small;font-family:"Courier New",Courier,"BB.FixedWidth""><div><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> 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></div></div></div>_______________________________________________<br>
Pulp-list mailing list<br>
<a href="mailto:Pulp-list@redhat.com" target="_blank">Pulp-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/pulp-list" rel="noreferrer" target="_blank">https://www.redhat.com/mailman/listinfo/pulp-list</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Grant Gainey</div><div>Principal Software Engineer, Red Hat System Management Engineering</div></div></div></div></div></div>