Hi,
On 08/30/2012 01:28 PM, Alvise Dorigo wrote:
> On Aug 30, 2012, at 12:24 PM, Maarten Litmaath wrote:
>
>> Ciao Alvise,
>>
>>> We observed (and didn't understand yet) that ICE and CREAM sometime lose EventID synchronization. If this happens, ICE can continue to work properly with other CEs, but cannot receive anymore events (== job status changes) from the CE which loosed event id sync with... I've to check the ICE logs and execute a query on the CREAM DB.
>> OK, let's follow up offline.
> In the ICE node, last event ID for kashif on the CE abaddon is 36450707. After that event the ICE's EventQuery didn't receive any new event (job status change) for kashif from the abaddon CE.
>
> So you need to check on the abaddon CE database which is the last event ID available for kashif and also check which is the database ID (ICE believes that the CREAM abaddon has the DBID 1288274571000, timestamp at millisecond resolution).
>
> Please Eric, could you provide Matt with the 2 queries ?
What's the output of the following queries?
-----------------------------------------
use creamdb;
select max(status.id) as eventId, j.userId from job j, job_status AS
status LEFT OUTER JOIN job_status AS latest ON
latest.jobId=status.jobId AND
status.id < latest.id WHERE latest.id IS null and j.id=status.jobId and
j.userId like '%kashif%' group by j.userId;
-----------------------------------------
-----------------------------------------
use creamdb;
select creationTime from db_info;
-----------------------------------------
Thanks,
E r i c.
|