Update: we tried executing the SELECT directly against trac,db
(SQLite) and:
SELECT description, name, sorting_keys, ticket_types,
b_type FROM agilo_backlog ORDER BY b_type, name
works fine.
BUT, SELECT description, name, sorting_keys, ticket_types,
b_type FROM agilo_backlog ORDER BY b_type, name {}
blocks and freezes. it appears that somehow the trailing empty braces
("{}") causes the problem
On Jun 3, 12:42 pm, Lior K <[email protected]> wrote:
> Hi,
>
> We've encountered an issue with the latest version of Agilo Open.
> Yesterday we rebooted our server, and since then the backlog views are
> not loading (any type of backlog).
>
> The backlog headers are showing, and then the contents are waiting to
> be displayed forever.
> we set up a DEBUG log and the last lines in the log are:
>
> 2010-06-03 12:37:09,776 Trac[log] DEBUG: [Environment]: SELECT =>
> Executing Query: SELECT description, name, team, ts_fri, ts_mon,
> ts_sat, ts_sun, ts_thu, ts_tue, ts_wed FROM agilo_team_member WHERE
> agilo_team_member.team=%(team)s {'team': u'VeNotion-Dev'}
> 2010-06-03 12:37:09,796 Trac[log] DEBUG: [Sprint]: Returning duration
> 18 start: 2009-12-22 22:00:00+00:00, end: 2010-01-14 22:00:00+00:00
> 2010-06-03 12:37:09,816 Trac[log] DEBUG: [Sprint]: Returning duration
> 15 start: 2010-01-19 08:00:00+00:00, end: 2010-02-08 20:00:00+00:00
> 2010-06-03 12:37:09,836 Trac[log] DEBUG: [Sprint]: Returning duration
> 43 start: 2010-02-10 22:00:00+00:00, end: 2010-04-09 17:00:00+00:00
> 2010-06-03 12:37:09,856 Trac[log] DEBUG: [Sprint]: Returning duration
> 15 start: 2010-04-12 07:52:29+00:00, end: 2010-04-30 17:00:00+00:00
> 2010-06-03 12:37:09,876 Trac[log] DEBUG: [Sprint]: Returning duration
> 11 start: 2010-05-03 06:00:00+00:00, end: 2010-05-17 18:00:00+00:00
> 2010-06-03 12:37:09,896 Trac[log] DEBUG: [Sprint]: Returning duration
> 23 start: 2010-05-20 06:00:00+00:00, end: 2010-06-21 18:00:00+00:00
> 2010-06-03 12:37:09,916 Trac[log] DEBUG: [Environment]: SELECT =>
> Executing Query: SELECT description, name, sorting_keys, ticket_types,
> b_type FROM agilo_backlog ORDER BY b_type, name {}
>
> I suspect some DB issue, and will appreciate any help.
>
> thanks!
--
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
agile42 GmbH <http://www.agile42.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
