rhtyd commented on issue #3458: Cannot create zone. "Fail to create a physical network" error with VMWare 6.5 hypervisor URL: https://github.com/apache/cloudstack/issues/3458#issuecomment-508202447 @AndreaGHG can you share your MySQL server version, and if you're using any forks such as MariaDB, or any mysql-proxy etc? Please set the `host` global setting to be the management server host IP address and the `management.network.cidr` to match the management network CIDR, then restart the management server. Per the exception `Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction` there seems to be some database related issue in your environment. Are you running multiple management server(s)? Did you restart the mysql server after changing the proposed/recommended changes in the mysql cnf file: ``` [mysqld] server_id = 1 sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION" innodb_rollback_on_timeout=1 innodb_lock_wait_timeout=600 max_connections=1000 log-bin=mysql-bin binlog-format = 'ROW' ```
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services
