#32968: Migration errors from SQLite to Postgres
-------------------------------------+-------------------------------------
Reporter: Song Yang | Owner: nobody
Type: Bug | Status: closed
Component: Migrations | Version: 3.2
Severity: Normal | Resolution: invalid
Keywords: postgres, sqlite, | Triage Stage:
programmingerror, migration | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by Song Yang:
Old description:
> To put my app on Heroku, I am changing my database from SQLite to
> Postgres at the end of my project. Everything works fine locally on
> SQLite. But during `python manage.py migrate --run-syncdb`, I get a
> `ProgrammingError`. I was planning on loading the dumped json later in
> Postgres.
>
> I created a branch on my repo for you to reproduce this bug. The branch
> is `postgres` and the link is https://github.com/XsongyangX/uml-fragment-
> labeling/tree/postgres
>
> Here is the log.
>
> {{{
>
> $ py manage.py migrate --run-syncdb
> Traceback (most recent call last):
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\ba
> ckends\utils.py", line 84, in _execute
> return self.cursor.execute(sql, params)
> psycopg2.errors.UndefinedTable: relation "labeling_model" does not exist
> LINE 1: ...del"."classes", "labeling_model"."relations" FROM
> "labeling_...
> ^
>
> The above exception was the direct cause of the following exception:
>
> Traceback (most recent call last):
> File "C:\Users\Song\Documents\UDEM\master thesis\uml
> data\database\umllabels\m
> anage.py", line 22, in <module>
> main()
> File "C:\Users\Song\Documents\UDEM\master thesis\uml
> data\database\umllabels\m
> anage.py", line 18, in main
> execute_from_command_line(sys.argv)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> management\__init__.py", line 419, in execute_from_command_line
> utility.execute()
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> management\__init__.py", line 413, in execute
> self.fetch_command(subcommand).run_from_argv(self.argv)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> management\base.py", line 354, in run_from_argv
> self.execute(*args, **cmd_options)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> management\base.py", line 398, in execute
> output = self.handle(*args, **options)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> management\base.py", line 89, in wrapped
> res = handle_func(*args, **kwargs)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> management\commands\migrate.py", line 75, in handle
> self.check(databases=[database])
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> management\base.py", line 419, in check
> all_issues = checks.run_checks(
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> checks\registry.py", line 76, in run_checks
> new_errors = check(app_configs=app_configs, databases=databases)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> checks\urls.py", line 13, in check_url_config
> return check_resolver(resolver)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\core\
> checks\urls.py", line 23, in check_resolver
> return check_method()
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\urls\
> resolvers.py", line 412, in check
> for pattern in self.url_patterns:
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\utils
> \functional.py", line 48, in __get__
> res = instance.__dict__[self.name] = self.func(instance)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\urls\
> resolvers.py", line 598, in url_patterns
> patterns = getattr(self.urlconf_module, "urlpatterns",
> self.urlconf_module)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\utils
> \functional.py", line 48, in __get__
> res = instance.__dict__[self.name] = self.func(instance)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\urls\
> resolvers.py", line 591, in urlconf_module
> return import_module(self.urlconf_name)
> File "C:\Program Files\Python39\lib\importlib\__init__.py", line 127,
> in impor
> t_module
> return _bootstrap._gcd_import(name[level:], package, level)
> File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
> File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
> File "<frozen importlib._bootstrap>", line 986, in
> _find_and_load_unlocked
> File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
> File "<frozen importlib._bootstrap_external>", line 790, in exec_module
> File "<frozen importlib._bootstrap>", line 228, in
> _call_with_frames_removed
> File "C:\Users\Song\Documents\UDEM\master thesis\uml
> data\database\umllabels\u
> mllabels\urls.py", line 24, in <module>
> path('labeling/', include(('labeling.urls', 'labeling'),
> namespace="labeling
> ")),
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\urls\
> conf.py", line 34, in include
> urlconf_module = import_module(urlconf_module)
> File "C:\Program Files\Python39\lib\importlib\__init__.py", line 127,
> in impor
> t_module
> return _bootstrap._gcd_import(name[level:], package, level)
> File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
> File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
> File "<frozen importlib._bootstrap>", line 986, in
> _find_and_load_unlocked
> File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
> File "<frozen importlib._bootstrap_external>", line 790, in exec_module
> File "<frozen importlib._bootstrap>", line 228, in
> _call_with_frames_removed
> File "C:\Users\Song\Documents\UDEM\master thesis\uml
> data\database\umllabels\l
> abeling\urls.py", line 3, in <module>
> from . import views
> File "C:\Users\Song\Documents\UDEM\master thesis\uml
> data\database\umllabels\l
> abeling\views.py", line 2, in <module>
> from labeling.sampler import Sampler, block
> File "C:\Users\Song\Documents\UDEM\master thesis\uml
> data\database\umllabels\l
> abeling\sampler.py", line 108, in <module>
> class Sampler:
> File "C:\Users\Song\Documents\UDEM\master thesis\uml
> data\database\umllabels\l
> abeling\sampler.py", line 111, in Sampler
> largest_class_count =
> Model.objects.order_by("-classes").first().classes
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\mo
> dels\query.py", line 674, in first
> for obj in (self if self.ordered else self.order_by('pk'))[:1]:
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\mo
> dels\query.py", line 280, in __iter__
> self._fetch_all()
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\mo
> dels\query.py", line 1324, in _fetch_all
> self._result_cache = list(self._iterable_class(self))
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\mo
> dels\query.py", line 51, in __iter__
> results = compiler.execute_sql(chunked_fetch=self.chunked_fetch,
> chunk_size=
> self.chunk_size)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\mo
> dels\sql\compiler.py", line 1175, in execute_sql
> cursor.execute(sql, params)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\ba
> ckends\utils.py", line 66, in execute
> return self._execute_with_wrappers(sql, params, many=False,
> executor=self._e
> xecute)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\ba
> ckends\utils.py", line 75, in _execute_with_wrappers
> return executor(sql, params, many, context)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\ba
> ckends\utils.py", line 84, in _execute
> return self.cursor.execute(sql, params)
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\ut
> ils.py", line 90, in __exit__
> raise dj_exc_value.with_traceback(traceback) from exc_value
> File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
> packages\django\db\ba
> ckends\utils.py", line 84, in _execute
> return self.cursor.execute(sql, params)
> django.db.utils.ProgrammingError: relation "labeling_model" does not
> exist
> LINE 1: ...del"."classes", "labeling_model"."relations" FROM
> "labeling_...
>
> }}}
New description:
To put my app on Heroku, I am changing my database from SQLite to Postgres
at the end of my project. Everything works fine locally on SQLite. But
during `python manage.py migrate --run-syncdb`, I get a
`ProgrammingError`. I was planning on loading the dumped json later in
Postgres.
I created a branch on my repo for you to reproduce this bug. The branch is
`postgres` and the commit is https://github.com/XsongyangX/uml-fragment-
labeling/commit/c14a49990b115bd0b8ba74640a7c65da301562d3
Here is the log.
{{{
$ py manage.py migrate --run-syncdb
Traceback (most recent call last):
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\ba
ckends\utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation "labeling_model" does not exist
LINE 1: ...del"."classes", "labeling_model"."relations" FROM "labeling_...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\Song\Documents\UDEM\master thesis\uml
data\database\umllabels\m
anage.py", line 22, in <module>
main()
File "C:\Users\Song\Documents\UDEM\master thesis\uml
data\database\umllabels\m
anage.py", line 18, in main
execute_from_command_line(sys.argv)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
management\__init__.py", line 419, in execute_from_command_line
utility.execute()
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
management\__init__.py", line 413, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
management\base.py", line 354, in run_from_argv
self.execute(*args, **cmd_options)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
management\base.py", line 398, in execute
output = self.handle(*args, **options)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
management\base.py", line 89, in wrapped
res = handle_func(*args, **kwargs)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
management\commands\migrate.py", line 75, in handle
self.check(databases=[database])
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
management\base.py", line 419, in check
all_issues = checks.run_checks(
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
checks\registry.py", line 76, in run_checks
new_errors = check(app_configs=app_configs, databases=databases)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
checks\urls.py", line 13, in check_url_config
return check_resolver(resolver)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\core\
checks\urls.py", line 23, in check_resolver
return check_method()
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\urls\
resolvers.py", line 412, in check
for pattern in self.url_patterns:
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\utils
\functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\urls\
resolvers.py", line 598, in url_patterns
patterns = getattr(self.urlconf_module, "urlpatterns",
self.urlconf_module)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\utils
\functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\urls\
resolvers.py", line 591, in urlconf_module
return import_module(self.urlconf_name)
File "C:\Program Files\Python39\lib\importlib\__init__.py", line 127, in
impor
t_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
File "<frozen importlib._bootstrap>", line 986, in
_find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 790, in exec_module
File "<frozen importlib._bootstrap>", line 228, in
_call_with_frames_removed
File "C:\Users\Song\Documents\UDEM\master thesis\uml
data\database\umllabels\u
mllabels\urls.py", line 24, in <module>
path('labeling/', include(('labeling.urls', 'labeling'),
namespace="labeling
")),
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\urls\
conf.py", line 34, in include
urlconf_module = import_module(urlconf_module)
File "C:\Program Files\Python39\lib\importlib\__init__.py", line 127, in
impor
t_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
File "<frozen importlib._bootstrap>", line 986, in
_find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 790, in exec_module
File "<frozen importlib._bootstrap>", line 228, in
_call_with_frames_removed
File "C:\Users\Song\Documents\UDEM\master thesis\uml
data\database\umllabels\l
abeling\urls.py", line 3, in <module>
from . import views
File "C:\Users\Song\Documents\UDEM\master thesis\uml
data\database\umllabels\l
abeling\views.py", line 2, in <module>
from labeling.sampler import Sampler, block
File "C:\Users\Song\Documents\UDEM\master thesis\uml
data\database\umllabels\l
abeling\sampler.py", line 108, in <module>
class Sampler:
File "C:\Users\Song\Documents\UDEM\master thesis\uml
data\database\umllabels\l
abeling\sampler.py", line 111, in Sampler
largest_class_count =
Model.objects.order_by("-classes").first().classes
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\mo
dels\query.py", line 674, in first
for obj in (self if self.ordered else self.order_by('pk'))[:1]:
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\mo
dels\query.py", line 280, in __iter__
self._fetch_all()
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\mo
dels\query.py", line 1324, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\mo
dels\query.py", line 51, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch,
chunk_size=
self.chunk_size)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\mo
dels\sql\compiler.py", line 1175, in execute_sql
cursor.execute(sql, params)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\ba
ckends\utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False,
executor=self._e
xecute)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\ba
ckends\utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\ba
ckends\utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\ut
ils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Users\Song\AppData\Roaming\Python\Python39\site-
packages\django\db\ba
ckends\utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "labeling_model" does not exist
LINE 1: ...del"."classes", "labeling_model"."relations" FROM "labeling_...
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/32968#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/068.e197abd70ec000496e662c21cf2d1c6b%40djangoproject.com.
