List:General Discussion« Previous MessageNext Message »
From:Hans Scheffers Date:November 14 2013 4:22pm
Subject:FW: MySQL Problems
View as plain text  




Hi,


We
 are running on opensuse that defaults to a mariadb instead of mysql 
install, so we were running icinga 1.9.2 / idoutils 1.9.2 on a opensuse 
ppc system, with mariadb 5.5.33. This generated a lot of errors in de 
database (with restarts):

InnoDB: Assertion failure in thread 70366933971360 in file buf0buf.ic line 1277

Some googling showed this could be a problem in Percona XtraDB, which is as INNODB
replacement in MariaDB.

Next
 step: install MySQL Server instead of MariaDB. We were able to install 
MySQL-5.5.6 in PPC, and the number of MySQL crashes went down to 1 in 2 
days now (instead of 8 crashes a night). For now this is acceptable, and
 we started with icinga-web on a separate system. We now have the 
following setup:

LPAR 1 (OpenSuSE 13.1) - Icinga /idoutils (1.9.2)
LPAR 2 (OpenSuSE 13.1) - MySQL 5.5.6
X86 (OpenSuSE 12.2) - Icinga-Web 1.9.2

When
 we log in in icinga-web we get a screen showing we don't have enough 
permissions, and no servers show up. After debugging, googling a.s.o. I 
found  that if we install the databases on mariaDB 5.5.33 (local on 
X86), we get all the hosts & services.
Installing icinga-web db local, and icinga db remote (LPAR2), we can see the hosts, but
not the services.

I tried the following statement in the different DB's (X86 DB is a restore of  the LPAR2
dump):

LPAR2:
MySQL
 [nagios]> select count(*) from icinga_hosts join icinga_objects on 
icinga_hosts.host_object_id=icinga_objects.object_id join 
icinga_hoststatus on 
icinga_hoststatus.host_object_id=icinga_objects.object_id;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

X86:
mysql>
 select count(*) from icinga_hosts join icinga_objects on
> 
icinga_hosts.host_object_id=icinga_objects.object_id join 
icinga_hoststatus on
> 
icinga_hoststatus.host_object_id=icinga_objects.object_id;
+----------+
| count(*) |
+----------+
|      153 |
+----------+
1 row in set (0.00 sec)

Both statements are executed as root user in mysql (so all grants should be OK) and are on
the same database.
The only difference I see is the mysql / mariadb version, it looks like the syntax in the
newer mysql has been changed.

Anyone can shed a light on this ;)

Hans Scheffers

AIX / Linux Systeembeheer
 		 	   		   		 	   		  
Thread
FW: MySQL ProblemsHans Scheffers14 Nov