[Pulp-list] Pulp-list Digest, Vol 126, Issue 47

Bin Li (BLOOMBERG/ 120 PARK) bli111 at bloomberg.net
Fri May 29 03:46:49 UTC 2020


Below is output of querying the package through api

        {
            "pulp_href": "/pulp/api/v3/content/rpm/packages/ed31233e-2745-406b-8e5d-17e616725040/",
            "name": "admin-python-36",
            "version": "3.6.5",
            "release": "2.el7",
            "location_href": "packages/admin-python-36-3.6.5-2.el7.x86_64.rpm"
        },


From: pulp-list at redhat.com At: 05/28/20 23:26:41To:  pulp-list at redhat.com
Subject: Pulp-list Digest, Vol 126, Issue 47

Send Pulp-list mailing list submissions to
 pulp-list at redhat.com

To subscribe or unsubscribe via the World Wide Web, visit
     https://www.redhat.com/mailman/listinfo/pulp-list
or, via email, send a message with subject or body 'help' to
 pulp-list-request at redhat.com

You can reach the person managing the list at
 pulp-list-owner at redhat.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pulp-list digest..."


Today's Topics:

   1. Re: pulp 3.3 migration error (Dennis Kliban)
   2. Re: pulp 3.3 migration error (Bin Li (BLOOMBERG/ 120 PARK))


----------------------------------------------------------------------

Message: 1
Date: Thu, 28 May 2020 17:12:40 -0400
From: Dennis Kliban <dkliban at redhat.com>
To: Bin Li <bli111 at bloomberg.net>
Cc: pulp-list <pulp-list at redhat.com>
Subject: Re: [Pulp-list] pulp 3.3 migration error
Message-ID:
       <CAPmNiup4+3pAV9eZW5DO_Skyuu2PGLOcTTkkt=bt5KaSK+pTqA at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Are you upgrading to pulp-rpm 3.3.2?

On Thu, May 28, 2020 at 5:08 PM Bin Li (BLOOMBERG/ 120 PARK) <
bli111 at bloomberg.net> wrote:

> Hi All,
> Getting a new error when migrate from 3.2 to 3.3. Please advise if this
> can be fixed manually.
>
> TASK [pulp_database : Run database migrations]
> 
********************************************************************************
****************************************
> fatal: [pulpp-ob-581]: FAILED! => {"changed": true, "cmd":
> ["/opt/utils/venv/pulp/3.7.3/bin/django-admin", "migrate", "--no-input"],
> "delta": "0:00:01.768909", "end": "2020-05-28 17:02:22.996242", "msg":
> "non-zero return code", "rc": 1, "start": "2020-05-28 17:02:21.227333",
> "stderr": "Traceback (most recent call last):\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)\npsycopg2.errors.NotNullViolation: column
> \"last_sync_revision_number\" contains null values\n\n\nThe above exception
> was the direct cause of the following exception:\n\nTraceback (most recent
> call last):\n File \"/opt/utils/venv/pulp/3.7.3/bin/django-admin\", line 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 execute_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_command(subcommand).run_from_argv(self.argv)\n File
> 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/base.py\",
> line 323, in run_from_argv\n self.execute(*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, **options)\n File
> 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/management/base.py\",
> line 83, in wrapped\n res = handle_func(*args, **kwargs)\n File
> 
\"/opt/utils/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/lib64/python3.7/site-packages/django/db/migrations/executor.py\",
> line 117, in migrate\n state = 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/executor.py\",
> line 147, in _migrate_all_forwards\n state = self.apply_migration(state,
> migration, 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/site-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/pulp/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, params)\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 execute\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.py\",
> line 76, in _execute_with_wrappers\n return executor(sql, params, many,
> context)\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)\n File
> 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/utils.py\",
> line 89, in __exit__\n raise 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_revision_number\" contains null values", "stderr_lines":
> ["Traceback (most recent call last):", " File
> 
\"/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.NotNullViolation: column \"last_sync_revision_number\"
> contains null values", "", "", "The above exception 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/django/core/management/__init__.py\",
> line 375, in execute", "
> self.fetch_command(subcommand).run_from_argv(self.argv)", " File
> 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/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/core/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/base.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\",
> line 234, in handle", " fake_initial=fake_initial,", " File
> 
\"/opt/utils/venv/pulp/3.7.3/lib64/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_initial)", " 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/lib64/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/lib64/python3.7/site-packages/django/db/migrations/migration.py\",
> line 124, in apply", " operation.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/fields.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-packages/django/db/backends/base/schema.py\",
> line 137, in execute", " cursor.execute(sql, params)", " File
> 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backends/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-packages/django/db/backends/utils.py\",
> line 76, in _execute_with_wrappers", " return executor(sql, params, many,
> context)", " File
> 
\"/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)", " 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/backends/utils.py\",
> line 84, in _execute", " return self.cursor.execute(sql, params)",
> "django.db.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 rpm.0005_optimize_sync...", "stdout_lines":
> ["Operations to perform:", " Apply all migrations: admin, auth,
> contenttypes, core, file, rpm, sessions", "Running migrations:", " Applying
> rpm.0005_optimize_sync..."]}
> _______________________________________________
> Pulp-list mailing list
> Pulp-list at redhat.com
> https://www.redhat.com/mailman/listinfo/pulp-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
<https://www.redhat.com/archives/pulp-list/attachments/20200528/b72a1bd7/atta
chment.html>

------------------------------

Message: 2
Date: Fri, 29 May 2020 03:26:21 -0000
From: "Bin Li (BLOOMBERG/ 120 PARK)" <bli111 at bloomberg.net>
To: dkliban at redhat.com
Cc: pulp-list at redhat.com
Subject: Re: [Pulp-list] pulp 3.3 migration error
Message-ID: <5ED080DD013F001C003900BF_0_6156 at msllnjpmsgsv06>
Content-Type: text/plain; charset="utf-8"

Yes, we are trying to upgrade to 3.3.2.

From: dkliban at redhat.com At: 05/28/20 17:13:05To:  Bin Li (BLOOMBERG/ 120 PARK 
) 
Cc:  pulp-list at redhat.com
Subject: Re: [Pulp-list] pulp 3.3 migration error

Are you upgrading to pulp-rpm 3.3.2? 

On Thu, May 28, 2020 at 5:08 PM Bin Li (BLOOMBERG/ 120 PARK) 
<bli111 at bloomberg.net> wrote:

Hi All,Getting a new error when migrate from 3.2 to 3.3. Please advise if this 
can be fixed manually.

TASK [pulp_database : Run database migrations] 
********************************************************************************
****************************************
fatal: [pulpp-ob-581]: FAILED! => {"changed": true, "cmd": 
["/opt/utils/venv/pulp/3.7.3/bin/django-admin", "migrate", "--no-input"], 
"delta": "0:00:01.768909", "end": "2020-05-28 17:02:22.996242", "msg": 
"non-zero return code", "rc": 1, "start": "2020-05-28 17:02:21.227333", 
"stderr": "Traceback (most recent call last):\n  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backen
ds/utils.py\", line 84, in _execute\n    return self.cursor.execute(sql, 
params)\npsycopg2.errors.NotNullViolation: column \"last_sync_revision_number\" 
contains null values\n\n\nThe above exception was the direct cause of the 
following exception:\n\nTraceback (most recent call last):\n  File 
\"/opt/utils/venv/pulp/3.7.3/bin/django-admin\", line 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/mana
gement/__init__.py\", line 381, in execute_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_command(subcommand).run_from_argv(self.argv)\n  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/mana
gement/base.py\", line 323, in run_from_argv\n    self.execute(*args, 
**cmd_options)\n  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/mana
gement/base.py\", line 364, in execute\n    output = self.handle(*args, 
**options)\n  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/mana
gement/base.py\", line 83, in wrapped\n    res = handle_func(*args, **kwargs)\n 
 File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/mana
gement/commands/migrate.py\", line 234, in handle\n    
fake_initial=fake_initial,\n  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrat
ions/executor.py\", line 117, in migrate\n    state = 
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/migrat
ions/executor.py\", line 147, in _migrate_all_forwards\n    state = 
self.apply_migration(state, migration, 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/site-packages/django/db/migrat
ions/migration.py\", line 124, in apply\n    
operation.database_forwards(self.app_label, schema_editor, old_state, 
project_state)\n  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrat
ions/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/ba
se/schema.py\", line 447, in add_field\n    self.execute(sql, params)\n  F
 ile 
\"/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 execute\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/backen
ds/utils.py\", line 76, in _execute_with_wrappers\n    return executor(sql, 
params, many, context)\n  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backen
ds/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    raise 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/backen
ds/utils.py\", line 84, in _exec
 ute\n    return self.cursor.execute(sql, 
params)\ndjango.db.utils.IntegrityError: column \"last_sync_revision_number\" 
contains null values", "stderr_lines": ["Traceback (most recent call last):", " 
 File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backen
ds/utils.py\", line 84, in _execute", "    return self.cursor.execute(sql, 
params)", "psycopg2.errors.NotNullViolation: column 
\"last_sync_revision_number\" contains null values", "", "", "The above 
exception 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/mana
gement/__init__.py\", line 381, in execute_from_command_line", "    
utility.execute()", "  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/mana
gement/__init__.py\", line 375, in ex
 ecute", "    self.fetch_command(subcommand).run_from_argv(self.argv)", "  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/core/managemen
t/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/core/mana
gement/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/mana
gement/base.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/mana
gement/commands/migrate.py\", line 234, in handle", "    
fake_initial=fake_initial,", "  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrat
ions/executor.py\", line 117, in migrate", "    state = 
self._migrate_all_forwards(state, plan, full_plan, fake=fake, 
fake_initial=fake_initial)", "  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/lib64/python3.7/site-packages/django/db/migrat
ions/executor.py\", line 245, in apply_migration", "    state = 
migration.apply(state, schema_editor)", "  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/migrat
ions/migration.py\", line 124, in apply", "    
operation.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/migrat
ions/operations/fields.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, params)", "  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backen
ds/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-packages/django/db/backen
ds/utils.py\", line 76, in _execute_with_wrappers", "    return executor(sql, 
params, many, context)", "  File 
\"/opt/utils/venv/pulp/3.7.3/lib64/python3.7/site-packages/django/db/backen
ds/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/backen
ds/utils.py\", line 84, in _execute", "    return self.cursor.execut
 e(sql, params)", "django.db.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 
rpm.0005_optimize_sync...", "stdout_lines": ["Operations to perform:", "  Apply 
all migrations: admin, auth, contenttypes, core, file, rpm, sessions", "Running 
migrations:", "  Applying 
rpm.0005_optimize_sync..."]}_______________________________________________
Pulp-list mailing list
Pulp-list at redhat.com
https://www.redhat.com/mailman/listinfo/pulp-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
<https://www.redhat.com/archives/pulp-list/attachments/20200529/28d1d08f/atta
chment.html>

------------------------------

_______________________________________________
Pulp-list mailing list
Pulp-list at redhat.com
https://www.redhat.com/mailman/listinfo/pulp-list

End of Pulp-list Digest, Vol 126, Issue 47
******************************************


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/pulp-list/attachments/20200529/0ea16b54/attachment.htm>


More information about the Pulp-list mailing list