It sounds like a lot of the problems boil down to the MyISAM vs. InnoDB
incompatibility. I recommend altering the tables using the MySQL command line
and not a dump/load. You should be able to do this by performing the following
on each table:
ALTER TABLE `tablename` ENGINE=InnoDB;
You'd need to do this for *all* tables. From an answer on this StackOverflow
you can do:
SET @DATABASE_NAME = 'name_of_your_db';
SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS
FROM information_schema.tables AS tb
WHERE table_schema = @DATABASE_NAME
AND `ENGINE` = 'MyISAM'
AND `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;
I'd test all this on a backup first.
Once you do that, I would expect a simple rb-site upgrade to work. You
shouldn't need to do any database dumps/loads for any of this.
Do you have a list of the schema changes you've made to your database? It
sounded like there was at least one. If there are more, you may run into issues
down the road as you upgrade.
Completely optional, but we offer direct assistance with difficult upgrades due
to things like schema changes or other problems as part of a support contract,
where we'll grab a copy of the database schema and figure out exactly what it'd
take to get a successful upgrade going. I'm also happy to help on here, of
course, but if this ends up becoming very hard to diagnose, that could be a
suitable option for you.
Christian Hammond - christ...@beanbaginc.com
Review Board - https://www.reviewboard.org
Beanbag, Inc. - https://www.beanbaginc.com
From: e...@tibco.com <e...@tibco.com>
Reply: firstname.lastname@example.org <email@example.com>>
Date: February 11, 2015 at 11:15:06 AM
To: firstname.lastname@example.org <email@example.com>>
Subject: Crazy difficulties trying to upgrade from 188.8.131.52 - any tool for
finding/correcting DB problems?
> My company has been using ReviewBoard successfully for quite some time, and
> everyone seems to like it.
> However, I'm trying to upgrade past 184.108.40.206, and run into a bevy of trouble.
> Just running the site upgrade didn't work - perhaps something weird about
> my configuration, but on the target machines, if I have my 220.127.116.11 MySQL
> MyISAM tables, they refuse to upgrade even to 1.7.8. (I did this with an
> *empty* database with no reviews in it, and it still didn't migrate). If
> the starting database is uses the InnoDB engine, the upgrade to 1.7.8
> fails, because a key gets too big). Apparently, I can work around *that*
> problem by sticking:
> into /etc/mysql/my.cnf
> OK, so the strategy to move forward seem to be to migrate all my data from
> MyISAM to InnoDB via rb-site manage .... dumbdb and loaddb. However, that
> *also* "fails" in the sense that not all my data is being imported, due to
> foreign key problems. I started looking at them, and realized that some of
> them are genuine problems that must some how be addressed.
> - last_login being null (my fault, due to integration with external
> authentication, easy to fix)
> - extra permissions in the auth_permissions table (presumably I can correct
> this by deleting no-longer-needed permissions flags)
> - deleted users (I don't know how they were deleted, I don't have that
> enabled! I can work-around this issue by re-adding "deleted" but inactive
> ... I don't know what other problems I'll uncover, but I expect that I'll
> uncover them. Before I go through that trial and error work, is there any
> tool out there that will diagnose and potentially fix all the issues? I
> know that 18.104.22.168 is a fairly old version (partly why I'm trying to bring
> the darn thing current!), so I don't expect that someone has anything for
> exactly this version - but perhaps for a later version, that I can adjust
> for the older database schema?
> Supercharge your Review Board with Power Pack:
> Want us to host Review Board for you? Check out RBCommons:
> Happy user? Let us know! https://www.reviewboard.org/users/
> You received this message because you are subscribed to the Google Groups
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
Supercharge your Review Board with Power Pack:
Want us to host Review Board for you? Check out RBCommons:
Happy user? Let us know! https://www.reviewboard.org/users/
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
For more options, visit https://groups.google.com/d/optout.