problem w/HA mysql toolkit @ SGLX 11.18.06

[Panos Agoros]

Hi!


I have a problem with mysql toolkit on SGLX 11.18.06:

-mysql when started manually works fine.

-when I try to start the mysql package, startup completion is reported as succesful, but it is not. I've been through the toolkit's README a lot of times and I consider I did all configuration correctly. As a matter of fact, I compared the configuration files/scripts with those of another cluster at the same site (11.16 though), and except some minor changes as per the version, everything else config-like is similar.Mysql log doesn't offer any evidence to help pinpoint the problem.

-evidence of the problem is located in the package error log. Please find the errors below:

Aug 27 12:58:23 - ERROR: Function start_myssql_server: mysql failed to create PID file /var/lib/mysql/mysql_db.pid
Aug 27 12:58:23 - ERROR: Function start_mysql_server: Failed to start HA MySQL daemons.
Aug 27 12:58:23 - Please check Mysql log files for more details.
Aug 27 12:58:23 - Node "augustus": Stopping MySQL daemons
Aug 27 12:58:23 - ERROR: Function stop_mysql_server: The /var/lib/mysql/mysql_db.pid does not exist.
Aug 27 12:58:23 - ERROR: Function stop_mysql_server: Failed to stop MySQL daemons

- I have tried with different PID_FILE filenames/locations without success. I have made sure that this is not a problem of file rights.

I am not familiar with mysql and I acknowledge it might be something simple that I overlooked... Does somebody has any possible clue?

thank you very much for your time!

Panos

[Steven E. Protter]

Shalom,

Aug 27 12:58:23 - ERROR: Function start_myssql_server: mysql failed to create PID file /var/lib/mysql/mysql_db.pid

Check permissions and what is in /var/lib/mysql

Check the scripts for compatible floating ip addresses.

Check access to shared storage if in use.

SEP

[Panos Agoros]

Hi,

all those checks are done. Mysql starts manually ok. The IP is good because before the toolkit integration, the package was coming up and the IP was reachable.

thanks

Panos

[Panos Agoros]

With the help of a colleague we fixed the problem! FYI:

=========================================================
PROBLEM:
=========================================================
Aug 27 12:58:23 - ERROR: Function start_myssql_server: mysql

failed to create PID file /var/lib/mysql/mysql_db.pid
Aug 27 12:58:23 - ERROR: Function start_mysql_server: Failed to

start HA MySQL daemons.
Aug 27 12:58:23 - Please check Mysql log files for more details.
Aug 27 12:58:23 - Node "augustus": Stopping MySQL daemons
Aug 27 12:58:23 - ERROR: Function stop_mysql_server: The

/var/lib/mysql/mysql_db.pid does not exist.
Aug 27 12:58:23 - ERROR: Function stop_mysql_server: Failed to

stop MySQL daemons

=========================================================
FIX:
=========================================================
-Edit hamysql.sh.
-Increase STARTUP_RETRIES to 40 instead of default 10.
-@ function start_mysql_server, add a sleep 5:


#Check if the pid file is ready
counter=5
while :; do
if [ -f $PID_FILE ]; then
break
else
if [ $counter -ge $STARTUP_RETRIES ]; then
echo "$(date '+%b %e %T') - ERROR: Function

start_myssql_server: mysql failed to create PID file $PID_FI\
LE"
check_return 1 1
else
================>sleep 5 <=========================
let counter="$counter+1"
fi
fi
done

[Panos Agoros]

See the last reply.