[rt-users] Upgrade 3.6 -> 3.8; database corruption? (was: something wacky with users)

Kenneth Marshall ktm at rice.edu
Tue Dec 16 16:14:48 EST 2008


Kevin,

The only database changes in this list are 3.7.3/schema.Pg
which just increases the size of a variable length field to
64k from 255. I do not see how that could have the effect
that you are observing.

Ken

On Tue, Dec 16, 2008 at 04:04:08PM -0500, Kevin Murphy 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 
> applied:
> 
> * 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
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> 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
> 



More information about the rt-users mailing list