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 > > > > > >
