[
https://issues.apache.org/jira/browse/AIRAVATA-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie resolved AIRAVATA-3376.
---------------------------------------
Resolution: Fixed
> Wagtail: Problem installing fixtures: no such table: wagtailcore_page__old,
> Python 3.7 incompatibility
> ------------------------------------------------------------------------------------------------------
>
> Key: AIRAVATA-3376
> URL: https://issues.apache.org/jira/browse/AIRAVATA-3376
> Project: Airavata
> Issue Type: Improvement
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
>
> The version of Django (1.11.29) and Wagtail (2.0) are not compatible with
> Python 3.7+. Newer versions of Django have the fix but 1.11.x didn't get the
> fix.
> Workaround:
> - use Python 3.6
> See also:
> https://code.djangoproject.com/ticket/29182
> https://github.com/wagtail/wagtail/issues/4941
> Stack trace:
> {code}
> Traceback (most recent call last):
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py",
> line 62, in execute
> return self.cursor.execute(sql)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py",
> line 326, in execute
> return Database.Cursor.execute(self, query)
> sqlite3.OperationalError: no such table: wagtailcore_page__old
> The above exception was the direct cause of the following exception:
> Traceback (most recent call last):
> File "manage.py", line 22, in <module>
> execute_from_command_line(sys.argv)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/__init__.py",
> line 364, in execute_from_command_line
> utility.execute()
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/__init__.py",
> line 356, in execute
> self.fetch_command(subcommand).run_from_argv(self.argv)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/base.py",
> line 283, in run_from_argv
> self.execute(*args, **cmd_options)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/base.py",
> line 330, in execute
> output = self.handle(*args, **options)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/django_airavata/wagtailapps/base/management/commands/load_cms_data.py",
> line 36, in handle
> call_command('loaddata', fixture_file, verbosity=0)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/__init__.py",
> line 131, in call_command
> return command.execute(*args, **defaults)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/base.py",
> line 330, in execute
> output = self.handle(*args, **options)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/commands/loaddata.py",
> line 69, in handle
> self.loaddata(fixture_labels)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/commands/loaddata.py",
> line 115, in loaddata
> connection.check_constraints(table_names=table_names)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py",
> line 286, in check_constraints
> column_name, referenced_column_name,
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py",
> line 79, in execute
> return super(CursorDebugWrapper, self).execute(sql, params)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py",
> line 64, in execute
> return self.cursor.execute(sql, params)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/utils.py",
> line 94, in __exit__
> six.reraise(dj_exc_type, dj_exc_value, traceback)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/utils/six.py",
> line 685, in reraise
> raise value.with_traceback(tb)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py",
> line 62, in execute
> return self.cursor.execute(sql)
> File
> "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py",
> line 326, in execute
> return Database.Cursor.execute(self, query)
> django.db.utils.OperationalError: Problem installing fixtures: no such table:
> wagtailcore_page__old
> {code}
> h5. TODO
> - [x] integrate tox for running Python unittests against multiple Python
> versions
> - [x] Upgrade to more recent and supported Django and Wagtail
> - [x] Upgrade to more recent and supported Python
> - [x] check for deprecation warnings
> - [x] upgrade Python version used in Dockerfile
--
This message was sent by Atlassian Jira
(v8.3.4#803005)