Hi Thanh,
Thank you very much for your response.
From outputs from gdb I can see that you have hit a bug in IB joining algorithm. I will create corresponding ticket in Infobright bug tracking system soon. Could you please confirm that when server hang it was probably executing the following query:
SELECT bannerid, B.locationID, SUM(totalClick)totalClick
FROM
( SELECT bannerid, ip, Count(guid)`totalClick`
FROM ad0509 WHERE clickorview=1
AND timecreate BETWEEN '2009-05-13 16:00:00' AND '2009-05-13 16:29:59'
GROUP BY bannerid, ip
) AS A
LEFT JOIN `ip2location_bh` AS B on A.ip = B.`ip`
GROUP BY bannerid, B.locationID;
As about server hangs that you have encountered. This is normal when you run program under gdb and it hit some problem. This is exactly what happend in your case and thanks to that we know where we should look for a bug in ICE source code.
Unfortunately we still don’t know why you can’t load new data to ad0509 table. This is just a guess but it is possible that this is an implication of problem with above query. However we should confirm reject this hypothesis.
It looks that the problem that you hit when you scheduled just data loads was caused by the fact that the server was doing nothing for a long time. This may happen when you run program under gdb.
To be continued…
