ERROR 1047 (08S01) Unknown Command

[jon]

Hello

I have set up galera 0.7.6 using the debian packages on two lenny
installations and started them up.

The initial sync seems to have worked - or at least as far as I can
tell (more on that in a moment) but now almost every mysql command run
on the "slave" machine returns "ERROR 1047 (08S01) Unknown Command.

I can run SHOW PROCESSLIST and SHOW DATABASES but not, for example,
USE [DBNAME} or any SELECTs. I am logged in as root.

The "Master" machine is fine, and running commands on the master
results in entries in the slaves syslog, so I presume it is syncing.

Can anyone help me?

Many thanks in advance
Jon

[seppo....@codership.com]

Jon,

Your second node (slave as you call it here) has not joined
successfully with the "master" node. If you look in the wsrep_ready
status variable, it probably has value OFF (.e.g. by: show status like
'wsrep%').

Problem may be in connectivity or access control, the joining node
must receive mysqldump from one active cluster node and sometimes this
process is blocked for some reason. The mysql error log should give
some hints of what has gone wrong in the joining process.

Pay attention to the 'wsrep_sst_receive_address' configuration
variable in the slave node. It should tell the mysqld listen address
of the joining node.

Regards, Seppo

[Jon Vile]

Quoting jon <jonn...@gmail.com>:

Hello Seppo

Many thanks! The issue was connectivity, which has now been resolved and everthing looks like it's working fine.

Jon
 

[jdf]

I waited a while and eventually it would rejoin and operate normally. It seems to not answer until everything is in sync - which is good for proxy failover.

On Saturday, July 28, 2012 6:58:51 AM UTC-5, MATkit wrote:

Hi Jon,

Can you kindly tell how you check and solve your connectivity problem. Because i also have the same problem, it is very strange as no firewall is running on both servers.

Kindly help,

Thanks

MATkit