[jira] [Commented] (AIRAVATA-3697) Handle unicode characters in file names
[
https://issues.apache.org/jira/browse/AIRAVATA-3697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736268#comment-17736268
]
Marcus Christie commented on AIRAVATA-3697:
---
I'm using mariadb-tools to do an online conversion of a large instance of
replica_catalog. First, I'm doing a dry run on a copy of the database:
{code}
MariaDB> create database replica_catalog_copy DEFAULT CHARACTER SET utf8
COLLATE utf8_bin;
{code}
{code}
mysqldump replica_catalog > replica_catalog.sql
mysql replica_catalog_copy < replica_catalog.sql
{code}
Need to remove the foreign keys for this to work
{code}
ALTER TABLE DATA_PRODUCT DROP FOREIGN KEY DATA_PRODUCT_ibfk_1;
ALTER TABLE DATA_PRODUCT_METADATA DROP FOREIGN KEY DATA_PRODUCT_METADATA_ibfk_1;
ALTER TABLE DATA_REPLICA_LOCATION DROP FOREIGN KEY DATA_REPLICA_LOCATION_ibfk_1;
ALTER TABLE DATA_REPLICA_METADATA DROP FOREIGN KEY DATA_REPLICA_METADATA_ibfk_1;
{code}
Running mariadb-tools to do the incremental, online character set conversion
{code}
mariadb-schema-change --alter "CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin"
D=replica_catalog_copy,t=DATA_PRODUCT --execute
mariadb-schema-change --alter "CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin"
D=replica_catalog_copy,t=DATA_PRODUCT_METADATA --execute
mariadb-schema-change --alter "CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin"
D=replica_catalog_copy,t=DATA_REPLICA_LOCATION --execute
mariadb-schema-change --alter "CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin"
D=replica_catalog_copy,t=DATA_REPLICA_METADATA --execute
mariadb-schema-change --alter "CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin"
D=replica_catalog_copy,t=CONFIGURATION --execute
{code}
After it's done, I'll add the FKs back
{code}
ALTER TABLE DATA_PRODUCT ADD CONSTRAINT DATA_PRODUCT_ibfk_1 FOREIGN KEY
(`PARENT_PRODUCT_URI`) REFERENCES `DATA_PRODUCT` (`PRODUCT_URI`) ON DELETE
CASCADE;
ALTER TABLE DATA_PRODUCT_METADATA ADD CONSTRAINT `DATA_PRODUCT_METADATA_ibfk_1`
FOREIGN KEY (`PRODUCT_URI`) REFERENCES `DATA_PRODUCT` (`PRODUCT_URI`) ON DELETE
CASCADE;
ALTER TABLE DATA_REPLICA_LOCATION ADD CONSTRAINT `DATA_REPLICA_LOCATION_ibfk_1`
FOREIGN KEY (`PRODUCT_URI`) REFERENCES `DATA_PRODUCT` (`PRODUCT_URI`) ON DELETE
CASCADE;
ALTER TABLE DATA_REPLICA_METADATA ADD CONSTRAINT `DATA_REPLICA_METADATA_ibfk_1`
FOREIGN KEY (`REPLICA_ID`) REFERENCES `DATA_REPLICA_LOCATION` (`REPLICA_ID`) ON
DELETE CASCADE;
{code}
> Handle unicode characters in file names
> ---
>
> Key: AIRAVATA-3697
> URL: https://issues.apache.org/jira/browse/AIRAVATA-3697
> Project: Airavata
> Issue Type: Bug
> Components: Airavata API, Django Portal
>Reporter: Marcus Christie
>Assignee: Marcus Christie
>Priority: Major
> Attachments: Photophysical properties and photodegradation mechanism
> of 2-(2′-furanyl)-1H-benzimidazole (Fuberidazole) - ScienceDirect.html
>
>
> Getting the following Django error when browsing experiment output files with
> unicode characters in the file names:
> {code}
> Traceback (most recent call last):
> File
> "/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/rest_framework/views.py",
> line 506, in dispatch
>response = handler(request, *args, **kwargs)
> File
> "/var/www/portals/django-seagrid/airavata-django-portal/django_airavata/apps/api/views.py",
> line 1467, in get
>return self._create_response(request, experiment_id, path)
> File
> "/var/www/portals/django-seagrid/airavata-django-portal/django_airavata/apps/api/views.py",
> line 1471, in _create_response
>directories, files = user_storage.list_experiment_dir(request,
> experiment_id, path)
> File
> "/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/airavata_django_portal_sdk/user_storage/api.py",
> line 629, in list_experiment_dir
>backend=backend, owner=experiment.userName)
> File
> "/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/airavata_django_portal_sdk/user_storage/api.py",
> line 760, in _get_data_product_uri
>if user_file.exists():
> File
> "/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/django/db/models/query.py",
> line 808, in exists
>return self.query.has_results(using=self.db)
> File
> "/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/django/db/models/sql/query.py",
> line 561, in has_results
>return compiler.has_results()
> File
> "/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/django/db/models/sql/compiler.py",
> line 1145, in has_results
>return bool(self.execute_sql(SINGLE))
> File
> "/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/django/db/models/sql/compiler.py",
> line 1175, in execute_sql
>cursor.execute(sql, params)
> File
>
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736230#comment-17736230 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit 53585786f4493b4765f778c4b617b7edd6e681f3 in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=53585786 ] AIRAVATA-3698 Changing supported Python version to 3.9 - 3.11 > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736209#comment-17736209 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit 5432028312d2c9130d1bfb99788dec87004213b7 in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=54320283 ] AIRAVATA-3698 Fixing deprecation warnings > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736210#comment-17736210 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit b47c4e4adb69ea5678ab0b5b45fec9775419d15e in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=b47c4e4a ] AIRAVATA-3698 Fixing deprecation warnings in commons package > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736207#comment-17736207 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit 703a37a6c399172c36cdda9f99d4dba6c92a334e in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=703a37a6 ] AIRAVATA-3698 Upgrade to Wagtail 4.2 > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736211#comment-17736211 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit 119c88e307e75acb86ec700a0cfe62264eadce55 in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=119c88e3 ] AIRAVATA-3698 Upgrading to Django 4.2 > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736205#comment-17736205 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit 28f1d838456ef0c3dfd227b350fc6a5b9c5a049d in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=28f1d838 ] AIRAVATA-3698 Upgrade to Wagtail 3.0, WAGTAILADMIN_BASE_URL setting added > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736208#comment-17736208 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit 47f09aecae5a42c5d20921b6b65d712734bc019a in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=47f09aec ] AIRAVATA-3698 Upgrade to Wagtail 5.0, remove wagtailfontawesome > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736206#comment-17736206 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit 839e35148d9bb4b8911e8f67c2aa000d580004a1 in airavata-django-portal's branch refs/heads/AIRAVATA-3698--Add-support-for-Python-3.11 from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=839e3514 ] AIRAVATA-3698 Upgrade to Wagtail 4.0 > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (AIRAVATA-3698) Add support for Python 3.11
[ https://issues.apache.org/jira/browse/AIRAVATA-3698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17736169#comment-17736169 ] ASF subversion and git services commented on AIRAVATA-3698: --- Commit f2c981106d9baea9cab620a6356e181a8222549a in airavata-django-portal-commons's branch refs/heads/main from Marcus Christie [ https://gitbox.apache.org/repos/asf?p=airavata-django-portal-commons.git;h=f2c9811 ] AIRAVATA-3698 Fixing deprecation warnings > Add support for Python 3.11 > --- > > Key: AIRAVATA-3698 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3698 > Project: Airavata > Issue Type: Improvement > Components: Django Portal >Reporter: Marcus Christie >Assignee: Marcus Christie >Priority: Major > > Upgrade Wagtail and Django versions to get Python 3.11 support -- This message was sent by Atlassian Jira (v8.20.10#820010)
