Red Hat Bugzilla – Bug 1250304
long_query_timeout does not support postgres
Last modified: 2015-11-04 00:40:57 EST
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):
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)
long_query_timeout does not function as expected
long_query_timeout functions as expected
Might be easier to just change the session statement timeout before the request and reset it after the request.
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 )
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 email@example.com 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.