[MDEV-22143] Problem systemctl & mariadb / mysql Created: 2020-04-03  Updated: 2020-04-03

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3.11
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Aurélien LEQUOY Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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.


Generated at Thu Feb 08 09:12:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.