We just changed our Agilo (1.3.0.7 running on Trac 0.11.7, Python 2.5)
from SQLITE to PostGreSQL to get rid of multitasking problems.
PostgreSQL helped fro those, but then other problems arised. When
updating a task and entering s number in "remaining_time", Agilo traps
generating the following DEBUG log:
Help! Anyone?
;-D Hans
2010-10-19 13:33:25,618 Trac[log] DEBUG: [RemainingTime]: DB
Committed, saved remaining time (200.0) for task 50
2010-10-19 13:33:25,618 Trac[log] DEBUG: [RemainingTimeUpdater]:
Updated remaining_time for ticket #<AgiloTicket #50 (u'task')> from:
100 to 200.0
2010-10-19 13:33:25,618 Trac[log] DEBUG: [BurndownDataChange]: SAVE =>
Executing Query: INSERT INTO agilo_burndown_data_change (scope,
timestamp, burndown_type, value) VALUES (%(scope)s, %(timestamp)s, %
(burndown_type)s, %(value)s) ({'scope': u'Sprint 7 - General NSS',
'burndown_type': 'remaining_time', 'id': None, 'value': '100.0',
'timestamp': 1287488005})
2010-10-19 13:33:25,618 Trac[model] ERROR: duplicate key value
violates unique constraint "agilo_burndown_data_change_pkey"
Traceback (most recent call last):
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\core\model.py", line 811, in save
safe_execute(cursor, sql, parameters)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\core\model.py", line 118, in safe_execute
return cursor.execute(sql, args)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\db\util.py", line 64, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\db\util.py", line 64, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
IntegrityError: duplicate key value violates unique constraint
"agilo_burndown_data_change_pkey"
2010-10-19 13:33:25,618 Trac[log] ERROR: [TicketUpdateView]:
UnableToSaveObjectError: An error occurred while saving
BurndownDataChange(id=None, type='remaining_time', scope=u'Sprint 7 -
General NSS', when=datetime.datetime(2010, 10, 19, 13, 33, 25, 619000,
tzinfo=<trac.util.datefmt.LocalTimezone object at 0x012282D0>),
value='100.0') to the database: IntegrityError: duplicate key value
violates unique constraint "agilo_burndown_data_change_pkey"
Traceback (most recent call last):
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\api\view.py", line 314, in process_request
response = self.get_handler(req)(req, data)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\json_ui.py", line 233, in do_post
success, errors = self._modify_ticket_attributes(req, args)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\json_ui.py", line 172, in
_modify_ticket_attributes
update_was_successful = self.call_ticket_module(wrapped_request,
'_process_ticket_request')
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\json_ui.py", line 115, in call_ticket_module
getattr(ticket_module, method_name)(req)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\web_ui.py", line 201, in
_process_ticket_request
template, data, content_type = super(AgiloTicketModule,
self)._process_ticket_request(req)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\ticket\web_ui.py", line 513, in _process_ticket_request
self._do_save(req, ticket, action)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\ticket\web_ui.py", line 1034, in _do_save
cnum=internal_cnum):
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\model.py", line 761, in save_changes
res = super(AgiloTicket, self).save_changes(author, comment, when,
db, cnum)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\ticket\model.py", line 299, in save_changes
listener.ticket_changed(self, comment, author, old_values)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\scrum\burndown\changelistener.py", line 89, in
ticket_changed
self._record_change_if_necessary(current_sprint_name,
remaining_time_delta, current_component)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\scrum\burndown\changelistener.py", line 171, in
_record_change_if_necessary
self._record_change(sprint_name, remaining_time_delta, component)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\scrum\burndown\changelistener.py", line 61, in
_record_change
change.save()
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\scrum\burndown\model.py", line 135, in save
return self.super()
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\utils\simple_super.py", line 143, in __call__
return method(*vargs, **kwargs)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\core\model.py", line 826, in save
(self, exception_to_unicode(e)))
UnableToSaveObjectError: An error occurred while saving
BurndownDataChange(id=None, type='remaining_time', scope=u'Sprint 7 -
General NSS', when=datetime.datetime(2010, 10, 19, 13, 33, 25, 619000,
tzinfo=<trac.util.datefmt.LocalTimezone object at 0x012282D0>),
value='100.0') to the database: IntegrityError: duplicate key value
violates unique constraint "agilo_burndown_data_change_pkey"
2010-10-19 13:33:25,618 Trac[log] DEBUG: [AgiloTicket]: Initializing
with: 50, None, None
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'fields'
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'changes'
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'available_types'
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'row_groups'
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'allowed_links'
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'source'
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'ticket_types'
2010-10-19 13:33:25,618 Trac[log] WARNING: [CommandParser] [By Key]:
Warning 'target'
2010-10-19 13:33:25,618 Trac[log] DEBUG: [CoreTemplateProvider]: Type:
requirement, Alias: Requirement Permission: AGILO_CREATE_REQUIREMENT
2010-10-19 13:33:25,618 Trac[log] DEBUG: [CoreTemplateProvider]: Type:
task, Alias: Task Permission: AGILO_CREATE_TASK
2010-10-19 13:33:25,618 Trac[log] DEBUG: [CoreTemplateProvider]: Type:
story, Alias: User Story Permission: AGILO_CREATE_STORY
2010-10-19 13:33:25,618 Trac[log] DEBUG: [CoreTemplateProvider]: Type:
administrative task, Alias: Admin Permission: CREATE_ADMINISTRATIVE
TASK
2010-10-19 13:33:25,618 Trac[log] DEBUG: [CoreTemplateProvider]: Type:
bug, Alias: Bug Permission: AGILO_CREATE_BUG
2010-10-19 13:33:25,618 Trac[log] DEBUG: [CoreTemplateProvider]: hka
has create permission for types: [u'requirement', u'task', u'story',
u'administrative task', u'bug']
2010-10-19 13:33:25,618 Trac[main] ERROR: Internal Server Error:
Traceback (most recent call last):
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\web\main.py", line 450, in _dispatch_request
dispatcher.dispatch(req)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\web\main.py", line 206, in dispatch
resp = chosen_handler.process_request(req)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\api\view.py", line 323, in process_request
self.error_response(req, {}, [msg])
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\json_ui.py", line 138, in error_response
current_data = self.get_ticket_as_json_if_allowed(req)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\json_ui.py", line 134, in
get_ticket_as_json_if_allowed
return self.get_ticket_as_json(req, ticket.id)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\json_ui.py", line 109, in get_ticket_as_json
ticket = self._ticket_without_cache(ticket_id)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\json_ui.py", line 102, in _ticket_without_cache
ticket = AgiloTicket(self.env, ticket_id)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\model.py", line 122, in __init__
self._fetch_ticket(tkt_id, db=db, t_type=t_type)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\model.py", line 147, in _fetch_ticket
t_type = self._get_type(tkt_id, db)
File "c:\python25\lib\site-packages\binary_agilo-1.3.0.7_PRO-
py2.5.egg\agilo\ticket\model.py", line 886, in _get_type
cursor.execute(sql_get_type)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\db\util.py", line 65, in execute
return self.cursor.execute(sql)
File "c:\python25\lib\site-packages\Trac-0.11.7-py2.5-win32.egg\trac
\db\util.py", line 65, in execute
return self.cursor.execute(sql)
InternalError: current transaction is aborted, commands ignored until
end of transaction block
InternalError: current transaction is aborted, commands ignored until
end of transaction block
2010-10-19 13:33:25,650 Trac[chrome] DEBUG: Prepare chrome data for
request
2010-10-19 13:33:25,681 Trac[tande_filters] DEBUG:
self.billing_reports= set([])
--
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-scrum
http://freshmeat.net/projects/agiloforscrum
You have received this message because you are subscribed to
the "Agilo for Scrum" Google Group. This group is focused on
supporting Agilo for Scrum users and is moderated by
Agilo Software GmbH <http://www.agiloforscrum.com>.
To post to this group, send email to [email protected]
To unsubscribe from this group, send an email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo
