GitHub user akrasnov-drv added a comment to the discussion: CloudStack starts misbehaving under minimal load
Nice SQL query btw. I managed to start 100 VMs on 5 hosts. I mean all properly started. Again after first several ones delays increased, sometimes to more than 1.5 minutes. Still I've got all I requested in the end. ``` +------+-------------+------------+-----------------+---------------------+---------------------+-------------------+ | id | instance_id | job_status | job_result_code | created | last_updated | time_diff_seconds | +------+-------------+------------+-----------------+---------------------+---------------------+-------------------+ | 4725 | 1082 | 1 | 0 | 2025-02-20 11:46:58 | 2025-02-20 11:47:06 | 8 | | 4722 | 1081 | 1 | 0 | 2025-02-20 11:46:49 | 2025-02-20 11:46:54 | 5 | | 4719 | 1080 | 1 | 0 | 2025-02-20 11:44:18 | 2025-02-20 11:44:25 | 7 | | 4716 | 1079 | 1 | 0 | 2025-02-20 11:44:09 | 2025-02-20 11:44:14 | 5 | | 4696 | 1078 | 1 | 0 | 2025-02-20 11:38:49 | 2025-02-20 11:39:49 | 60 | | 4694 | 1077 | 1 | 0 | 2025-02-20 11:38:48 | 2025-02-20 11:39:53 | 65 | | 4690 | 1076 | 1 | 0 | 2025-02-20 11:38:39 | 2025-02-20 11:39:43 | 64 | | 4688 | 1075 | 1 | 0 | 2025-02-20 11:38:38 | 2025-02-20 11:39:48 | 70 | | 4686 | 1074 | 1 | 0 | 2025-02-20 11:38:28 | 2025-02-20 11:39:44 | 76 | | 4683 | 1073 | 1 | 0 | 2025-02-20 11:38:00 | 2025-02-20 11:39:34 | 94 | | 4681 | 1072 | 1 | 0 | 2025-02-20 11:38:00 | 2025-02-20 11:39:37 | 97 | | 4679 | 1071 | 1 | 0 | 2025-02-20 11:37:59 | 2025-02-20 11:39:31 | 92 | | 4677 | 1070 | 1 | 0 | 2025-02-20 11:37:59 | 2025-02-20 11:39:42 | 103 | .... | 4432 | 986 | 1 | 0 | 2025-02-20 11:32:08 | 2025-02-20 11:32:25 | 17 | | 4431 | 985 | 1 | 0 | 2025-02-20 11:32:07 | 2025-02-20 11:32:23 | 16 | | 4430 | 984 | 1 | 0 | 2025-02-20 11:32:07 | 2025-02-20 11:32:29 | 22 | | 4427 | 983 | 1 | 0 | 2025-02-20 11:31:58 | 2025-02-20 11:32:03 | 5 | +------+-------------+------------+-----------------+---------------------+---------------------+-------------------+ 100 rows in set (0.00 sec) ``` here are maximum delays ``` +------+-------------+------------+-----------------+---------------------+---------------------+-------------------+ | id | instance_id | job_status | job_result_code | created | last_updated | time_diff_seconds | +------+-------------+------------+-----------------+---------------------+---------------------+-------------------+ | 4498 | 1015 | 1 | 0 | 2025-02-20 11:32:39 | 2025-02-20 11:34:33 | 114 | | 4473 | 1005 | 1 | 0 | 2025-02-20 11:32:29 | 2025-02-20 11:34:17 | 108 | | 4505 | 1017 | 1 | 0 | 2025-02-20 11:32:48 | 2025-02-20 11:34:35 | 107 | | 4493 | 1012 | 1 | 0 | 2025-02-20 11:32:38 | 2025-02-20 11:34:24 | 106 | | 4663 | 1063 | 1 | 0 | 2025-02-20 11:37:48 | 2025-02-20 11:39:32 | 104 | | 4677 | 1070 | 1 | 0 | 2025-02-20 11:37:59 | 2025-02-20 11:39:42 | 103 | | 4673 | 1068 | 1 | 0 | 2025-02-20 11:37:51 | 2025-02-20 11:39:33 | 102 | | 4681 | 1072 | 1 | 0 | 2025-02-20 11:38:00 | 2025-02-20 11:39:37 | 97 | ``` GitHub link: https://github.com/apache/cloudstack/discussions/10414#discussioncomment-12262631 ---- This is an automatically sent email for users@cloudstack.apache.org. To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
