id summary reporter owner description type status priority component severity resolution keywords cc release 4648 [DiscussionPlugin] Upgrade fails after creating new project in multiproject setup Taras Mankovski Radek Bartoň "Hello There, I have trac setup in multi project configuration. All projects inherit from one trac.ini file. The global trac.ini file activates DiscussionPlugin. The problem occurs when I create a new project using --inherit option. when I open the project page the first time I get the following error {{{ Trac Error TracError: The Trac Environment needs to be upgraded. Run ""trac-admin /var/lib/trac/sites/optego upgrade"" }}} The log files shows the following entries {{{ 2009-02-17 14:19:37,548 Trac[loader] DEBUG: Adding plugin TracWysiwyg 0.2-r4353 from /var/lib/trac/global/plugins/TracWysiwyg-0.2_r4353-py2.5.egg 2009-02-17 14:19:37,548 Trac[loader] DEBUG: Adding plugin TracAccountManager 0.2.1dev-r3857 from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,548 Trac[loader] DEBUG: Adding plugin TracUserManagerPlugin 0.3 from /usr/lib64/python2.5/site-packages/TracUserManagerPlugin-0.3-py2.5.egg 2009-02-17 14:19:37,549 Trac[loader] DEBUG: Adding plugin AutocompleteUsers 0.4.1 from /var/lib/trac/global/plugins/AutocompleteUsers-0.4.1-py2.5.egg 2009-02-17 14:19:37,549 Trac[loader] DEBUG: Adding plugin Genshi 0.5.1 from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,549 Trac[loader] DEBUG: Adding plugin setuptools 0.6c8 from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,549 Trac[loader] DEBUG: Adding plugin TracDiscussion 0.6 from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,549 Trac[loader] DEBUG: Adding plugin TicketImport 0.7b from /var/lib/trac/global/plugins/TicketImport-0.7b-py2.5.egg 2009-02-17 14:19:37,550 Trac[loader] DEBUG: Adding plugin timingandestimationplugin 0.7.3 from /var/lib/trac/global/plugins/timingandestimationplugin-0.7.3-py2.5.egg 2009-02-17 14:19:37,550 Trac[loader] DEBUG: Adding plugin AdvancedTicketWorkflowPlugin 0.10dev-r3940 from /var/lib/trac/global/plugins/AdvancedTicketWorkflowPlugin-0.10dev_r3940-py2.5.egg 2009-02-17 14:19:37,550 Trac[loader] DEBUG: Adding plugin Trac 0.11.2 from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,550 Trac[loader] DEBUG: Adding plugin TracXMLRPC 1.0.0 from /var/lib/trac/global/plugins/TracXMLRPC-1.0.0-py2.5.egg 2009-02-17 14:19:37,550 Trac[loader] DEBUG: Adding plugin TracMasterTickets 2.1.3 from /var/lib/trac/global/plugins/TracMasterTickets-2.1.3-py2.5.egg 2009-02-17 14:19:37,551 Trac[loader] DEBUG: Skipping ""TracHtGroupEditor 1.0dev-r1949"": (""TracWebAdmin"" not found) 2009-02-17 14:19:37,551 Trac[loader] DEBUG: Loading acct_mgr.admin from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,551 Trac[loader] DEBUG: Loading acct_mgr.db from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,551 Trac[loader] DEBUG: Loading acct_mgr.htfile from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,551 Trac[loader] DEBUG: Loading acct_mgr.http from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,551 Trac[loader] DEBUG: Loading acct_mgr.notification from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,552 Trac[loader] DEBUG: Loading acct_mgr.pwhash from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,552 Trac[loader] DEBUG: Loading acct_mgr.svnserve from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,552 Trac[loader] DEBUG: Loading acct_mgr.web_ui from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,552 Trac[loader] DEBUG: Loading acct_mgr.api from /usr/lib64/python2.5/site-packages/TracAccountManager-0.2.1dev_r3857-py2.5.egg 2009-02-17 14:19:37,552 Trac[loader] DEBUG: Loading tracusermanager.account from /usr/lib64/python2.5/site-packages/TracUserManagerPlugin-0.3-py2.5.egg 2009-02-17 14:19:37,552 Trac[loader] DEBUG: Loading tracusermanager.api from /usr/lib64/python2.5/site-packages/TracUserManagerPlugin-0.3-py2.5.egg 2009-02-17 14:19:37,553 Trac[loader] DEBUG: Loading tracusermanager.profile from /usr/lib64/python2.5/site-packages/TracUserManagerPlugin-0.3-py2.5.egg 2009-02-17 14:19:37,553 Trac[loader] DEBUG: Loading tracusermanager.permissions from /usr/lib64/python2.5/site-packages/TracUserManagerPlugin-0.3-py2.5.egg 2009-02-17 14:19:37,553 Trac[loader] DEBUG: Loading tracusermanager.admin from /usr/lib64/python2.5/site-packages/TracUserManagerPlugin-0.3-py2.5.egg 2009-02-17 14:19:37,553 Trac[loader] DEBUG: Loading trac.ticket.web_ui from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,553 Trac[loader] DEBUG: Loading trac.mimeview.php from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,554 Trac[loader] DEBUG: Loading trac.ticket.query from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,554 Trac[loader] DEBUG: Loading trac.attachment from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,554 Trac[loader] DEBUG: Loading trac.versioncontrol.svn_fs from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,555 Trac[loader] DEBUG: Loading trac.mimeview.patch from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,555 Trac[loader] DEBUG: Loading trac.mimeview.txtl from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,555 Trac[loader] DEBUG: Loading trac.admin.web_ui from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,556 Trac[loader] DEBUG: Loading trac.ticket.admin from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,556 Trac[loader] DEBUG: Loading trac.mimeview.rst from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,556 Trac[loader] DEBUG: Loading trac.db.postgres from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,557 Trac[loader] DEBUG: Loading trac.versioncontrol.web_ui from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,557 Trac[loader] DEBUG: Loading trac.timeline from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,557 Trac[loader] DEBUG: Loading trac.mimeview.pygments from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,558 Trac[loader] DEBUG: Loading trac.about from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,558 Trac[loader] DEBUG: Loading trac.ticket.roadmap from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,558 Trac[loader] DEBUG: Loading trac.mimeview.silvercity from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,569 Trac[loader] DEBUG: Skipping ""trac.mimeview.silvercity = trac.mimeview.silvercity [silvercity]"": (""SilverCity>=0.9.4"" not found) 2009-02-17 14:19:37,569 Trac[loader] DEBUG: Loading trac.wiki.macros from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,569 Trac[loader] DEBUG: Loading trac.db.sqlite from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,570 Trac[loader] DEBUG: Loading trac.wiki.web_ui from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,570 Trac[loader] DEBUG: Loading trac.mimeview.enscript from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,570 Trac[loader] DEBUG: Loading trac.web.auth from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,571 Trac[loader] DEBUG: Loading trac.admin.console from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,571 Trac[loader] DEBUG: Loading trac.db.mysql from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,571 Trac[loader] DEBUG: Loading trac.search from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,571 Trac[loader] DEBUG: Loading trac.prefs from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,572 Trac[loader] DEBUG: Loading trac.ticket.report from /usr/lib64/python2.5/site-packages 2009-02-17 14:19:37,572 Trac[loader] DEBUG: Loading tracwysiwyg from /var/lib/trac/global/plugins/TracWysiwyg-0.2_r4353-py2.5.egg 2009-02-17 14:19:37,572 Trac[loader] DEBUG: Loading autocompleteusers from /var/lib/trac/global/plugins/AutocompleteUsers-0.4.1-py2.5.egg 2009-02-17 14:19:37,572 Trac[loader] DEBUG: Loading TracDiscussion.core from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,573 Trac[loader] DEBUG: Loading TracDiscussion.api from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,573 Trac[loader] DEBUG: Loading TracDiscussion.init from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,573 Trac[loader] DEBUG: Loading TracDiscussion.search from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,573 Trac[loader] DEBUG: Loading TracDiscussion.timeline from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,573 Trac[loader] DEBUG: Loading TracDiscussion.wiki from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,574 Trac[loader] DEBUG: Loading TracDiscussion.admin from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,574 Trac[loader] DEBUG: Loading TracDiscussion.notification from /var/lib/trac/global/plugins/TracDiscussion-0.6-py2.5.egg 2009-02-17 14:19:37,574 Trac[loader] DEBUG: Loading TicketImport from /var/lib/trac/global/plugins/TicketImport-0.7b-py2.5.egg 2009-02-17 14:19:37,574 Trac[loader] DEBUG: Loading timingandestimationplugin from /var/lib/trac/global/plugins/timingandestimationplugin-0.7.3-py2.5.egg 2009-02-17 14:19:37,574 Trac[loader] DEBUG: Loading advancedworkflow.controller from /var/lib/trac/global/plugins/AdvancedTicketWorkflowPlugin-0.10dev_r3940-py2.5.egg 2009-02-17 14:19:37,574 Trac[loader] DEBUG: Loading TracXMLRPC from /var/lib/trac/global/plugins/TracXMLRPC-1.0.0-py2.5.egg 2009-02-17 14:19:37,575 Trac[loader] DEBUG: Loading mastertickets.web_ui from /var/lib/trac/global/plugins/TracMasterTickets-2.1.3-py2.5.egg 2009-02-17 14:19:37,575 Trac[loader] DEBUG: Loading mastertickets.api from /var/lib/trac/global/plugins/TracMasterTickets-2.1.3-py2.5.egg 2009-02-17 14:19:37,596 Trac[default_workflow] DEBUG: Workflow actions at initialization: {'resolve': {'operations': [u'set_resolution'], 'name': 'resolve', 'default': 1, 'newstate': u'testing', 'oldstates': [u'assigned', u'accepted'], 'permissions': [u'TICKET_MODIFY']}, 'close_new': {'operations': [u'set_resolution'], 'name': u'close', 'default': 0, 'newstate': u'closed', 'oldstates': [u'new', u'reopened'], 'permissions': [u'TICKET_ADMIN']}, 'accept': {'operations': [u'set_owner_to_self'], 'name': 'accept', 'default': 3, 'newstate': u'accepted', 'oldstates': [u'new', u'assigned', u'accepted', u'reopened'], 'permissions': [u'TICKET_MODIFY']}, 'leave': {'operations': [u'leave_status'], 'name': 'leave', 'default': 4, 'newstate': u'*', 'oldstates': [u'*'], 'permissions': []}, 'reopen': {'operations': [u'del_resolution'], 'name': 'reopen', 'default': 3, 'newstate': u'reopened', 'oldstates': [u'testing', u'closed'], 'permissions': [u'TICKET_CREATE']}, 'reassign': {'operations': [u'set_owner'], 'name': 'reassign', 'default': 2, 'newstate': u'assigned', 'oldstates': [u'new', u'assigned', u'accepted', u'reopened'], 'permissions': [u'TICKET_MODIFY']}, 'close': {'operations': [], 'name': 'close', 'default': 0, 'newstate': u'closed', 'oldstates': [u'testing'], 'permissions': [u'TICKET_ADMIN']}, '_reset': {'operations': ['reset_workflow'], 'name': 'reset', 'default': 0, 'newstate': 'new', 'oldstates': [], 'permissions': []}} 2009-02-17 14:19:37,604 Trac[init] DEBUG: SELECT value FROM system WHERE name='discussion_version' 2009-02-17 14:19:37,604 Trac[env] WARNING: Component requires environment upgrade }}} If I run trac-admin project upgrade, I get the following error {{{ trac-admin ../sites/optego/ upgrade Traceback (most recent call last): File ""/usr/bin/trac-admin"", line 8, in load_entry_point('Trac==0.11.2', 'console_scripts', 'trac-admin')() File ""/usr/lib64/python2.5/site-packages/trac/admin/console.py"", line 1294, in run return admin.onecmd(command) File ""/usr/lib64/python2.5/site-packages/trac/admin/console.py"", line 123, in onecmd rv = cmd.Cmd.onecmd(self, line) or 0 File ""/usr/lib64/python2.5/cmd.py"", line 219, in onecmd return func(arg) File ""/usr/lib64/python2.5/site-packages/trac/admin/console.py"", line 1144, in do_upgrade self.__env.upgrade(backup=do_backup) File ""/usr/lib64/python2.5/site-packages/trac/env.py"", line 449, in upgrade participant.upgrade_environment(db) File ""build/bdist.linux-x86_64/egg/tracdiscussion/init.py"", line 35, in upgrade_environment File ""build/bdist.linux-x86_64/egg/tracdiscussion/db/db2.py"", line 31, in do_upgrade File ""/usr/lib64/python2.5/site-packages/trac/db/util.py"", line 51, in execute return self.cursor.execute(sql) File ""/usr/lib64/python2.5/site-packages/trac/db/sqlite_backend.py"", line 58, in execute args or []) File ""/usr/lib64/python2.5/site-packages/trac/db/sqlite_backend.py"", line 50, in _rollback_on_error return function(self, *args, **kwargs) sqlite3.OperationalError: table forum_group already exists }}} This is the only component that exhibits this kind of problem after installation. Thank you, Taras" defect closed normal DiscussionPlugin critical fixed multi-projects upgrade 0.11