Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-10597

mysql : Dependency Mysql_datadir[/var/lib/mysql] has failures

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: mysql
    • Labels:
    • Template:
      MODULES Bug Template
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      Basic Info
      Module Version: 10.4.0
      Puppet Version: 5
      OS Name/Version: Centos 7.7

      I am trying to install percona-server-8 with mysql module. Tested the same behavior with percona-5.7  and mysql 5.7 there is no issue but when I try to configure the mysql with percona-8 or mysql8 I get this errors:

      Info: Applying configuration version '1584547261'
      Notice: /Stage[main]/Mysql::Server::Service/Service[mysqld]: Dependency Mysql_datadir[/var/lib/mysql] has failures: true
      Warning: /Stage[main]/Mysql::Server::Service/Service[mysqld]: Skipping because of failed dependencies
      Notice: /Stage[main]/Mysql::Server::Service/Exec[wait_for_mysql_socket_to_open]: Dependency Mysql_datadir[/var/lib/mysql] has failures: true
      Warning: /Stage[main]/Mysql::Server::Service/Exec[wait_for_mysql_socket_to_open]: Skipping because of failed dependencies
      Notice: /Stage[main]/Mysql::Server::Root_password/Exec[remove install pass]: Dependency Mysql_datadir[/var/lib/mysql] has failures: true
      Warning: /Stage[main]/Mysql::Server::Root_password/Exec[remove install pass]: Skipping because of failed dependencies

      ...

      Error: Could not find a suitable provider for mysql_datadir

       

      I tried to remove /var/lib/mysql and then run "/usr/sbin/mysqld --initialize-insecure" after that I run again puppet apply but got the same error.

       

      Here is and my hierra sample configuration:

      mysql::client::package_name: 'percona-server-server'
      mysql::server::config_file: '/etc/my.cnf'
      mysql::server::create_root_my_cnf: true
      mysql::server::create_root_user: true
      mysql::server::includedir: '/etc/my.cnf.d'
      mysql::server::package_name: 'percona-server-client'
      mysql::server::purge_conf_dir: true
      mysql::server::remove_default_accounts: true
      mysql::server::restart: true
      mysql::server::service_name: 'mysqld'
      mysql::server::service_provider: systemd

      mysql::server::override_options:
      mysqld:
      datadir: '/var/lib/mysql'
      bind-address: '0.0.0.0'
      binlog_format: 'MIXED'
      default-storage-engine: 'innodb'
      expire_logs_days: 3
      innodb_buffer_pool_size: ~
      innodb_flush_method: 'O_DIRECT'
      innodb_log_buffer_size: '32M'
      log-bin: '/var/lib/mysql/binlog'
      log-error: '/var/log/mysqld.log'
      long_query_time: 1
      max_allowed_packet: '64M'
      max_connections: 600
      pid-file: ~
      server_id: "%{mysql_server_id}"
      skip-log-bin: ~
      skip-name-resolve: 1
      slow_query_log_file: '/var/log/mysql/log-slow-queries.log'
      slow_query_log: 1
      sql_mode: 'NO_ENGINE_SUBSTITUTION'
      symbolic-links: 0
      table_open_cache: 8192
      thread_cache_size: 256
      default-authentication-plugin: 'mysql_native_password'
      mysqld_safe:
      log-error: '/var/log/mysqld.log'
      pid-file: '/var/run/mysqld/mysqld.pid'

       

      The same configuration works fine with mysql5.7 and percona 5.7.

       

      Desired Behavior:

      Actual Behavior:

       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sheena Sheena Tharakanparampil
              Reporter:
              s_kolew Svetozar Kolev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Zendesk Support