Uploaded image for project: 'Service Orchestrator'
  1. Service Orchestrator
  2. SO-720

so-db installation (in OOM) takes too long

XMLWordPrintable

      The installation and initialisation of the SO DB takes up to 40 minutes.
      As the liveness/readiness probe timeout is set to 450s, the SO DB is restarted doring the setup and in a corrupted state, when the SO services are started.

      In our test cloud we had to set the timeouts to 3600s to solve the problem.

      ...
      
      2018-07-13  7:37:58 140685896230848 [Note] Plugin 'FEEDBACK' is disabled.
      180713  7:37:58 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED.
      180713  7:37:58 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.180713  7:37:58 server_audit: logging started to the file //var/lib/mysql/audit.log.
      MySQL init process in progress...
      2018-07-13  7:37:58 140685896230848 [Warning] 'user' entry 'root@mariadb' ignored in --skip-name-resolve mode.
      2018-07-13  7:37:58 140685896230848 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode.
      2018-07-13  7:37:58 140685896230848 [Note] mysqld: ready for connections.
      Version: '10.1.11-MariaDB-1~jessie-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
      2018-07-13  7:37:58 140685894907648 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
      2018-07-13  7:37:58 140685894907648 [Note] WSREP: REPL Protocols: 7 (3, 2)
      2018-07-13  7:37:58 140683624490752 [Note] WSREP: Service thread queue flushed.
      2018-07-13  7:37:58 140685894907648 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
      2018-07-13  7:37:58 140683624490752 [Note] WSREP: Service thread queue flushed.
      2018-07-13  7:37:58 140685894907648 [Note] WSREP: Synchronized with group, ready for connections
      2018-07-13  7:37:58 140685894907648 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
      Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
      2018-07-13  8:07:39 140685844653824 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode./docker-entrypoint.sh: running /docker-entrypoint-initdb.d/01-load-default-sql-files.sh
      2018-07-13  8:07:40 140685844920064 [Warning] 'proxies_priv' entry '@% root@mariadb' ignored in --skip-name-resolve mode.
      2018-07-13  8:08:34 140685844920064 [Note] InnoDB: Online DDL : Start
      2018-07-13  8:08:34 140685844920064 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
      2018-07-13  8:08:34 140685844920064 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
      2018-07-13  8:08:34 140685844920064 [Note] InnoDB: Online DDL : Start applying row log
      
      ...
      2018-07-13  8:14:29 140685844920064 [Note] InnoDB: Online DDL : Start applying row log
      2018-07-13  8:14:29 140685844920064 [Note] InnoDB: Online DDL : End of applying row log
      2018-07-13  8:14:29 140685844920064 [Note] InnoDB: Online DDL : Completed
      ERROR 1146 (42S02) at line 2 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.heat_template_params' doesn't exist
      ERROR 1146 (42S02) at line 6 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.model_recipe' doesn't exist
      ERROR 1146 (42S02) at line 10 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.service' 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 1146 (42S02) at line 18 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.service_to_resource_customizations' doesn't exist
      ERROR 1146 (42S02) at line 22 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.vf_module' doesn't exist
      ERROR 1146 (42S02) at line 26 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.vnf_resource_customization' doesn't exist
      2018-07-13  8:15:10 140685844920064 [Note] InnoDB: Online DDL : Start
      2018-07-13  8:15:10 140685844920064 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
      2018-07-13  8:15:10 140685844920064 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
      2018-07-13  8:15:10 140685844920064 [Note] InnoDB: Online DDL : Start applying row log...
      2018-07-13  8:16:40 140201328891648 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
      2018-07-13  8:16:40 140201328891648 [Note] WSREP: REPL Protocols: 7 (3, 2)
      2018-07-13  8:16:40 140199060743936 [Note] WSREP: Service thread queue flushed.
      2018-07-13  8:16:40 140201328891648 [Note] WSREP: Assign initial position for certification: 7479, protocol version: 3
      2018-07-13  8:16:40 140199060743936 [Note] WSREP: Service thread queue flushed.
      2018-07-13  8:16:40 140201328891648 [Note] WSREP: Synchronized with group, ready for connections
      2018-07-13  8:16:40 140201328891648 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
      

            stevesmokowski stevesmokowski
            andreasgeissler Andreas Geissler
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: