[
https://issues.apache.org/jira/browse/AIRAVATA-3372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17243196#comment-17243196
]
Marcus Christie commented on AIRAVATA-3372:
-------------------------------------------
Did cleanup on this most recent instance:
{noformat}
MariaDB [experiment_catalog]> set @tid =
'TASK_b04380ed-20f3-43fe-b4bb-a547e0495ada';
Query OK, 0 rows affected (0.00 sec)
MariaDB [experiment_catalog]> set @tsid =
'TASK_STATE_0ebaf0de-fec0-4a42-8d7b-fe93c121b581';
Query OK, 0 rows affected (0.00 sec)
MariaDB [experiment_catalog]> begin;
Query OK, 0 rows affected (0.00 sec)
MariaDB [experiment_catalog]> delete from TASK_STATUS where TASK_ID = @tid and
STATUS_ID <> @tsid;
Query OK, 94165 rows affected (25.14 sec)
MariaDB [experiment_catalog]> SELECT t0.STATUS_ID, t0.TASK_ID, t0.REASON,
t0.STATE, t0.TIME_OF_STATE_CHANGE FROM TASK_STATUS t0 WHERE t0.TASK_ID =
'TASK_b04380ed-20f3-43fe-b4bb-a547e0495ada' ORDER BY t0.TIME_OF_STATE_CHANGE
ASC;
+-------------------------------------------------+-------------------------------------------+--------+-----------+----------------------------+
| STATUS_ID | TASK_ID
| REASON | STATE | TIME_OF_STATE_CHANGE |
+-------------------------------------------------+-------------------------------------------+--------+-----------+----------------------------+
| TASK_STATE_0ebaf0de-fec0-4a42-8d7b-fe93c121b581 |
TASK_b04380ed-20f3-43fe-b4bb-a547e0495ada | NULL | COMPLETED | 2020-12-03
01:16:52.133000 |
+-------------------------------------------------+-------------------------------------------+--------+-----------+----------------------------+
1 row in set (0.16 sec)
MariaDB [experiment_catalog]> commit;
Query OK, 0 rows affected (0.01 sec)
{noformat}
> BUG: Saved experiment cannot be edited and launch
> -------------------------------------------------
>
> Key: AIRAVATA-3372
> URL: https://issues.apache.org/jira/browse/AIRAVATA-3372
> Project: Airavata
> Issue Type: Sub-task
> Components: Airavata API, Django Portal
> Affects Versions: 0.19
> Environment: https://seagrid.org/
> Reporter: Eroma
> Assignee: Marcus Christie
> Priority: Major
> Fix For: 0.19
>
>
> # Create an experiment and save for later launch
> # Select the above experiment edit, and change the wall time and launch.
> # Error message in Django - *"An error occurred while processing your
> request. The gateway administrator has been notified of this error."*
> # In the mailed error report the folowing
> timeout
> The read operation timed out
> Django Version: 1.11.29
> Exception Type: timeout
> Exception Value:
> The read operation timed out
> Exception Location: /usr/lib64/python3.6/ssl.py in read, line 589
> Python Executable: /var/www/portals/django-seagrid/venv/bin/python
> Python Version: 3.6.8
> Python Path:
> ['/usr/lib64/python36.zip',
> '/usr/lib64/python3.6',
> '/usr/lib64/python3.6/lib-dynload',
> '/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages',
> '/var/www/portals/django-seagrid/airavata-django-portal',
> '/var/www/portals/django-seagrid/venv/lib/python3.6/site-packages',
>
> '/var/www/portals/django-seagrid/venv/lib64/python3.6/site-packages/IPython/extensions']
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
