#3266: Cant Upgrade Trac After Updating to 0.10-dev
----------------------------------+-----------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: daniel
Type: defect | Status: reopened
Priority: normal | Milestone: 0.10
Component: trac-admin | Version: devel
Severity: normal | Resolution:
Keywords: sqlite |
----------------------------------+-----------------------------------------
Changes (by cboos):
* keywords: => sqlite
* resolution: invalid =>
* status: closed => reopened
Comment:
I think the ticket is valid.
The problem occurs if both upgrades/db15.py and upgrades/db18.py
are executed during the same upgrade process, as the same connection
will be used for both set of commands.
From SQLite's doc:
> If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and
"TABLE" then the table that is created is only visible within that same
database connection and is automatically deleted when the database
connection is closed.
and from our code:
* source:trunk/trac/[EMAIL PROTECTED]: get the connection __once__
* source:trunk/trac/[EMAIL PROTECTED]: even reusing the same cursor here;
I think we should explicitely close() and re-obtain the connection, for
the temp tables to be cleared.
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3266>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
