# rpm -q ReviewBoard python-djblets python-django-evolution ReviewBoard-2.0.17-1.el7.noarch python-djblets-0.8.20-1.el7.noarch python-django-evolution-0.7.5-1.el7.noarch
On Sat, Jul 4, 2015 at 12:53 PM, Christian Hammond <[email protected] > wrote: > Hi John, > > What versions of Review Board and Django Evolution are you using? > > Christian > > > On Saturday, July 4, 2015, John Schmitt <[email protected]> wrote: > >> Something seems to go wrong during my upgrade. What do I need to do to >> make this work? >> >> This is my script that ought to upgrade my installation from 1.55 to 2.0 >> >> #!/bin/bash >> >> >> export PS4='+(${BASH_SOURCE}:${LINENO}): >> ${FUNCNAME[0]:+${FUNCNAME[0]}(): }' >> set -x >> set -e >> set -u >> >> >> systemctl stop httpd >> >> >> # perform a fresh installation of ReviewBoard >> rm -rf /var/www/reviews.domain.com >> mysql --password=password -e 'drop database if exists reviewboard;' >> mysql --password=password -e 'create database reviewboard;' >> rb-site install /var/www/reviews.domain.com --noinput >> \ >> --opt-out-support-data >> \ >> --domain-name=' >> reviews.domain.com' \ >> --site-root='/' >> \ >> --static-url='static/' >> \ >> --media-url='media/' >> \ >> --db-type='mysql' >> \ >> --db-name='reviewboard' >> \ >> --db-user='root' >> \ >> --db-pass='password' >> \ >> --db-host='localhost' >> \ >> --cache-type='memcached' >> \ >> --cache-info= >> 'localhost:11211' \ >> --web-server-type='apache' >> \ >> --web-server-port='80' >> \ >> --python-loader='wsgi' >> \ >> --admin-user='admin' >> \ >> --admin-password='password' >> \ >> --admin-email=' >> [email protected]' >> chown -R apache.apache "/var/www/reviews.domain.com/data" >> chown -R apache.apache "/var/www/reviews.domain.com/htdocs/media/ext" >> chown -R apache.apache "/var/www/reviews.domain.com/htdocs/media/uploaded >> " >> chown -R apache.apache "/var/www/reviews.domain.com/htdocs/static/ext" >> mkdir "/var/www/reviews.domain.com/search-index" >> chown -R apache.apache "/var/www/reviews.domain.com/search-index" >> >> >> # import the reviewboard data from the old reviewobard installation >> # general.log grows too big so I delete it but I have to restart mariadb >> so it'll create a fresh one >> rm -rf /var/log/mariadb/general.log >> mysql --password=password < /root/reviewboard.dump >> rm -rf /var/log/mariadb/general.log >> systemctl restart mariadb >> >> >> # the old installation was stored at /data/... >> # the new installation is stored at /var/www/reviews.domain.com/... >> # the new installation directory has to be manually set in the >> siteconfig_siteconfiguration table >> # the siteconfig_siteconfiguration is a giant json string >> #mysql --password=password --batch --skip-column-names -e 'use >> reviewboard; select settings from siteconfig_siteconfiguration;' | grep >> '^{' > siteconfig_siteconfiguration.text >> mysql --password=password --batch --skip-column-names -e 'use >> reviewboard; select settings from siteconfig_siteconfiguration;' > >> siteconfig_siteconfiguration.text >> sed -i 's|/data/django-sites/ReviewBoard|/var/www/reviews.domain.com|' >> siteconfig_siteconfiguration.text >> sed -i 's|data/django-sites/ReviewBoard|/var/www/reviews.domain.com|' >> siteconfig_siteconfiguration.text >> # the giant json string needs to be quoted so bash won't munge it; is >> there a better way? >> /usr/bin/echo -n 'use reviewboard; update siteconfig_siteconfiguration >> set settings=' > siteconfig.command0 >> /usr/bin/echo -n "'" >> siteconfig.command0 >> cat siteconfig_siteconfiguration.text >> siteconfig.command0 >> /usr/bin/echo -n "'" >> siteconfig.command0 >> # `cat` seems to put in a newline I do not want >> tr -d '\n' < siteconfig.command0 > siteconfig.command >> # print the final command, for debugging >> /usr/bin/echo ------------------------------ >> cat siteconfig.command >> /usr/bin/echo ------------------------------ >> mysql --password=password < siteconfig.command >> rb-site upgrade /var/www/reviews.domain.com >> systemctl start httpd >> >> This seems to work but then I see this when I try to start httpd: >> >> Jul 04 11:07:32 dyn40-62-43.tintri.com systemd[1]: Starting The Apache >> HTTP Server... >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: CRITICAL:root:Error >> running database evolver function change_column_attr_unique: >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: Traceback (most >> recent call last): >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line >> 495, in change_column_attrs >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: attr_info[ >> 'new_value']) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line >> 607, in change_column_attr_unique >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: self. >> remove_recorded_index(model, constraint_name, unique=True) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line >> 822, in remove_recorded_index >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: index_name, unique= >> unique) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/signature.py", line >> 186, in remove_index_from_database_sig >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: assert index_name >> in indexes >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: AssertionError >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: ERROR:root: >> Unexpected error: >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: Traceback (most >> recent call last): >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/management/commands/evolve.py" >> , line 65, in handle >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: self.evolve(* >> app_labels, **options) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/management/commands/evolve.py" >> , line 125, in evolve >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: sql.extend(self. >> evolve_app(app)) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/management/commands/evolve.py" >> , line 165, in evolve_app >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: app_mutator_sql = >> app_mutator.to_sql() >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/mutators.py", line 304 >> , in to_sql >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: sql.extend(mutator. >> to_sql()) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/mutators.py", line 187 >> , in to_sql >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: return self.evolver >> .generate_table_ops_sql(self, self._ops) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line 42 >> , in generate_table_ops_sql >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: prev_sql_result, >> prev_op) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line 84 >> , in generate_table_op_sql >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: op['new_attrs'])) >> Jul 04 11:07:44 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line >> 495, in change_column_attrs >> Jul 04 11:07:45 dyn40-62-43.tintri.com rb-site[2066]: attr_info[ >> 'new_value']) >> Jul 04 11:07:45 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line >> 607, in change_column_attr_unique >> Jul 04 11:07:45 dyn40-62-43.tintri.com rb-site[2066]: self. >> remove_recorded_index(model, constraint_name, unique=True) >> Jul 04 11:07:45 dyn40-62-43.tintri.com rb-site[2066]: File >> "/usr/lib/python2.7/site-packages/django_evolution/db/common.py", line >> 822, in remove_recorded_index >> Jul 04 11:07:45 dyn40-62-43.tintri.com rb-site[2066]: index_name, unique= >> unique) >> > > > -- > -- > Christian Hammond - [email protected] > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > -- > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > Happy user? Let us know! https://www.reviewboard.org/users/ > --- > You received this message because you are subscribed to a topic in the > Google Groups "reviewboard" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/reviewboard/oT0NC1Bcokk/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://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.
