anjanaprasd opened a new issue, #12659:
URL: https://github.com/apache/cloudstack/issues/12659
Description:
We are experiencing an issue during the database initialization of our
CloudStack environment. Although the database configuration script completes
successfully, the logs indicate failures during the process. We need guidance
to resolve this issue and ensure proper HA setup with Galera and ProxySQL.
Environment Details:
- CloudStack Management Servers: 3 nodes (HA setup)
- ProxySQL Servers: 3 nodes (HA setup)
- ProxySQL version : **3.0.5-60-g7e9e009**
- Database: MariaDB Galera Cluster (3 nodes)
- Database Version : 10.6.25-MariaDB
- OS: ****AlmaLinux release 9.7****
- CloudStack Version: **cloudstack-management-4.22.0.0-shapeblue0.noarch**
- For troubleshooting purpose firewalld is stopped
Logs :
`2026-02-18 12:27:54,526 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `customized_iops` tinyint(1)
unsigned COMMENT 'Should customized IOPS be displayed to the end user'
2026-02-18 12:27:55,103 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `min_iops` bigint(20) unsigned
COMMENT 'Minimum IOPS'
2026-02-18 12:27:55,635 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `max_iops` bigint(20) unsigned
COMMENT 'Maximum IOPS'
2026-02-18 12:27:56,060 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`volumes` ADD COLUMN `min_iops` bigint(20) unsigned COMMENT
'Minimum IOPS'
2026-02-18 12:27:56,502 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`volumes` ADD COLUMN `max_iops` bigint(20) unsigned COMMENT
'Maximum IOPS'
2026-02-18 12:27:57,113 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`storage_pool` ADD COLUMN `managed` tinyint(1) unsigned NOT
NULL DEFAULT 0 COMMENT 'Should CloudStack manage this storage'
2026-02-18 12:27:57,543 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`storage_pool` ADD COLUMN `capacity_iops` bigint(20)
unsigned DEFAULT NULL COMMENT 'IOPS CloudStack can provision from this storage
pool'
2026-02-18 12:27:58,045 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `bytes_read_rate` bigint(20)
2026-02-18 12:27:58,419 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `bytes_write_rate` bigint(20)
2026-02-18 12:27:59,397 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `iops_read_rate` bigint(20)
2026-02-18 12:27:59,969 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `iops_write_rate` bigint(20)
2026-02-18 12:28:00,612 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE TABLE `cloud`.`volume_details` ( `id` bigint unsigned NOT NULL
auto_increment, `volume_id` bigint unsigned NOT NULL COMMENT 'volume id',
`name` varchar(255) NOT NULL, `value` varchar(1024) NOT NULL,
`display_detail` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Should detail be
displayed to the end user', PRIMARY KEY (`id`), CONSTRAINT
`fk_volume_details__volume_id` FOREIGN KEY
`fk_volume_details__volume_id`(`volume_id`) REFERENCES `volumes`(`id`) ON
DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2026-02-18 12:28:01,232 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE TABLE `cloud`.`network_details` ( `id` bigint unsigned NOT NULL
auto_increment, `network_id` bigint unsigned NOT NULL COMMENT 'network id',
`name` varchar(255) NOT NULL, `value` varchar(1024) NOT NULL,
`display_detail` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Should detail be
displayed to the end user', PRIMARY KEY (`id`), CONSTRAINT
`fk_network_details__network_id` FOREIGN KEY
`fk_network_details__network_id`(`network_id`) REFERENCES `networks`(`id`) ON
DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2026-02-18 12:28:02,173 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE TABLE `cloud`.`nic_details` ( `id` bigint unsigned NOT NULL
auto_increment, `nic_id` bigint unsigned NOT NULL COMMENT 'nic id', `name`
varchar(255) NOT NULL, `value` varchar(1024) NOT NULL, `display_detail`
tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Should detail be displayed to the end
user', PRIMARY KEY (`id`), CONSTRAINT `fk_nic_details__nic_id` FOREIGN KEY
`fk_nic_details__nic_id`(`nic_id`) REFERENCES `nics`(`id`) ON DELETE CASCADE )
ENGINE=InnoDB DEFAULT CHARSET=utf8
2026-02-18 12:28:02,565 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE TABLE `cloud`.`disk_offering_details` ( `id` bigint unsigned NOT NULL
auto_increment, `offering_id` bigint unsigned NOT NULL COMMENT 'offering id',
`name` varchar(255) NOT NULL, `value` varchar(1024) NOT NULL,
`display_detail` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Should detail be
displayed to the end user', PRIMARY KEY (`id`), CONSTRAINT
`fk_offering_details__offering_id` FOREIGN KEY
`fk_offering_details__offering_id`(`offering_id`) REFERENCES
`disk_offering`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2026-02-18 12:28:02,979 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE TABLE `cloud`.`global_load_balancing_rules` ( `id` bigint unsigned NOT
NULL auto_increment COMMENT 'id', `uuid` varchar(40), `account_id` bigint
unsigned NOT NULL COMMENT 'account id', `domain_id` bigint unsigned NOT NULL
COMMENT 'domain id', `region_id` int unsigned NOT NULL, `name`
varchar(255) NOT NULL, `description` varchar(4096) NULL COMMENT
'description', `state` char(32) NOT NULL COMMENT 'current state of this
rule', `algorithm` varchar(255) NOT NULL COMMENT 'load balancing algorithm
used to distribbute traffic across zones', `persistence` varchar(255) NOT
NULL COMMENT 'session persistence used across the zone', `service_type`
varchar(255) NOT NULL COMMENT 'GSLB service type (tcp/udp)',
`gslb_domain_name` varchar(255) NOT NULL COMMENT 'DNS name for the GSLB service
that is used to provide a FQDN for the GSLB service', PRIMARY KEY (`id`),
CONSTRAINT `fk_global_load_ba
lancing_rules_account_id` FOREIGN KEY (`account_id`) REFERENCES
`account`(`id`) ON DELETE CASCADE, CONSTRAINT
`fk_global_load_balancing_rules_region_id` FOREIGN KEY(`region_id`) REFERENCES
`region`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2026-02-18 12:28:03,717 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE TABLE `cloud`.`global_load_balancer_lb_rule_map` ( `id` bigint
unsigned NOT NULL auto_increment, `gslb_rule_id` bigint unsigned NOT NULL,
`lb_rule_id` bigint unsigned NOT NULL, `weight` bigint unsigned NOT NULL
DEFAULT 1 COMMENT 'weight of the site in gslb', `revoke` tinyint(1) unsigned
NOT NULL DEFAULT 0 COMMENT '1 is when rule is set for Revoke', PRIMARY KEY
(`id`), UNIQUE KEY (`gslb_rule_id`, `lb_rule_id`), CONSTRAINT
`fk_gslb_rule_id` FOREIGN KEY(`gslb_rule_id`) REFERENCES
`global_load_balancing_rules`(`id`) ON DELETE CASCADE, CONSTRAINT
`fk_lb_rule_id` FOREIGN KEY(`lb_rule_id`) REFERENCES
`load_balancing_rules`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2026-02-18 12:28:04,279 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'cloud.dns.name', null, 'DNS name of the cloud for the
GSLB service')
2026-02-18 12:28:04,280 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Account Defaults',
'DEFAULT', 'management-server', 'max.account.cpus', '40', 'The default maximum
number of cpu cores that can be used for an account')
2026-02-18 12:28:04,281 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Account Defaults',
'DEFAULT', 'management-server', 'max.account.memory', '40960', 'The default
maximum memory (in MiB) that can be used for an account')`
Additionally, port 8080 is not listening on the first start of the
management service, but becomes active after a service restart. Local
deployment with MySQL 8 works without issues. We need guidance to ensure proper
HA setup with Galera and ProxySQL.
I apologize if this ticket doesn’t fully follow the usual format. I would
really appreciate any guidance or advice from the team on this issue.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
