Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22143

Problem systemctl & mariadb / mysql

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.11
    • None
    • Server
    • None

    Description

      how it's possible to get one green and one red in same time with mysqld working correctly

      [root@maria36-par.storage.criteo.prod /usr/bin]# systemctl status mysql
      ● mysql.service - LSB: start and stop MariaDB
         Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
         Active: active (running) since Fri 2020-04-03 14:56:29 UTC; 1h 8min ago
           Docs: man:systemd-sysv-generator(8)
         CGroup: /system.slice/mysql.service
                 ├─27345 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/maria36-par.pid
                 └─27664 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/my...
       
      Apr 03 14:56:44 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): User belongs to 61 groups [Domain Users,gr-xdc-usr-alllinux-chef-production-admin,gr...
      Apr 03 14:56:44 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): Check if user is in group 'gu-dba': YES
      Apr 03 14:56:44 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): User mapped as 'adminprod'
      Apr 03 15:08:32 maria36-par mysqld[27664]: pam_ldap(mariadb:auth): nslcd authentication; user=k.hodin
      Apr 03 15:08:32 maria36-par mysqld[27664]: pam_ldap(mariadb:auth): Authentication failure; user=k.hodin
      Apr 03 15:08:32 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): Opening file '/etc/security/user_map.conf'.
      Apr 03 15:08:32 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): Incoming username 'k.hodin'.
      Apr 03 15:08:32 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): User belongs to 84 groups [Domain Users,gr-xdc-usr-host-policy-jenkins-slave-admin,g...
      Apr 03 15:08:32 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): Check if user is in group 'gu-dba': YES
      Apr 03 15:08:32 maria36-par mysqld[27664]: pam_user_map(mariadb:auth): User mapped as 'adminprod'
      Hint: Some lines were ellipsized, use -l to show in full.
      [root@maria36-par.storage.criteo.prod /usr/bin]# systemctl status mariadb
       
       
      ● mariadb.service - MariaDB 10.3.11 database server
         Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
        Drop-In: /etc/systemd/system/mariadb.service.d
                 └─migrated-from-my.cnf-settings.conf, overrides.conf
         Active: failed (Result: exit-code) since Fri 2020-04-03 11:50:23 UTC; 4h 14min ago
           Docs: man:mysqld(8)
                 https://mariadb.com/kb/en/library/systemd/
       Main PID: 6903 (code=exited, status=1/FAILURE)
         Status: "Starting final batch to recover 13 pages from redo log"
       
      Apr 03 11:50:00 maria36-par systemd[1]: Starting MariaDB 10.3.11 database server...
      Apr 03 11:50:01 maria36-par mysqld[6903]: 2020-04-03 11:50:01 0 [Note] /usr/sbin/mysqld (mysqld 10.3.11-MariaDB-log) starting as process 6903 ...
      Apr 03 11:50:23 maria36-par systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
      Apr 03 11:50:23 maria36-par systemd[1]: Failed to start MariaDB 10.3.11 database server.
      Apr 03 11:50:23 maria36-par systemd[1]: Unit mariadb.service entered failed state.
      Apr 03 11:50:23 maria36-par systemd[1]: mariadb.service failed.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Aurelien_LEQUOY Aurélien LEQUOY
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.