Comment 3 for bug 1231110

Revision history for this message
markus_albe (markus-albe) wrote :

There is some part of this which is not fixed, because the "mysql" user can't start with

[root@percona1 ~]# cat /etc/my.cnf |egrep "flush|numa"
flush_caches=1
numa_interleave=1

[root@percona1 ~]# id
uid=0(root) gid=0(root) groups=0(root)

[root@percona1 ~]# /etc/init.d/mysql start
Starting MySQL (Percona Server)..... SUCCESS!

[root@percona1 ~]# /etc/init.d/mysql stop
Shutting down MySQL (Percona Server)... SUCCESS!

[root@percona1 ~]# su - mysql

# as "mysql" user:

-bash-4.1$ cat /etc/my.cnf |egrep "flush|numa"
flush_caches=1
numa_interleave=1

-bash-4.1$ id
uid=497(mysql) gid=498(mysql) groups=498(mysql)

-bash-4.1$ /etc/init.d/mysql stop
 ERROR! MySQL (Percona Server) PID file could not be found!

-bash-4.1$ /etc/init.d/mysql start
Starting MySQL (Percona Server). ERROR! The server quit without updating PID file (/var/lib/mysql/percona1.pid).

-bash-4.1$ logout
[root@percona1 ~]# vi /etc/my.cnf
[root@percona1 ~]# cat /etc/my.cnf |egrep "flush|numa"
flush_caches
numa_interleave

[root@percona1 ~]# id
uid=0(root) gid=0(root) groups=0(root)

[root@percona1 ~]# /etc/init.d/mysql start
Starting MySQL (Percona Server)..... SUCCESS!

[root@percona1 ~]# /etc/init.d/mysql stop
Shutting down MySQL (Percona Server).. SUCCESS!

# as mysql user; now succeeds:
[root@percona1 ~]# su - mysql

-bash-4.1$ /etc/init.d/mysql start
Starting MySQL (Percona Server).. SUCCESS!
-bash-4.1$