alibaba-clusterdata-analysis
alibaba-clusterdata-analysis copied to clipboard
Published
20 hours ago •
lioncruise
lioncruise
Duplicate data in container_event
There exist cases of redundant container create events in container_event, and the requested memory of the redundant rows is abnormal I guess ( they request approximately 100% machine's memory ).
SELECT * FROM container_event
WHERE instance_id
IN (SELECT instance_id FROM container_event GROUP BY instance_id HAVING count(instance_id) > 1)
ORDER BY instance_id
+-------+-----------+------------+-------------+------------+---------------+----------------------+----------------------+-------------------------+
| id | timestamp | event_type | instance_id | machine_id | cpu_requested | memory_requested | disk_requested | cpu_ids |
+-------+-----------+------------+-------------+------------+---------------+----------------------+----------------------+-------------------------+
| 13070 | 0 | Create | 1681 | 56 | 4 | 0.042409339165997983 | 0.0340851218221338 | 42|43|44|45 |
| 13071 | 0 | Create | 1681 | 56 | 4 | 0.9999633571040303 | 0.0340851218221338 | 42|43|44|45 |
| 13579 | 0 | Create | 2160 | 1038 | 4 | 0.042409339165997983 | 0.056808536370223005 | 12|13|14|15 |
| 13580 | 0 | Create | 2160 | 1038 | 4 | 1.0000023457924572 | 0.056808536370223005 | 12|13|14|15 |
| 14345 | 0 | Create | 2878 | 1112 | 4 | 0.042409339165997983 | 0.0340851218221338 | 32|33|34|35 |
| 14346 | 0 | Create | 2878 | 1112 | 4 | 1.0000023457924572 | 0.0340851218221338 | 32|33|34|35 |
| 14893 | 0 | Create | 3384 | 102 | 8 | 0.08481867833199597 | 0.0852128045553345 | 24|25|26|27|28|29|30|31 |
| 14894 | 0 | Create | 3384 | 102 | 8 | 0.9999633571040303 | 0.0852128045553345 | 24|25|26|27|28|29|30|31 |
| 16057 | 0 | Create | 4467 | 331 | 4 | 0.042409339165997983 | 0.0340851218221338 | 8|9|10|11 |
| 16058 | 0 | Create | 4467 | 331 | 4 | 1.0000024064595034 | 0.0340851218221338 | 8|9|10|11 |
| 17145 | 0 | Create | 5470 | 866 | 4 | 0.042409339165997983 | 0.0340851218221338 | 40|41|42|43 |
| 17146 | 0 | Create | 5470 | 866 | 4 | 0.9999633571040303 | 0.0340851218221338 | 40|41|42|43 |
| 18068 | 0 | Create | 6330 | 95 | 4 | 0.042409339165997983 | 0.0340851218221338 | 44|45|46|47 |
| 18069 | 0 | Create | 6330 | 95 | 4 | 0.9999633571040303 | 0.0340851218221338 | 44|45|46|47 |
| 18302 | 0 | Create | 6549 | 1134 | 8 | 0.08481867833199597 | 0.056808536370223005 | 0|1|2|3|4|5|6|7 |
| 18303 | 0 | Create | 6549 | 1134 | 8 | 1.0000102729531748 | 0.056808536370223005 | 0|1|2|3|4|5|6|7 |
| 18397 | 0 | Create | 6639 | 19 | 4 | 0.042409339165997983 | 0.0340851218221338 | 40|41|42|43 |
| 18398 | 0 | Create | 6639 | 19 | 4 | 0.9999633571040303 | 0.0340851218221338 | 40|41|42|43 |
| 19502 | 0 | Create | 7663 | 323 | 4 | 0.042409339165997983 | 0.0340851218221338 | 0|1|2|3 |
| 19503 | 0 | Create | 7663 | 323 | 4 | 1.0000024064595034 | 0.0340851218221338 | 0|1|2|3 |
| 19777 | 0 | Create | 7915 | 69 | 4 | 0.042409339165997983 | 0.0340851218221338 | 8|9|10|11 |
| 19778 | 0 | Create | 7915 | 69 | 4 | 0.9999633571040303 | 0.0340851218221338 | 8|9|10|11 |
| 20379 | 0 | Create | 8476 | 323 | 4 | 0.042409339165997983 | 0.0340851218221338 | 60|61|62|63 |
| 20380 | 0 | Create | 8476 | 323 | 4 | 1.0000024064595034 | 0.0340851218221338 | 60|61|62|63 |
| 11933 | 0 | Create | 10772 | 85 | 4 | 0.042409339165997983 | 0.0340851218221338 | 32|33|34|35 |
| 11934 | 0 | Create | 10772 | 85 | 4 | 0.9999633571040303 | 0.0340851218221338 | 32|33|34|35 |
+-------+-----------+------------+-------------+------------+---------------+----------------------+----------------------+-------------------------+
26 rows in set (0.05 sec)
