Hi John,
What versions of Review Board and Django Evolution are you using?
Christian
On Saturday, July 4, 2015, John Schmitt <marmalo...@gmail.com> 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='
> jschm...@domain.com <javascript:_e(%7B%7D,'cvml','jschm...@domain.com');>'
> 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 - christ...@beanbaginc.com
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 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/d/optout.
