news ?
On Aug 30, 2012, at 2:08 PM, Alvise Dorigo wrote:
> this seems a big mess...
> I'm not yet sure about the DBID for abaddon registered in the ICE DB (I get it from the logs, but multiple threads are interleaved and I could mess different log lines).
> Please guys, execute this query on the WMS node:
>
> sqlite3 /var/ice/persist_dir/ice.db "select db_id from ce_dbid where ceurl like '%abaddon%';"
>
> Alvise
>
> ICE has a DBID for abaddon CE equal to
> On Aug 30, 2012, at 1:54 PM, Matt Doidge wrote:
>
>> Hello,
>>> What's the output of the following queries?
>>
>> mysql> 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;
>> +---------+----------------------------------------------------------------------------------------+
>> | eventId | userId |
>> +---------+----------------------------------------------------------------------------------------+
>> | 3138440 | _C_UK_O_eScience_OU_Oxford_L_OeSC_CN_kashif_mohammad_ops_Role_lcgadmin_Capability_NULL |
>> +---------+----------------------------------------------------------------------------------------+
>> 1 row in set (0.00 sec)
>>
>> mysql> select creationTime from db_info;
>> +---------------------+
>> | creationTime |
>> +---------------------+
>> | 2010-10-28 15:02:51 |
>> +---------------------+
>> 1 row in set (0.00 sec)
>>
>> As problems started after the cream service crashed then it is likely that the cream database has got itself into a "bad" state.
>>
>> Thanks,
>> Matt
>>
>>>
>>> Thanks,
>>> E r i c.
>>>
>>>
>>>
>>>
>>>
>>>
|