Modify ↓
Opened 19 years ago
Closed 17 years ago
#3720 closed defect (wontfix)
Upgrade script db18.py can fail.
| Reported by: | Christian Boos | Owned by: | Jonas Borgström |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | general | Version: | 0.10b1 |
| Severity: | normal | Keywords: | upgrade |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description (last modified by )
In the new session table, we introduce a compound primary key on (sid,authenticated).
However, during the upgrade, depending on the content of the old session table, we might insert duplicate records according to this key. This in turn aborts the upgrade.
On 9/13/06, nomorsad <nomorsad@gmail.com> wrote:
… In fact, the db17 is working well, but db18 fails !! …
Command failed: columns sid, authenticated, name are not unique
Attachments (0)
Change History (2)
comment:1 by , 19 years ago
| Description: | modified (diff) |
|---|
comment:2 by , 17 years ago
| Milestone: | 0.10.6 |
|---|---|
| Resolution: | → wontfix |
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.



Well, I think it's a bit old to touch at this point.
If this happens for someone, simply restore the db from before the update, then manually empty the session table, and run trac-admin update again.