run mariadb script manually, output with below error. And the values of service table in mso_catalog database are mismatch with the columns
root@mariadb:/docker-entrypoint-initdb.d# sh 01-load-default-sql-files.sh ERROR 1396 (HY000) at line 10 in file: '../../camunda/mariadb_engine_7.6.0.sql': Operation CREATE USER failed for 'camunda'@'%' ERROR 1146 (42S02) at line 2 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.heat_template' doesn't exist ERROR 1146 (42S02) at line 6 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.heat_template_params' doesn't exist ERROR 1146 (42S02) at line 10 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.model_recipe' doesn't exist ERROR 1146 (42S02) at line 14 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.service_recipe' doesn't exist ERROR 1136 (21S01) at line 17: Column count doesn't match value count at row 1 ERROR 1136 (21S01) at line 23: Column count doesn't match value count at row 1 ERROR 1452 (23000) at line 29: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 30: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 31: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 32: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 33: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 34: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 35: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 36: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 37: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 38: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 39: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 40: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 41: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 42: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 43: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 44: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 45: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 46: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 47: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 48: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 49: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 50: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 51: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 52: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1452 (23000) at line 53: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`)) ERROR 1136 (21S01) at line 65: Column count doesn't match value count at row 1 ERROR 1136 (21S01) at line 71: Column count doesn't match value count at row 1 root@mariadb:/docker-entrypoint-initdb.d# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) root@mariadb:/docker-entrypoint-initdb.d# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 69143 Server version: 10.1.11-MariaDB-1~jessie mariadb.org binary distribution
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | camundabpmn | | information_schema | | mso_catalog | | mso_requests | | mysql | | performance_schema | +--------------------+ 6 rows in set (0.00 sec)
MariaDB [(none)]> use mso_catalog; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed MariaDB [mso_catalog]> select * from service; +----+-------------------------+--------------+-------------+-------------------------------------------------------------+-----------------+-------------+---------------------+--------------------------------------+ | id | SERVICE_NAME_VERSION_ID | SERVICE_NAME | VERSION_STR | DESCRIPTION | SERVICE_VERSION | HTTP_METHOD | CREATION_TIMESTAMP | MODEL_INVARIANT_UUID | +----+-------------------------+--------------+-------------+-------------------------------------------------------------+-----------------+-------------+---------------------+--------------------------------------+ | 4 | MANUAL_RECORD | VID_DEFAULT | 1.0 | Default service for VID to use for infra APIH orchestration | NULL | NULL | 2017-09-28 14:25:57 | MANUAL_RECORD | | 5 | MANUAL_RECORD | * | 1.0 | Default service to use for infra APIH orchestration | NULL | NULL | 2017-09-28 14:25:57 | MANUAL_RECORD | | 11 | vfw-service | 1.0 | VFW service | 2e34774e-715e-4fd5-bd09-7b654622f35i | NULL | NULL | 2016-11-14 13:04:07 | 585822c7-4027-4f84-ba50-e9248606f112 | +----+-------------------------+--------------+-------------+-------------------------------------------------------------+-----------------+-------------+---------------------+--------------------------------------+ 3 rows in set (0.00 sec)
run mariadb script manually, output with below error. And the values of service table in mso_catalog database are mismatch with the columns
root@mariadb:/docker-entrypoint-initdb.d# sh 01-load-default-sql-files.sh
ERROR 1396 (HY000) at line 10 in file: '../../camunda/mariadb_engine_7.6.0.sql': Operation CREATE USER failed for 'camunda'@'%'
ERROR 1146 (42S02) at line 2 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.heat_template' doesn't exist
ERROR 1146 (42S02) at line 6 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.heat_template_params' doesn't exist
ERROR 1146 (42S02) at line 10 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.model_recipe' doesn't exist
ERROR 1146 (42S02) at line 14 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.service_recipe' doesn't exist
ERROR 1136 (21S01) at line 17: Column count doesn't match value count at row 1
ERROR 1136 (21S01) at line 23: Column count doesn't match value count at row 1
ERROR 1452 (23000) at line 29: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 30: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 31: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 32: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 33: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 34: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 35: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 36: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 37: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 38: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 39: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 40: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 41: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 42: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 43: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 44: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 45: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 46: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 47: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 48: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 49: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 50: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 51: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 52: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1452 (23000) at line 53: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`heat_template_params`, CONSTRAINT `FK_8sxvm215cw3tjfh3wni2y3myx` FOREIGN KEY (`HEAT_TEMPLATE_ID`) REFERENCES `heat_template` (`id`))
ERROR 1136 (21S01) at line 65: Column count doesn't match value count at row 1
ERROR 1136 (21S01) at line 71: Column count doesn't match value count at row 1
root@mariadb:/docker-entrypoint-initdb.d# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root@mariadb:/docker-entrypoint-initdb.d# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 69143
Server version: 10.1.11-MariaDB-1~jessie mariadb.org binary distribution
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| camundabpmn |
| information_schema |
| mso_catalog |
| mso_requests |
| mysql |
| performance_schema |
+--------------------+
6 rows in set (0.00 sec)
MariaDB [(none)]> use mso_catalog;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mso_catalog]> select * from service;
+----+-------------------------+--------------+-------------+-------------------------------------------------------------+-----------------+-------------+---------------------+--------------------------------------+
| id | SERVICE_NAME_VERSION_ID | SERVICE_NAME | VERSION_STR | DESCRIPTION | SERVICE_VERSION | HTTP_METHOD | CREATION_TIMESTAMP | MODEL_INVARIANT_UUID |
+----+-------------------------+--------------+-------------+-------------------------------------------------------------+-----------------+-------------+---------------------+--------------------------------------+
| 4 | MANUAL_RECORD | VID_DEFAULT | 1.0 | Default service for VID to use for infra APIH orchestration | NULL | NULL | 2017-09-28 14:25:57 | MANUAL_RECORD |
| 5 | MANUAL_RECORD | * | 1.0 | Default service to use for infra APIH orchestration | NULL | NULL | 2017-09-28 14:25:57 | MANUAL_RECORD |
| 11 | vfw-service | 1.0 | VFW service | 2e34774e-715e-4fd5-bd09-7b654622f35i | NULL | NULL | 2016-11-14 13:04:07 | 585822c7-4027-4f84-ba50-e9248606f112 |
+----+-------------------------+--------------+-------------+-------------------------------------------------------------+-----------------+-------------+---------------------+--------------------------------------+
3 rows in set (0.00 sec)