Hi, We have recently upgraded our ReviewBoard from version 1.7.22 to 2.5.10 - as well as also upgrading from RHEL 6.x to CentOS 7.3.1611. Since then we have a review that cannot be interacted with...can't post a new review or comment, adjust existing comments etc - or even delete the review. We get a "HTTP 500 INTERNAL SERVER ERROR" from the browser and the following error in the ReviewBoard logs:
-------------------------------- None - admin - /api/review-requests/27393/ - Exception thrown for user admin at http://reviews/api/review-requests/27393/?api_format=json&force-text-type=html&include-text-types=raw (1062, "Duplicate entry '1701871-1' for key 'reviews_reviewrequest_b8c24015'") Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/django/core/handlers/base.py", line 112, in get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/lib/python2.7/site-packages/django/views/decorators/cache.py", line 52, in _wrapped_view_func response = view_func(request, *args, **kwargs) File "/usr/lib/python2.7/site-packages/django/views/decorators/vary.py", line 19, in inner_func response = func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/resources/base.py", line 196, in __call__ request, method, view, api_format=api_format, *args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/resources/mixins/api_tokens.py", line 65, in call_method_view return view(request, *args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/util/decorators.py", line 75, in _call f = augmented_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/decorators.py", line 122, in _call return view_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/reviewboard/webapi/decorators.py", line 36, in _check return view_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/decorators.py", line 122, in _call return view_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/reviewboard/webapi/decorators.py", line 139, in _check return view_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/util/decorators.py", line 75, in _call f = augmented_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/decorators.py", line 122, in _call return view_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/resources/base.py", line 488, in get etag = self.get_etag(request, obj, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/resources/base.py", line 1134, in get_etag encode_etag=False, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/resources/base.py", line 1162, in generate_etag etag = repr(self.serialize_object(obj, request=request, **kwargs)) File "/usr/lib/python2.7/site-packages/reviewboard/webapi/mixins.py", line 60, in serialize_object obj, *args, **kwargs) File "/usr/lib/python2.7/site-packages/djblets/webapi/resources/base.py", line 774, in serialize_object value = serialize_func(obj, request=request) File "/usr/lib/python2.7/site-packages/reviewboard/webapi/resources/review_request.py", line 561, in serialize_commit_id_field return obj.commit File "/usr/lib/python2.7/site-packages/reviewboard/reviews/models/review_request.py", line 273, in get_commit commit_id=six.text_type(self.changenum)) File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 493, in update rows = query.get_compiler(self.db).execute_sql(None) File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 980, in execute_sql cursor = super(SQLUpdateCompiler, self).execute_sql(result_type) File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 786, in execute_sql cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute return self.cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/django/db/utils.py", line 99, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute return self.cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute return self.cursor.execute(query, args) File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue IntegrityError: (1062, "Duplicate entry '1701871-1' for key 'reviews_reviewrequest_b8c24015'") -------------------------------- I've seen another similar post on this forum but no resolution. (https://groups.google.com/forum/#!topic/reviewboard/7T9oAFHuLSU) Is there anything we can do here? Thanks Rob -- 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.
