[Django] #33089: Unable to run db migration
Django
------------------------------------------------+------------------------
Reporter: aprilahijriyan | Owner: (none)
Type: Cleanup/optimization | Status: new
Component: Error reporting | Version: 3.2
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
------------------------------------------------+------------------------
To be honest this previously worked fine, but I don't know why I can't run
the "makemigrations" command.
The error that appears in my terminal:
{{{
WARNING:apscheduler.scheduler:Error getting due jobs from job store
'default': relation "django_apscheduler_djangojob" does not exist
LINE 1: ..., "django_apscheduler_djangojob"."job_state" FROM "django_ap...
^
DEBUG:apscheduler.scheduler:Next wakeup is due at 2021-09-08
17:59:12.316528+07:00 (in 10.000000 seconds)
Traceback (most recent call last):
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/backends/utils.py", line
84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation "drf_superset_permission" does
not exist
LINE 1: SELECT (1) AS "a" FROM "drf_superset_permission" WHERE "drf_...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 22, in <module>
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/core/management/__init__.py",
line 419, in execute_from_command_line
utility.execute()
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/core/management/__init__.py",
line 395, in execute
django.setup()
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/__init__.py", line 24, in
setup
apps.populate(settings.INSTALLED_APPS)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/apps/registry.py", line 122,
in populate
app_config.ready()
File "/home/apriladev/Workspace/bankjateng-new/api/apps.py", line 44, in
ready
create_all_permissions()
File "/home/apriladev/Workspace/bankjateng-
new/drf_superset/core/helpers.py", line 74, in create_all_permissions
if not Permission.objects.filter(name=view).exists():
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/models/query.py", line 808,
in exists
return self.query.has_results(using=self.db)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/models/sql/query.py", line
552, in has_results
return compiler.has_results()
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/models/sql/compiler.py",
line 1145, in has_results
return bool(self.execute_sql(SINGLE))
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/models/sql/compiler.py",
line 1175, in execute_sql
cursor.execute(sql, params)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/backends/utils.py", line
98, in execute
return super().execute(sql, params)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/backends/utils.py", line
66, in execute
return self._execute_with_wrappers(sql, params, many=False,
executor=self._execute)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/backends/utils.py", line
75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/backends/utils.py", line
84, in _execute
return self.cursor.execute(sql, params)
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/utils.py", line 90, in
__exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/apriladev/.local/share/virtualenvs/bankjateng-new-
Hvy1TumD/lib/python3.8/site-packages/django/db/backends/utils.py", line
84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "drf_superset_permission" does
not exist
LINE 1: SELECT (1) AS "a" FROM "drf_superset_permission" WHERE "drf_...
}}}
I'm using a postgre database with docker images. As I explained earlier, I
can't run the "makemigrations" command.
So I took the initiative to pull back the image Docker (clean all the
image Docker & and volume).
Also I cleaned all files *.pyc, __pycache__, migrations.
Then I ran the command "python manage.py reset_db -c".
Still not working, anyone please help me. :)
--
Ticket URL: <https://code.djangoproject.com/ticket/33089>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
Reporter: aprilahijriyan | Owner: (none)
Type: | Status: closed
Cleanup/optimization |
Component: Error reporting | Version: 3.2
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
Changes (by Mariusz Felisiak):
* status: new => closed
* resolution: => invalid
Comment:
See TicketClosingReasons/UseSupportChannels for ways to get help. Trac is
not a support channel.
--
Ticket URL: <https://code.djangoproject.com/ticket/33089#comment:1>