zidz commented on issue #12460:
URL: https://github.com/apache/cloudstack/issues/12460#issuecomment-3767408536
I now found the missing procedure so I can add it:
It's in
`engine/schema/src/main/resources/META-INF/db/schema-42010to42100.sql`
```
DROP PROCEDURE IF EXISTS `cloud`.`INSERT_EXTENSION_IF_NOT_EXISTS`;
CREATE PROCEDURE `cloud`.`INSERT_EXTENSION_IF_NOT_EXISTS`(
IN ext_name VARCHAR(255),
IN ext_desc VARCHAR(255),
IN ext_path VARCHAR(255)
)
BEGIN
IF NOT EXISTS (
SELECT 1 FROM `cloud`.`extension` WHERE `name` = ext_name
) THEN
INSERT INTO `cloud`.`extension` (
`uuid`, `name`, `description`, `type`,
`relative_path`, `path_ready`,
`is_user_defined`, `state`, `created`, `removed`
)
VALUES (
UUID(), ext_name, ext_desc, 'Orchestrator',
ext_path, 1, 0, 'Enabled', NOW(), NULL
)
; END IF
;END;
```
This should be added by cloudstack at some point and should not need to be
manually added.
I have the following procedures available now, before I'm trying to fix any
issues:
```
MariaDB [(none)]> show procedure status where Db='cloud';
+-------+----------------------------------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db | Name | Type | Definer
| Modified | Created | Security_type | Comment |
character_set_client | collation_connection | Database Collation |
+-------+----------------------------------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| cloud | ADD_GUEST_OS_AND_HYPERVISOR_MAPPING | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_ADD_COLUMN | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_ADD_FOREIGN_KEY | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_ADD_KEY | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_ADD_UNIQUE_KEY | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_CHANGE_COLUMN | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_CREATE_UNIQUE_INDEX | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_DROP_FOREIGN_KEY | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_DROP_INDEX | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_DROP_UNIQUE_KEY | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_INSERT_GUESTOS_HYPERVISOR_MAPPING | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
| cloud | IDEMPOTENT_UPDATE_API_PERMISSION | PROCEDURE | cloud@%
| 2026-01-19 10:28:49 | 2026-01-19 10:28:49 | DEFINER | | utf8mb4
| utf8mb4_general_ci | utf8mb4_general_ci |
+-------+----------------------------------------------+-----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
12 rows in set (0.002 sec)
```
--
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]
