[ 
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)

Reply via email to