Hi Joy!

On Fri, Dec 25, 2015 at 6:33 AM, Joy Bhattacherjee <joy.bhattacherjee@gmail.com> wrote:

.. cut .. 

This is reflected in my configuration as:

[mysqld]

datadir = /datadrive/galera/mysql 

socket = /datadrive/galera/mysql/mysql.sock 

You also need to set socket for your client tools. (mysqladmin --print-defaults)

$ mysqladmin --help | grep -A2 ^Default

Default options are read from the following files in the given order:

/etc/my.cnf ~/.my.cnf 

The following groups are read: mysqladmin client client-server client-mariadb

Best,

Nirbhay

 

Issue:

--------

Coming to the issue at hand;

When starting the primary component  through:

$ sudo service mysql bootstrap

or,

$ sudo service mysqld start --wsrep-new-cluster

( Essentially same, as bootstrap differs to start --wsrep_new_cluster )

The bootstrap sequence correctly calls mysqldsafe, as below

/usr/bin/mysqld_safe --datadir=/datadrive/galera/mysql --pid-file=/datadrive/galera/mysql/ciq-test-db01.pid --wsrep-new-cluster

However,

it then gets stuck in the wait_for_ready() function of /etc/init.d/mysql

The sequence tries to ping mysqladmin through:

 if $bindir/mysqladmin ping >/dev/null 2>&1; then

   log_success_msg

   return 0

elif kill -0 $! 2>/dev/null ; then

  :  # mysqld_safe is still running

else

  # mysqld_safe is no longer running, abort the wait loop

  break

It gets stuck here as the test:

 if $bindir/mysqladmin ping >/dev/null 2>&1; then

Always fails and the counter keeps increasing till 900 and Error's out with the

log_failure_msg

return 1

Test:

I tested that line from the console as:

$mysqladmin ping >dev/null 2>&1

and, was thrown the following error:

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")'

Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Obviously, '/var/lib/mysql' does not exist in my setup, and the socket file was at '/datadrive/galera/mysql/mysql.sock'

But, my socket can be passed explicitly to mysqladmin by doing,

$mysqladmin --socket=/datadrive/galera/mysql/mysql.sock ping

This actually worked as expected and I got the desired output,

mysqld is alive

Solution:

-----------

What I surmised through my novice abilities was that the init script was not passing the variables it read from /etc/my.cnf.d/server.cnf to mysqladmin

So, for now I have done a hackjob by altering the init script function wait_for_ready() with the test:

if $bindir/mysqladmin --socket=/datadrive/galera/mysql/mysql.sock ping >/dev/null 2>&1; then

  log_success_msg

  return 0

And voila, 

$ sudo service mysql start

$ sudo service mysql start --wsrep-new-cluster

$ sudo service mysql bootstrap

All above works. It is evident that I should be passing all the variables from /etc/my.cnf.d/server.cnf that mysqladmin needs to set it's environement correctly.

However I think that this could be / should be done on the pre-distributed init script itself rather than a user-side hack.

While I have tried to be thorough in my inspection of the issue, I may have missed either something very basic or inherently complex that's currently is inherent to the process of initializing the mysql service. Please redirect me to a corrected course if that is the case.

P.S. First time post in the list, I may have stated things unacceptably

P.P.S. Merry Christmas to you all.

Thanks and regards,

Joy Bhattacherjee

Mob: +91-9011235028

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp