Hi
I've tried to register for an account on the issue tracker but I get a
404 error using the link(https://issues.apache.org/bloodhound/register)
Anyway, I'm trying our bloodhound for as an option for migrating our
current issue tracking system. Our tracking system contains 232 products
and >6000 tickets.
I've written a script which loads the data into the bloodhound
database, but the 232 projects make bloodhound VERY slow. Every page
load takes more than 30 sec. The cpu load from tracd is at 99% and the
postgress sql database is also takes quite a beating.
The log shows an entry like this for every product(and for every page load):
2015-03-24 13:07:41,157 Trac[env] DEBUG: Log type 'file' for product '3'
2015-03-24 13:07:41,157 Trac[env] INFO: Inheriting parent logger for
product '3'
2015-03-24 13:07:41,158 Trac[default_workflow] DEBUG: Workflow actions
at initialization: {u'resolve': {u'operations': [u'set_resolution'],
'name': u'resolve', 'default': 0, 'newstate': u'closed', 'oldstates':
[u'new', u'assigned', u'accepted', u'reopened'], u'permissions':
[u'TICKET_MODIFY']}, u'accept': {u'operations': [u'set_owner_to_self'],
'name': u'accept', 'default': 0, 'newstate': u'accepted', 'oldstates':
[u'new', u'assigned', u'accepted', u'reopened'], u'permissions':
[u'TICKET_MODIFY']}, u'leave': {u'operations': [u'leave_status'],
'name': u'leave', u'default': 1, 'newstate': u'*', 'oldstates': [u'*'],
'permissions': []}, u'reopen': {u'operations': [u'del_resolution'],
'name': u'reopen', 'default': 0, 'newstate': u'reopened', 'oldstates':
[u'closed'], u'permissions': [u'TICKET_CREATE']}, u'reassign':
{u'operations': [u'set_owner'], 'name': u'reassign', 'default': 0,
'newstate': u'assigned', 'oldstates': [u'new', u'assigned', u'accepted',
u'reopened'], u'permissions': [u'TICKET_MODIFY']}, '_reset':
{'operations': ['reset_workflow'], 'name': 'reset', 'default': 0,
'newstate': 'new', 'oldstates': [], 'permissions': []}}
2015-03-24 13:07:41,158 Trac[api] DEBUG: action controllers for ticket
workflow: ['ConfigurableTicketWorkflow']
2015-03-24 13:07:41,159 Trac[env] INFO: --------------------------------
product 3 environment startup [Trac 1.0.1] --------------------------------
2015-03-24 13:07:41,159 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,159 Trac[util] DEBUG: args: [u'3', u'trac',
u'permission_policies']
2015-03-24 13:07:41,162 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,162 Trac[util] DEBUG: args: [u'3', u'trac',
u'permission_policies']
2015-03-24 13:07:41,163 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s
2015-03-24 13:07:41,163 Trac[util] DEBUG: args: [u'3', u'components']
2015-03-24 13:07:41,164 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,165 Trac[util] DEBUG: args: [u'3', u'components',
u'acct_mgr.admin.*']
2015-03-24 13:07:41,165 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,166 Trac[util] DEBUG: args: [u'3', u'components',
u'acct_mgr.api.accountmanager']
2015-03-24 13:07:41,167 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,167 Trac[util] DEBUG: args: [u'3', u'components',
u'acct_mgr.guard.accountguard']
2015-03-24 13:07:41,167 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,168 Trac[util] DEBUG: args: [u'3', u'components',
u'acct_mgr.htfile.htdigeststore']
2015-03-24 13:07:41,168 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,169 Trac[util] DEBUG: args: [u'3', u'components',
u'acct_mgr.macros.*']
2015-03-24 13:07:41,169 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,169 Trac[util] DEBUG: args: [u'3', u'components',
u'acct_mgr.web_ui.accountmodule']
2015-03-24 13:07:41,170 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,170 Trac[util] DEBUG: args: [u'3', u'components',
u'acct_mgr.web_ui.loginmodule']
2015-03-24 13:07:41,171 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,171 Trac[util] DEBUG: args: [u'3', u'components',
u'bhdashboard.*']
2015-03-24 13:07:41,172 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,172 Trac[util] DEBUG: args: [u'3', u'components',
u'bhrelations.*']
2015-03-24 13:07:41,174 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,174 Trac[util] DEBUG: args: [u'3', u'ticket',
u'workflow']
2015-03-24 13:07:41,174 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,174 Trac[util] DEBUG: args: [u'3', u'components',
u'bhsearch.*']
2015-03-24 13:07:41,176 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,177 Trac[util] DEBUG: args: [u'3', u'components',
u'bhtheme.*']
2015-03-24 13:07:41,177 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s
2015-03-24 13:07:41,178 Trac[util] DEBUG: args: [u'3', u'ticket-workflow']
2015-03-24 13:07:41,178 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,180 Trac[util] DEBUG: args: [u'3', u'components',
u'multiproduct.*']
2015-03-24 13:07:41,179 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,181 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'accept']
2015-03-24 13:07:41,182 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,182 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'accept.operations']
2015-03-24 13:07:41,181 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,182 Trac[util] DEBUG: args: [u'3', u'components',
u'permredirect.*']
2015-03-24 13:07:41,183 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,183 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'accept.permissions']
2015-03-24 13:07:41,184 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,184 Trac[util] DEBUG: args: [u'3', u'components',
u'themeengine.api.*']
2015-03-24 13:07:41,185 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,185 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'leave']
2015-03-24 13:07:41,185 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,185 Trac[util] DEBUG: args: [u'3', u'components',
u'themeengine.web_ui.*']
2015-03-24 13:07:41,186 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,187 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'leave.default']
2015-03-24 13:07:41,187 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,187 Trac[util] DEBUG: args: [u'3', u'components',
u'trac.ticket.report.reportmodule']
2015-03-24 13:07:41,188 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,188 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'leave.operations']
2015-03-24 13:07:41,188 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,188 Trac[util] DEBUG: args: [u'3', u'components',
u'trac.ticket.web_ui.ticketmodule']
2015-03-24 13:07:41,189 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,189 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'reassign']
2015-03-24 13:07:41,190 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,190 Trac[util] DEBUG: args: [u'3', u'components',
u'trac.web.auth.loginmodule']
2015-03-24 13:07:41,192 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,192 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'reassign.operations']
2015-03-24 13:07:41,194 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,194 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'reassign.permissions']
2015-03-24 13:07:41,195 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,195 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'reopen']
2015-03-24 13:07:41,196 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,196 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'reopen.operations']
2015-03-24 13:07:41,197 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,197 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'reopen.permissions']
2015-03-24 13:07:41,199 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,200 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'resolve']
2015-03-24 13:07:41,200 Trac[util] DEBUG: SQL: SELECT
"prefix","name","description","owner" FROM bloodhound_product WHERE
"prefix"=%s
2015-03-24 13:07:41,201 Trac[util] DEBUG: args: [u'23']
2015-03-24 13:07:41,201 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,201 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'resolve.operations']
2015-03-24 13:07:41,202 Trac[util] DEBUG: SQL: SELECT
"product","section","option","value" FROM bloodhound_productconfig WHERE
"product"=%s AND "section"=%s AND "option"=%s
2015-03-24 13:07:41,202 Trac[util] DEBUG: args: [u'3',
u'ticket-workflow', u'resolve.permissions']
Any ideas on what could be the issue?
Thanks in advance
/Anders
