Skip to content

Instantly share code, notes, and snippets.

@alena1108
Created January 12, 2017 03:59
Show Gist options
  • Save alena1108/301f578d55823a1c7dc8af769702bc9c to your computer and use it in GitHub Desktop.
Save alena1108/301f578d55823a1c7dc8af769702bc9c to your computer and use it in GitHub Desktop.
processes
mysql> select * from process_instance where resource_type='service' and resource_id=19;
+------+---------------------+---------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------------------+---------------+-------------+---------+-------------+-------+-------------------------+---------------------------+-----------------+---------------------+
| 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 |
+------+---------------------+---------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------------------+---------------+-------------+---------+-------------+-------+-------------------------+---------------------------+-----------------+---------------------+
| 592 | 2017-01-11 23:07:31 | 2017-01-11 23:07:31 | {"metadata":{"io.rancher.service.hash":"8b1fc98cc77bf5aa800b0dff01bcd5cbf82c62d4"},"system":false,"startOnCreate":false,"kind":"service","launchConfig":{"command":["lb-controller","--controller=kubernetes","--provider=rancher"],"environment":{"KUBERNETES_URL":"http://kubernetes.kubernetes.rancher.internal"},"healthCheck":{"healthyThreshold":2,"interval":2000,"port":10241,"requestLine":"GET /healthz HTTP/1.0","responseTimeout":2000,"unhealthyThreshold":3,"strategy":"recreate"},"imageUuid":"docker:rancher/lb-service-rancher:v0.4.0","labels":{"io.rancher.container.agent.role":"environment","io.rancher.container.create_agent":"true","io.rancher.scheduler.affinity:host_label_soft":"orchestration=true","io.rancher.service.hash":"13e60c71cde8a21df5f5c258324cb1b5b5ada84f"},"logConfig":{},"networkMode":"managed","startOnCreate":true,"instanceTriggeredStop":"stop","kind":"container","privileged":false,"publishAllPorts":false,"readOnly":false,"stdinOpen":false,"system":false,"tty":false,"version":"0","vcpu":1},"stackId":12,"name":"rancher-ingress-controller","scale":1,"serviceIndexStrategy":"deploymentUnitBased","assignServiceIpAddress":false} | 0 | service.create | service | 19 | SUCCESS | DONE | DONE | 172.17.0.2 | NULL | 1 | 2017-01-11 23:07:46 |
| 627 | 2017-01-11 23:11:40 | 2017-01-11 23:12:40 | {} | 0 | service.activate | service | 19 | SUCCESS | DONE | DONE | 172.17.0.2 | NULL | 1 | 2017-01-11 23:12:56 |
| 1614 | 2017-01-11 23:52:56 | 2017-01-11 23:53:26 | {} | 0 | service.update | service | 19 | SUCCESS | DONE | DONE | 172.17.0.2 | NULL | 2 | 2017-01-11 23:53:41 |
+------+---------------------+---------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------------------+---------------+-------------+---------+-------------+-------+-------------------------+---------------------------+-----------------+---------------------+
3 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment