#7315 closed defect (fixed)
"trac-admin upgrade" doesn't seem to work
Reported by: | Owned by: | Russ Tyndall | |
---|---|---|---|
Priority: | normal | Component: | TimingAndEstimationPlugin |
Severity: | normal | Keywords: | |
Cc: | mark_kids@… | Trac Release: | 0.12 |
Description (last modified by )
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)
Change History (18)
comment:1 Changed 14 years ago by
Changed 14 years ago by
comment:2 Changed 14 years ago by
Thanks for the quick response. I've attached the log file that you requested.
comment:3 Changed 14 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:4 Changed 14 years ago by
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
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
comment:6 follow-up: 7 Changed 14 years ago by
I've just tried to install the fix, and get the same error as above.
comment:7 Changed 14 years ago by
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
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 follow-up: 11 Changed 14 years ago by
Resolution: | → fixed |
---|---|
Status: | reopened → closed |
comment:10 Changed 14 years ago by
updated the supported-versions section of the wiki page to reflect new sqlite3 requirements
comment:11 Changed 14 years ago by
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
comment:13 Changed 14 years ago by
I think this should prevent the need to upgrade sqlite. Please continue to file bugs. Thanks
Russ
comment:14 Changed 14 years ago by
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
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 9 years ago by
Description: | modified (diff) |
---|
comment:17 Changed 9 years ago by
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
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