Edgewall Software
Modify

Opened 16 months ago

Last modified 8 months ago

#13550 new defect

OverflowError: Python int too large to convert to SQLite INTEGER

Reported by: Jun Omae Owned by:
Priority: normal Milestone: 1.6.1
Component: database backend Version: 1.0.20
Severity: minor Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

Passing a large integer to version parameter of wiki handler, OverflowError is raised.

09:20:38 AM Trac[main] ERROR: [192.168.11.15] Internal Server Error: <RequestWithSession "GET '/wiki/WikiStart?version=999999999999999999999999999999999'">, referrer 'http://192.168.11.122:3000/1.5-sqlite/wiki/WikiStart?version=999999999999999999999999999999999'
Traceback (most recent call last):
  File "trac/web/main.py", line 610, in dispatch_request
    dispatcher.dispatch(req)
  File "trac/web/main.py", line 302, in dispatch
    raise e
  File "trac/web/main.py", line 248, in dispatch
    resp = chosen_handler.process_request(req)
  File "trac/wiki/web_ui.py", line 126, in process_request
    versioned_page = WikiPage(self.env, pagename, version)
  File "trac/wiki/model.py", line 68, in __init__
    self._fetch(name, version)
  File "trac/wiki/model.py", line 87, in _fetch
    self.env.db_query(sql, args):
  File "trac/db/api.py", line 50, in execute
    return db.execute(query, params)
  File "trac/db/util.py", line 129, in execute
    cursor.execute(query, params if params is not None else [])
  File "trac/db/util.py", line 62, in execute
    r = self.cursor.execute(sql_escape_percent(sql), args)
  File "trac/db/sqlite_backend.py", line 89, in execute
    result = PyFormatCursor.execute(self, *args)
  File "trac/db/sqlite_backend.py", line 64, in execute
    return self._rollback_on_error(sqlite.Cursor.execute, sql,
  File "trac/db/sqlite_backend.py", line 56, in _rollback_on_error
    return function(self, *args, **kwargs)
OverflowError: Python int too large to convert to SQLite INTEGER

Attachments (0)

Change History (1)

comment:1 by Ryan J Ollos, 8 months ago

Milestone: 1.4.51.6.1

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.
The ticket will be disowned.
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.