 |
 |
Hello, > 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%';" The value the WMS admins had returned from that query was: 1288274571000 Cheers, Matt >> >> 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. >>>> >>>> >>>> >>>> >>>> >>>> >