Skip to content

Instantly share code, notes, and snippets.

@alena1108

alena1108/gist:9ebcbfeafb7084b709b6daca9ed03258

Created September 25, 2017 23:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alena1108/9ebcbfeafb7084b709b6daca9ed03258 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alena1108/9ebcbfeafb7084b709b6daca9ed03258 to your computer and use it in GitHub Desktop.
Download ZIP
process
Raw
gistfile1.txt
mysql> select * from process_instance where resource_id=149 and resource_type='instance';
+-----+---------------------+---------------------+-----------------------------+----------+-----------------+---------------+-------------+---------+--------------+-------+-------------------------+---------------------------+-----------------+---------------------+------------+------------+
| id | start_time | end_time | data | priority | process_name | resource_type | resource_id | result | exit_reason | phase | start_process_server_id | running_process_server_id | execution_count | run_after | account_id | cluster_id |
+-----+---------------------+---------------------+-----------------------------+----------+-----------------+---------------+-------------+---------+--------------+-------+-------------------------+---------------------------+-----------------+---------------------+------------+------------+
| 866 | 2017-09-25 22:51:28 | 2017-09-25 22:51:28 | {"createOnly":true} | 50 | instance.create | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:51:31 | 5 | 1 |
| 869 | 2017-09-25 22:51:30 | 2017-09-25 22:51:37 | {} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 3 | 2017-09-25 22:51:40 | 5 | 1 |
| 879 | 2017-09-25 22:51:40 | 2017-09-25 22:51:40 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:51:42 | 5 | 1 |
| 880 | 2017-09-25 22:51:42 | 2017-09-25 22:51:44 | {} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 4 | 2017-09-25 22:51:47 | 5 | 1 |
| 881 | 2017-09-25 22:51:44 | 2017-09-25 22:51:44 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:51:46 | 5 | 1 |
| 882 | 2017-09-25 22:51:48 | 2017-09-25 22:51:48 | {} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:51:50 | 5 | 1 |
| 883 | 2017-09-25 22:51:50 | 2017-09-25 22:51:50 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:51:52 | 5 | 1 |
| 884 | 2017-09-25 22:51:57 | 2017-09-25 22:51:57 | {} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:51:59 | 5 | 1 |
| 885 | 2017-09-25 22:51:59 | 2017-09-25 22:51:59 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:52:01 | 5 | 1 |
| 886 | 2017-09-25 22:52:13 | 2017-09-25 22:52:13 | {"containerNoOpEvent":true} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:52:15 | 5 | 1 |
| 890 | 2017-09-25 22:52:14 | 2017-09-25 22:52:14 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:52:17 | 5 | 1 |
| 891 | 2017-09-25 22:52:28 | 2017-09-25 22:52:28 | {"containerNoOpEvent":true} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:52:30 | 5 | 1 |
| 892 | 2017-09-25 22:52:30 | 2017-09-25 22:52:30 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:52:32 | 5 | 1 |
| 893 | 2017-09-25 22:52:44 | 2017-09-25 22:52:44 | {"containerNoOpEvent":true} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:52:47 | 5 | 1 |
| 894 | 2017-09-25 22:52:46 | 2017-09-25 22:52:46 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:52:48 | 5 | 1 |
| 895 | 2017-09-25 22:52:58 | 2017-09-25 22:52:58 | {"containerNoOpEvent":true} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:53:00 | 5 | 1 |
| 896 | 2017-09-25 22:53:00 | 2017-09-25 22:53:00 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:53:02 | 5 | 1 |
| 897 | 2017-09-25 22:53:13 | 2017-09-25 22:55:23 | {"containerNoOpEvent":true} | 50 | instance.remove | instance | 149 | SUCCESS | ALREADY_DONE | NULL | 192.168.68.1 | NULL | 0 | 2017-09-25 22:55:13 | 5 | 1 |
| 898 | 2017-09-25 22:53:13 | 2017-09-25 22:53:13 | {"containerNoOpEvent":true} | 50 | instance.start | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:53:16 | 5 | 1 |
| 899 | 2017-09-25 22:53:15 | 2017-09-25 22:53:15 | {"containerNoOpEvent":true} | 50 | instance.stop | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 1 | 2017-09-25 22:53:17 | 5 | 1 |
| 900 | 2017-09-25 22:53:28 | 2017-09-25 22:53:28 | {"containerNoOpEvent":true} | 50 | instance.remove | instance | 149 | SUCCESS | DONE | NULL | 192.168.68.1 | NULL | 2 | 2017-09-25 22:53:31 | 5 | 1 |
+-----+---------------------+---------------------+-----------------------------+----------+-----------------+---------------+-------------+---------+--------------+-------+-------------------------+---------------------------+-----------------+---------------------+------------+------------+
21 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment