MariaDB 5.5.27 breaks install and upgrade because of its mytop related bug

You need to kill all those hanging barracuda processes to prevent removing MariaDB, as there is a critical bug in this recent version: #1778712: mariadb-client-5.5.27 upgrade leaves MariaDB unstartable

Then remove mytop with apt-get remove mytop, apt-get purge mytop, rm -f /usr/bin/mytop and try to run barracuda up again - it will complain about two pid files - delete them and run barracuda up again to complete the upgrade.

You may need to run dpkg --configure -a if it will fail to delete mytop. Only when mytop is deleted, you will be able to complete MariaDB upgrade.

np

Thanks Omega for you help also.

followed omega8cc suggestions.
ran barracuda stable-update again.
aptitude full-update ran fine.

now froze up at "Restarting Redis and PHP-FPM, reloading Nginx."

Success

rm boa_wait.pid & boa_run.pid (again)
run dpkg --configure -a
run barracuda-upstable again (now completes full process)

my logs listed a missing pid for phpFPM

Changing the title to help others find the issue.

We have added a hot-fix also in BOA-2.0.3 stable, since 2.0.4 is not yet available and it is a critical issue.

Tried another BOA 2.03 stable upgrade
Still had an issue with the upgrade script freezing up at "Restarting Redis and PHP-FPM, reloading Nginx."

same as before, after
rm boa_wait.pid & boa_run.pid (again)
run dpkg --configure -a

run barracuda-upstable again (now completes full process)

Experiencing the same issue on our server today.

Per the thread we have:

1. Killed the hanging boa_wait.pid
2. Removed mytop with apt-get remove mytop, apt-get purge mytop and rm -f /usr/bin/mytop
3. Ran dpkg --configure -a
4. Ran run barracuda up again
5. Scripts run but stops with MariaDB server not running!
6. Checking of /var/backups/barracuda-upgrade-120917-1714.log shows no errors -- posted file here http://pastebin.com/K4uE5CnX
7. Trying to start mysql manually by service mysql force-reload gives the following result:
   

   Reloading MariaDB database server: mysqld/usr/bin/mysqladmin: connect to server at 'localhost' failed
   error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
   Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Advise of suggestions please.

Thank you
Hg

Looked at #1553166: How does one restart services like MariaDB on the BOA system? and see that there /etc/mysql/my.cnf contains :

lc_messages_dir         = /usr/share/mysql
lc_messages             = en_US

Tried to remove both lines and restart with same error message. as #8.

Running tail -f /var/log/syslog | grep mysql results in:

Sep 17 18:15:55 server mysqld: ??:0(??)[0xb6ce8955]
Sep 17 18:15:55 server mysqld: ??:0(??)[0xb69565ee]
Sep 17 18:15:55 server mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Sep 17 18:15:55 server mysqld: information that should help you find out what is causing the crash.
Sep 17 18:15:55 server mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Sep 17 18:16:06 server /etc/init.d/mysql[22745]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 17 18:16:06 server /etc/init.d/mysql[22745]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 17 18:16:06 server /etc/init.d/mysql[22745]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 17 18:16:06 server /etc/init.d/mysql[22745]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 17 18:16:06 server /etc/init.d/mysql[22745]: 

Running tail -f /var/log/syslog | grep mysql at the same time as service mysql start results in http://pastebin.com/wLarEnZc

Help please.

mysql -V == mysql Ver 15.1 Distrib 5.5.27-MariaDB, for debian-linux-gnu (i686) using readline 5.1

@matsav That hanging php-fpm restart during upgrade is a separate issue - please open a new issue to avoid confusion here. Thanks.

@HyperGlide We have introduced a working workaround to this MariaDB bug, so this issue is fixed. Please open separate support request and attach there all logs/files required, as listed in the submission guidelines. Thanks.

New issues added at #1786572: MariaDB 5.5.27 -- Reloading MariaDB database server: mysqld/usr/bin/mysqladmin: connect to server at 'localhost' failed.

New issue added for missing pid for phpFPM / freeze at "Restarting Redis and PHP-FPM, reloading Nginx"
https://drupal.org/node/1788452
Thanks omega8.cc