Agilo problems installing eggs

9 views
Skip to first unread message

Nicu B.

unread,
Nov 19, 2009, 3:02:21 AM11/19/09
to Agilo for Scrum
Hi everyone,

I have installed Agilo egg on a Trac environment (version 0.11.4), but
when I try to modify an existing ticket I obtain the following error:
"OperationalError: no such column: i_links".
My Trac environments has a lot of tickets already present in it and we
are trying to migrate our process of development to Scrum.
I'm attaching to this email also the Python Traceback:

Python Traceback
Most recent call last:

* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/web/main.py", line 435, in _dispatch_request
Code fragment:
430. try:
431. if not env and env_error:
432. raise HTTPInternalError(env_error)
433. try:
434. dispatcher = RequestDispatcher(env)
435. dispatcher.dispatch(req)
436. except RequestDone:
437. pass
438. resp = req._response or []
439.
440. except HTTPException, e:
Local variables:
Name Value
after [u' except RequestDone:', u' pass', u' resp = ...
before [u' try:', u' if not env and env_error:', u' raise ...
dispatcher <trac.web.main.RequestDispatcher object at
0xa1c124c>
e OperationalError('no such column: i_links',)
env <trac.env.Environment object at 0x991184c>
env_error None
exc_info (<class 'pysqlite2.dbapi2.OperationalError'>,
OperationalError('no such ...
filename '/usr/lib/python2.5/site-packages/Trac-0.11.4-
py2.5.egg/trac/web/main.py'
frames [{'function': '_dispatch_request', 'lines_before': [u'
try:', u' ...
has_admin True
line u' dispatcher.dispatch(req)'
lineno 434
message u'OperationalError: no such column: i_links'
req <Request "POST u'/ticket/2862'">
resp []
tb <traceback object at 0xa31a8ec>
tb_hide None
traceback u'Traceback (most recent call last):\n File ...
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/web/main.py", line 205, in dispatch
Code fragment:
200. req.args.get('__FORM_TOKEN') != req.form_token:
201. raise HTTPBadRequest('Missing or invalid form token. '
202. 'Do you have cookies enabled?')
203.
204. # Process the request and render the template
205. resp = chosen_handler.process_request(req)
206. if resp:
207. if len(resp) == 2: # Clearsilver
208. chrome.populate_hdf(req)
209. template, content_type = \
210. self._post_process_request(req, *resp)
Local variables:
Name Value
chosen_handler <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
chrome <trac.web.chrome.Chrome object at 0xa1c118c>
ctype 'application/x-www-form-urlencoded'
err (<class 'pysqlite2.dbapi2.OperationalError'>,
OperationalError('no such ...
handler <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
options {}
req <Request "POST u'/ticket/2862'">
self <trac.web.main.RequestDispatcher object at 0xa1c124c>
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/web_ui.py", line 182, in process_request
Code fragment:
177.
178. def process_request(self, req):
179. if 'id' in req.args:
180. if req.path_info == '/newticket':
181. raise TracError(_("id can't be set for a new ticket
request."))
182. return self._process_ticket_request(req)
183. return self._process_newticket_request(req)
184.
185. # ITemplateProvider methods
186.
187. def get_htdocs_dirs(self):
Local variables:
Name Value
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
* File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-
py2.5.egg/agilo/ticket/web_ui.py", line 200, in
_process_ticket_request
Local variables:
Name Value
RuleValidationException <class
'agilo.scrum.workflow.api.RuleValidationException'>
content_type None
data None
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
template None
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/web_ui.py", line 508, in _process_ticket_request
Code fragment:
503. # things.
504. valid = self._validate_ticket(req, ticket) and not
problems
505. if 'preview' not in req.args:
506. if valid:
507. # redirected if successful
508. self._do_save(req, ticket, action)
509. # else fall through in a preview
510. req.args['preview'] = True
511.
512. # Preview an existing ticket (after a Preview or a failed
Save)
513. data.update({
Local variables:
Name Value
action u'reassign'
actions ['leave', 'resolve', 'request_info', 'reassign']
data {'comment': None, 'preserve_newlines': True, 'ticket': ...
field_changes {'i_links': {'new': u'', 'old': None, 'by':
'user'}, 'businessvalue': ...
id 2862
problems []
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
ticket <AgiloTicket@163184556 #2862 (u'bug')>
valid True
version None
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/web_ui.py", line 1014, in _do_save
Code fragment:
1009. # -- Save changes
1010.
1011. now = datetime.now(utc)
1012. if ticket.save_changes(get_reporter_id(req, 'author'),
1013. req.args.get('comment'), when=now,
1014. cnum=internal_cnum):
1015. try:
1016. tn = TicketNotifyEmail(self.env)
1017. tn.notify(ticket, newticket=False, modtime=now)
1018. except Exception, e:
1019. self.log.error("Failure sending notification on change to
"
Local variables:
Name Value
action u'reassign'
cnum u'23'
controllers
[<trac.ticket.default_workflow.ConfigurableTicketWorkflow object
at ...
internal_cnum u'23'
now datetime.datetime(2009, 11, 19, 7, 41, 42, 916873,
tzinfo=<FixedOffset ...
replyto u''
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
ticket <AgiloTicket@163184556 #2862 (u'bug')>
* File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-
py2.5.egg/agilo/ticket/model.py", line 756, in save_changes
Local variables:
Name Value
author u'nicolae....@alcatel-lucent.ro'
cnum u'23'
comment u''
db None
self <AgiloTicket@163184556 #2862 (u'bug')>
when datetime.datetime(2009, 11, 19, 7, 41, 42, 916873,
tzinfo=<FixedOffset ...
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/model.py", line 273, in save_changes
Code fragment:
268. cursor.execute("INSERT INTO ticket_custom (ticket,name,"
269. "value) VALUES(%s,%s,%s)",
270. (self.id, name, self[name]))
271. else:
272. cursor.execute("UPDATE ticket SET %s=%%s WHERE id=%%s" %
name,
273. (self[name], self.id))
274. cursor.execute("INSERT INTO ticket_change "
275. "(ticket,time,author,field,oldvalue,newvalue) "
276. "VALUES (%s, %s, %s, %s, %s, %s)",
277. (self.id, when_ts, author, name, self._old[name],
278. self[name]))
Local variables:
Name Value
author u'nicolae....@alcatel-lucent.ro'
cc u'Mario...@alcatel-lucent.fr'
cclist [u'Mario...@alcatel-lucent.fr']
cnum u'23'
comment u''
cursor <trac.db.util.IterableCursor object at 0xa1ed644>
custom_fields ['sprint']
db <trac.db.pool.PooledConnection object at 0xa61e22c>
f {'name': 'sprint', 'optional': True, 'value': u'', 'custom':
True, ...
handle_ta True
name 'i_links'
self <AgiloTicket@163184556 #2862 (u'bug')>
when datetime.datetime(2009, 11, 19, 7, 41, 42, 916873,
tzinfo=<FixedOffset ...
when_ts 1258616502
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/db/util.py", line 50, in execute
Code fragment:
45. def execute(self, sql, args=None):
46. # -- In case of SQL errors, uncomment the following
'print' statements
47. # print 'execute', repr(sql)
48. if args:
49. # print repr(args)
50. return self.cursor.execute(sql_escape_percent(sql), args)
51. return self.cursor.execute(sql)
52.
53. def executemany(self, sql, args=None):
54. # print 'executemany', repr(sql)
55. if args:
Local variables:
Name Value
args (u'', 2862)
self <trac.db.util.IterableCursor object at 0xa1ed644>
sql 'UPDATE ticket SET i_links=%s WHERE id=%s'
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/db/sqlite_backend.py", line 58, in execute
Code fragment:
53. raise
54. def execute(self, sql, args=None):
55. if args:
56. sql = sql % (('?',) * len(args))
57. return self._rollback_on_error(sqlite.Cursor.execute, sql,
58. args or [])
59. def executemany(self, sql, args=None):
60. if args:
61. sql = sql % (('?',) * len(args[0]))
62. return self._rollback_on_error(sqlite.Cursor.executemany,
sql,
63. args or [])
Local variables:
Name Value
args (u'', 2862)
self <trac.db.sqlite_backend.PyFormatCursor object at
0xa443f2c>
sql 'UPDATE ticket SET i_links=? WHERE id=?'
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/db/sqlite_backend.py", line 50, in _rollback_on_error
Code fragment:
45. sqlite_version_string = '%d.%d.%d' % (_ver[0], _ver[1], int
(_ver[2]))
46.
47. class PyFormatCursor(sqlite.Cursor):
48. def _rollback_on_error(self, function, *args, **kwargs):
49. try:
50. return function(self, *args, **kwargs)
51. except sqlite.DatabaseError, e:
52. self.cnx.rollback()
53. raise
54. def execute(self, sql, args=None):
55. if args:
Local variables:
Name Value
args ('UPDATE ticket SET i_links=? WHERE id=?', (u'', 2862))
e OperationalError('no such column: i_links',)
function <method 'execute' of 'pysqlite2.dbapi2.Cursor'
objects>
kwargs {}
self <trac.db.sqlite_backend.PyFormatCursor object at
0xa443f2c>

File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/web/
main.py", line 435, in _dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/web/
main.py", line 205, in dispatch
resp = chosen_handler.process_request(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/
ticket/web_ui.py", line 182, in process_request
return self._process_ticket_request(req)
File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-py2.5.egg/
agilo/ticket/web_ui.py", line 200, in _process_ticket_requestFile "/
usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/ticket/
web_ui.py", line 508, in _process_ticket_request
self._do_save(req, ticket, action)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/
ticket/web_ui.py", line 1014, in _do_save
cnum=internal_cnum):
File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-py2.5.egg/
agilo/ticket/model.py", line 756, in save_changesFile "/usr/lib/
python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/ticket/model.py",
line 273, in save_changes
(self[name], self.id))
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/db/
util.py", line 50, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/db/
sqlite_backend.py", line 58, in execute
args or [])
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/db/
sqlite_backend.py", line 50, in _rollback_on_error
return function(self, *args, **kwargs)


Did anyone has this error before ? Please help me.

Thank you,
Nicu.

Martin Häcker

unread,
Nov 23, 2009, 4:57:16 AM11/23/09
to ag...@googlegroups.com
Hi Nicu,

> I have installed Agilo egg on a Trac environment (version 0.11.4), but
> when I try to modify an existing ticket I obtain the following error:
> "OperationalError: no such column: i_links".
> My Trac environments has a lot of tickets already present in it and we
> are trying to migrate our process of development to Scrum.
> I'm attaching to this email also the Python Traceback:

As a first try, you could have a look at the Upgrade Guide on our wiki:
<https://dev.agile42.com/wiki/agilo/dev/users/UpgradeGuide>

Just from your description I would guess that somehow the db upgrade has
gone wrong - but I'm not sure.

Did you modify delete some of the original ticket types that trac has?

In any event could you please provide the versions of all the
components? They are best available by logging into agilo as admin and
visiting "About Trac" in the upper right part. Then copy the "System
Information" table.

Hope this helps!

Regards,
Martin

Nicu B.

unread,
Nov 23, 2009, 10:22:55 AM11/23/09
to ag...@googlegroups.com
Hi Martin,

I found a workaround for this problem: if a press "Preview" when I modify a ticket and after that I press "Submit" then the error doesn't appear any more.
I think it's a quite strange behavior.

Here is the System Information Table:

System Information

Trac: 0.11.4
Python: 2.5.4 (r254:67916, Feb 17 2009, 20:36:34) [GCC 4.3.3]
setuptools: 0.6c9
SQLite: 3.6.14
pysqlite: 2.5.0
Genshi: 0.5.1
mod_python: 3.3.1
RPC: 1.0.6
Agilo: 1.1.0-PRO
Subversion: 1.5.6 (r36142)
jQuery:1.2.6


Thank you,
Nicu.

--
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
-----
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
To post to this group, send email to ag...@googlegroups.com
To unsubscribe from this group, send email to
agilo+un...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en

Martin Häcker

unread,
Nov 24, 2009, 4:09:13 AM11/24/09
to ag...@googlegroups.com
Hi Nicu,

> I found a workaround for this problem: if a press "Preview" when I
> modify a ticket and after that I press "Submit" then the error doesn't
> appear any more.
> I think it's a quite strange behavior.

Indeed.

I am still quite in the dark why this might happen. Did you modify
delete some of the original ticket types that trac creates on initial
startup?

The way you worked around the issue doesn't really make sense - as
either that table is missing or it isn't.

We did have a recent bug report where suddenly some ticket-fields where
missing temporarily - this might be an instance of this problem.

If that is the case it would be great if you could help replicate that
issue, it seems to only happen in certain circumstances that we haven't
yet narrowed down (and strangely it happens to different custom fields
all the time).

I've added your report to the bug at
<https://dev.agile42.com/ticket/929> in the hope that it helps us narrow
down why this happens.

If you have any additional information that could help us narrow this
down - please share.

Best Regards,
Martin
Reply all
Reply to author
Forward
0 new messages