This one Wei: Server version: 10.10.6-MariaDB-1:10.10.6+maria~ubu2004
Atte, Ricardo Pertuz On 19 Oct 2023 at 12:56 PM -0500, Wei ZHOU <ustcweiz...@gmail.com>, wrote: > HI Ricardo, > > Do you use MySQL, mariadb or other alternatives? What's the version? > > -Wei > > 在 2023年10月19日星期四,Ricardo Pertuz <ricardo.per...@kuasar.co.invalid> 写道: > > > 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 <ustcweiz...@gmail.com>, 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 <ricardo.per...@kuasar.co.invalid> 写道: > > > > > > > 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 > > > > > > > > > > > > > >