Hi Christian, looks like all of the tables are using the InnoDB engine. The commands I used inside mysql were:
use rb2; show table status; On Sunday, 21 September 2014 22:24:09 UTC-4, Christian Hammond wrote: > > Hi Kenneth, > > Can you determine if the tables being created are using InnoDB or MyISAM? > Or a mix? > > Christian > > -- > Christian Hammond - [email protected] <javascript:> > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > > On September 21, 2014 at 7:18:11 PM, Kenneth Wong ([email protected] > <javascript:>) wrote: > > Hi, I'm upgrading from 1.6.4.1 to 2.0.5 as well as transitioning from > > sqlite to mysql. I'm looking for some help on understanding the error > > messages and what I can do about it. > > > > As per Christian's recommendation (from another thread), I did the > > following: > > > > 1. Create a brand new 2.0.5 reviewboard site that uses sqlite. (rb1) > > 2. Copied over the 1.6.4.1 reviewboard.db file. > > 3. Performed "rb-site upgrade rb1". I had to run a couple of other > > changes from the commandline such as: > > 1. removing the old authentication backend > > 2. adding in active directirectory authentication > > 4. Performed "rb-site manage rb1 condensediffs" > > 5. Also performed all the necessary permission changes > > > > From there I was able to log in to the new site... very nice. At this > > point, I'd like to be able to switch over to mysql... there's enough > > traffic on the site to definitely warrant a more solid database backend. > I > > did the following: > > > > 1. Create a brand new 2.0.5 reviewboard site that uses mysql (rb2) > > 2. Performed "rb-site manage rb1 dumpdb > rb1.json" > > 3. Performed "rb-site manage rb2 loaddb rb1.json" > > > > Lots of errors flew by... ended up with a "done" message and a > reviewboard > > that I could log into but that's definitely broken. > > > > There were two types of errors, the first being foreign key constraint > > failures (such as the one below): > > > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`django_admin_log`, CONSTRAINT > > `user_id_refs_id_c0d12874` FOREIGN KEY (`user_id`) REFERENCES > `auth_user` > > (`id`))') > > > > And the other were Duplicate Entry errors such as: > > > > - Error: (1062, "Duplicate entry 'changedescs-changedescription' for key > > 'app_label'") > > > > Below are the remaining unique foreign key constraint failures that came > up > > (multiple instances of each): > > > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`auth_permission`, CONSTRAINT > > `content_type_id_refs_id_d043b34a` FOREIGN KEY (`content_type_id`) > > REFERENCES `django_content_type` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`accounts_reviewrequestvisit`, CONSTRAINT > > `review_request_id_refs_id_0943e99f` FOREIGN KEY (`review_request_id`) > > REFERENCES `reviews_reviewrequest` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`accounts_profile_starred_review_requests`, > > CONSTRAINT `reviewrequest_id_refs_id_342ff1ac` FOREIGN KEY > > (`reviewrequest_id`) REFERENCES `reviews_reviewrequest` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`accounts_localsiteprofile`, CONSTRAINT > > `local_site_id_refs_id_02a402db` FOREIGN KEY (`local_site_id`) > REFERENCES > > `site_localsite` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`diffviewer_filediff`, CONSTRAINT > > `diffset_id_refs_id_c4a01a9e` FOREIGN KEY (`diffset_id`) REFERENCES > > `diffviewer_diffset` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`diffviewer_diffset`, CONSTRAINT > > `history_id_refs_id_153db9d3` FOREIGN KEY (`history_id`) REFERENCES > > `diffviewer_diffsethistory` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`diffviewer_diffset`, CONSTRAINT > > `repository_id_refs_id_76fa8bca` FOREIGN KEY (`repository_id`) > REFERENCES > > `scmtools_repository` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`reviews_defaultreviewer`, CONSTRAINT > > `local_site_id_refs_id_c0a6afc5` FOREIGN KEY (`local_site_id`) > REFERENCES > > `site_localsite` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`reviews_comment`, CONSTRAINT > > `filediff_id_refs_id_828a3cce` FOREIGN KEY (`filediff_id`) REFERENCES > > `diffviewer_filediff` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`reviews_comment`, CONSTRAINT > > `reply_to_id_refs_id_fd1965c8` FOREIGN KEY (`reply_to_id`) REFERENCES > > `reviews_comment` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`reviews_reviewrequest`, CONSTRAINT > > `local_site_id_refs_id_7b3d9679` FOREIGN KEY (`local_site_id`) > REFERENCES > > `site_localsite` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`reviews_review`, CONSTRAINT > > `review_request_id_refs_id_c50f4370` FOREIGN KEY (`review_request_id`) > > REFERENCES `reviews_reviewrequest` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`reviews_reviewrequestdraft`, CONSTRAINT > > `review_request_id_refs_id_1b41e63e` FOREIGN KEY (`review_request_id`) > > REFERENCES `reviews_reviewrequest` (`id`))') > > - Error: (1452, 'Cannot add or update a child row: a foreign key > > constraint fails (`rb2`.`scmtools_repository`, CONSTRAINT > > `local_site_id_refs_id_a0854215` FOREIGN KEY (`local_site_id`) > REFERENCES > > `site_localsite` (`id`))') > > > > I have the full log if anyone thinks that it might help. > > > > Thanks in advance, > > Ken. > > > > -- > > Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ > > --- > > Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ > > --- > > Happy user? Let us know at http://www.reviewboard.org/users/ > > --- > > You received this message because you are subscribed to the Google > Groups "reviewboard" > > group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected] <javascript:>. > > For more options, visit https://groups.google.com/d/optout. > > > > -- Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ --- Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ --- Happy user? Let us know at http://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
