You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2021/03/10 21:19:48 UTC
[GitHub] [cloudstack] abdelouahabb edited a comment on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
abdelouahabb edited a comment on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796089227
@weizhouapache same thing !
@rhtyd same result, and I have the `/usr/sbin/haveged` installed,
Tried on Windows with both virtualbox and vmware and never had this result, it was fast, the issue is not only about being slow but this is like the configuration is not being read like it dont exist even if it is there and filled with all the parameters ?
I hope someone else verifies using `virt-manager (qemu + kvm)` on `Ubuntu 20.04`
Edit : I tried to execute the files independly, here is the results (lot of warnings...) :
```
mysql> source /usr/share/cloudstack-management/setup/create-database.sql;
Query OK, 0 rows affected (0.00 sec)
Database changed
Query OK, 0 rows affected (0.14 sec)
Query OK, 0 rows affected (0.13 sec)
Query OK, 0 rows affected (0.16 sec)
Query OK, 0 rows affected, 1 warning (0.17 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.12 sec)
Query OK, 0 rows affected (0.28 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 0 rows affected (0.09 sec)
Query OK, 0 rows affected (0.10 sec)
Query OK, 0 rows affected (0.32 sec)
Query OK, 0 rows affected (0.14 sec)
Query OK, 0 rows affected (0.12 sec)
Query OK, 0 rows affected (0.10 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> source /usr/share/cloudstack-management/setup/create-schema.sql;
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.07 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.85 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 0 rows affected, 1 warning (2.05 sec)
Query OK, 0 rows affected, 1 warning (0.80 sec)
Query OK, 0 rows affected, 3 warnings (1.90 sec)
Query OK, 0 rows affected, 2 warnings (0.77 sec)
Query OK, 0 rows affected, 2 warnings (1.65 sec)
Query OK, 0 rows affected, 12 warnings (1.24 sec)
Query OK, 0 rows affected, 1 warning (1.94 sec)
Query OK, 0 rows affected, 1 warning (0.77 sec)
Query OK, 0 rows affected, 1 warning (0.67 sec)
Query OK, 0 rows affected, 1 warning (0.11 sec)
Query OK, 0 rows affected, 1 warning (1.23 sec)
Query OK, 0 rows affected, 2 warnings (1.60 sec)
Query OK, 0 rows affected, 1 warning (0.73 sec)
Query OK, 1 row affected (0.07 sec)
Query OK, 1 row affected (0.16 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 1 row affected (0.07 sec)
Query OK, 1 row affected (0.11 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 1 row affected (0.11 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 1 row affected (0.10 sec)
Query OK, 0 rows affected, 2 warnings (2.15 sec)
Query OK, 0 rows affected, 2 warnings (2.15 sec)
Query OK, 0 rows affected, 1 warning (1.29 sec)
Query OK, 0 rows affected, 1 warning (1.08 sec)
Query OK, 0 rows affected, 1 warning (1.12 sec)
Query OK, 0 rows affected, 1 warning (1.48 sec)
Query OK, 0 rows affected, 1 warning (1.39 sec)
Query OK, 0 rows affected, 1 warning (1.08 sec)
Query OK, 0 rows affected, 1 warning (1.27 sec)
Query OK, 0 rows affected, 1 warning (0.72 sec)
Query OK, 0 rows affected, 1 warning (1.92 sec)
Query OK, 0 rows affected, 1 warning (1.26 sec)
Query OK, 0 rows affected, 5 warnings (1.83 sec)
Query OK, 0 rows affected, 3 warnings (0.85 sec)
Query OK, 0 rows affected, 3 warnings (0.50 sec)
Query OK, 0 rows affected, 2 warnings (0.92 sec)
Query OK, 0 rows affected, 2 warnings (0.78 sec)
Query OK, 0 rows affected, 1 warning (0.96 sec)
Query OK, 0 rows affected, 3 warnings (0.75 sec)
Query OK, 0 rows affected, 7 warnings (2.24 sec)
Query OK, 0 rows affected, 1 warning (0.80 sec)
Query OK, 0 rows affected, 1 warning (0.67 sec)
Query OK, 0 rows affected, 1 warning (0.66 sec)
Query OK, 0 rows affected, 1 warning (1.02 sec)
Query OK, 0 rows affected, 1 warning (0.97 sec)
Query OK, 0 rows affected, 1 warning (0.73 sec)
Query OK, 0 rows affected, 1 warning (1.38 sec)
Query OK, 0 rows affected, 1 warning (1.71 sec)
Query OK, 0 rows affected, 4 warnings (2.69 sec)
Query OK, 0 rows affected, 1 warning (1.26 sec)
Query OK, 0 rows affected, 12 warnings (1.13 sec)
Query OK, 0 rows affected, 1 warning (0.69 sec)
Query OK, 0 rows affected, 3 warnings (3.17 sec)
Query OK, 0 rows affected, 2 warnings (0.83 sec)
Query OK, 0 rows affected, 1 warning (0.60 sec)
Query OK, 0 rows affected, 5 warnings (1.13 sec)
Query OK, 0 rows affected, 2 warnings (0.93 sec)
Query OK, 0 rows affected, 4 warnings (0.98 sec)
Query OK, 0 rows affected, 3 warnings (1.17 sec)
Query OK, 0 rows affected, 1 warning (1.05 sec)
Query OK, 0 rows affected, 1 warning (0.99 sec)
Query OK, 0 rows affected, 2 warnings (0.98 sec)
Query OK, 0 rows affected, 1 warning (1.03 sec)
Query OK, 0 rows affected, 3 warnings (1.39 sec)
Query OK, 0 rows affected, 3 warnings (2.09 sec)
Query OK, 0 rows affected, 1 warning (1.19 sec)
Query OK, 0 rows affected, 1 warning (1.63 sec)
Query OK, 0 rows affected, 2 warnings (1.37 sec)
Query OK, 0 rows affected, 3 warnings (1.02 sec)
Query OK, 0 rows affected, 6 warnings (2.04 sec)
Query OK, 0 rows affected, 1 warning (1.39 sec)
Query OK, 0 rows affected, 1 warning (1.20 sec)
Query OK, 0 rows affected, 1 warning (1.41 sec)
Query OK, 0 rows affected, 6 warnings (1.34 sec)
Query OK, 0 rows affected, 7 warnings (1.10 sec)
Query OK, 0 rows affected, 1 warning (0.57 sec)
Query OK, 0 rows affected, 1 warning (1.50 sec)
Query OK, 0 rows affected, 1 warning (1.58 sec)
Query OK, 0 rows affected, 1 warning (1.81 sec)
Query OK, 0 rows affected, 1 warning (1.62 sec)
Query OK, 0 rows affected, 1 warning (1.24 sec)
Query OK, 0 rows affected, 3 warnings (1.14 sec)
Query OK, 0 rows affected, 1 warning (1.16 sec)
Query OK, 0 rows affected, 1 warning (0.75 sec)
Query OK, 0 rows affected, 1 warning (0.81 sec)
Query OK, 0 rows affected, 2 warnings (0.73 sec)
Query OK, 1 row affected (0.19 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 1 row affected (0.12 sec)
Query OK, 1 row affected (0.09 sec)
Query OK, 1 row affected (0.20 sec)
Query OK, 1 row affected (0.15 sec)
Query OK, 1 row affected (0.41 sec)
Query OK, 1 row affected (0.24 sec)
Query OK, 1 row affected (0.06 sec)
Query OK, 1 row affected (0.15 sec)
Query OK, 1 row affected (0.16 sec)
Query OK, 1 row affected (0.19 sec)
Query OK, 1 row affected (0.09 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 0 rows affected, 1 warning (2.19 sec)
Query OK, 0 rows affected, 4 warnings (1.18 sec)
Query OK, 0 rows affected, 1 warning (2.75 sec)
Query OK, 0 rows affected, 1 warning (0.75 sec)
Query OK, 0 rows affected, 1 warning (1.35 sec)
Query OK, 0 rows affected, 1 warning (1.82 sec)
Query OK, 0 rows affected, 1 warning (1.18 sec)
Query OK, 0 rows affected, 1 warning (0.10 sec)
Query OK, 0 rows affected, 1 warning (0.96 sec)
Query OK, 0 rows affected, 1 warning (1.48 sec)
Query OK, 0 rows affected, 1 warning (0.89 sec)
Query OK, 0 rows affected, 1 warning (2.04 sec)
Query OK, 0 rows affected, 1 warning (0.68 sec)
Query OK, 0 rows affected, 1 warning (0.63 sec)
Query OK, 1 row affected (0.24 sec)
Query OK, 0 rows affected, 1 warning (1.06 sec)
Query OK, 1 row affected (0.10 sec)
Query OK, 0 rows affected, 1 warning (1.00 sec)
Query OK, 0 rows affected, 1 warning (0.94 sec)
Query OK, 0 rows affected, 2 warnings (1.10 sec)
Query OK, 0 rows affected, 1 warning (1.02 sec)
Query OK, 0 rows affected, 1 warning (1.10 sec)
Query OK, 0 rows affected, 1 warning (0.76 sec)
Query OK, 0 rows affected, 1 warning (1.99 sec)
Query OK, 0 rows affected, 1 warning (1.13 sec)
Query OK, 0 rows affected, 1 warning (1.52 sec)
Query OK, 0 rows affected, 1 warning (2.08 sec)
Query OK, 0 rows affected, 1 warning (1.86 sec)
Query OK, 0 rows affected, 1 warning (0.74 sec)
Query OK, 0 rows affected, 1 warning (0.82 sec)
Query OK, 0 rows affected, 1 warning (1.58 sec)
Query OK, 0 rows affected, 1 warning (0.89 sec)
Query OK, 0 rows affected, 1 warning (1.18 sec)
Query OK, 0 rows affected, 1 warning (1.01 sec)
Query OK, 0 rows affected, 13 warnings (1.03 sec)
Query OK, 0 rows affected, 4 warnings (1.03 sec)
Query OK, 0 rows affected, 2 warnings (1.22 sec)
Query OK, 0 rows affected, 1 warning (1.16 sec)
Query OK, 0 rows affected, 1 warning (1.53 sec)
Query OK, 0 rows affected, 2 warnings (1.23 sec)
Query OK, 0 rows affected, 1 warning (1.14 sec)
Query OK, 0 rows affected, 1 warning (1.00 sec)
Query OK, 0 rows affected, 5 warnings (0.72 sec)
Query OK, 0 rows affected, 1 warning (0.85 sec)
Query OK, 0 rows affected, 1 warning (2.02 sec)
Query OK, 0 rows affected, 2 warnings (1.17 sec)
Query OK, 0 rows affected, 1 warning (1.77 sec)
Query OK, 0 rows affected, 1 warning (1.35 sec)
Query OK, 0 rows affected, 2 warnings (1.69 sec)
Query OK, 0 rows affected, 2 warnings (1.63 sec)
Query OK, 0 rows affected, 1 warning (0.83 sec)
Query OK, 0 rows affected, 1 warning (1.25 sec)
Query OK, 0 rows affected, 1 warning (2.78 sec)
Query OK, 0 rows affected, 1 warning (1.20 sec)
Query OK, 0 rows affected, 1 warning (1.59 sec)
Query OK, 0 rows affected, 1 warning (1.73 sec)
Query OK, 0 rows affected, 1 warning (1.38 sec)
Query OK, 0 rows affected, 1 warning (1.00 sec)
Query OK, 0 rows affected (0.00 sec)
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org