store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Sat Oct 19, 2019 6:18 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Issue with mariadb update
Unread postPosted: Mon Oct 14, 2013 4:53 am 
Offline
New Forum User
New Forum User

Joined: Mon Oct 14, 2013 3:57 am
Posts: 3
Location: Germany
Hello,
a while ago I setup a new Server with Centos 6.4 and mariadb 5.5.29
Now I tried to update to mariadb 5.5.32
But /etc/init.d/mysqld restart always fails with:
131014 09:49:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131014 09:49:56 mysqld_safe WSREP: Running position recovery with --log_error= --pid-file=/var/lib/mysql/myserver.de-recover.pid
131014 9:49:56 [ERROR] WSREP: Query cache is not supported (size=268435456 type=1)
131014 09:50:09 mysqld_safe WSREP: Failed to recover position:''

I have no Cluster or something. Selinux is on, which worked fine all the time.

I even tried to dump all databases and completly remove mariadb and do a fresh install. Same error.


Top
 Profile  
Reply with quote  
 Post subject: Re: Issue with mariadb update
Unread postPosted: Mon Oct 14, 2013 10:07 am 
Offline
New Forum User
New Forum User

Joined: Mon Oct 14, 2013 3:57 am
Posts: 3
Location: Germany
I now cloned the machine, so I can test without worrying about downtimes.
Turns out that SELinux is the issue. If I run setenforce 0, I can do /etc/init.d/mysqld start
mariadb 5.5.29 works with SELinux, so I wonder why 5.5.32 doesn't?

I ran:
sealert -a /var/log/audit/audit.log > /root/whatswrong

And did:
grep chown /var/log/audit/audit.log | audit2allow -M chown
semodule -i chown.pp
grep mysqld /var/log/audit/audit.log | audit2allow -M mysqld
semodule -i mysqld.pp
grep rm /var/log/audit/audit.log | audit2allow -M rm
semodule -i rm.pp
grep mktemp /var/log/audit/audit.log | audit2allow -M mktemp
semodule -i mktemp.pp

This works for now on the testing machine. But I'm not sure if this is to permissive?


Top
 Profile  
Reply with quote  
 Post subject: Re: Issue with mariadb update
Unread postPosted: Mon Oct 14, 2013 11:40 am 
Offline
Forum Regular
Forum Regular

Joined: Tue Aug 01, 2006 2:45 pm
Posts: 573
Location: Netherlands
Are you sure you haven't installed the cluster version?
# rpm -qa | grep -i galera

And haven't configured any cluster settings?
# grep -rin wsrep /etc/my*

If both commands yield no output, you have not.

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
 Post subject: Re: Issue with mariadb update
Unread postPosted: Tue Oct 15, 2013 3:00 am 
Offline
New Forum User
New Forum User

Joined: Mon Oct 14, 2013 3:57 am
Posts: 3
Location: Germany
prupert wrote:
Are you sure you haven't installed the cluster version?
# rpm -qa | grep -i galera

And haven't configured any cluster settings?
# grep -rin wsrep /etc/my*

If both commands yield no output, you have not.


Both show no output.
rpm -qa | grep maria shows:

mariadb-libs-5.5.32-12.el6.art.x86_64
mariadb-5.5.32-12.el6.art.x86_64
mariadb-server-5.5.32-12.el6.art.x86_64

And as said, 5.5.29-11 worked with SELinux (enforcing, targeted) without changing any policy.

Here my my.cnf:
Code:
[client]
default-character-set= utf8
[mysql]
default-character-set= utf8

[mysqld]
user=mysql
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
tmpdir=/tmp
query_cache_type=1
query_cache_limit=10M
query_cache_min_res_unit=1K
query_cache_size=256M
table_cache=500
max_connections=300
performance_schema=off
symbolic-links=0
max_heap_table_size=512M
tmp_table_size=512M
skip-name-resolve
thread_cache_size=10

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Confs in my.cnf.d are untouched.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group