Replies: 3 comments
-
|
@rongage , centos stream is not explicitely supported by ACS. I do not know how far forked it is from the likes of Oracle Linux 9, Alma Linux 9 and Rocky Linux 9, which are all supported. It could be that it is a matter of a package version to control better (the DB for instance). The mariaDB I think, is only supported for version 5 ; MySQL 8.0 (or equivalent compatible DBMS). |
Beta Was this translation helpful? Give feedback.
-
|
I tested mariadb-server 10.6.18-0ubuntu0.22.04.1, it worked well. 10.6.18 is a more recent release (released in May 2024) than 10.5.22 (released in August 2023) |
Beta Was this translation helpful? Give feedback.
-
|
@rongage please have a try |
Beta Was this translation helpful? Give feedback.
-
ISSUE TYPE
COMPONENT NAME
CLOUDSTACK VERSION
CONFIGURATION
Separate database server:
mysql> select @@Version
-> ;
+-----------------+
| @@Version |
+-----------------+
| 10.5.22-MariaDB |
+-----------------+
1 row in set (0.00 sec)
OS / ENVIRONMENT
CentOS Stream 9
SUMMARY
First startup, system detects that database is not correct revision ...
2024-09-06 22:05:47,734 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 4.0.0 Code Version = 4.19.1.1
2024-09-06 22:05:47,735 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed from 4.0.0 to 4.19.1.1
2024-09-06 22:05:47,751 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Running upgrade Upgrade40to41 to upgrade from 4.0.0-4.1.0 to 4.1.0
During the upgrade of the database schema, there is an invalid operation attempted (altering a foreign key column) which is not allowed unless you turn of foreign key constraints.
2024-09-06 22:05:47,796 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
2024-09-06 22:05:47,817 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: alter table storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
2024-09-06 22:05:47,817 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'
2024-09-06 22:05:47,819 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)
STEPS TO REPRODUCE
EXPECTED RESULTS
ACTUAL RESULTS
Beta Was this translation helpful? Give feedback.
All reactions