[
https://issues.apache.org/jira/browse/AIRAVATA-3372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17193169#comment-17193169
]
Marcus Christie commented on AIRAVATA-3372:
-------------------------------------------
Slow query log on the prod db is showing some slow queries related to
getJobbDetails:
{noformat}
# Time: 200909 16:13:16
# User@Host: airavata[airavata] @ scigap02.sciencegateways.iu.edu
[156.56.104.12]
# Thread_id: 6502127 Schema: experiment_catalog QC_hit: No
# Query_time: 25.968814 Lock_time: 0.000083 Rows_sent: 1 Rows_examined:
417863
SET timestamp=1599682396;
SELECT DISTINCT t1.TASK_ID, t2.JOB_ID, t2.TASK_ID,
t2.COMPUTE_RESOURCE_CONSUMED, t2.CREATION_TIME, t2.EXIT_CODE, t2.JOB_NAME,
t2.PROCESS_ID, t2.WORKING_DIR FROM PROCESS t0 INNER JOIN TASK t1 ON
t0.PROCESS_ID = t1.PARENT_PROCESS_ID INNER JOIN JOB t2 ON t1.TASK_ID =
t2.TASK_ID WHERE (t0.EXPERIMENT_ID LIKE
'Clone_of_UMAPPER_on_Sep_9,_2020_12:27_PM_017c7dd4-b27d-4866-b03b-36be2b85357f'
ESCAPE '\\') ORDER BY t1.TASK_ID ASC;
# Time: 200909 16:13:19
# User@Host: airavata[airavata] @ scigap02.sciencegateways.iu.edu
[156.56.104.12]
# Thread_id: 6500158 Schema: experiment_catalog QC_hit: No
# Query_time: 5.074020 Lock_time: 0.000069 Rows_sent: 54047 Rows_examined:
162151
SET timestamp=1599682399;
SELECT DISTINCT t1.TASK_ID, t2.STATUS_ID, t2.TASK_ID, t2.STATE,
t2.TIME_OF_STATE_CHANGE FROM PROCESS t0 INNER JOIN TASK t1 ON t0.PROCESS_ID =
t1.PARENT_PROCESS_ID INNER JOIN TASK_STATUS t2 ON t1.TASK_ID = t2.TASK_ID WHERE
t0.EXPERIMENT_ID =
'RmAc-FeII-5H2O-osp2-1con_d4eabd13-0f15-4c57-96be-36016addffd3' ORDER BY
t1.TASK_ID ASC, t2.TIME_OF_STATE_CHANGE ASC;
{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)
