Hi Ricardo, This seems to be an issue with mariadb refer to https://jira.mariadb.org/browse/MDEV-31987
-Wei On Thu, 19 Oct 2023 at 21:36, Ricardo Pertuz <[email protected]> wrote: > I tried these versions none of them work > > 10.10.6-MariaDB > 10.5.22-MariaDB > 10.11.5-MariaDB > > Looks weird as I have a functional ACS 4.18.0 running on 10.5.19-MariaDB > > > Atte, > > Ricardo Pertuz > > > On 19 Oct 2023 at 1:35 PM -0500, Wei ZHOU <[email protected]>, wrote: > > The issue might be related to database versions, need to confirm. > > Can you try MySQL or upgrade mariadb? > > > > -Wei > > > > 在 2023年10月19日星期四，Ricardo Pertuz <[email protected]> 写道： > > > > > 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 <[email protected]>, > wrote: > > > > 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] > .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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
