Ticket #7315 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

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

Reported by: gary.bennett@spargonet.com Assigned to: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: mark_kids@yahoo.com Trac Release: 0.12

Description

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

trac.log (24.6 kB) - added by anonymous on 06/30/10 16:09:55.

Change History

06/30/10 15:49:45 changed by bobbysmith007

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

06/30/10 16:09:55 changed by anonymous

  • attachment trac.log added.

06/30/10 16:10:57 changed by anonymous

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

06/30/10 19:07:33 changed by bobbysmith007

  • status changed from new to closed.
  • resolution set to fixed.

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

06/30/10 19:08:25 changed by bobbysmith007

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.

07/01/10 05:51:29 changed by mark_kids@yahoo.com

  • status changed from closed to reopened.
  • resolution deleted.

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

(follow-up: ↓ 7 ) 07/01/10 14:00:11 changed by gary.bennett@spargonet.com

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

(in reply to: ↑ 6 ) 07/01/10 15:42:37 changed by bobbysmith007

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

07/01/10 16:55:31 changed by bobbysmith007

  • cc set to mark_kids@yahoo.com.

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.

(follow-up: ↓ 11 ) 07/01/10 17:08:17 changed by bobbysmith007

  • status changed from reopened to closed.
  • resolution set to fixed.

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

07/01/10 17:13:51 changed by bobbysmith007

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

(in reply to: ↑ 9 ) 07/02/10 02:38:35 changed by mark_kids@yahoo.com

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

07/02/10 15:58:56 changed by bobbysmith007

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

re #7315

07/02/10 15:59:58 changed by bobbysmith007

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

Russ

07/03/10 10:03:39 changed by anonymous

  • status changed from closed to reopened.
  • resolution deleted.

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

07/03/10 10:46:20 changed by mark_kids@yahoo.com

  • status changed from reopened to closed.
  • resolution set to fixed.

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.

Add/Change #7315 ("trac-admin upgrade" doesn't seem to work)




Change Properties
Action