quey error

[steff]

Hi all,

periodically (circa every two days) my zabbix server exits due to a
query error. The query of the death are (I took two queries as example) :

Query::select num,value_min,value_avg,value_max from trends where itemid=18758 and cloc<C0><B2>^<80><BA>^p<C1><FF><BF><F8<F8<FF>^G

Query::select num,value_min,value_avg,value_max from trends where itemid=18790 and clock=1157439<C1><FF><BF><D0<D0<FF>

Did someone encountered the same problem? I really don't know ho to fix
this ...

Thanks for the support,
steff

[dantheman]

check for corruption in the trend's table.. I had this problem too and it was always the same couple of tables that caused it to shut down. After I ran the mysql repair tools they took care of the problem and I was up and running again.

[steff]

check for corruption in the trend's table..

I ran mysqlcheck but none of the table was found corrupted.
This morning the server creashed once again : always for the same query on the same trends table.
Here is the query :

Query::select num,value_min,value_avg,value_max from trends where itemid=18649 and cl^D^H??^K^H?^G

I've checked that item in the items and trends table looking for a corrupted record but I didn't find nothing strange.
Now I made a full dump of zabbix db and reloaded the dump on mysql, in the hope that maybe it could repair the problem.

I really don't know what could be the problem : I've got (fortunately) another zabbix server with same version of zabbix_server and mysqld and works fine, cause it has never crashed. The hosts checked are the same too. So I don't think it's a zabbix_server's bug.

thanks
steff

[dantheman]

If your tables are MyISAM you can check for corruption with this.

myisamchk tbl_name

This finds 99.99% of all errors. What it cannot find is corruption that involves only the data file (which is very unusual). If you want to check a table, you should normally run myisamchk without options or with the -s (silent) option.

that's how I found the problems I had.

[steff]

If your tables are MyISAM you can check for corruption with this.



that's how I found the problems I had.

root@zabbix ~# myisamchk /var/lib/mysql/zabbix/items.frm 
myisamchk: error: '/var/lib/mysql/zabbix/items.frm' is not a MyISAM-table

Sfortunately they are InnoDB tables ...