Modify

Opened 14 years ago

Closed 14 years ago

Last modified 9 years ago

#7315 closed defect (fixed)

"trac-admin upgrade" doesn't seem to work

Reported by: gary.bennett@… Owned by: Russ Tyndall
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: mark_kids@… Trac Release: 0.12

Description (last modified by Ryan J Ollos)

Running Trac 0.12 Installed the timingandestimation plugin (along with the scrumdown plugin) Updated the [component] section of trac.ini Run the upgrade: no errors were reported. Restart trac.

I get the following error when I connect to Trac:

    Trac Error
    TracError: The Trac Environment needs to be upgraded.
    Run "trac-admin c:\apps\trac\repo\main upgrade"

I've retried several times, but it still doesn't work.

Attachments (1)

trac.log (24.6 KB) - added by anonymous 14 years ago.

Download all attachments as: .zip

Change History (18)

comment:1 Changed 14 years ago by Russ Tyndall

I have been testing this repeatedly, and I thought I had it working, but its a pretty complex change, so its easy I missed something in a specific setup. Can you please enable logging and post a copy of your log while you upgrade. There should be exceptions in there that help locate the bug.

Thanks,

Russ

Changed 14 years ago by anonymous

Attachment: trac.log added

comment:2 Changed 14 years ago by anonymous

Thanks for the quick response. I've attached the log file that you requested.

comment:3 Changed 14 years ago by Russ Tyndall

Resolution: fixed
Status: newclosed

(In [8176]) fixed #7315 - upgrade bug was preventing proper upgrade

comment:4 Changed 14 years ago by Russ Tyndall

Thanks for the bug report and log file. I solved the problem you saw and was able to install upgrade a new trac on my end once the changes were applied.

comment:5 Changed 14 years ago by mark_kids@…

Resolution: fixed
Status: closedreopened
2010-06-30 20:34:54,626 Trac[env] INFO: -------------------------------- environment startup [Trac 0.12] --------------------------------
2010-06-30 20:34:54,671 Trac[loader] DEBUG: Loading MilestoneCatcher from /usr/local/lib/python2.6/site-packages/MilestoneCatcher-1.0.0-py2.6.egg
2010-06-30 20:34:54,690 Trac[loader] DEBUG: Loading TracBurndown from /usr/local/lib/python2.6/site-packages/TracBurndown-1.9.2-py2.6.egg
2010-06-30 20:34:54,696 Trac[loader] DEBUG: Loading TracXMLRPC from /usr/local/lib/python2.6/site-packages/TracXMLRPC-1.0.6-py2.6.egg
2010-06-30 20:34:54,720 Trac[loader] DEBUG: Loading addcomment.macro from /usr/local/lib/python2.6/site-packages/TracAddCommentMacro-0.3-py2.6.egg
2010-06-30 20:34:54,723 Trac[loader] DEBUG: Loading advancedworkflow.controller from /usr/local/lib/python2.6/site-packages/AdvancedTicketWorkflowPlugin-0.10dev_r7701-py2.6.egg
2010-06-30 20:34:54,726 Trac[loader] DEBUG: Loading cc_selector from /usr/local/lib/python2.6/site-packages/cc_selector-0.0.2-py2.6.egg
2010-06-30 20:34:54,728 Trac[loader] DEBUG: Loading childtickets from /usr/local/lib/python2.6/site-packages/Tracchildtickets-1.0.2-py2.6.egg
2010-06-30 20:34:54,730 Trac[loader] DEBUG: Loading customfieldadmin.api from /usr/local/lib/python2.6/site-packages/TracCustomFieldAdmin-0.2.2-py2.6.egg
2010-06-30 20:34:54,731 Trac[loader] DEBUG: Loading customfieldadmin.customfieldadmin from /usr/local/lib/python2.6/site-packages/TracCustomFieldAdmin-0.2.2-py2.6.egg
2010-06-30 20:34:54,731 Trac[loader] DEBUG: Loading datefield.filter from /usr/local/lib/python2.6/site-packages/TracDateField-1.0.1-py2.6.egg
2010-06-30 20:34:54,732 Trac[loader] DEBUG: Loading ganttcalendar.admin from /usr/local/lib/python2.6/site-packages/TracGanttCalendarPlugin-0.2-py2.6.egg
2010-06-30 20:34:54,736 Trac[loader] DEBUG: Loading ganttcalendar.complete_by_close from /usr/local/lib/python2.6/site-packages/TracGanttCalendarPlugin-0.2-py2.6.egg
2010-06-30 20:34:54,736 Trac[loader] DEBUG: Loading ganttcalendar.ticketcalendar from /usr/local/lib/python2.6/site-packages/TracGanttCalendarPlugin-0.2-py2.6.egg
2010-06-30 20:34:54,736 Trac[loader] DEBUG: Loading ganttcalendar.ticketgantt from /usr/local/lib/python2.6/site-packages/TracGanttCalendarPlugin-0.2-py2.6.egg
2010-06-30 20:34:54,737 Trac[loader] DEBUG: Loading itteco.calendar.api from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,844 Trac[loader] DEBUG: Loading itteco.calendar.rpc from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,860 Trac[loader] DEBUG: Loading itteco.calendar.web_ui from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,862 Trac[loader] DEBUG: Loading itteco.init from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,862 Trac[loader] DEBUG: Loading itteco.popup.web_ui from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,870 Trac[loader] DEBUG: Loading itteco.scrum.api from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,870 Trac[loader] DEBUG: Loading itteco.scrum.burndown from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,871 Trac[loader] DEBUG: Loading itteco.scrum.web_ui from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,871 Trac[loader] DEBUG: Loading itteco.ticket.admin from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,874 Trac[loader] DEBUG: Loading itteco.ticket.api from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,875 Trac[loader] DEBUG: Loading itteco.ticket.report from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,877 Trac[loader] DEBUG: Loading itteco.ticket.roadmap from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,879 Trac[loader] DEBUG: Loading itteco.ticket.web_ui from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,880 Trac[loader] DEBUG: Loading itteco.ticket.workflow from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,881 Trac[loader] DEBUG: Loading itteco.timeline.web_ui from /usr/local/lib/python2.6/site-packages/itteco-0.2.6-py2.6.egg
2010-06-30 20:34:54,882 Trac[loader] DEBUG: Loading macropost.web_ui from /usr/local/lib/python2.6/site-packages/TracMacroPost-0.2-py2.6.egg
2010-06-30 20:34:54,884 Trac[loader] DEBUG: Loading mastertickets.api from /usr/local/lib/python2.6/site-packages/TracMasterTickets-2.1.3-py2.6.egg
2010-06-30 20:34:54,886 Trac[loader] DEBUG: Loading mastertickets.web_ui from /usr/local/lib/python2.6/site-packages/TracMasterTickets-2.1.3-py2.6.egg
2010-06-30 20:34:54,888 Trac[loader] DEBUG: Loading sequencediagram.macro from /usr/local/lib/python2.6/site-packages/SequenceDiagram-1.0-py2.6.egg
2010-06-30 20:34:54,889 Trac[loader] DEBUG: Loading ticketmoverplugin from /usr/local/lib/python2.6/site-packages/TicketMoverPlugin-0.1.1-py2.6.egg
2010-06-30 20:34:54,892 Trac[loader] DEBUG: Loading ticketmoverweb from /usr/local/lib/python2.6/site-packages/TicketMoverPlugin-0.1.1-py2.6.egg
2010-06-30 20:34:54,894 Trac[loader] DEBUG: Loading ticketsidebarprovider from /usr/local/lib/python2.6/site-packages/TicketSidebarProvider-0.0-py2.6.egg
2010-06-30 20:34:54,894 Trac[loader] DEBUG: Loading timingandestimationplugin from /usr/local/lib/python2.6/site-packages/timingandestimationplugin-1.0.0-py2.6.egg
2010-06-30 20:34:54,900 Trac[loader] DEBUG: Loading trac.about from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,901 Trac[loader] DEBUG: Loading trac.admin.console from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,901 Trac[loader] DEBUG: Loading trac.admin.web_ui from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,903 Trac[loader] DEBUG: Loading trac.attachment from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,904 Trac[loader] DEBUG: Loading trac.db.mysql from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,909 Trac[loader] DEBUG: Loading trac.db.postgres from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,910 Trac[loader] DEBUG: Loading trac.db.sqlite from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,916 Trac[loader] DEBUG: Loading trac.mimeview.patch from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,917 Trac[loader] DEBUG: Loading trac.mimeview.pygments from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,939 Trac[loader] DEBUG: Loading trac.mimeview.rst from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,962 Trac[loader] DEBUG: Skipping "trac.mimeview.rst = trac.mimeview.rst [rest]": ("DistributionNotFound: docutils>=0.3" not found)
2010-06-30 20:34:54,962 Trac[loader] DEBUG: Loading trac.mimeview.silvercity from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:54,982 Trac[loader] DEBUG: Skipping "trac.mimeview.silvercity = trac.mimeview.silvercity [silvercity]": ("DistributionNotFound: SilverCity>=0.9.4" not found)
2010-06-30 20:34:54,982 Trac[loader] DEBUG: Loading trac.mimeview.txtl from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,001 Trac[loader] DEBUG: Skipping "trac.mimeview.txtl = trac.mimeview.txtl [textile]": ("DistributionNotFound: textile>=2.0" not found)
2010-06-30 20:34:55,001 Trac[loader] DEBUG: Loading trac.prefs from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,003 Trac[loader] DEBUG: Loading trac.search from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,003 Trac[loader] DEBUG: Loading trac.ticket.admin from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,003 Trac[loader] DEBUG: Loading trac.ticket.query from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,004 Trac[loader] DEBUG: Loading trac.ticket.report from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,004 Trac[loader] DEBUG: Loading trac.ticket.roadmap from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,004 Trac[loader] DEBUG: Loading trac.ticket.web_ui from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,005 Trac[loader] DEBUG: Loading trac.timeline from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,007 Trac[loader] DEBUG: Loading trac.versioncontrol.admin from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,008 Trac[loader] DEBUG: Loading trac.versioncontrol.svn_authz from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,008 Trac[loader] DEBUG: Loading trac.versioncontrol.svn_fs from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,011 Trac[loader] DEBUG: Loading trac.versioncontrol.svn_prop from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,024 Trac[loader] DEBUG: Loading trac.versioncontrol.web_ui from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,024 Trac[loader] DEBUG: Loading trac.web.auth from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,031 Trac[loader] DEBUG: Loading trac.web.session from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,031 Trac[loader] DEBUG: Loading trac.wiki.admin from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,032 Trac[loader] DEBUG: Loading trac.wiki.interwiki from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,034 Trac[loader] DEBUG: Loading trac.wiki.macros from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,034 Trac[loader] DEBUG: Loading trac.wiki.web_api from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,035 Trac[loader] DEBUG: Loading trac.wiki.web_ui from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,035 Trac[loader] DEBUG: Loading tracopt.mimeview.enscript from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,036 Trac[loader] DEBUG: Loading tracopt.mimeview.php from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,037 Trac[loader] DEBUG: Loading tracopt.perm.authz_policy from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,038 Trac[loader] DEBUG: Loading tracopt.perm.config_perm_provider from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,039 Trac[loader] DEBUG: Loading tracopt.ticket.commit_updater from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,040 Trac[loader] DEBUG: Loading tracopt.ticket.deleter from /usr/local/lib/python2.6/site-packages/Trac-0.12-py2.6.egg
2010-06-30 20:34:55,041 Trac[loader] DEBUG: Loading tracwysiwyg from /usr/local/lib/python2.6/site-packages/TracWysiwyg-0.2_r7772-py2.6.egg
2010-06-30 20:34:55,052 Trac[default_workflow] DEBUG: Workflow actions at initialization: {u'testing': {u'operations': [u'set_owner'], u'name': u'submit for testing', 'default': 0, 'newstate': u'testing', 'oldstates': [u'new', u'accepted', u'needs_work', u'assigned', u'reopened'], u'permissions': [u'TICKET_MODIFY']}, u'review': {u'operations': [u'set_owner'], 'name': u'review', 'default': 0, 'newstate': u'reviewing', 'oldstates': [u'new', u'assigned', u'reopened'], u'permissions': [u'TICKET_MODIFY']}, u'reject': {u'operations': [u'set_owner_to_previous'], u'name': u'failed testing, return to developer', 'default': 0, 'newstate': u'needs_work', 'oldstates': [u'testing'], 'permissions': []}, 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'reviewing'], 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', u'reset_milestone'], 'name': u'reopen', 'default': 0, 'newstate': u'reopened', 'oldstates': [u'closed'], u'permissions': [u'TICKET_CREATE']}, 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'reviewing', u'needs_work'], u'permissions': [u'TICKET_MODIFY']}, '_reset': {'operations': ['reset_workflow'], 'name': 'reset', 'default': 0, 'newstate': 'new', 'oldstates': [], 'permissions': []}, u'unassign': {u'operations': [u'del_owner', u'set_owner'], u'name': u'unassign from current owner and reassign', 'default': 0, 'newstate': u'*', 'oldstates': [u'new', u'assigned', u'accepted', u'reopened', u'reviewing'], u'set_owner': u'somebody', u'permissions': [u'TICKET_MODIFY']}, u'pass': {u'operations': [u'set_resolution'], u'name': u'Passes Testing', 'default': 0, 'newstate': u'closed', u'set_resolution': u'fixed', 'oldstates': [u'testing'], 'permissions': []}, 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'reviewing'], u'permissions': [u'TICKET_MODIFY']}, u'reassign_reviewing': {u'operations': [u'set_owner'], u'name': u'reassign review', 'default': 0, 'newstate': u'*', 'oldstates': [u'reviewing'], u'permissions': [u'TICKET_MODIFY']}, u'request_info': {'operations': [], u'name': u'request for more information', 'default': 0, 'newstate': u'infoneeded', 'oldstates': [u'assigned', u'accepted', u'reviewing'], u'permissions': [u'TICKET_MODIFY']}, u'provide_info': {u'operations': [u'set_status_to_previous'], u'name': u'provide information', 'default': 0, 'newstate': u'*', 'oldstates': [u'infoneeded'], u'permissions': [u'TICKET_MODIFY']}, u'dup': {u'operations': [u'set_resolution', u'xref'], u'xref': u'Ticket %s has been marked as a duplicate of this ticket.', u'name': u'close', 'default': 0, 'newstate': u'closed', u'xref_local': u'Closed as duplicate of %s.', u'set_resolution': u'duplicate', 'oldstates': [u'*'], 'permissions': []}}

2010-06-30 20:34:55,055 Trac[api] DEBUG: T&E NEEDS UP?: sys:True, rep:True, stats:True, fields:True, man:True
2010-06-30 20:34:55,056 Trac[env] WARNING: Component <timingandestimationplugin.api.TimeTrackingSetupParticipant object at 0x1ce88d50> requires environment upgrade
2010-06-30 20:34:55,057 Trac[api] DEBUG: T&E NEEDS UP?: sys:True, rep:True, stats:True, fields:True, man:True
2010-06-30 20:34:55,066 Trac[env] INFO: timingandestimationplugin.api.TimeTrackingSetupParticipant upgrading...
2010-06-30 20:34:55,066 Trac[api] DEBUG: T&E Beginning DB Upgrade
2010-06-30 20:34:55,240 Trac[api] DEBUG: T&E End DB Upgrade
2010-06-30 20:34:55,244 Trac[api] DEBUG: T&E Beginning Reports Upgrade
2010-06-30 20:34:55,245 Trac[reportmanager] DEBUG: T&E Starting Report Schema Upgrade
2010-06-30 20:34:55,245 Trac[reportmanager] DEBUG: T&E Ending Report Schema Upgrade
2010-06-30 20:34:55,247 Trac[reportmanager] DEBUG: add_report b24f08c0-d41f-4c63-93a5-25e18a8513c2 (ver:21) | id: None currentversion: 0
2010-06-30 20:34:55,247 Trac[reportmanager] DEBUG: Inserting new report 'Ticket Work Summary' with uuid 'b24f08c0-d41f-4c63-93a5-25e18a8513c2'
2010-06-30 20:34:55,248 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,248 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,250 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,250 Trac[reportmanager] DEBUG: add_report af13564f-0e36-4a17-96c0-632dc68d8d14 (ver:18) | id: None currentversion: 0
2010-06-30 20:34:55,251 Trac[reportmanager] DEBUG: Inserting new report 'Milestone Work Summary' with uuid 'af13564f-0e36-4a17-96c0-632dc68d8d14'
2010-06-30 20:34:55,251 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,251 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,252 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,252 Trac[reportmanager] DEBUG: add_report 7bd4b0ce-da6d-4b11-8be3-07e65b540d99 (ver:18) | id: None currentversion: 0
2010-06-30 20:34:55,252 Trac[reportmanager] DEBUG: Inserting new report 'Developer Work Summary' with uuid '7bd4b0ce-da6d-4b11-8be3-07e65b540d99'
2010-06-30 20:34:55,253 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,253 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,253 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,254 Trac[reportmanager] DEBUG: add_report 8d785cdb-dcf5-43c9-b2a6-216997b0011a (ver:16) | id: None currentversion: 0
2010-06-30 20:34:55,254 Trac[reportmanager] DEBUG: Inserting new report 'Ticket Hours' with uuid '8d785cdb-dcf5-43c9-b2a6-216997b0011a'
2010-06-30 20:34:55,254 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,255 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,255 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,255 Trac[reportmanager] DEBUG: add_report 71e7c36d-e512-4d0b-b499-087d4d20ff0b (ver:16) | id: None currentversion: 0
2010-06-30 20:34:55,255 Trac[reportmanager] DEBUG: Inserting new report 'Ticket Hours with Description' with uuid '71e7c36d-e512-4d0b-b499-087d4d20ff0b'
2010-06-30 20:34:55,256 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,256 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,256 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,257 Trac[reportmanager] DEBUG: add_report 5f33b102-e6a6-47e8-976c-ac7a6794a909 (ver:16) | id: None currentversion: 0
2010-06-30 20:34:55,257 Trac[reportmanager] DEBUG: Inserting new report 'Ticket Hours Grouped By Component' with uuid '5f33b102-e6a6-47e8-976c-ac7a6794a909'
2010-06-30 20:34:55,258 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,258 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,258 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,258 Trac[reportmanager] DEBUG: add_report 7816f034-a174-4a94-aed6-358fb648b2fc (ver:16) | id: None currentversion: 0
2010-06-30 20:34:55,259 Trac[reportmanager] DEBUG: Inserting new report 'Ticket Hours Grouped By Component with Description' with uuid '7816f034-a174-4a94-aed6-358fb648b2fc'
2010-06-30 20:34:55,259 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,260 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,260 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,260 Trac[reportmanager] DEBUG: add_report 03815803-7688-4f3a-8e65-8d254cc1d1fb (ver:16) | id: None currentversion: 0
2010-06-30 20:34:55,260 Trac[reportmanager] DEBUG: Inserting new report 'Ticket Hours Grouped By Milestone' with uuid '03815803-7688-4f3a-8e65-8d254cc1d1fb'
2010-06-30 20:34:55,261 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,261 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,261 Trac[reportmanager] DEBUG: Sequence updated
2010-06-30 20:34:55,262 Trac[reportmanager] DEBUG: add_report 040c9025-7641-4d18-96ad-2b26b4095566 (ver:16) | id: None currentversion: 0
2010-06-30 20:34:55,262 Trac[reportmanager] DEBUG: Inserting new report 'Ticket Hours Grouped By MileStone with Description' with uuid '040c9025-7641-4d18-96ad-2b26b4095566'
2010-06-30 20:34:55,262 Trac[reportmanager] DEBUG: Attempting to increment sequence (only works in postgres)
2010-06-30 20:34:55,263 Trac[dbhelper] ERROR: There was a problem executing sql:SELECT nextval('report_id_seq'); 
     with parameters:[]
Exception:no such function: nextval
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 48, in execute_in_trans
    @env.with_transaction()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 73, in transaction_wrapper
    fn(ldb)
  File "build/bdist.linux-x86_64/egg/timingandestimationplugin/dbhelper.py", line 54, in fn
    cur.execute(sql, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such function: nextval
2010-06-30 20:34:55,263 Trac[reportmanager] DEBUG: Sequence updated
Last edited 9 years ago by Ryan J Ollos (previous) (diff)

comment:6 Changed 14 years ago by gary.bennett@…

I've just tried to install the fix, and get the same error as above.

comment:7 in reply to:  6 Changed 14 years ago by Russ Tyndall

Replying to gary.bennett@spargonet.com:

I've just tried to install the fix, and get the same error as above.

The giant set of errors above is about trying to set sequences on a database that doesn't have them. What is confusing to me is that this is actually causing problems on sqlite backends. In a discussion about this on the mailing list I thought we had reasoned out how this shouldnt interrupt the upgrade, though it might report errors in the log.

I will install a new trac with sqlite and debug this (I use postgres predominately).

HTH, Russ

comment:8 Changed 14 years ago by Russ Tyndall

Cc: mark_kids@… added; anonymous removed

I have investigated further and have found out that there is a toplevel transaction that is wrapping everything I do. This causes the upgrade process to be more difficult. I have a good solution if you are using sqlite3 > 3.6.8 (which supports nested transactions). For now I am going to implement that, because its easy and will get you up and running if you have the correct version.

After that I am going to look submitting a patch for an update sequences function mentioned http://trac.edgewall.org/ticket/8575.

comment:9 Changed 14 years ago by Russ Tyndall

Resolution: fixed
Status: reopenedclosed

(In [8193]) use savepoints for nested transactions so that sequence updates dont cause the upgrade to fail on sqlite fix #7315

comment:10 Changed 14 years ago by Russ Tyndall

updated the supported-versions section of the wiki page to reflect new sqlite3 requirements

comment:11 in reply to:  9 Changed 14 years ago by mark_kids@…

my sqlite version is 3.3.6. Is there any way to make this work without upgrading to 3.6.8?

Replying to bobbysmith007:

(In [8193]) use savepoints for nested transactions so that sequence updates dont cause the upgrade to fail on sqlite fix #7315

comment:12 Changed 14 years ago by Russ Tyndall

(In [8202]) Added special casing on the database backend to make this work on sqlites < 3.6.8

re #7315

comment:13 Changed 14 years ago by Russ Tyndall

I think this should prevent the need to upgrade sqlite. Please continue to file bugs. Thanks

Russ

comment:14 Changed 14 years ago by anonymous

Resolution: fixed
Status: closedreopened

after trac-admin upgrade, the site is now accessible but when issuing another "trac-admin /path/to/trac upgrade", is issues OperationalError: table custom_report already exists

comment:15 Changed 14 years ago by mark_kids@…

Resolution: fixed
Status: reopenedclosed

i tried to restore the backup db for the trac site, then i upgraded it with the current version of estimations plugin. so far no trouble. it must have been a corrupted database.

comment:16 Changed 9 years ago by Ryan J Ollos

Description: modified (diff)

comment:17 Changed 9 years ago by Russ Tyndall

I saw a comment come through email that seems to have disappeared, saying this was still a valid error. Please open a new ticket if that is the case

Modify Ticket

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

Add Comment


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

 
Note: See TracTickets for help on using tickets.