Can you look for all review requests with changenum 1701871 (possibly commit_id with that value --it's a string in this case), see what turns up?
Christian On Wed, Jun 7, 2017 at 03:37 'Rob Backhurst' via reviewboard < [email protected]> wrote: > Hi Christian, > > This is from our DBA... > > ---- > > ok, in that case we either have no problematic dupes or we are not sure > how to find them. All dupes mentioned before have same changenum but > different repository_id.. All items returned by executing below code have > different repository_id: > > “select a.id, a.status, a.public, a.changenum, a.repository_id, > b.totalCount AS no_of_duplicate > > from reviews_reviewrequest a > > inner join ( SELECT changenum, COUNT(*) totalCount FROM > reviews_reviewrequest GROUP BY changenum) b ON a.changenum = b.changenum > > WHERE b.totalCount >= 2 order by a.changenum desc” > > There will be items with exactly same ‘status’ and/or ‘public’ values, > there will be some dupes where those are different but in all cases > repository_id differs between the dupes on changenum column.. Are you able > to point us in right direction in order to identify the problematic dupes > (or other issue that might be causing the problem) ? > --- > > Thanks > Rob > > On Friday, 26 May 2017 09:24:00 UTC+1, Rob Backhurst wrote: >> >> 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. > -- -- Christian Hammond President/CEO of Beanbag Makers of Review Board -- 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.
