Re: [percona-group] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) error

[Jay Janssen]

On Mar 20, 2013, at 7:35 AM, Kevin Nguyen <kevinng...@gmail.com> wrote:

Hello,

I am running Percona XtraDB Cluster with some nodes. My primary node is working fine, but my node1, 2, 3, 4 are not working as expected. They can run, but i could not log in mysql. 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) error

mysql    17225 17179  0 07:19 ?        00:00:00 sh -c wsrep_sst_rsync --role 'joiner' --address '192.168.1.68' --auth '' --datadir '/var/lib/mysql/' --d efaults-file '/etc/my.cnf' --parent '17179'

mysql    17226 17225  0 07:19 ?        00:00:00 /bin/bash -ue /usr//bin/wsrep_sst_rsync --role joiner --address 192.168.133.68 --auth  --datadir /var/lib  mysql/ --defaults-file /etc/my.cnf --parent 17179

mysql    17258     1  0 07:19 ?        00:00:00 rsync --daemon --port 4444 --config /var/lib/mysql//rsync_sst.conf

mysql    17292 17258  0 07:19 ?        00:00:00 rsync --daemon --port 4444 --config /var/lib/mysql//rsync_sst.conf

mysql    17293 17292 10 07:19 ?        00:01:07 rsync --daemon --port 4444 --config /var/lib/mysql//rsync_sst.conf

root     18027 17112  0 07:30 pts/0    00:00:00 grep --color=auto mysql

mysql    18028 17226  0 07:30 ?        00:00:00 sleep 1

You have a lot of extra rsync daemons sitting around you'll probably want to kill off.  

These error comes from error log

130319 16:57:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

130319 20:32:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/

130319 20:32:23 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.geDNJClcAF

130319 20:32:23 mysqld_safe WSREP: Failed to recover position:

130319 20:32:23 [ERROR] WSREP: Query cache is not supported (size=268435456 type=1)

130319 20:32:23 [ERROR] Aborting

The query cache is not supported in PXC, you should disable it by adding the following to your my.cnf:

query_cache_size=0

query_cache_type=0

130319  8:52:34 InnoDB: Completed initialization of buffer pool

InnoDB: Error: log file ./ib_logfile0 is of different size 0 1048576 bytes

InnoDB: than specified in the .cnf file 0 134217728 bytes!

130319  8:52:34 [ERROR] Plugin 'InnoDB' init function returned error.

130319  8:52:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

130319  8:52:34 [ERROR] Unknown/unsupported storage engine: InnoDB

130319  8:52:34 [ERROR] Aborting

This is your Innodb log files being incorrectly sized.  Delete the existing log files in your datadir (most likely in /var/lib/mysql/ib_logfile*) and then try again.

Please tell me how can i fix them. And is Percona Xtradb support MyISAM well?

Technically, yes, but you don't want it.  If Innodb is not your primary use storage engine, PXC is not right for you.

Jay Janssen, MySQL Consulting Lead, Percona

http://about.me/jay.janssen

Percona Live in Santa Clara, CA  April 22nd-25th 2013

http://www.percona.com/live/mysql-conference-2013/

[Kevin Nguyen]

Thank you, but no luck. 

On Wednesday, March 20, 2013 4:35:31 AM UTC-7, Kevin Nguyen wrote:

Hello,

I am running Percona XtraDB Cluster with some nodes. My primary node is working fine, but my node1, 2, 3, 4 are not working as expected. They can run, but i could not log in mysql. 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) error

mysql    17225 17179  0 07:19 ?        00:00:00 sh -c wsrep_sst_rsync --role 'joiner' --address '192.168.1.68' --auth '' --datadir '/var/lib/mysql/' --d efaults-file '/etc/my.cnf' --parent '17179'

mysql    17226 17225  0 07:19 ?        00:00:00 /bin/bash -ue /usr//bin/wsrep_sst_rsync --role joiner --address 192.168.133.68 --auth  --datadir /var/lib  mysql/ --defaults-file /etc/my.cnf --parent 17179

mysql    17258     1  0 07:19 ?        00:00:00 rsync --daemon --port 4444 --config /var/lib/mysql//rsync_sst.conf

mysql    17292 17258  0 07:19 ?        00:00:00 rsync --daemon --port 4444 --config /var/lib/mysql//rsync_sst.conf

mysql    17293 17292 10 07:19 ?        00:01:07 rsync --daemon --port 4444 --config /var/lib/mysql//rsync_sst.conf

root     18027 17112  0 07:30 pts/0    00:00:00 grep --color=auto mysql

mysql    18028 17226  0 07:30 ?        00:00:00 sleep 1

These error comes from error log

130319 16:57:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

130319 20:32:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/

130319 20:32:23 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.geDNJClcAF

130319 20:32:23 mysqld_safe WSREP: Failed to recover position:

130319 20:32:23 [ERROR] WSREP: Query cache is not supported (size=268435456 type=1)

130319 20:32:23 [ERROR] Aborting

130319  8:52:34 InnoDB: Completed initialization of buffer pool

InnoDB: Error: log file ./ib_logfile0 is of different size 0 1048576 bytes

InnoDB: than specified in the .cnf file 0 134217728 bytes!

130319  8:52:34 [ERROR] Plugin 'InnoDB' init function returned error.

130319  8:52:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

130319  8:52:34 [ERROR] Unknown/unsupported storage engine: InnoDB

130319  8:52:34 [ERROR] Aborting

Please tell me how can i fix them. And is Percona Xtradb support MyISAM well?

Kevin