Edgewall Software

Opened 12 years ago

Last modified 3 years ago

#7454 new defect

Query timeouts with PG result in traceback

Reported by: anonymous Owned by:
Priority: normal Milestone: next-stable-1.2.x
Component: search system Version: 0.10.5
Severity: minor Keywords: postgresql
Cc: Branch:
Release Notes:
API Changes:

Description (last modified by Tim Hatch)

In trac.adiumx.com search select :tickets, wikis, and changesets; search for "tor" (without the quotes). This is the effect:

If you think this really should work and you can reproduce it, you should consider reporting this problem to the Trac team.

Go to http://trac.edgewall.org/ and create a new ticket where you describe the problem, how to reproduce it. Don't forget to include the Python traceback found below.

TracGuide — The Trac User and Administration Guide Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 406, in dispatch_request
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/Search.py", line 181, in process_request
    results += list(source.get_search_results(req, terms, filters))
  File "/usr/lib/python2.4/site-packages/trac/ticket/api.py", line 269, in get_search_results
    args + args2)
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: canceling statement due to statement timeout

Attachments (0)

Change History (6)

comment:1 by anonymous, 12 years ago

This only seems to happen when searching for tor.

comment:2 by Tim Hatch, 12 years ago

Component: generalsearch system
Description: modified (diff)
Keywords: postgres added
Summary: Search on Adium site failed with ERRORs said to report it here.Query timeouts with PG result in traceback
Version: 0.10.5

This is a db timeout, caused (my guess) by too many results. Adium's Trac is using postgres with a query timeout, and the timeout is doing its job…

Searching for other short sequences which appear often in larger words ("are", for example) results in the same error. Should we handle this and give a prettier error?

comment:3 by Christian Boos, 12 years ago

Milestone: 0.11.2
Priority: highnormal
Severity: majorminor

Maybe yes, depends on #6348 then.

comment:4 by Ryan J Ollos, 5 years ago

Milestone: next-minor-0.12.xnext-stable-1.0.x

comment:5 by Ryan J Ollos, 5 years ago

Keywords: postgresql added; postgres removed

comment:6 by Ryan J Ollos, 3 years ago

Milestone: next-stable-1.0.xnext-stable-1.2.x

Moved ticket assigned to next-stable-1.0.x since maintenance of 1.0.x is coming to a close. Please move the ticket back if it's critical to fix on 1.0.x.

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.
The ticket will be disowned. Next status will be 'new'.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.