Description of problem: long_query_timeout uses DBIx::Timeout which has a note saying "This release supports only MySQL." Version-Release number of selected component (if applicable): 4.4 How reproducible: Always Steps to Reproduce: 1. set long_query_timeout to 120 on a site using Pg 2. do a search (works) 3. search again (always times out) Actual results: long_query_timeout does not function as expected Expected results: long_query_timeout functions as expected Additional info: Might be easier to just change the session statement timeout before the request and reset it after the request.
Tested on QA environment(bzweb01-qe) with version(4.4.9040-1, DB: mysql) QA environment(bzperfweb01.app.qa) with version(4.4.9040-1, DB: psql ) Result: Pass Steps: 1.Set 'long_query_timeout' to 30 in data/params 2.Then do a long query(like do simple search to all products with some strings) which will cost more than 30 seconds ==>Verify this query show long query time out error immediately: Your query was taking longer than 30 seconds and had to be killed. Please back up and narrow your search criteria. If you feel your results were expected and your search criteria was correct, please send email to bugzilla-requests describing what you were doing and we will correct the error.
This change is now live. If there are any issues, do not reopen this bug. Instead, you should create a new bug and reference this bug.