MatthiasDrexler opened a new issue, #10068:
URL: https://github.com/apache/cloudstack/issues/10068
##### ISSUE TYPE
* Bug Report
##### COMPONENT NAME
Installation of management node
##### CLOUDSTACK VERSION
4.20.0.0
##### CONFIGURATION
- VirtualBox VM environment
##### OS / ENVIRONMENT
Rocky Linux 9.5/AlmaLinux 8.10, both with MySQL version 8.0.36
##### SUMMARY
I tried to install Cloudstack using the
[documentation](https://docs.cloudstack.apache.org/en/4.20.0.0/installguide/management-server/index.html#overview)
in a VirtualBox environment for evaluation purposes.
##### STEPS TO REPRODUCE
Follow the documentation:
- Install operating system
- Update system packages
- Install chrony
- Add repo
- Install cloudstack-management
- Install mysql on same node (with mysql_secure_installation)
- Set SELinux to permissive
- Run cloudstack-setup-databases cloud:[pw]@127.0.0.1
--deploy-as=root:[rootpw]
- Ensure config contains 127.0.0.1 as cluster ip
- Run cloudstack-setup-management
##### EXPECTED RESULTS
I would expect localhost:8080/client to show the (some kind of limited no
storage, etc.) UI.
I would either expect the database version to be 4.20.0 without the need for
database migrations, or, if lower, expect the migrations to run successfully.
##### ACTUAL RESULTS
The server recognizes that the database version (4.0.0 in the version table)
is below the application version (4.20.0.0) and runs migrations starting from
4.0.0). The migration fails when trying to add column `size` to the
`vm_templates` table since it already exists. If dropped manually, the
migration fails one step later when trying to add column `status` to the
`vm_templates` table.
If the version is altered to a higher version (tried all versions with a vm
snapshot after cloudstack-setup-management):
- 4.1.0: fails to add a column just like before
- 4.20.0: misses some prerequisites
- 4.2.0: misses some prerequisites
```
2024-12-09 10:56:29,885 INFO [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) DB version = 4.0.0 Code Version = 4.20.0.0
2024-12-09 10:56:29,885 INFO [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing Stored Procedure scripts that are under resource directory
[META-INF/db/procedures].
2024-12-09 10:56:29,886 INFO [c.c.u.FileUtil] (main:[]) (logid:) Searching
for files under resource directory [META-INF/db/procedures].
2024-12-09 10:56:29,981 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_change_column.sql].
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:29,983 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
in usage Idempotent CHANGE COLUMN
2024-12-09 10:56:29,984 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_CHANGE_COLUMN`
2024-12-09 10:56:30,050 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_CHANGE_COLUMN` ( IN in_table_name
VARCHAR(200) , IN in_column_name VARCHAR(200) , IN in_column_new_name
VARCHAR(200) , IN in_column_new_definition VARCHAR(1000) ) BEGIN
DECLARE CONTINUE HANDLER FOR 1054 BEGIN END; SET @ddl = CONCAT('ALTER TABLE ',
in_table_name); SET @ddl = CONCAT(@ddl, ' ', 'CHANGE COLUMN') ; SET @ddl =
CONCAT(@ddl, ' ', in_column_name); SET @ddl = CONCAT(@ddl, ' ',
in_column_new_name); SET @ddl = CONCAT(@ddl, ' ', in_column_new_definition);
PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt; END
2024-12-09 10:56:30,108 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/usage.idempotent_drop_index.sql].
2024-12-09 10:56:30,109 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:30,109 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:30,109 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:30,110 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:30,111 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:30,111 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
in usage
2024-12-09 10:56:30,111 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud_usage`.`IDEMPOTENT_DROP_INDEX`
2024-12-09 10:56:30,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud_usage`.`IDEMPOTENT_DROP_INDEX` ( IN in_index_name
VARCHAR(200) , IN in_table_name VARCHAR(200) ) BEGIN DECLARE CONTINUE
HANDLER FOR 1091 BEGIN END; SET @ddl = CONCAT('DROP INDEX ', in_index_name);
SET @ddl = CONCAT(@ddl, ' ', ' ON ') ; SET @ddl = CONCAT(@ddl, ' ',
in_table_name); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt;
END
2024-12-09 10:56:30,261 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_create_unique_index.sql].
2024-12-09 10:56:30,263 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:30,263 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:30,263 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:30,263 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:30,264 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_CREATE_UNIQUE_INDEX`
2024-12-09 10:56:30,342 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_CREATE_UNIQUE_INDEX` ( IN
in_index_name VARCHAR(200) , IN in_table_name VARCHAR(200) , IN
in_index_definition VARCHAR(1000) ) BEGIN DECLARE CONTINUE HANDLER FOR 1061
BEGIN END; SET @ddl = CONCAT('CREATE UNIQUE INDEX ', in_index_name); SET @ddl =
CONCAT(@ddl, ' ', ' ON ') ; SET @ddl = CONCAT(@ddl, ' ', in_table_name); SET
@ddl = CONCAT(@ddl, ' ', in_index_definition); PREPARE stmt FROM @ddl; EXECUTE
stmt; DEALLOCATE PREPARE stmt; END
2024-12-09 10:56:30,404 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/usage.idempotent_change_column.sql].
2024-12-09 10:56:30,405 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:30,405 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:30,405 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:30,405 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:30,405 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:30,405 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
in usage Idempotent CHANGE COLUMN
2024-12-09 10:56:30,406 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud_usage`.`IDEMPOTENT_CHANGE_COLUMN`
2024-12-09 10:56:30,470 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud_usage`.`IDEMPOTENT_CHANGE_COLUMN` ( IN
in_table_name VARCHAR(200) , IN in_old_column_name VARCHAR(200) , IN
in_new_column_name VARCHAR(200) , IN in_column_definition VARCHAR(1000) )
BEGIN DECLARE CONTINUE HANDLER FOR 1060 BEGIN END; SET @ddl = CONCAT('ALTER
TABLE ', in_table_name); SET @ddl = CONCAT(@ddl, ' ', ' CHANGE COLUMN') ; SET
@ddl = CONCAT(@ddl, ' ', in_old_column_name); SET @ddl = CONCAT(@ddl, ' ',
in_new_column_name); SET @ddl = CONCAT(@ddl, ' ', in_column_definition);
PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt; END
2024-12-09 10:56:30,540 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_add_key.sql].
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:30,542 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:30,543 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:30,543 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_ADD_KEY`
2024-12-09 10:56:30,605 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_ADD_KEY` ( IN in_index_name
VARCHAR(200) , IN in_table_name VARCHAR(200) , IN in_key_definition
VARCHAR(1000) ) BEGIN DECLARE CONTINUE HANDLER FOR 1061 BEGIN END; SET @ddl
= CONCAT('ALTER TABLE ', in_table_name); SET @ddl = CONCAT(@ddl, ' ', ' ADD KEY
') ; SET @ddl = CONCAT(@ddl, ' ', in_index_name); SET @ddl = CONCAT(@ddl, ' ',
in_key_definition); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE
stmt; END
2024-12-09 10:56:30,687 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_insert_guestos_hypervisor_mapping.sql].
2024-12-09 10:56:30,688 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:30,688 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,689 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:30,690 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:30,690 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:30,690 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:30,690 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:30,690 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:30,690 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_INSERT_GUESTOS_HYPERVISOR_MAPPING`
2024-12-09 10:56:30,757 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_INSERT_GUESTOS_HYPERVISOR_MAPPING`(
IN in_hypervisor_type VARCHAR(32),
IN in_hypervisor_version VARCHAR(32), IN
in_guest_os_name VARCHAR(255), IN in_guest_os_id
BIGINT(20) UNSIGNED, IN is_user_defined int(1)
UNSIGNED) BEGIN IF NOT EXISTS ((SELECT * FROM
`cloud`.`guest_os_hypervisor` WHERE
hypervisor_type=in_hypervisor_type AND
hypervisor_version=in_hypervisor_version AND guest_os_id =
in_guest_os_id)) THEN INSERT INTO
`cloud`.`guest_os_hypervisor` ( uuid,
hypervisor_type, hypervisor_version,
guest_os_name, guest_os_id,
created,
is_user_defined) VALUES (
UUID(), in_hypervisor_type,
in_hypervisor_version,
in_guest_os_name, in_guest_os_id,
utc_timestamp(), is_user_defined
); END IF; END;
2024-12-09 10:56:30,973 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_drop_index.sql].
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:30,975 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:30,976 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:30,976 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:30,976 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:30,976 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
in cloud
2024-12-09 10:56:30,976 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_DROP_INDEX`
2024-12-09 10:56:31,092 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_DROP_INDEX` ( IN in_index_name
VARCHAR(200) , IN in_table_name VARCHAR(200) ) BEGIN DECLARE CONTINUE
HANDLER FOR 1091 BEGIN END; SET @ddl = CONCAT('DROP INDEX ', in_index_name);
SET @ddl = CONCAT(@ddl, ' ', ' ON ') ; SET @ddl = CONCAT(@ddl, ' ',
in_table_name); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt;
END
2024-12-09 10:56:31,179 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/usage.idempotent_add_column.sql].
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:31,180 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
in usage
2024-12-09 10:56:31,181 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud_usage`.`IDEMPOTENT_ADD_COLUMN`
2024-12-09 10:56:31,261 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud_usage`.`IDEMPOTENT_ADD_COLUMN` ( IN in_table_name
VARCHAR(200) , IN in_column_name VARCHAR(200) , IN in_column_definition
VARCHAR(1000) ) BEGIN DECLARE CONTINUE HANDLER FOR 1060 BEGIN END; SET @ddl
= CONCAT('ALTER TABLE ', in_table_name); SET @ddl = CONCAT(@ddl, ' ', 'ADD
COLUMN') ; SET @ddl = CONCAT(@ddl, ' ', in_column_name); SET @ddl =
CONCAT(@ddl, ' ', in_column_definition); PREPARE stmt FROM @ddl; EXECUTE stmt;
DEALLOCATE PREPARE stmt; END
2024-12-09 10:56:31,324 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.add_guest_os_and_hypervisor_mapping.sql].
2024-12-09 10:56:31,325 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:31,326 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:31,327 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
PR#4699 Drop the procedure `ADD_GUEST_OS_AND_HYPERVISOR_MAPPING` if it already
exist.
2024-12-09 10:56:31,327 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`ADD_GUEST_OS_AND_HYPERVISOR_MAPPING`
2024-12-09 10:56:31,382 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
PR#4699 Create the procedure `ADD_GUEST_OS_AND_HYPERVISOR_MAPPING` to add
guest_os and guest_os_hypervisor mapping.
2024-12-09 10:56:31,383 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`ADD_GUEST_OS_AND_HYPERVISOR_MAPPING` ( IN
guest_os_category_id bigint(20) unsigned, IN guest_os_display_name
VARCHAR(255), IN guest_os_hypervisor_hypervisor_type VARCHAR(32), IN
guest_os_hypervisor_hypervisor_version VARCHAR(32), IN
guest_os_hypervisor_guest_os_name VARCHAR(255) ) BEGIN INSERT INTO
cloud.guest_os (uuid, category_id, display_name, created) SELECT UUID(),
guest_os_category_id, guest_os_display_name, now() FROM DUAL WHERE not
exists( SELECT 1 FROM cloud.guest_os
WHERE cloud.guest_os.category_id = guest_os_category_id
AND cloud.guest_os.display_name = guest_os_display_name) ; INSERT
INTO cloud.guest_os_hypervisor (uuid, hypervisor_type, hypervisor_version,
guest_os_name, guest_os_id, created) SELECT UUID(),
guest_os_hypervisor_hypervisor_type, guest_os_hyper
visor_hypervisor_version, guest_os_hypervisor_guest_os_name, guest_os.id,
now() FROM cloud.guest_os WHERE guest_os.category_id =
guest_os_category_id AND guest_os.display_name = guest_os_display_name
AND NOT EXISTS (SELECT 1 FROM
cloud.guest_os_hypervisor as hypervisor WHERE
hypervisor_type = guest_os_hypervisor_hypervisor_type
AND hypervisor_version = guest_os_hypervisor_hypervisor_version
AND hypervisor.guest_os_id = guest_os.id
AND hypervisor.guest_os_name =
guest_os_hypervisor_guest_os_name) ;END
2024-12-09 10:56:31,480 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_add_column.sql].
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:31,482 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:31,483 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:31,483 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:31,483 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:31,483 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:31,483 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
in cloud
2024-12-09 10:56:31,483 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_ADD_COLUMN`
2024-12-09 10:56:31,555 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_ADD_COLUMN` ( IN in_table_name
VARCHAR(200), IN in_column_name VARCHAR(200), IN
in_column_definition VARCHAR(1000) ) BEGIN DECLARE CONTINUE HANDLER FOR
1060 BEGIN END; SET @ddl = CONCAT('ALTER TABLE ', in_table_name); SET @ddl =
CONCAT(@ddl, ' ', 'ADD COLUMN') ; SET @ddl = CONCAT(@ddl, ' ', in_column_name);
SET @ddl = CONCAT(@ddl, ' ', in_column_definition); PREPARE stmt FROM @ddl;
EXECUTE stmt; DEALLOCATE PREPARE stmt; END
2024-12-09 10:56:31,622 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_add_unique_index.sql].
2024-12-09 10:56:31,623 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:31,624 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Idempotent ADD UNIQUE INDEX
2024-12-09 10:56:31,625 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud_usage`.`IDEMPOTENT_ADD_UNIQUE_INDEX`
2024-12-09 10:56:31,681 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud_usage`.`IDEMPOTENT_ADD_UNIQUE_INDEX` ( IN
in_table_name VARCHAR(200) , IN in_index_name VARCHAR(200) , IN
in_index_definition VARCHAR(1000) ) BEGIN DECLARE CONTINUE HANDLER FOR 1061
BEGIN END; SET @ddl = CONCAT('ALTER TABLE ', in_table_name); SET @ddl =
CONCAT(@ddl, ' ', 'ADD UNIQUE INDEX ', in_index_name); SET @ddl = CONCAT(@ddl,
' ', in_index_definition); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE
PREPARE stmt; END
2024-12-09 10:56:31,760 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_drop_foreign_key.sql].
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:31,761 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:31,762 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_DROP_FOREIGN_KEY`
2024-12-09 10:56:31,863 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_DROP_FOREIGN_KEY` ( IN
in_table_name VARCHAR(200), IN in_foreign_key_name VARCHAR(200) ) BEGIN
DECLARE CONTINUE HANDLER FOR 1091, 1025 BEGIN END; SET @ddl = CONCAT('ALTER
TABLE ', in_table_name); SET @ddl = CONCAT(@ddl, ' ', ' DROP FOREIGN KEY ');
SET @ddl = CONCAT(@ddl, ' ', in_foreign_key_name); PREPARE stmt FROM @ddl;
EXECUTE stmt; DEALLOCATE PREPARE stmt; END
2024-12-09 10:56:31,942 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Executing PROCEDURE script
[META-INF/db/procedures/cloud.idempotent_add_unique_key.sql].
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:31,943 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Idempotent ADD UNIQUE KEY
2024-12-09 10:56:31,944 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) DROP
PROCEDURE IF EXISTS `cloud`.`IDEMPOTENT_ADD_UNIQUE_KEY`
2024-12-09 10:56:31,996 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
CREATE PROCEDURE `cloud`.`IDEMPOTENT_ADD_UNIQUE_KEY` ( IN in_table_name
VARCHAR(200) , IN in_key_name VARCHAR(200) , IN in_key_definition VARCHAR(1000)
) BEGIN DECLARE CONTINUE HANDLER FOR 1061 BEGIN END; SET @ddl =
CONCAT('ALTER TABLE ', in_table_name); SET @ddl = CONCAT(@ddl, ' ', 'ADD UNIQUE
KEY ', in_key_name); SET @ddl = CONCAT(@ddl, ' ', in_key_definition); PREPARE
stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt; END
2024-12-09 10:56:32,061 INFO [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Finished execution of PROCEDURE scripts that are under resource
directory [META-INF/db/procedures].
2024-12-09 10:56:32,062 INFO [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Database upgrade must be performed from 4.0.0 to 4.20.0.0
2024-12-09 10:56:32,069 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Running upgrade Upgrade40to41 to upgrade from 4.0.0-4.1.0 to 4.1.0
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
or more contributor license agreements. See the NOTICE file
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
distributed with this work for additional information
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
regarding copyright ownership. The ASF licenses this file
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
to you under the Apache License, Version 2.0 (the
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"License"); you may not use this file except in compliance
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
with the License. You may obtain a copy of the License at
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Unless required by applicable law or agreed to in writing,
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
software distributed under the License is distributed on an
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
KIND, either express or implied. See the License for the
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
specific language governing permissions and limitations
2024-12-09 10:56:32,070 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
under the License.
2024-12-09 10:56:32,071 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --;
2024-12-09 10:56:32,071 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --
Schema upgrade from 4.0.0 to 4.1.0;
2024-12-09 10:56:32,071 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) --;
2024-12-09 10:56:32,071 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) use
cloud
2024-12-09 10:56:32,071 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) SET
foreign_key_checks = 0
2024-12-09 10:56:32,071 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:)
alter table vm_template add size bigint unsigned
2024-12-09 10:56:32,072 ERROR [c.c.u.d.ScriptRunner] (main:[]) (logid:)
Error executing: alter table vm_template add size bigint unsigned
2024-12-09 10:56:32,075 ERROR [c.c.u.d.ScriptRunner] (main:[]) (logid:)
java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
2024-12-09 10:56:32,077 ERROR [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Unable to execute upgrade script java.sql.SQLSyntaxErrorException:
Duplicate column name 'size'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:186)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:88)
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:240)
at
com.cloud.upgrade.DatabaseUpgradeChecker.executeUpgrade(DatabaseUpgradeChecker.java:361)
at
com.cloud.upgrade.DatabaseUpgradeChecker.executeUpgrades(DatabaseUpgradeChecker.java:337)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:303)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:476)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:62)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:52)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:937)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:174)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:143)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:274)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:279)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:262)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:131)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
at
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
at
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:53)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1073)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:572)
at
org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:1002)
at
org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:765)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:379)
at
org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1449)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1414)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:916)
at
org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:288)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:426)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at org.eclipse.jetty.server.Server.start(Server.java:423)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at org.eclipse.jetty.server.Server.doStart(Server.java:387)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:199)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:112)
2024-12-09 10:56:32,078 ERROR [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:246)
at
com.cloud.upgrade.DatabaseUpgradeChecker.executeUpgrade(DatabaseUpgradeChecker.java:361)
at
com.cloud.upgrade.DatabaseUpgradeChecker.executeUpgrades(DatabaseUpgradeChecker.java:337)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:303)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:476)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:62)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:52)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:937)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:174)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:143)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:274)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:279)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:262)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:131)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
at
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
at
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:53)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1073)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:572)
at
org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:1002)
at
org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:765)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:379)
at
org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1449)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1414)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:916)
at
org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:288)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:426)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at org.eclipse.jetty.server.Server.start(Server.java:423)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at org.eclipse.jetty.server.Server.doStart(Server.java:387)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:199)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:112)
Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:186)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:88)
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:240)
... 54 more
2024-12-09 10:56:32,079 DEBUG [c.c.u.d.T.Transaction] (main:[]) (logid:)
Rolling back the transaction: Time = 9 Name = Upgrade; called by
-TransactionLegacy.rollback:896-TransactionLegacy.removeUpTo:839-TransactionLegacy.close:663-DatabaseUpgradeChecker.executeUpgrade:376-DatabaseUpgradeChecker.executeUpgrades:337-DatabaseUpgradeChecker.upgrade:303-DatabaseUpgradeChecker.check:476-CloudStackExtendedLifeCycle.checkIntegrity:62-CloudStackExtendedLifeCycle.start:52-DefaultLifecycleProcessor.doStart:178-DefaultLifecycleProcessor.access$200:54-DefaultLifecycleProcessor$LifecycleGroup.start:356
2024-12-09 10:56:32,082 WARN [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:[]) (logid:) Failed to start module [system] due to: [Failed to start
bean 'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the
database].
2024-12-09 10:56:32,082 DEBUG [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:[]) (logid:) module start failure of module [system] was due to:
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:181)
at
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:937)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:174)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:143)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:274)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:279)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:262)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:131)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
at
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
at
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:53)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1073)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:572)
at
org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:1002)
at
org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:765)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:379)
at
org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1449)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1414)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:916)
at
org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:288)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:426)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at org.eclipse.jetty.server.Server.start(Server.java:423)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at org.eclipse.jetty.server.Server.doStart(Server.java:387)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:199)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:112)
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
upgrade the database
at
com.cloud.upgrade.DatabaseUpgradeChecker.executeUpgrade(DatabaseUpgradeChecker.java:374)
at
com.cloud.upgrade.DatabaseUpgradeChecker.executeUpgrades(DatabaseUpgradeChecker.java:337)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:303)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:476)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:62)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:52)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
... 47 more
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
execute upgrade script
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:246)
at
com.cloud.upgrade.DatabaseUpgradeChecker.executeUpgrade(DatabaseUpgradeChecker.java:361)
... 53 more
Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:186)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:88)
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:240)
... 54 more
2024-12-09 10:56:32,082 DEBUG [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:[]) (logid:) Trying to obtain module [core] context.
2024-12-09 10:56:32,082 DEBUG [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:[]) (logid:) Trying to load module [core] context.
```
--
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]
