Hi everyone,
I'm reaching out for advise on how to handle recent errors that have come
up since attempting to migrate from SQLite to PostgreSQL.
First has to do with the sub-tickets plugin. Since upgrading, no tickets
can be accessed due to the error outlined below.
==== How to Reproduce ====
While doing a GET operation on `/ticket/1790`, Trac issued an internal
error.
''(please provide additional details here)''
Request parameters:
{{{
{'id': u'1790'}
}}}
User agent: `Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/36.0.1985.125 Safari/537.36`
==== System Information ====
|| '''`Trac`''' || `1.0` ||
|| '''`Trac`''' || `1.0` ||
|| '''`Babel`''' || `0.9.6` ||
|| '''`Genshi`''' || `0.6 (without speedups)` ||
|| '''`GIT`''' || `1.7.1` ||
|| '''`mod_wsgi`''' || `3.2 (WSGIProcessGroup trac-dev WSGIApplicationGroup
trac-dev.agraquest.int|)` ||
|| '''`psycopg2`''' || `2.0.13` ||
|| '''`Python`''' || `2.6.6 (r266:84292, Apr 11 2011, 15:50:32) ` [[br]]
`[GCC 4.4.4 20100726 (Red Hat 4.4.4-13)]` ||
|| '''`Python`''' || `2.6.6 (r266:84292, Apr 11 2011, 15:50:32) ` [[br]]
`[GCC 4.4.4 20100726 (Red Hat 4.4.4-13)]` ||
|| '''`pytz`''' || `2010h` ||
|| '''`pytz`''' || `2010h` ||
|| '''`setuptools`''' || `0.6c11` ||
|| '''`setuptools`''' || `0.6c11` ||
|| '''`Subversion`''' || `1.6.15 (r1038135)` ||
|| '''`jQuery`''' || `1.7.2` ||
==== Enabled Plugins ====
|| '''`AutocompleteUsers`''' || `0.4.2dev` ||
|| '''`BlackMagicTicketTweaks`''' || `0.12r1` ||
|| '''`BreadCrumbsNav`''' || `0.2` ||
|| '''`ComponentDependencyPlugin`''' || `0.1` ||
|| '''`ContextChrome`''' || `0.3` ||
|| '''`graphviz`''' || `0.7.7dev` ||
|| '''`ReadonlySignedTickets`''' || `N/A` ||
|| '''`ScreenshotPaste`''' || `0.1.1` ||
|| '''`TicketSidebarProvider`''' || `0.0` ||
|| '''`TicketValidator`''' || `0.2dev` ||
|| '''`trac-MultiRepoSearchPlugin`''' || `0.6` ||
|| '''`trac-WorkflowNotificationPlugin`''' || `0.5` ||
|| '''`TracAccountManager`''' || `0.4.3` ||
|| '''`TracAnnouncer`''' || `1.0dev` ||
|| '''`TracAttachmentNotifyPlugin`''' || `1.0.1` ||
|| '''`TracAutoWikify`''' || `0.2dev` ||
|| '''`TracCustomFieldAdmin`''' || `0.2.8-r12166` ||
|| '''`TracDateField`''' || `2.0.0dev-r12118` ||
|| '''`TracDragDrop`''' || `0.12.0.11` ||
|| '''`TracHoursPlugin`''' || `0.6.0dev` ||
|| '''`TracHtmlNotificationPlugin`''' || `0.12.0.1` ||
|| '''`TracMigratePlugin`''' || `0.12.0.3` ||
|| '''`TracReportManager`''' || `0.1` ||
|| '''`TracSubTicketsPlugin`''' || `0.2.0.dev-20130908` ||
==== Python Traceback ====
{{{
Traceback (most recent call last):
File
"/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py",
line 497, in _dispatch_request
dispatcher.dispatch(req)
File
"/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py",
line 224, in dispatch
self._post_process_request(req, *resp)
File
"/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py",
line 338, in _post_process_request
resp = f.post_process_request(req, *resp)
File "build/bdist.linux-x86_64/egg/tracsubtickets/web_ui.py", line 73, in
post_process_request
children = self.get_children(ticket.id)
File "build/bdist.linux-x86_64/egg/tracsubtickets/web_ui.py", line 107,
in get_children
(parent_id, ))
File
"/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/db/util.py", line
65, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: relation "subtickets" does not exist
LINE 1: SELECT parent, child FROM subtickets WHERE parent=1790
^
}}}
On Tuesday, October 19, 2010 9:57:11 PM UTC-7, Andy Baker wrote:
>
> Hi All,
>
> I'm looking into switching from sqlite to postgreSQL as our backend. I'm
> assuming this shouldn't be an issue, but does anyone have any good/bad
> experiences to share?
>
> Ideally I'd like to hear from people using bleeding edge 0.12 saying "yep,
> works just fine" :-)
>
> Cheers
> Andy
>
>
>
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.
