Opened 4 years ago
Closed 4 years ago
#33089 closed Cleanup/optimization (invalid)
Unable to run db migration
| Reported by: | Aprila Hijriyan | Owned by: | |
|---|---|---|---|
| Component: | Error reporting | Version: | 3.2 |
| Severity: | Normal | Keywords: | |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
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. :)
See TicketClosingReasons/UseSupportChannels for ways to get help. Trac is not a support channel.