zidz commented on issue #12460:
URL: https://github.com/apache/cloudstack/issues/12460#issuecomment-3767490547
Fixing the next missing procedure:
```
2026-01-19 10:56:33,565 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) CALL
`cloud`.`INSERT_EXTENSION_IF_NOT_EXISTS`('MaaS', 'Baremetal Extension for
Canonical MaaS written in Python', 'Ma
aS/maas.py')
2026-01-19 10:56:33,567 DEBUG [c.c.u.d.ScriptRunner] (main:[]) (logid:) CALL
`cloud`.`INSERT_EXTENSION_DETAIL_IF_NOT_EXISTS`('MaaS',
'orchestratorrequirespreparevm', 'true', 0)
2026-01-19 10:56:33,570 ERROR [c.c.u.d.ScriptRunner] (main:[]) (logid:)
Error executing: CALL `cloud`.`INSERT_EXTENSION_DETAIL_IF_NOT_EXISTS`('MaaS',
'orchestratorrequirespreparevm', 'true'
, 0)
2026-01-19 10:56:33,570 ERROR [c.c.u.d.ScriptRunner] (main:[]) (logid:)
java.sql.SQLSyntaxErrorException: PROCEDURE
cloud.INSERT_EXTENSION_DETAIL_IF_NOT_EXISTS does not exist
2026-01-19 10:56:33,571 ERROR [c.c.u.DatabaseUpgradeChecker] (main:[])
(logid:) Unable to execute upgrade script java.sql.SQLSyntaxErrorException:
PROCEDURE cloud.INSERT_EXTENSION_DETAIL_IF
_NOT_EXISTS does not exist
```
Procedure also found in:
`engine/schema/src/main/resources/META-INF/db/schema-42010to42100.sql`
```
DROP PROCEDURE IF EXISTS `cloud`.`INSERT_EXTENSION_DETAIL_IF_NOT_EXISTS`;
CREATE PROCEDURE `cloud`.`INSERT_EXTENSION_DETAIL_IF_NOT_EXISTS`(
IN ext_name VARCHAR(255),
IN detail_key VARCHAR(255),
IN detail_value TEXT,
IN display TINYINT(1)
)
BEGIN
DECLARE ext_id BIGINT
; SELECT `id` INTO ext_id FROM `cloud`.`extension` WHERE `name` = ext_name
LIMIT 1
; IF NOT EXISTS (
SELECT 1 FROM `cloud`.`extension_details`
WHERE `extension_id` = ext_id AND `name` = detail_key
) THEN
INSERT INTO `cloud`.`extension_details` (
`extension_id`, `name`, `value`, `display`
)
VALUES (
ext_id, detail_key, detail_value, display
)
; END IF
;END;
```
--
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]
