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.
>
>
>
>
>
>
|