Ubuntu
mariadb-10.0 package

MariaDB fails to update from 10.0.27 to 10.0.29

Asked by Bobby Yakovich

Need help, seems when I ran updates on mariadb it tried to update from 10.0.27 to 10.0.29 and mysql hung on shut down.
now it says 10.0.27 is not fully configured. When I try apt-get upgrade it just hangs on shutting DB down..

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu mariadb-10.0 Edit question
Assignee:
No assignee Edit question
Solved by:
Bobby Yakovich
Solved:
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#1

What is the output of:

lsb_release -a; uname -a; apt-cache policy `dpkg -l | grep -i maria | awk ('print $2'}`

Thanks

Revision history for this message
Bobby Yakovich (bgyako) said : 		#2

Sorry for delay was away, here is the output you requested.
http://pastebin.com/bCydjUna

Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#3

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04.5 LTS
Release: 14.04
Codename: trusty
Linux cwtrdb001 3.13.0-107-generic #154-Ubuntu SMP Tue Dec 20 09:57:27 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
-bash: command substitution: line 1: syntax error near unexpected token `'print $2'}'
-bash: command substitution: line 1: `dpkg -l | grep -i maria | awk ('print $2'}'
Package files:
 100 /var/lib/dpkg/status
     release a=now
 500 http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu/ trusty/main i386 Packages
     release o=MariaDB,n=trusty,l=MariaDB,c=main
     origin ftp.osuosl.org
 500 http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu/ trusty/main amd64 Packages
     release o=MariaDB,n=trusty,l=MariaDB,c=main
     origin ftp.osuosl.org
 500 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ trusty/main i386 Packages
     release o=MariaDB,n=trusty,l=MariaDB,c=main
     origin mirrors.syringanetworks.net
 500 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ trusty/main amd64 Packages
     release o=MariaDB,n=trusty,l=MariaDB,c=main
     origin mirrors.syringanetworks.net
 500 http://security.ubuntu.com/ubuntu/ trusty-security/universe Translation-en
 500 http://security.ubuntu.com/ubuntu/ trusty-security/restricted Translation-en
 500 http://security.ubuntu.com/ubuntu/ trusty-security/multiverse Translation-en
 500 http://security.ubuntu.com/ubuntu/ trusty-security/main Translation-en
 500 http://security.ubuntu.com/ubuntu/ trusty-security/multiverse i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=multiverse
     origin security.ubuntu.com
 500 http://security.ubuntu.com/ubuntu/ trusty-security/universe i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=universe
     origin security.ubuntu.com
 500 http://security.ubuntu.com/ubuntu/ trusty-security/restricted i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=restricted
     origin security.ubuntu.com
 500 http://security.ubuntu.com/ubuntu/ trusty-security/main i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=main
     origin security.ubuntu.com
 500 http://security.ubuntu.com/ubuntu/ trusty-security/multiverse amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=multiverse
     origin security.ubuntu.com
 500 http://security.ubuntu.com/ubuntu/ trusty-security/universe amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=universe
     origin security.ubuntu.com
 500 http://security.ubuntu.com/ubuntu/ trusty-security/restricted amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=restricted
     origin security.ubuntu.com
 500 http://security.ubuntu.com/ubuntu/ trusty-security/main amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-security,n=trusty,l=Ubuntu,c=main
     origin security.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/universe Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/restricted Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/multiverse Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/main Translation-en
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/multiverse i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=multiverse
     origin us.archive.ubuntu.com
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/universe i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=universe
     origin us.archive.ubuntu.com
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/restricted i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=restricted
     origin us.archive.ubuntu.com
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/main i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=main
     origin us.archive.ubuntu.com
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/multiverse amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=multiverse
     origin us.archive.ubuntu.com
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/universe amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=universe
     origin us.archive.ubuntu.com
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/restricted amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=restricted
     origin us.archive.ubuntu.com
 100 http://us.archive.ubuntu.com/ubuntu/ trusty-backports/main amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-backports,n=trusty,l=Ubuntu,c=main
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/universe Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/restricted Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/multiverse Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/multiverse i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=multiverse
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/universe i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=universe
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/restricted i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=restricted
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main i386 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=main
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/multiverse amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=multiverse
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/universe amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=universe
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/restricted amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=restricted
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty-updates,n=trusty,l=Ubuntu,c=main
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/universe Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/restricted Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/multiverse Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main Translation-en
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/multiverse i386 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=multiverse
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/universe i386 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=universe
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/restricted i386 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=restricted
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main i386 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=main
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/multiverse amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=multiverse
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/universe amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=universe
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/restricted amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=restricted
     origin us.archive.ubuntu.com
 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages
     release v=14.04,o=Ubuntu,a=trusty,n=trusty,l=Ubuntu,c=main
     origin us.archive.ubuntu.com
Pinned packages:

Revision history for this message
Bobby Yakovich (bgyako) said : 		#4

That is the output, are you asking a question?

Side note, I was able to clean up the install and reinstall mariaDB and got this node working.
The issue I am seeing now is that the second node is showing wsrep_local_state_comment = joined and wsrep_ready = off.
Should show wsrep_local_state_comment = synced and wsrep_ready=on.
Any idea why? Seems the cluster is not synced.

Revision history for this message
Bobby Yakovich (bgyako) said : 		#5

When in a state of Joined indicates that node lost connection to cluster. Takes very long time to re-sync