 |
MySQLTalk.org
MYSQL discussions groups
|
| View previous topic :: View next topic |
| Author |
Message |
Elm Morrow
Guest
|
 Posted: Tue May 15, 2007 12:42 am Post subject: Lockup problem |
 |
|
Every time the below query runs it locks up our Eventum db.
We've been using Eventum 1.7.1 for over a year and have never had this
problem. The only thing that's changed recently is another workgroup has
added their project to Eventum so there is quite a bit more traffic than
usual.
SELECT iss_id, GREATEST( iss_last_public_action_date, IFNULL(
iss_last_internal_action_date, '0000-00-00' ) ) AS last_action_date
FROM (
eventum.eventum_issue, eventum.eventum_user,
eventum.eventum_issue_custom_field AS cf7,
eventum.eventum_issue_custom_field AS cf6
)
LEFT JOIN eventum.eventum_issue_user ON isu_iss_id = iss_id
LEFT JOIN eventum.eventum_status ON iss_sta_id = sta_id
LEFT JOIN eventum.eventum_project_priority ON iss_pri_id = pri_id
WHERE iss_prj_id =10
AND iss_usr_id = usr_id
AND (
isu_usr_id =3
)
AND sta_is_closed =0
GROUP BY iss_id
ORDER BY iss_pri_id ASC , iss_id DESC
-E.L.M. |
|
| Back to top |
|
 |
will
Guest
|
| Posted: Tue May 15, 2007 12:53 am Post subject: Re: Lockup problem |
|
|
You need to add join criteria on your inner/comma joins.
On 5/14/07, Elm Morrow <emorrow@cms-solutions.com> wrote:
| Quote: | Every time the below query runs it locks up our Eventum db.
We've been using Eventum 1.7.1 for over a year and have never had this
problem. The only thing that's changed recently is another workgroup has
added their project to Eventum so there is quite a bit more traffic than
usual.
SELECT iss_id, GREATEST( iss_last_public_action_date, IFNULL(
iss_last_internal_action_date, '0000-00-00' ) ) AS last_action_date
FROM (
eventum.eventum_issue, eventum.eventum_user,
eventum.eventum_issue_custom_field AS cf7,
eventum.eventum_issue_custom_field AS cf6
)
LEFT JOIN eventum.eventum_issue_user ON isu_iss_id = iss_id
LEFT JOIN eventum.eventum_status ON iss_sta_id = sta_id
LEFT JOIN eventum.eventum_project_priority ON iss_pri_id = pri_id
WHERE iss_prj_id =10
AND iss_usr_id = usr_id
AND (
isu_usr_id =3
)
AND sta_is_closed =0
GROUP BY iss_id
ORDER BY iss_pri_id ASC , iss_id DESC
-E.L.M.
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
