gistfile1.txt

=========================
= Setup on any session
=========================

DELETE FROM FAILURE_EVENT;
DELETE FROM RUNTIME_ATTRIBUTES;
DELETE FROM EXECUTION_INFO;
DELETE FROM SYMBOL;
DELETE FROM WORKFLOW_EXECUTION_AUX;
DELETE FROM EXECUTION_EVENT;
DELETE FROM EXECUTION;
DELETE FROM WORKFLOW_EXECUTION;

ALTER TABLE FAILURE_EVENT AUTO_INCREMENT = 1;
ALTER TABLE RUNTIME_ATTRIBUTES AUTO_INCREMENT = 1;
ALTER TABLE EXECUTION_INFO AUTO_INCREMENT = 1;
ALTER TABLE SYMBOL AUTO_INCREMENT = 1;
ALTER TABLE WORKFLOW_EXECUTION_AUX AUTO_INCREMENT = 1;
ALTER TABLE EXECUTION_EVENT AUTO_INCREMENT = 1;
ALTER TABLE EXECUTION AUTO_INCREMENT = 1;
ALTER TABLE WORKFLOW_EXECUTION AUTO_INCREMENT = 1;

SET autocommit=0;
insert into `WORKFLOW_EXECUTION` (`WORKFLOW_EXECUTION_UUID`,`WORKFLOW_NAME`,`STATUS`,`START_DT`,`END_DT`)  values ('3db8b664-177d-40e7-9176-0f1e0e05be7a','w','Submitted','2016-04-01 09:09:25.322',null);
insert into `WORKFLOW_EXECUTION_AUX` (`WORKFLOW_EXECUTION_ID`,`WDL_SOURCE`,`JSON_INPUTS`,`WORKFLOW_OPTIONS`)  values (1,'task a {command{}}\nworkflow w {\n  call a\n  call a as b\n  call a as c\n}\n          ','{}','{}');
insert into `EXECUTION` (`WORKFLOW_EXECUTION_ID`,`CALL_FQN`,`IDX`,`STATUS`,`RC`,`START_DT`,`END_DT`,`BACKEND_TYPE`,`ALLOWS_RESULT_REUSE`,`DOCKER_IMAGE_HASH`,`RESULTS_CLONED_FROM`,`EXECUTION_HASH`,`ATTEMPT`)  values (1,'w.a',-1,'NotStarted',null,null,null,'Local',1,null,null,null,1);
insert into `EXECUTION` (`WORKFLOW_EXECUTION_ID`,`CALL_FQN`,`IDX`,`STATUS`,`RC`,`START_DT`,`END_DT`,`BACKEND_TYPE`,`ALLOWS_RESULT_REUSE`,`DOCKER_IMAGE_HASH`,`RESULTS_CLONED_FROM`,`EXECUTION_HASH`,`ATTEMPT`)  values (1,'w.b',-1,'NotStarted',null,null,null,'Local',1,null,null,null,1);
insert into `EXECUTION` (`WORKFLOW_EXECUTION_ID`,`CALL_FQN`,`IDX`,`STATUS`,`RC`,`START_DT`,`END_DT`,`BACKEND_TYPE`,`ALLOWS_RESULT_REUSE`,`DOCKER_IMAGE_HASH`,`RESULTS_CLONED_FROM`,`EXECUTION_HASH`,`ATTEMPT`)  values (1,'w.c',-1,'NotStarted',null,null,null,'Local',1,null,null,null,1);
commit;

=========================
= Session 1
=========================

SET autocommit=0;

=========================
= Session 2
=========================

SET autocommit=0;

=========================
= Session 1
=========================

insert into `RUNTIME_ATTRIBUTES` (`EXECUTION_ID`,`ATTRIBUTE_NAME`,`ATTRIBUTE_VALUE`,`RUNTIME_ATTRIBUTE_ID`)  values (1,'e','1',null) on duplicate key update `EXECUTION_ID`=VALUES(`EXECUTION_ID`), `ATTRIBUTE_NAME`=VALUES(`ATTRIBUTE_NAME`), `ATTRIBUTE_VALUE`=VALUES(`ATTRIBUTE_VALUE`);

=========================
= Session 2
=========================

# !!!!! THIS WILL CAUSE MYSQL TO HANG !!!!!

insert into `RUNTIME_ATTRIBUTES` (`EXECUTION_ID`,`ATTRIBUTE_NAME`,`ATTRIBUTE_VALUE`,`RUNTIME_ATTRIBUTE_ID`)  values (2,'e','1',null) on duplicate key update `EXECUTION_ID`=VALUES(`EXECUTION_ID`), `ATTRIBUTE_NAME`=VALUES(`ATTRIBUTE_NAME`), `ATTRIBUTE_VALUE`=VALUES(`ATTRIBUTE_VALUE`);

=========================
= Session 1
=========================

# !!!!! THIS WILL CAUSE PRIOR COMMAND ON Session 2 TO ABORT WITH AN ERROR !!!!!

insert into `RUNTIME_ATTRIBUTES` (`EXECUTION_ID`,`ATTRIBUTE_NAME`,`ATTRIBUTE_VALUE`,`RUNTIME_ATTRIBUTE_ID`)  values (1,'f','2.2',null) on duplicate key update `EXECUTION_ID`=VALUES(`EXECUTION_ID`), `ATTRIBUTE_NAME`=VALUES(`ATTRIBUTE_NAME`), `ATTRIBUTE_VALUE`=VALUES(`ATTRIBUTE_VALUE`);