DataError: integer out of range

[carlosadean@…]

How to Reproduce

While doing a POST operation on /admin/ticket/milestones, Trac issued an internal error.

After set the this format of date "07/31/17 00:00:00" in the field "Due" trac shows this error and does not register the milestone. How can I fix it ?

Thanks!

Request parameters:

{'__FORM_TOKEN': u'cc21c2d7e26d9060c1d49020',
 'add': u'Add',
 'cat_id': u'ticket',
 'duedate': u'07/31/17 00:00:00',
 'name': u'Sprint-09',
 'panel_id': u'milestones',
 'path_info': None}

User agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0

System Information

Trac	0.12.1
Babel	0.9.4 (translations unavailable)
Genshi	0.6
mod_python	3.3.1
psycopg2	2.0.14
Pygments	1.1.1
Python	2.6.6 (r266:84292, Aug 18 2016, 15:13:37) [GCC 4.4.7 20120313 (Red Hat 4.4.7-17)]
pytz	2010h
setuptools	0.6
Subversion	1.6.11 (r934486)
jQuery	1.4.2

Enabled Plugins

timingandestimationplugin	1.3.7
Trac-jsGantt	0.9-r11182
TracSubcomponents	1.1.2

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/trac/web/main.py", line 514, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.6/site-packages/trac/web/main.py", line 240, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.6/site-packages/trac/admin/web_ui.py", line 116, in process_request
    path_info)
  File "/usr/lib/python2.6/site-packages/trac/ticket/admin.py", line 53, in render_admin_panel
    return self._render_admin_panel(req, cat, page, version)
  File "/usr/lib/python2.6/site-packages/trac/ticket/admin.py", line 298, in _render_admin_panel
    mil.insert()
  File "/usr/lib/python2.6/site-packages/trac/ticket/model.py", line 984, in insert
    @self.env.with_transaction(db)
  File "/usr/lib/python2.6/site-packages/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/lib/python2.6/site-packages/trac/ticket/model.py", line 992, in do_insert
    to_utimestamp(self.completed), self.description))
  File "/usr/lib/python2.6/site-packages/trac/db/util.py", line 54, in execute
    r = self.cursor.execute(sql_escape_percent(sql), args)
DataError: integer out of range

[Jun Omae]

Please make sure that type of milestone.due is bigint. Similar issue is #9535.

trac-# \d milestone
     Table "public.milestone"
   Column    |  Type  | Modifiers
-------------+--------+-----------
 name        | text   | not null
 due         | bigint |
 completed   | bigint |
 description | text   |
Indexes:
    "milestone_pkey" PRIMARY KEY, btree (name)

[anonymous]

Unfortunately I do not know the cause of the error nor if other errors will appear after I change the column to bigint, maybe a plugin is the source. Anyway, it's working now.

Thank you!

trac_linea=# \d trac.milestone
      Table "trac.milestone"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 name        | text    | not null
 due         | integer | 
 completed   | integer | 
 description | text    | 
 started     | integer | 
Indexes:
    "milestone_pkey" PRIMARY KEY, btree (name)

trac_linea=# ALTER TABLE trac.milestone ALTER COLUMN due TYPE bigint;
ALTER TABLE

trac_linea=# \d trac.milestone
      Table "trac.milestone"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 name        | text    | not null
 due         | bigint  | 
 completed   | integer | 
 description | text    | 
 started     | integer | 
Indexes:
    "milestone_pkey" PRIMARY KEY, btree (name)

[anonymous]

Maybe ​th:ScrumBurndownPlugin? ​th:browser:scrumburndownplugin/trunk/burndown/dbhelper.py@13148:24-29

[Jun Omae]

PluginIssue. Also, your milestone.completed has the same issue.

[Jun Omae]

At least, that plugin shouldn't modify tables which are created by Trac core.

[anonymous]

Replying to Jun Omae:

PluginIssue. Also, your milestone.completed has the same issue.

Certainly one of these:

GoogleCalendar 0.1.2
timingandestimationplugin 1.3.7
Trac-jsGantt 0.9-r11182
TracSubcomponents 1.1.2

What about the column milestone.started, shouldn't be its datatype bigin?

[Ryan J Ollos]

Created ​th:#13257 to deal with issue for ​th:ScrumBurndownPlugin.