Results 1 to 2 of 2

Thread: DB getting locked out because of query

  1. #1
    Thread Starter
    yschris's Avatar
    Join Date
    May 2013
    Location
    United States
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DB getting locked out because of query

    I am having a query lock the db while

    | 3240750 | youthspe_ysjobs | localhost | youthspe_ysjobbank | Query | 89 | Copying to tmp table | SELECT hudk1o_posts.*, hudk1o_p2p.* FROM hudk1o_posts LEFT JOIN hudk1o_postmeta ON hudk1o_posts.ID = hudk1o_postmeta.post_id INNER JOIN hudk1o_p2p WHERE 1=1 AND hudk1o_posts.post_type IN ('transaction', 'job_listing', 'discount_coupon') AND (hudk1o_posts.post_status <> 'trash' AND hudk1o_posts.post_status <> 'auto-draft') OR (hudk1o_posts.post_title LIKE '%%') OR (hudk1o_posts.post_content LIKE '%%') AND (hudk1o_p2p.p2p_type = 'order-connection' AND hudk1o_posts.ID = hudk1o_p2p.p2p_to AND hudk1o_p2p.p2p_from IN (SELECT hudk1o_posts.ID FROM hudk1o_posts LEFT JOIN hudk1o_postmeta ON hudk1o_posts.ID = hudk1o_postmeta.post_id WHERE 1=1 AND hudk1o_posts.ID IN (11868) AND hudk1o_posts.post_type IN ('transaction', 'job_listing', 'discount_coupon') AND (hudk1o_posts.post_status <> 'trash' AND hudk1o_posts.post_status <> 'auto-draft') OR (hudk1o_posts.post_title LIKE '%%') OR (hudk1o_posts.post_content LIKE '%%') GROUP BY hudk1o_posts.ID ORDER BY hudk1o_posts.post_date DESC )) GROUP BY hudk1o_posts.ID ORDER BY hudk1o_posts.post_date DESC |
    | 3240902 | youthspe_ysjobs | localhost | youthspe_ysjobbank | Query | 88 | Copying to tmp table | SELECT hudk1o_posts.*, hudk1o_p2p.* FROM hudk1o_posts LEFT JOIN hudk1o_postmeta ON hudk1o_posts.ID = hudk1o_postmeta.post_id INNER JOIN hudk1o_p2p WHERE 1=1 AND hudk1o_posts.post_type IN ('transaction', 'job_listing', 'discount_coupon') AND (hudk1o_posts.post_status <> 'trash' AND hudk1o_posts.post_status <> 'auto-draft') OR (hudk1o_posts.post_title LIKE '%%') OR (hudk1o_posts.post_content LIKE '%%') AND (hudk1o_p2p.p2p_type = 'order-connection' AND hudk1o_posts.ID = hudk1o_p2p.p2p_to AND hudk1o_p2p.p2p_from IN (SELECT hudk1o_posts.ID FROM hudk1o_posts LEFT JOIN hudk1o_postmeta ON hudk1o_posts.ID = hudk1o_postmeta.post_id WHERE 1=1 AND hudk1o_posts.ID IN (11876) AND hudk1o_posts.post_type IN ('transaction', 'job_listing', 'discount_coupon') AND (hudk1o_posts.post_status <> 'trash' AND hudk1o_posts.post_status <> 'auto-draft') OR (hudk1o_posts.post_title LIKE '%%') OR (hudk1o_posts.post_content LIKE '%%') GROUP BY hudk1o_posts.ID ORDER BY hudk1o_posts.post_date DESC )) GROUP BY hudk1o_posts.ID ORDER BY hudk1o_posts.post_date DESC |

    Looks as though it's copy the tmp because it's sql query. Can someone help in determining what is causing this to happen. the prefix of the table is hudk1.

    | SELECT hudk1o_posts.*, hudk1o_p2p.* FROM hudk1o_posts LEFT JOIN hudk1o_postmeta ON hudk1o_posts.ID = hudk1o_postmeta.post_id INNER JOIN hudk1o_p2p WHERE 1=1 AND hudk1o_posts.post_type IN ('transaction', 'job_listing', 'discount_coupon') AND (hudk1o_posts.post_status <> 'trash' AND hudk1o_posts.post_status <> 'auto-draft') OR (hudk1o_posts.post_title LIKE '%%') OR (hudk1o_posts.post_content LIKE '%%') AND (hudk1o_p2p.p2p_type = 'order-connection' AND hudk1o_posts.ID = hudk1o_p2p.p2p_to AND hudk1o_p2p.p2p_from IN (SELECT hudk1o_posts.ID FROM hudk1o_posts LEFT JOIN hudk1o_postmeta ON hudk1o_posts.ID = hudk1o_postmeta.post_id WHERE 1=1 AND hudk1o_posts.ID IN (11861) AND hudk1o_posts.post_type IN ('transaction', 'job_listing', 'discount_coupon') AND (hudk1o_posts.post_status <> 'trash' AND hudk1o_posts.post_status <> 'auto-draft') OR (hudk1o_posts.post_title LIKE '%%') OR (hudk1o_posts.post_content LIKE '%%') GROUP BY hudk1o_posts.ID ORDER BY hudk1o_posts.post_date DESC )) GROUP BY hudk1o_posts.ID ORDER BY hudk1o_posts.post_date DESC |
    | 3240902 | youthspe_ysjobs | localhost | youthspe_ysjobbank | Query | 96 | Waiting for table level lock | SELECT meta_id FROM hudk1o_postmeta WHERE meta_key = 'total_price' AND post_id = 11868

  2. #2
    trude76's Avatar
    Join Date
    Dec 2012
    Location
    Leipzig, Germany
    Posts
    785
    Thanks
    1
    Thanked 61 Times in 57 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Locked Fields - ClassiPress
    By postitworld in forum ClassiPress General Discussion
    Replies: 1
    Last Post: January 9th, 2013, 01:48 AM
  2. Help! My [Page 1 of 3] [1] [2] [3] is locked! Don't working!
    By lars in forum ClassiPress General Discussion
    Replies: 2
    Last Post: August 24th, 2011, 10:16 PM
  3. Locked out... Help!!
    By dollarpermile.com in forum Help Using ClassiPress
    Replies: 6
    Last Post: June 9th, 2010, 07:50 PM
  4. Locked Out of Site Admin
    By ssgupta in forum Help Using ClassiPress
    Replies: 5
    Last Post: April 8th, 2010, 06:44 AM