# 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 <christ...@beanbaginc.com
> wrote:

> 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'
>> 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 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
> reviewboard+unsubscr...@googlegroups.com.
> 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 reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to