Thank you for your help. I noticed most of my tables were MyISAM. I made the default engine for my mysql install be "MyISAM".
I converted a few tables to MyISAM: mysql> ALTER TABLE diffviewer_filediffdata ENGINE = MyISAM ; Query OK, 4582 rows affected (0.12 sec) Records: 4582 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE extensions_registeredextension ENGINE = MyISAM ; Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE hostingsvcs_hostingserviceaccount ENGINE = MyISAM ; Query OK, 0 rows affected (0.00 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE reviews_reviewrequest_depends_on ENGINE = MyISAM ; Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 now rb-site upgrade works now I will go drink heavily. On Wed, Jun 5, 2013 at 9:27 PM, Christian Hammond <chip...@chipx86.com>wrote: > You have a mix of InnoDB tables and MyISAM tables. You need to make sure > they're all consistent. Either convert all your old tables, or configure > MySQL to create new tables of the same type as existing ones (you'll have > to look up how to configure this as I don't know off-hand). > > Christian > > -- > Christian Hammond - chip...@chipx86.com > Review Board - http://www.reviewboard.org > Beanbag, Inc. - http://www.beanbaginc.com > > On Jun 5, 2013, at 2:25 PM, kegstand <kegst...@gmail.com> wrote: > > 2) The result of: rb-site manage /path/to/site evolve -- --hint >> > (edited slightly) > MUTATIONS = [ > AddField('Profile', 'extra_data', JSONField, null=True) > ] > MUTATIONS = [ > AddField('HostingServiceAccount', 'hosting_url', models.CharField, > max_length=255, null=True) > ] > MUTATIONS = [ > AddField('ReviewRequest', 'depends_on', models.ManyToManyField, > null=True, related_model='reviews.ReviewRequest'), > AddField('ReviewRequestDraft', 'depends_on', models.ManyToManyField, > null=True, related_model='reviews.ReviewRequest') > ] > > which makes me think I need to delete: > column extra_data in accounts_profile > column hosting_url in hostingsvcs_hostingserviceaccount > table reviews_reviewrequestdraft_depends_on > table reviews_reviewrequest_depends_on > > So I do so: > > mysql> alter table accounts_profile drop column extra_data ; > Query OK, 25 rows affected (0.01 sec) > Records: 25 Duplicates: 0 Warnings: 0 > > mysql> drop table reviews_reviewrequest_depends_on ; > Query OK, 0 rows affected (0.01 sec) > > mysql> drop table reviews_reviewrequestdraft_depends_on ; > ERROR 1051 (42S02): Unknown table 'reviews_reviewrequestdraft_depends_on' > mysql> alter table accounts_profile drop column extra_data ; > Query OK, 25 rows affected (0.00 sec) > Records: 25 Duplicates: 0 Warnings: 0 > > mysql> alter table hostingsvcs_hostingserviceaccount drop column > hosting_url ; > Query OK, 0 rows affected (0.01 sec) > Records: 0 Duplicates: 0 Warnings: 0 > > mysql> drop table reviews_reviewrequest_depends_on ; > Query OK, 0 rows affected (0.01 sec) > > mysql> drop table reviews_reviewrequestdraft_depends_on ; > ERROR 1051 (42S02): Unknown table 'reviews_reviewrequestdraft_depends_on' > > > [root@rb ~]# rb-site upgrade /var/www/reviewboard > Rebuilding directory structure > Updating database. This may take a while. > > The log output below, including warnings and errors, > can be ignored unless upgrade fails. > > ------------------ <begin log output> ------------------ > Creating tables ... > There are unapplied evolutions for accounts. > There are unapplied evolutions for hostingsvcs. > There are unapplied evolutions for reviews. > Project signature has changed - an evolution is required > Installing custom SQL ... > Installing indexes ... > Installed 0 object(s) from 0 fixture(s) > Error: Error applying evolution: (1005, "Can't create table > 'reviewboard.#sql-4f26_13b25' (errno: 150)") > [root@rb ~]# > > > > > I think it's failing to create reviews_reviewrequestdraft_depends_on at > this last step? But I can't prove it. > > > > > > On Wed, Jun 5, 2013 at 9:04 PM, kegstand <kegst...@gmail.com> wrote: > >> Here I show I deleted what I needed to: >> >> mysql> select extra_data from accounts_profile ; >> ERROR 1054 (42S22): Unknown column 'extra_data' in 'field list' >> mysql> select hosting_url from hostingsvcs_hostingserviceaccount; >> ERROR 1054 (42S22): Unknown column 'hosting_url' in 'field list' >> mysql> show create table reviews_reviewrequest_depends_on ; >> ERROR 1146 (42S02): Table 'reviewboard.reviews_reviewrequest_depends_on' >> doesn't exist >> mysql> show create table reviews_reviewrequestdraft_depends_on ; >> ERROR 1146 (42S02): Table >> 'reviewboard.reviews_reviewrequestdraft_depends_on' doesn't exist >> mysql> >> >> >> [root@rb ~]# rb-site -d upgrade /var/www/reviewboard >> Rebuilding directory structure >> Updating database. This may take a while. >> >> The log output below, including warnings and errors, >> can be ignored unless upgrade fails. >> >> ------------------ <begin log output> ------------------ >> Creating tables ... >> There are unapplied evolutions for accounts. >> There are unapplied evolutions for hostingsvcs. >> There are unapplied evolutions for reviews. >> Project signature has changed - an evolution is required >> Installing custom SQL ... >> Installing indexes ... >> Installed 0 object(s) from 0 fixture(s) >> Error: Error applying evolution: (1005, "Can't create table >> 'reviewboard.#sql-4f26_13b10' (errno: 150)") >> [root@rb ~]# >> >> >> >> >> >> >> >> On Wed, Jun 5, 2013 at 9:00 PM, Christian Hammond <chip...@chipx86.com>wrote: >> >>> You need to delete all the fields, not just the next set. >>> >>> It's applying part of the evolutions, then failing at the next step. >>> Because of the failure, it's already applied the previous steps but didn't >>> record that, so it tries to apply again next time. >>> >>> Delete extra_data, hosting_url, and all the other things it and I >>> mentioned, and then it should work. >>> >>> Christian >>> >>> -- >>> Christian Hammond - chip...@chipx86.com >>> Review Board - http://www.reviewboard.org >>> Beanbag, Inc. - http://www.beanbaginc.com >>> >>> >>> On Wed, Jun 5, 2013 at 1:47 PM, kegstand <kegst...@gmail.com> wrote: >>> >>>> db backed up. >>>> >>>> mysql: >>>> >>>> mysql> alter table accounts_profile drop column extra_data ; >>>> Query OK, 25 rows affected (0.00 sec) >>>> Records: 25 Duplicates: 0 Warnings: 0 >>>> >>>> mysql> alter table hostingsvcs_hostingserviceaccount drop column >>>> hosting_url ; >>>> ERROR 1091 (42000): Can't DROP 'hosting_url'; check that column/key >>>> exists >>>> mysql> drop table reviews_reviewrequest_depends_on ; >>>> ERROR 1051 (42S02): Unknown table 'reviews_reviewrequest_depends_on' >>>> mysql> drop table reviews_reviewrequestdraft_depends_on ; >>>> ERROR 1051 (42S02): Unknown table >>>> 'reviews_reviewrequestdraft_depends_on' >>>> mysql> >>>> >>>> >>>> >>>> rb upgrade: >>>> >>>> [root@rb ~]# rb-site upgrade /var/www/reviewboard >>>> Rebuilding directory structure >>>> Updating database. This may take a while. >>>> >>>> The log output below, including warnings and errors, >>>> can be ignored unless upgrade fails. >>>> >>>> ------------------ <begin log output> ------------------ >>>> Creating tables ... >>>> There are unapplied evolutions for accounts. >>>> There are unapplied evolutions for hostingsvcs. >>>> There are unapplied evolutions for reviews. >>>> Project signature has changed - an evolution is required >>>> Installing custom SQL ... >>>> Installing indexes ... >>>> Installed 0 object(s) from 0 fixture(s) >>>> Error: Error applying evolution: (1005, "Can't create table >>>> 'reviewboard.#sql-4f26_13ae5' (errno: 150)") >>>> [root@rb ~]# rb-site upgrade /var/www/reviewboard >>>> Rebuilding directory structure >>>> Updating database. This may take a while. >>>> >>>> The log output below, including warnings and errors, >>>> can be ignored unless upgrade fails. >>>> >>>> ------------------ <begin log output> ------------------ >>>> Creating tables ... >>>> There are unapplied evolutions for accounts. >>>> There are unapplied evolutions for hostingsvcs. >>>> There are unapplied evolutions for reviews. >>>> Project signature has changed - an evolution is required >>>> Installing custom SQL ... >>>> Installing indexes ... >>>> Installed 0 object(s) from 0 fixture(s) >>>> Error: Error applying evolution: (1060, "Duplicate column name >>>> 'extra_data'") >>>> [root@rb ~]# >>>> >>>> >>>> >>>> >>>> >>>> On Wed, Jun 5, 2013 at 8:28 PM, Christian Hammond >>>> <chip...@chipx86.com>wrote: >>>> >>>>> You'll have to repeat the process for all new fields listed in the >>>>> --hint, and the intermediate tables >>>>> (reviews_reviewrequestdraft_depends_on, reviews_reviewrequest_depends_on). >>>>> >>>>> I recommend also backing up your database first, just in case. >>>>> >>>>> Christian >>>>> >>>>> -- >>>>> Christian Hammond - chip...@chipx86.com >>>>> Review Board - http://www.reviewboard.org >>>>> Beanbag, Inc. - http://www.beanbaginc.com >>>>> >>>>> >>>>> On Wed, Jun 5, 2013 at 1:24 PM, kegstand <kegst...@gmail.com> wrote: >>>>> >>>>>> mysql> alter table accounts_profile drop column extra_data ; >>>>>> Query OK, 25 rows affected (0.00 sec) >>>>>> Records: 25 Duplicates: 0 Warnings: 0 >>>>>> >>>>>> mysql> quit >>>>>> Bye >>>>>> [root@rb reviewboard]# rb-site upgrade /var/www/reviewboard >>>>>> Rebuilding directory structure >>>>>> Updating database. This may take a while. >>>>>> >>>>>> The log output below, including warnings and errors, >>>>>> can be ignored unless upgrade fails. >>>>>> >>>>>> ------------------ <begin log output> ------------------ >>>>>> Creating tables ... >>>>>> There are unapplied evolutions for accounts. >>>>>> There are unapplied evolutions for hostingsvcs. >>>>>> There are unapplied evolutions for reviews. >>>>>> Project signature has changed - an evolution is required >>>>>> Installing custom SQL ... >>>>>> Installing indexes ... >>>>>> Installed 0 object(s) from 0 fixture(s) >>>>>> Error: Error applying evolution: (1060, "Duplicate column name >>>>>> 'hosting_url'") >>>>>> >>>>>> >>>>>> >>>>>> On Wed, Jun 5, 2013 at 8:16 PM, kegstand <kegst...@gmail.com> wrote: >>>>>> >>>>>>> >>>>>>> On Wed, Jun 5, 2013 at 8:14 PM, Christian Hammond <chip...@gmail.com >>>>>>> > wrote: >>>>>>> >>>>>>>> Did you at any point attempt an upgrade before to this version? >>>>>>>> >>>>>>> >>>>>>> Never. >>>>>>> >>>>>>> >>>>>>>> >>>>>>>> Also, did you install Review Boars using pip, or easy_install? >>>>>>>> >>>>>>>> >>>>>>> I cannot remember. >>>>>>> >>>>>>> >>>>>>> >>>>>>>> You can try dropping the extra_data field from accounts_profile >>>>>>>> and re-running rb-site upgrade. >>>>>>>> >>>>>>>> will try >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> Want to help the Review Board project? Donate today at >>>>>> http://www.reviewboard.org/donate/ >>>>>> Happy user? Let us know at http://www.reviewboard.org/users/ >>>>>> -~----------~----~----~----~------~----~------~--~--- >>>>>> To unsubscribe from this group, send email to >>>>>> reviewboard+unsubscr...@googlegroups.com >>>>>> For more options, visit this group at >>>>>> http://groups.google.com/group/reviewboard?hl=en >>>>>> --- >>>>>> 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 reviewboard+unsubscr...@googlegroups.com. >>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Want to help the Review Board project? Donate today at >>>>> http://www.reviewboard.org/donate/ >>>>> Happy user? Let us know at http://www.reviewboard.org/users/ >>>>> -~----------~----~----~----~------~----~------~--~--- >>>>> To unsubscribe from this group, send email to >>>>> reviewboard+unsubscr...@googlegroups.com >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/reviewboard?hl=en >>>>> --- >>>>> 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 reviewboard+unsubscr...@googlegroups.com. >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Want to help the Review Board project? Donate today at >>>> http://www.reviewboard.org/donate/ >>>> Happy user? Let us know at http://www.reviewboard.org/users/ >>>> -~----------~----~----~----~------~----~------~--~--- >>>> To unsubscribe from this group, send email to >>>> reviewboard+unsubscr...@googlegroups.com >>>> For more options, visit this group at >>>> http://groups.google.com/group/reviewboard?hl=en >>>> --- >>>> 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 reviewboard+unsubscr...@googlegroups.com. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> >>> -- >>> Want to help the Review Board project? Donate today at >>> http://www.reviewboard.org/donate/ >>> Happy user? Let us know at http://www.reviewboard.org/users/ >>> -~----------~----~----~----~------~----~------~--~--- >>> To unsubscribe from this group, send email to >>> reviewboard+unsubscr...@googlegroups.com >>> For more options, visit this group at >>> http://groups.google.com/group/reviewboard?hl=en >>> --- >>> 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 reviewboard+unsubscr...@googlegroups.com. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> > > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~----------~----~----~----~------~----~------~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en > --- > 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 reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~----------~----~----~----~------~----~------~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en > --- > 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 reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- 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 reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
