Opened 14 years ago

Closed 14 years ago

Last modified 8 years ago

#7315 closed defect (fixed)

"trac-admin upgrade" doesn't seem to work — at Version 16

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.

Change History (17)

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: new → closed

(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: closed → reopened 
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 8 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: reopened → closed

(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: closed → reopened

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: reopened → closed

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 8 years ago by Ryan J Ollos

Description: modified (diff)
Note: See TracTickets for help on using tickets.