[rt-users] Upgrade 3.6 -> 3.8; database corruption? (was: something wacky with users)
ruslan.zakirov at gmail.com
Tue Dec 16 16:21:04 EST 2008
Start from SELECT * FROM ACL WHERE RightName = 'OwnTicket'; Check
objects in the list may be there are some relevant details.
I don't think it's DB, but it may be either bug or fix of a bug that
On Wed, Dec 17, 2008 at 12:04 AM, Kevin Murphy <murphy at genome.chop.edu> wrote:
> Kevin Murphy wrote:
>> I just upgraded from RT 3.6.6 to 3.8.1 on Mac OS X Server 10.4.11, using
>> PostgreSQL 8.3.5.
>> Creating a ticket, I see a couple candidate owners who shouldn't be in
>> the Owner drop-down menu, even including a non-privileged user.
> Yikes! I repeated the upgrade from scratch with a fresh restore of the
> pre-upgrade database, with identical results. Is it possible that the
> database upgrade scripts corrupted something?
> Prior to the upgrade, I did a pg_dumpall, and I used that dump to
> rebuild the database.
> I then followed the upgrade instructions. These database updates were
> * 3.7.1
> * 3.7.3
> * 3.7.10
> * 3.7.15
> * 3.7.19
> * 3.7.81
> * 3.7.82
> * 3.7.85
> * 3.7.86
> * 3.7.87
> * 3.8.0
> * 3.8.1
> -Kevin Murphy
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
Best regards, Ruslan.
More information about the rt-users