Modify ↓

Opened 15 years ago

Closed 7 years ago

#5774 closed defect (fixed)

No such table: subscriptions

Reported by: davidrkirk@… Owned by:
Priority: high Component: AnnouncerPlugin
Severity: blocker Keywords: ProgrammingError upgrade db
Cc: trac@…, Ryan J Ollos, Robert Corsaro Trac Release: 0.11

Description

I've just installed AnnouncerPlugin and now when I go to any wiki page or a ticket I get the error 

OperationalError: no such table: subscriptions

This is how I installed. I downloaded the zip file, unzipped it and built the egg file. I copied the egg to my plugins directory. I renamed [notifications] to [announcer]. I put this under [components] 

announcerplugin.* = enabled
announcerplugin.subscribers.ticket_groups.* = disabled

Have I missed a step to update the database or something? I couldn't see anything about it in the doco.

I'm running Trac 0.11.5 and AnnouncerPlugin 0.2.

Attachments (0)

Change History (28)

comment:1 Changed 15 years ago by davidrkirk@…

If I turn off WatchSubscriber then the problem goes away, but obviously I can subscribe to anything.

comment:2 Changed 15 years ago by Ryan J Ollos

Summary: no such table: subscriptions → No such table: subscriptions

comment:3 Changed 15 years ago by davidrkirk@…

Ran trac-admin /var/trac upgrade and now it seems to be working.

If this is what fixed my problem, then maybe the documentation should be updated?

comment:4 Changed 14 years ago by anonymous

Cc: trac@… added; anonymous removed
Severity: normal → blocker

I too receive this error with the Watchlist and Announcer plugins installed, running Trac 0.11.5 on Python 1.6.4 on Windows 2003. 

Trac detected an internal error:

OperationalError: no such table: subscriptions

Python Traceback 

Most recent call last:
    * File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\web\main.py", line 444, in _dispatch_request
      Code fragment:
       439. try:
       440. if not env and env_error:
       441. raise HTTPInternalError(env_error)
       442. try:
       443. dispatcher = RequestDispatcher(env)
       444. dispatcher.dispatch(req)
       445. except RequestDone:
       446. pass
       447. resp = req._response or []
       448.  
       449. 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 0x01AA03B0>
      e 	OperationalError('no such table: subscriptions',)
      env 	<trac.env.Environment object at 0x0105D870>
      env_error 	None
      exc_info 	(<class 'sqlite3.OperationalError'>, OperationalError('no such table: ...
      filename 	'C:\\Python26\\lib\\site-packages\\trac-0.11.5-py2.6.egg\\trac\\web\\main.p ...
      frames 	[{'function': '_dispatch_request', 'lines_before': [u' try:', u' ...
      has_admin 	True
      line 	u' dispatcher.dispatch(req)'
      lineno 	443
      message 	u'OperationalError: no such table: subscriptions'
      req 	<Request "GET u'/ticket/14'">
      resp 	[]
      tb 	<traceback object at 0x01ADB0F8>
      tb_hide 	None
      traceback 	u'Traceback (most recent call last):\n File ...
    * File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\web\main.py", line 216, in dispatch
      Code fragment:
       211. # Give the session a chance to persist changes
       212. req.session.save()
       213. req.display(template, content_type or 'text/html')
       214. else: # Genshi
       215. template, data, content_type = \
       216. self._post_process_request(req, *resp)
       217. if 'hdfdump' in req.args:
       218. req.perm.require('TRAC_ADMIN')
       219. # debugging helper - no need to render first
       220. from pprint import pprint
       221. out = StringIO()
      Local variables:
      Name	Value
      chosen_handler 	<trac.ticket.web_ui.TicketModule object at 0x01AA0C50>
      chrome 	<trac.web.chrome.Chrome object at 0x01ACDAD0>
      e 	OperationalError('no such table: subscriptions',)
      err 	(<class 'sqlite3.OperationalError'>, OperationalError('no such table: ...
      handler 	<trac.ticket.web_ui.TicketModule object at 0x01AA0C50>
      req 	<Request "GET u'/ticket/14'">
      resp 	('ticket.html', {'comment': None, 'change_preview': None, ...
      self 	<trac.web.main.RequestDispatcher object at 0x01AA03B0>
    * File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\web\main.py", line 308, in _post_process_request
      Code fragment:
       303. # Trac 0.10, only filters with same arity gets passed real values.
       304. # Errors will call all filters with None arguments,
       305. # and results will not be not saved.
       306. extra_arg_count = arity(f.post_process_request) - 2
       307. if extra_arg_count == nbargs:
       308. resp = f.post_process_request(req, *resp)
       309. elif nbargs == 0:
       310. f.post_process_request(req, *(None,)*extra_arg_count)
       311. return resp
       312.  
       313.  
      Local variables:
      Name	Value
      args 	('ticket.html', {'comment': None, 'change_preview': None, ...
      extra_arg_count 	3
      f 	<tracwatchlist.plugin.WatchlistPlugin object at 0x01ACDEB0>
      nbargs 	3
      req 	<Request "GET u'/ticket/14'">
      resp 	('ticket.html', {'comment': None, 'change_preview': None, ...
      self 	<trac.web.main.RequestDispatcher object at 0x01AA03B0>
    * File "C:\Python26\lib\site-packages\tracwatchlistplugin-0.4.7094-py2.6.egg\tracwatchlist\plugin.py", line 517, in post_process_request
      Code fragment:
       512. resid=resid, realm=realm), title="Remove %s from watchlist" % realm)
       513. else:
       514. add_ctxtnav(req, "Watch", href=href('watchlist', action='watch',
       515. resid=resid, realm=realm), title="Add %s to watchlist" % realm)
       516. if self.gnotify and self.notifyctxtnav:
       517. if self.is_notify(req.session.sid, True, realm, resid):
       518. add_ctxtnav(req, "Do not Notify me", href=href('watchlist', action='notifyoff',
       519. resid=resid, realm=realm), title="No not notify me if %s changes" % realm)
       520. else:
       521. add_ctxtnav(req, "Notify me", href=href('watchlist', action='notifyon',
       522. resid=resid, realm=realm), title="Notify me if %s changes" % realm)
      Local variables:
      Name	Value
      content_type 	None
      data 	{'comment': None, 'change_preview': None, 'description_change': None, ...
      href 	<trac.web.href.Href object at 0x01E25110>
      msg 	[]
      parts 	[u'ticket', u'14']
      realm 	u'ticket'
      req 	<Request "GET u'/ticket/14'">
      resid 	u'14'
      self 	<tracwatchlist.plugin.WatchlistPlugin object at 0x01ACDEB0>
      template 	'ticket.html'
      user 	u'robert.morris'
    * File "build\bdist.win32\egg\announcerplugin\subscribers\watchers.py", line 77, in is_watching
      Local variables:
      Name	Value
      authenticated 	True
      cursor 	<trac.db.util.IterableCursor object at 0x01DFA450>
      db 	<trac.db.pool.PooledConnection object at 0x01E6B260>
      realm 	u'ticket'
      resource 	u'14'
      self 	<tracwatchlist.plugin.WatchlistPlugin object at 0x01ACDEB0>
      sid 	u'robert.morris'
    * File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\db\util.py", line 59, in execute
      Code fragment:
        54. return self.cursor.execute(sql)
        55. except Exception, e:
        56. self.log.debug('execute exception: %r', e)
        57. raise
        58. if args:
        59. return self.cursor.execute(sql_escape_percent(sql), args)
        60. return self.cursor.execute(sql)
        61.  
        62. def executemany(self, sql, args=None):
        63. if self.log:
        64. self.log.debug('SQL: %r', sql)
      Local variables:
      Name	Value
      args 	(u'robert.morris', 1, 'watcher', u'ticket', '*', u'14')
      self 	<trac.db.util.IterableCursor object at 0x01DFA450>
      sql 	'\n SELECT id\n FROM subscriptions\n ...
    * File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.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'robert.morris', 1, 'watcher', u'ticket', '*', u'14')
      self 	<trac.db.sqlite_backend.PyFormatCursor object at 0x01D2E540>
      sql 	'\n SELECT id\n FROM subscriptions\n ...
    * File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.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 	('\n SELECT id\n FROM subscriptions\n ...
      e 	OperationalError('no such table: subscriptions',)
      function 	<method 'execute' of 'sqlite3.Cursor' objects>
      kwargs 	{}
      self 	<trac.db.sqlite_backend.PyFormatCursor object at 0x01D2E540>

File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\web\main.py", line 444, in _dispatch_request
  dispatcher.dispatch(req)
File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\web\main.py", line 216, in dispatch
  self._post_process_request(req, *resp)
File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\web\main.py", line 308, in _post_process_request
  resp = f.post_process_request(req, *resp)
File "C:\Python26\lib\site-packages\tracwatchlistplugin-0.4.7094-py2.6.egg\tracwatchlist\plugin.py", line 517, in post_process_request
  if self.is_notify(req.session.sid, True, realm, resid):
File "build\bdist.win32\egg\announcerplugin\subscribers\watchers.py", line 77, in is_watchingFile "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\db\util.py", line 59, in execute
  return self.cursor.execute(sql_escape_percent(sql), args)
File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\db\sqlite_backend.py", line 58, in execute
  args or [])
File "C:\Python26\lib\site-packages\trac-0.11.5-py2.6.egg\trac\db\sqlite_backend.py", line 50, in _rollback_on_error
  return function(self, *args, **kwargs)

comment:5 Changed 14 years ago by Robert Corsaro

It is normal that any trac plugin that adds tables won't work without running trac-admin /path/to/env upgrade. It is not normal that you don't get a giant message telling you you need to run this command. I'll look into why and update the doc.

comment:6 Changed 14 years ago by Robert Corsaro

Priority: normal → low
Severity: blocker → minor

comment:7 Changed 14 years ago by anonymous

Priority: low → high
Severity: minor → blocker

Running trac-admin /path/to/env upgrade results in the message: 

Database is up to date, no upgrade necessary.

comment:8 Changed 14 years ago by anonymous

Priority: high → highest

comment:9 Changed 14 years ago by Robert Corsaro 

    def environment_needs_upgrade(self, db):
        cursor = db.cursor()
        try:
            cursor.execute("select count(*) from subscriptions")
            cursor.fetchone()
            return False
        except:
            db.rollback()
            return True

I don't understand how this can result in no upgrade if the table doesn't exist! Did some api change?

comment:10 Changed 14 years ago by Robert Corsaro

I just tested with trac trunk by dropping the subscriptions table. I got the "trac needs upgrade" message as expected. Running trac upgrade created the table. I can't reproduce this error. What DB are you using? Is there a permission problem? What happens when you run the above query manually?

comment:11 in reply to:  9 Changed 14 years ago by anonymous

Replying to doki_pen:

I don't understand how this can result in no upgrade if the table doesn't exist! Did some api change?

I just installed from scratch on Trac 0.12dev-r9098 and received the 'Database needs upgrade' notification as expected, so I don't think it is an API change.

comment:12 Changed 14 years ago by Ryan J Ollos

comment:11 was mine.

comment:13 Changed 14 years ago by anonymous

Resolution: → worksforme
Status: new → closed

comment:14 Changed 12 years ago by anonymous

It is still out of work. When I go to prefs, subscriptions I get 

Oops…
Trac detected an internal error:
OperationalError: no such table: subscription

When I try to upgrade database, I get AttributeError:

comment:15 in reply to:  14 Changed 12 years ago by Ryan J Ollos

Replying to anonymous:

It is still out of work. When I go to prefs, subscriptions I get [...] When I try to upgrade database, I get AttributeError:

This sounds like the issue described in #9742. We don't have a fix yet, but hope to have one soon. Please follow that ticket if you are interested.

comment:16 Changed 12 years ago by Steffen Hoffmann

Keywords: ProgrammingError upgrade db added
Priority: highest → high
Resolution: worksforme
Status: closed → reopened

First, thanks for the report, and all comments.

Second, as Ryan already pointed out, comment 14 is about another issue, that is rather unrelated. Everyone, please see and follow #9742 instead. Btw, that one is about a rather small Trac db API change.

Third, the issue here is about a major misconception of using Python exceptions with SQL queries since day one of this plugin. As discussed in ​t:#10451 SQL should be designed to succeed, especially in IEnvironmentSetupParticipant methods, where a single connection is passed around. One plugin can/will break the whole procedure. A fix is in Trac-1.0, but all plugins, that used the offending approach should be reworked as done for TagsPlugin lately.

Forth, priority and severity are agreeable after discussion, not to trigger it. And code rules, so the developers that are actually working on the code should be treated with due respected, and after all it's their ticket system, not a support forum (We have mailing-list for that, right?).

comment:17 Changed 12 years ago by Steffen Hoffmann

Cc: Ryan J Ollos Robert Corsaro added
Owner: changed from Robert Corsaro to Steffen Hoffmann
Status: reopened → new

Fifth and last for now, sorry for not taking this serious enough for much too long.

I confirm blocker status for that and will resolve the issue, but from the ground. It requires a major effort, that is WiP but will take yet another bit of time to fit in for misses and shortcomings in the past. Please bear with me.

comment:18 Changed 11 years ago by Steffen Hoffmann

(In [12296]) TracAnnouncer: Part 1 of 7 - Move towards a versioned db schema for this plugin, refs #5774 and #9742.

Main feature of the code added here:

  • schema version tracked in system Trac db table

Now we introduce the common, recommended approach of tracking plugin db schema versions in Trac db table system, that doesn't require any guessing later on.

This changeset requires a database upgrade.

Make sure to backup your db before upgrading, especially if you put faith into recovering user settings later on. While it may become technically possible to recover parts of an older configuration, the value of such a configuration is rather questionable in context of the current feature set, and I guess that doing a conceptual reinitialization by starting from scratch is what many (most?) users should consider anyway.

Stand back and wait, at least until it has survived more rigorous testing by other developers and until enough data migration code has been developed to preserve critical parts of your Trac applications configuration in production.

comment:19 Changed 11 years ago by Steffen Hoffmann

(In [12297]) TracAnnouncer: Part 2 of 7 - Restore db-related plugin history, refs #5774 and #9742.

Main feature of the code added here:

  • seamless schema upgrade by dedicated upgrade scripts - Trac core style

From the beginnung (see [3015]) this plugin's SQL driven schema check relied on a SELECT raising an exeption for non-existing db table. This has been discussed lately and found to be a flawed approach, that is even known to break installations and interferes with db upgrades for Trac 0.13dev and ultimately Trac 1.0 as well.

After introduction of the db schema version number for this plugin, table existence testing is required one last time, current schema version is registered, and only the registered schema version gets checked further on.

comment:20 Changed 11 years ago by Steffen Hoffmann

(In [12298]) TracAnnouncer: Part 3 of 7 - Follow historic footsteps in schema development for this plugin, refs #5774 and #9742.

The schema discovery logic already leaks a bit about my recent research and about the number of required follow-up changes to add an incremental upgrade module for each discovered schema revision as well.

Futhermore, thanks to Jun Omae we utilize a db-specific, non-intrusive query for retrieving the db table list used in any table existence check from now.

comment:21 Changed 11 years ago by Steffen Hoffmann

(In [12299]) TracAnnouncer: Part 4 of 7 - Just taste an evolutionary moment, refs #5774 and #9742.

The switch to the current subscription interface was certainly a reasonable and visionary step, but it has still some tasks pending for completion.

comment:22 Changed 11 years ago by Steffen Hoffmann

(In [12300]) TracAnnouncer: Part 5 of 7 - Care for some schema adjustments, refs #5774 and #9742.

Early adopters beware: The long-awaited script for data migration from subscriptions to subscription and subscription_attribute db tables is still a pending issue, that requires even more investigation.

Currently the upgrade procedure just drops the old table irrevocably, following corresponding historic schema changes, hereby labeled as revision 4. Make sure to backup your db before upgrading, if you still put faith into recovering some old user settings later on - you've been warned twice now.

comment:23 Changed 11 years ago by Steffen Hoffmann

(In [12301]) TracAnnouncer: Part 6 of 7 - The best way great ideas can go: refinement, refs #5774 and #9742.

With a seemingly small, but essential db table change we're approaching at the current db schema now.

comment:24 Changed 11 years ago by Steffen Hoffmann

(In [12302]) TracAnnouncer: Part 7 of 7 - Finally: Go from present to future, refs #5774, #7975, #8065, #9742 and #10384.

Now we've bridged the gap and provide an upgrade path for each historic schema revision of this plugin, while data migration is incomplete yet, especially regarding subscription attributes stored in session_attribute (before v3). Due to component name changes the conversion will be rather complicated, and therefore corresponding research and development is postponed to a future date and will largely depend on explicite demand as well.

comment:25 Changed 10 years ago by shorif2000

I am getting this problem too with bloodhound 0.7 when i run command 

(bloodhound)[root@cobra environments]# trac-admin main upgrade
The upgrade failed. Please fix the issue and try again.

OperationalError: no such table: @_subscription_attribute

see log 

2014-08-20 15:23:53,607 Trac[env] INFO: -------------------------------- environment startup [Trac 1.0.1] --------------------------------
2014-08-20 15:23:53,629 Trac[loader] DEBUG: Loading acct_mgr.admin from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,630 Trac[loader] DEBUG: Loading acct_mgr.api from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,630 Trac[loader] DEBUG: Loading acct_mgr.db from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,630 Trac[loader] DEBUG: Loading acct_mgr.htfile from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,631 Trac[loader] DEBUG: Loading acct_mgr.http from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,631 Trac[loader] DEBUG: Loading acct_mgr.macros from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,632 Trac[loader] DEBUG: Loading acct_mgr.notification from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,633 Trac[loader] DEBUG: Loading acct_mgr.pwhash from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,633 Trac[loader] DEBUG: Loading acct_mgr.svnserve from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,633 Trac[loader] DEBUG: Loading acct_mgr.web_ui from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,633 Trac[loader] DEBUG: Loading advancedworkflow.controller from /usr/lib/python2.6/site-packages/AdvancedTicketWorkflowPlugin-0.11dev_r13338-py2.6.egg
2014-08-20 15:23:53,635 Trac[loader] DEBUG: Loading announcer.api from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,637 Trac[loader] DEBUG: Loading announcer.distributors.mail from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,644 Trac[loader] DEBUG: Loading announcer.distributors.xmppd from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,656 Trac[loader] DEBUG: Skipping "announcer.distributors.xmppd = announcer.distributors.xmppd [xmpp]": ("DistributionNotFound: xmpppy" not found)
2014-08-20 15:23:53,656 Trac[loader] DEBUG: Loading announcer.email_decorators from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,657 Trac[loader] DEBUG: Loading announcer.filters from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,658 Trac[loader] DEBUG: Loading announcer.formatters from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,659 Trac[loader] DEBUG: Loading announcer.model from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,659 Trac[loader] DEBUG: Loading announcer.opt.acct_mgr.announce from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,660 Trac[loader] DEBUG: Loading announcer.opt.bitten.announce from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,669 Trac[loader] DEBUG: Skipping "announcer.opt.bitten.announce = announcer.opt.bitten.announce [bitten]": ("DistributionNotFound: Bitten" not found)
2014-08-20 15:23:53,669 Trac[loader] DEBUG: Loading announcer.opt.fullblog.announce from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,678 Trac[loader] DEBUG: Skipping "announcer.opt.fullblog.announce = announcer.opt.fullblog.announce [fullblog]": ("DistributionNotFound: TracFullBlogPlugin" not found)
2014-08-20 15:23:53,679 Trac[loader] DEBUG: Loading announcer.opt.subscribers from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,680 Trac[loader] DEBUG: Loading announcer.pref from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,680 Trac[loader] DEBUG: Loading announcer.producers from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,681 Trac[loader] DEBUG: Loading announcer.resolvers from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,691 Trac[loader] DEBUG: Loading announcer.subscribers from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,692 Trac[loader] DEBUG: Loading announcer.util.mail from /usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg
2014-08-20 15:23:53,692 Trac[loader] DEBUG: Loading bhdashboard.admin from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,768 Trac[loader] DEBUG: Loading bhdashboard.api from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,769 Trac[loader] DEBUG: Loading bhdashboard.layouts.bootstrap from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,770 Trac[loader] DEBUG: Loading bhdashboard.macros from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,770 Trac[loader] DEBUG: Loading bhdashboard.widgets.containers from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,773 Trac[loader] DEBUG: Loading bhdashboard.widgets.product from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,774 Trac[loader] DEBUG: Loading bhdashboard.widgets.query from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,774 Trac[loader] DEBUG: Loading bhdashboard.widgets.report from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,775 Trac[loader] DEBUG: Loading bhdashboard.widgets.ticket from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,778 Trac[loader] DEBUG: Loading bhdashboard.widgets.timeline from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,780 Trac[loader] DEBUG: Loading bhdashboard.wiki from /opt/html/apache-bloodhound-0.7/bloodhound_dashboard
2014-08-20 15:23:53,780 Trac[loader] DEBUG: Loading bhrelations.api from /opt/html/apache-bloodhound-0.7/bloodhound_relations
2014-08-20 15:23:53,783 Trac[loader] DEBUG: Loading bhrelations.search from /opt/html/apache-bloodhound-0.7/bloodhound_relations
2014-08-20 15:23:53,786 Trac[loader] DEBUG: Loading bhrelations.validation from /opt/html/apache-bloodhound-0.7/bloodhound_relations
2014-08-20 15:23:53,787 Trac[loader] DEBUG: Loading bhrelations.web_ui from /opt/html/apache-bloodhound-0.7/bloodhound_relations
2014-08-20 15:23:53,788 Trac[loader] DEBUG: Loading bhrelations.widgets.ticketrelations from /opt/html/apache-bloodhound-0.7/bloodhound_relations
2014-08-20 15:23:53,788 Trac[loader] DEBUG: Loading bhsearch.admin from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,789 Trac[loader] DEBUG: Loading bhsearch.api from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,789 Trac[loader] DEBUG: Loading bhsearch.query_parser from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,866 Trac[loader] DEBUG: Loading bhsearch.query_suggestion from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,867 Trac[loader] DEBUG: Loading bhsearch.search_resources.changeset_search from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,867 Trac[loader] DEBUG: Loading bhsearch.search_resources.milestone_search from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,868 Trac[loader] DEBUG: Loading bhsearch.search_resources.ticket_search from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,868 Trac[loader] DEBUG: Loading bhsearch.search_resources.wiki_search from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,869 Trac[loader] DEBUG: Loading bhsearch.security from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,869 Trac[loader] DEBUG: Loading bhsearch.web_ui from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,878 Trac[loader] DEBUG: Loading bhsearch.whoosh_backend from /opt/html/apache-bloodhound-0.7/bloodhound_search
2014-08-20 15:23:53,878 Trac[loader] DEBUG: Loading bhtheme.theme from /opt/html/apache-bloodhound-0.7/bloodhound_theme
2014-08-20 15:23:53,888 Trac[loader] DEBUG: Loading multiproduct.model from /opt/html/apache-bloodhound-0.7/bloodhound_multiproduct
2014-08-20 15:23:53,888 Trac[loader] DEBUG: Loading multiproduct.perm from /opt/html/apache-bloodhound-0.7/bloodhound_multiproduct
2014-08-20 15:23:53,888 Trac[loader] DEBUG: Loading multiproduct.product_admin from /opt/html/apache-bloodhound-0.7/bloodhound_multiproduct
2014-08-20 15:23:53,888 Trac[loader] DEBUG: Loading multiproduct.ticket.batch from /opt/html/apache-bloodhound-0.7/bloodhound_multiproduct
2014-08-20 15:23:53,888 Trac[loader] DEBUG: Loading multiproduct.ticket.query from /opt/html/apache-bloodhound-0.7/bloodhound_multiproduct
2014-08-20 15:23:53,888 Trac[loader] DEBUG: Loading multiproduct.ticket.web_ui from /opt/html/apache-bloodhound-0.7/bloodhound_multiproduct
2014-08-20 15:23:53,889 Trac[loader] DEBUG: Loading multiproduct.web_ui from /opt/html/apache-bloodhound-0.7/bloodhound_multiproduct
2014-08-20 15:23:53,889 Trac[loader] DEBUG: Loading permredirect.filter from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,890 Trac[loader] DEBUG: Loading themeengine.admin from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,890 Trac[loader] DEBUG: Loading themeengine.api from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,891 Trac[loader] DEBUG: Loading themeengine.web_ui from /opt/html/apache-bloodhound-0.7/installer/bloodhound/lib/python2.6/site-packages
2014-08-20 15:23:53,891 Trac[loader] DEBUG: Loading ticketlog from /usr/lib/python2.6/site-packages/TracTicketChangelogPlugin-0.2dev_r13960-py2.6.egg
2014-08-20 15:23:53,892 Trac[loader] DEBUG: Loading trac.about from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,893 Trac[loader] DEBUG: Loading trac.admin.console from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,893 Trac[loader] DEBUG: Loading trac.admin.web_ui from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,893 Trac[loader] DEBUG: Loading trac.attachment from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,893 Trac[loader] DEBUG: Loading trac.db.mysql from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,893 Trac[loader] DEBUG: Loading trac.db.postgres from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,894 Trac[loader] DEBUG: Loading trac.db.sqlite from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,894 Trac[loader] DEBUG: Loading trac.mimeview.patch from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,894 Trac[loader] DEBUG: Loading trac.mimeview.pygments from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,903 Trac[loader] DEBUG: Loading trac.mimeview.rst from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,913 Trac[loader] DEBUG: Skipping "trac.mimeview.rst = trac.mimeview.rst [rest]": ("DistributionNotFound: docutils>=0.3" not found)
2014-08-20 15:23:53,914 Trac[loader] DEBUG: Loading trac.mimeview.txtl from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,922 Trac[loader] DEBUG: Skipping "trac.mimeview.txtl = trac.mimeview.txtl [textile]": ("DistributionNotFound: textile>=2.0" not found)
2014-08-20 15:23:53,923 Trac[loader] DEBUG: Loading trac.prefs from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,923 Trac[loader] DEBUG: Loading trac.search from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,924 Trac[loader] DEBUG: Loading trac.ticket.admin from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,924 Trac[loader] DEBUG: Loading trac.ticket.batch from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,924 Trac[loader] DEBUG: Loading trac.ticket.query from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,924 Trac[loader] DEBUG: Loading trac.ticket.report from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,925 Trac[loader] DEBUG: Loading trac.ticket.roadmap from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,925 Trac[loader] DEBUG: Loading trac.ticket.web_ui from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,925 Trac[loader] DEBUG: Loading trac.timeline from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,925 Trac[loader] DEBUG: Loading trac.versioncontrol.admin from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,925 Trac[loader] DEBUG: Loading trac.versioncontrol.svn_authz from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,926 Trac[loader] DEBUG: Loading trac.versioncontrol.web_ui from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,926 Trac[loader] DEBUG: Loading trac.web.auth from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,926 Trac[loader] DEBUG: Loading trac.web.session from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,926 Trac[loader] DEBUG: Loading trac.wiki.admin from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,927 Trac[loader] DEBUG: Loading trac.wiki.interwiki from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,928 Trac[loader] DEBUG: Loading trac.wiki.macros from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,928 Trac[loader] DEBUG: Loading trac.wiki.web_api from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,928 Trac[loader] DEBUG: Loading trac.wiki.web_ui from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,929 Trac[loader] DEBUG: Loading tracbacks from /usr/lib/python2.6/site-packages/Tracbacks-0.2dev_r12197-py2.6.egg
2014-08-20 15:23:53,930 Trac[loader] DEBUG: Loading tracdragdrop.web_ui from /usr/lib/python2.6/site-packages/TracDragDrop-0.12.0.12_r13613-py2.6.egg
2014-08-20 15:23:53,932 Trac[loader] DEBUG: Loading tracduplicates.web_ui from /usr/lib/python2.6/site-packages/TracDuplicates-0.11-py2.6.egg
2014-08-20 15:23:53,932 Trac[loader] DEBUG: Loading tracopt.mimeview.enscript from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,933 Trac[loader] DEBUG: Loading tracopt.mimeview.php from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,934 Trac[loader] DEBUG: Loading tracopt.mimeview.silvercity from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,943 Trac[loader] DEBUG: Skipping "tracopt.mimeview.silvercity = tracopt.mimeview.silvercity [silvercity]": ("DistributionNotFound: SilverCity>=0.9.4" not found)
2014-08-20 15:23:53,943 Trac[loader] DEBUG: Loading tracopt.perm.authz_policy from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,943 Trac[loader] DEBUG: Loading tracopt.perm.config_perm_provider from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,943 Trac[loader] DEBUG: Loading tracopt.ticket.clone from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,944 Trac[loader] DEBUG: Loading tracopt.ticket.commit_updater from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,945 Trac[loader] DEBUG: Loading tracopt.ticket.deleter from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,946 Trac[loader] DEBUG: Loading tracopt.versioncontrol.git.git_fs from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,949 Trac[loader] DEBUG: Loading tracopt.versioncontrol.svn.svn_fs from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,950 Trac[loader] DEBUG: Loading tracopt.versioncontrol.svn.svn_prop from /opt/html/apache-bloodhound-0.7/trac
2014-08-20 15:23:53,954 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': []}}

2014-08-20 15:23:53,973 Trac[api] DEBUG: TracAnnouncer needs to register schema version
2014-08-20 15:23:53,973 Trac[api] INFO: TracAnnouncer db schema version is 5, should be 6
2014-08-20 15:23:53,973 Trac[env] WARNING: component announcer.api.AnnouncementSystem requires environment upgrade in environment <multiproduct.env.Environment object at 0x22f2fd0>...
2014-08-20 15:23:54,009 Trac[env] DEBUG: Log type 'file' for product '@'
2014-08-20 15:23:54,010 Trac[env] WARNING: Inheriting parent logger for product '@'
2014-08-20 15:23:54,010 Trac[env] INFO: -------------------------------- product @ environment startup [Trac 1.0.1] --------------------------------
2014-08-20 15:23:54,018 Trac[api] DEBUG: TracAnnouncer needs to register schema version
2014-08-20 15:23:54,018 Trac[api] INFO: TracAnnouncer db schema version is 5, should be 6
2014-08-20 15:23:54,019 Trac[env] WARNING: component announcer.api.AnnouncementSystem requires environment upgrade in environment <multiproduct.env.Environment object at 0x22f2fd0>...
2014-08-20 15:23:54,058 Trac[api] DEBUG: TracAnnouncer needs to register schema version
2014-08-20 15:23:54,058 Trac[api] INFO: TracAnnouncer db schema version is 5, should be 6
2014-08-20 15:23:54,058 Trac[env] INFO: announcer.api.AnnouncementSystem needs upgrade in environment <multiproduct.env.Environment object at 0x22f2fd0>...
2014-08-20 15:23:54,068 Trac[console] ERROR: Exception in trac-admin command: 
Traceback (most recent call last):
  File "/opt/html/apache-bloodhound-0.7/trac/trac/admin/console.py", line 109, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "/usr/lib64/python2.6/cmd.py", line 218, in onecmd
    return self.default(line)
  File "/opt/html/apache-bloodhound-0.7/trac/trac/admin/console.py", line 285, in default
    return cmd_mgr.execute_command(*args)
  File "/opt/html/apache-bloodhound-0.7/trac/trac/admin/api.py", line 124, in execute_command
    return f(*fargs)
  File "/opt/html/apache-bloodhound-0.7/trac/trac/env.py", line 984, in _do_upgrade
    self.env.upgrade(backup=no_backup is None)
  File "/opt/html/apache-bloodhound-0.7/bloodhound_multiproduct/multiproduct/env.py", line 221, in upgrade
    product_upgraders = upgraders_for_product_envs()
  File "/opt/html/apache-bloodhound-0.7/bloodhound_multiproduct/multiproduct/env.py", line 210, in upgraders_for_product_envs
    return [u for u in upgraders if u]
  File "/opt/html/apache-bloodhound-0.7/bloodhound_multiproduct/multiproduct/env.py", line 209, in <genexpr>
    for env in [self] + self.all_product_envs())
  File "/opt/html/apache-bloodhound-0.7/bloodhound_multiproduct/multiproduct/env.py", line 198, in upgrader_for_env
    if participant.environment_needs_upgrade(db):
  File "/usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg/announcer/api.py", line 412, in environment_needs_upgrade
    schema_ver = self.get_schema_version(db)
  File "/usr/lib/python2.6/site-packages/TracAnnouncer-1.0dev_r13984-py2.6.egg/announcer/api.py", line 443, in get_schema_version
    cursor.execute("SELECT * FROM subscription_attribute")
  File "/opt/html/apache-bloodhound-0.7/bloodhound_multiproduct/multiproduct/dbcursor.py", line 143, in execute
    return self.cursor.execute(sql, args=args)
  File "/opt/html/apache-bloodhound-0.7/bloodhound_multiproduct/multiproduct/dbcursor.py", line 83, in execute
    return super(BloodhoundIterableCursor, self).execute(translate_sql(self.env, sql), args=args)
  File "/opt/html/apache-bloodhound-0.7/trac/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "/opt/html/apache-bloodhound-0.7/trac/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/opt/html/apache-bloodhound-0.7/trac/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/opt/html/apache-bloodhound-0.7/trac/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such table: @_subscription_attribute
Version 0, edited 10 years ago by shorif2000 (next)

comment:26 in reply to:  25 Changed 10 years ago by Jun Omae

Replying to shorif2000:

I am getting this problem too with bloodhound 0.7 when i run command 

(bloodhound)[root@cobra environments]# trac-admin main upgrade
The upgrade failed. Please fix the issue and try again.

OperationalError: no such table: @_subscription_attribute

That is a Bloodhound issue. Please report to ​https://issues.apache.org/bloodhound.

comment:27 Changed 7 years ago by Ryan J Ollos

Owner: Steffen Hoffmann deleted

comment:28 Changed 7 years ago by Ryan J Ollos

Resolution: → fixed
Status: new → closed

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.