HI Ricardo, Do you use MySQL, mariadb or other alternatives? What's the version?
-Wei 在 2023年10月19日星期四，Ricardo Pertuz <[email protected]> 写道： > Thans Wei, > > It it a new virtual machine with no previous installation, I just > > 1. Dropped both databases > 2. Send de cloudstack-database-setup again with no errror > 3. Start de ACS Management daemon > > Now getting another SQL error > > 2023-10-19 12:47:29,711 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > Error executing: alter table storage_pool modify id bigint unsigned > AUTO_INCREMENT UNIQUE NOT NULL > 2023-10-19 12:47:29,719 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > java.sql.SQLException: Cannot change column 'id': used in a foreign key > constraint 'fk_storage_pool_details__pool_id' of table > 'cloud.storage_pool_details' > 2023-10-19 12:47:29,722 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Unable to execute upgrade script > java.sql.SQLException: Cannot change column 'id': used in a foreign key > constraint 'fk_storage_pool_details__pool_id' of table > 'cloud.storage_pool_details' > at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185) > > > Atte, > > Ricardo Pertuz > > > On 19 Oct 2023 at 12:39 PM -0500, Wei ZHOU <[email protected]>, wrote: > > Hi Ricardo, > > > > Have you installed management service on the host before? > > You can drop the cloud and cloud_usage database, then retry. > > > > If you install multiple management servers, install them one by one. > > > > -Wei > > > > 在 2023年10月19日星期四，Ricardo Pertuz <[email protected]> 写道： > > > > > Hi team, > > > > > > I’m trying to install a brand new ACS 4.18 in Ubuntu 20.04 LTS and when > > > starting it’s getting this error > > > > > > 2023-10-19 12:24:15,354 ERROR [c.c.u.d.ScriptRunner] (main:null) > (logid:) > > > Error executing: alter table vm_template add size bigint unsigned > > > 2023-10-19 12:24:15,355 ERROR [c.c.u.d.ScriptRunner] (main:null) > (logid:) > > > java.sql.SQLSyntaxErrorException: Duplicate column name 'size' > > > 2023-10-19 12:24:15,357 ERROR [c.c.u.DatabaseUpgradeChecker] > (main:null) > > > (logid:) Unable to execute upgrade script > > > > > > java.sql.SQLSyntaxErrorException: Duplicate column name 'size' > > > > > > 2023-10-19 12:24:15,389 ERROR [c.c.u.DatabaseUpgradeChecker] > (main:null) > > > (logid:) Unable to upgrade the database > > > com.cloud.utils.exception.CloudRuntimeException: Unable to execute > > > upgrade script > > > > > > Not so sure why is is upgrading it > > > > > > The cloud database setup command is > > > > > > cloudstack-setup-databases cloud:mysql_pass@database > --deploy-as=user:pass -r > > > 1 -i ip_mgnt_server > > > > > > > > > Atte, > > > > > > Ricardo Pertuz > > > > > > > > > >
