when i wanna see Data overview of a specified group and it's fail,
also if i move one or more host from this group to another group ,the overview show truly

Hosts location

No items defined

Error in query [SELECT DISTINCT h.hostid, h.host,i.itemid, i.key_, i.value_type, i.lastvalue, i.units, i.description, t.priority, i.valuemapid, t.value as tr_value, t.triggerid FROM hosts h, items i LEFT JOIN functions f on f.itemid=i.itemid LEFT JOIN triggers t on t.triggerid=f.triggerid and t.status=0 WHERE (h.hostid IN (10374,10424,10371,10231,10229,10186,10373,10219,10157,10116,10329,10170,10217,10048,10127,10180,10199,10200,10107,10124,10346,10064,10065,10171,10172,10173,10104,10106,10165,10057,10060,10228,10089,10091,10092,10362,10052,10196,10160,10223,10224,10225,10335,10125,10154,10155,10336,10055,10151,10156,10159,10145,10325,10130,10174,10175,10153,10332,10321,10330,10132,10222,10333,10334,10365,10366,10341,10140,10221,10111,10162,10066,10320,10071,10203,10189,10190,10075,10152,10077,10331,10352,10322,10327,10179,10163,10164,10169,10123,10117,10205,10204,10184,10056,10147,10183,10185,10216,10323,10367,10138,10360,10218,10220,10210,10161,10212,10115,10213,10081,10191,10328,10347,10128,10129,10348,10085,10150,10166,10167,10168,10144,10182,10047,10214,10187,10188,10096,10114,10122,10207,10061,10181,10079,10201,10364,10338,10141,10206,10215,10344,10340,10139,10349,10086,10108,10345,10209,10326,10260,10227,10226,10176,10177,10133,10134,10083,10368,10363,10337,10197,10158,10339,10343,10142,10149,10195,10423,10143,10146,10131,10119,10121,10230)) AND h.status=0 AND h.hostid=i.hostid AND i.status=0 ORDER BY i.description,i.itemid] Incorrect key file for table '/var/tmp/#sql767_46c_2.MYI'; try to repair it
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource [include/db.inc.php:614]
mysql_free_result(): supplied argument is not a valid MySQL result resource [include/db.inc.php:616]

df -h /var
Filesystem Size Used Avail Capacity Mounted on
/dev/ad0s1d 726M 320M 348M 48% /var