Edgewall Software
Modify ↓

Opened 15 years ago

Closed 15 years ago

#8014 closed defect (duplicate)

OperationalError: too many SQL variables

Reported by: dl@… Owned by:
Priority: high Milestone:
Component: general Version: 0.11.2
Severity: critical Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

How to Reproduce

While doing a GET operation on /tags, Trac issued an internal error.

(please provide additional details here)

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5

System Information

Trac 0.11.2
Python 2.5.2 (r252:60911, Dec 19 2008, 16:42:11)
[GCC 3.4.6 [FreeBSD] 20060305]
setuptools 0.6c9
SQLite 3.4.1
pysqlite 2.3.2
Genshi 0.5.1
Pygments 0.8.1
Subversion 1.5.4 (r33841)
jQuery: 1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/web/main.py", line 204, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/web_ui.py", line 99, in process_request
    data['tag_body'] =  macro.expand_macro(formatter, None, query)
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/macros.py", line 59, in expand_macro
    for resource, tags in query_result:
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/api.py", line 196, in query
    for resource, tags in provider.get_tagged_resources(req, query_tags):
  File "build/bdist.freebsd-6.2-RELEASE-i386/egg/tractags/api.py", line 107, in get_tagged_resources
    cursor.execute(sql, args)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: too many SQL variables

Attachments (0)

Change History (1)

comment:1 by Remy Blank, 15 years ago

Milestone: 0.11.3
Resolution: → duplicate
Status: new → closed

Duplicate of #8009. Seems to be the same Trac installation, too. Please report the issue to your Trac admin, as well as to the ​th:TagsPlugin plugin maintainer.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

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