Hello all,

For the record, my problem was caused by a corruption of our mysql backend.
(ran out of space....unbelievable, but I must come clean)

I figured this out and then ran some mysqlcheck type of actions to repair.

We are good now.

Thank you all!

Chris

On Thu, Jun 9, 2011 at 2:38 PM, Christopher Hahn <xrz1...@gmail.com> wrote:
> Christian,
>
> I am seeing MySQL as our backend:
> =================================
> DATABASE_ENGINE = 'mysql'
> DATABASE_NAME = 'reviewboard'
> DATABASE_USER = 'reviewboard'
> =================================
>
> ...and it is a perforce repository that we are working with here.
>
> Please let me know if this was not what you wanted to know.
>
> ...and I will try to analyze the dump as you suggest.
>
> Thank you very much for the kind attention,
>
> Christopher
>
> On Thu, Jun 9, 2011 at 2:12 PM, Christian Hammond <chip...@chipx86.com> wrote:
>> The mcm errors shouldn't actually be related (though it may mean your
>> memcached isn't working properly?).
>>
>> So it sounds like the database schema is correct and up-to-date. It's
>> probably some double entry in the database then.
>>
>> What repository backing are you using?
>>
>> We need to find out what field the "NULL-1" is in (and what actually
>> generated that). What you can try is to dump your database contents using
>> mysqldump to a text file, then searching it for "NULL-1". It should reveal
>> what field it's in. I can make more educated guesses after I know that.
>>
>> Christian
>>
>> --
>> Christian Hammond - chip...@chipx86.com
>> Review Board - http://www.reviewboard.org
>> VMware, Inc. - http://www.vmware.com
>>
>>
>> On Thu, Jun 9, 2011 at 1:55 PM, Christopher Hahn <xrz1...@gmail.com> wrote:
>>>
>>> Hello,
>>>
>>> I did run the 'rb-site upgrade'.
>>>
>>> Can you confirm that I gave it the right path to RB?
>>>
>>> It does seem to have chewed on something, but I get errors, and
>>> you see below.
>>>
>>> I may need to start with a fresh install....but if I cannot migrate
>>> the data, then
>>> I will be in a bad place.
>>>
>>> Thank you all so very much for taking the time.  It is heartening to
>>> have company.  ;0)
>>>
>>> Chris
>>>
>>> ===================================================================
>>> root@servicemanager:/data2/ReviewBoard# rb-site upgrade /data2/ReviewBoard
>>> Rebuilding directory structure
>>> Updating database. This may take a while.
>>> /var/lib/python-support/python2.6/MySQLdb/__init__.py:34:
>>> DeprecationWarning: the sets module is deprecated
>>>  from sets import ImmutableSet
>>> [NOTICE@1307646025.131383] mcm_server_connect():2302: Software caused
>>> connection abort
>>> [NOTICE@1307646025.131517] mcm_server_connect():2302: Software caused
>>> connection abort
>>> [NOTICE@1307646025.131573] mcm_server_connect_next_avail():2333:
>>> Software caused connection abort
>>> [WARN@1307646025.131614] mcm_server_connect_next_avail():2338
>>> [NOTICE@1307646025.131676] mcm_server_connect_next_avail():2328
>>> Upgrading Review Board from 1.5 to 1.5.5
>>> [NOTICE@1307646025.131902] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.132022] mcm_atomic_cmd():649
>>> [NOTICE@1307646025.195105] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.195214] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.221598] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.221678] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.238188] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.238276] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.266242] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.266347] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.292776] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.292856] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.315523] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.315571] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.333410] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.333452] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.346766] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.346810] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.369352] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.369395] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.418996] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.419049] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.437399] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.437443] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.455682] mcm_server_connect_next_avail():2328
>>> [NOTICE@1307646025.455733] mcm_server_connect_next_avail():2328
>>> No fixtures found.
>>>
>>> /usr/local/lib/python2.6/dist-packages/pycrypto-2.3-py2.6-linux-x86_64.egg/Crypto/Util/randpool.py:40:
>>> RandomPool_DeprecationWarning: This application uses RandomPool, which
>>> is BROKEN in older releases.  See
>>> http://www.pycrypto.org/randpool-broken
>>> No evolution required.
>>> Upgrade complete.
>>> ===================================================================
>>>
>>> On Thu, Jun 9, 2011 at 12:29 PM, Christian Hammond <chip...@chipx86.com>
>>> wrote:
>>> > After upgrading, did you run 'rb-site upgrade' on the site?
>>> >
>>> > Christian
>>> >
>>> > --
>>> > Christian Hammond - chip...@chipx86.com
>>> > Review Board - http://www.reviewboard.org
>>> > VMware, Inc. - http://www.vmware.com
>>> >
>>> >
>>> > On Thu, Jun 9, 2011 at 11:24 AM, Christopher Hahn <xrz1...@gmail.com>
>>> > wrote:
>>> >>
>>> >> I wanted to add that an upgrade from 1.5 to 1.5.5 executed without
>>> >> complaint, and
>>> >> the results loads fine in IE:
>>> >> ======================================================
>>> >> root@servicemanager:/data2/ReviewBoard# easy_install -U ReviewBoard
>>> >> Searching for ReviewBoard
>>> >> Reading http://pypi.python.org/simple/ReviewBoard/
>>> >> Reading http://www.review-board.org/
>>> >> Reading http://downloads.review-board.org/releases/ReviewBoard/1.0/
>>> >> Reading http://downloads.reviewboard.org/releases/ReviewBoard/1.5/
>>> >> Reading http://downloads.review-board.org/releases/
>>> >> Best match: ReviewBoard 1.5.5
>>> >> Downloading
>>> >>
>>> >> http://downloads.reviewboard.org/releases/ReviewBoard/1.5/ReviewBoard-1.5.5-py2.6.egg
>>> >>   <SNIP>
>>> >> Installed
>>> >> /usr/local/lib/python2.6/dist-packages/django_evolution-0.6.3-py2.6.egg
>>> >> Finished processing dependencies for ReviewBoard
>>> >> root@servicemanager:/data2/ReviewBoard#
>>> >> ======================================================
>>> >>
>>> >> This upgrade had no effect on the problem.  I am thinking that this
>>> >> problem
>>> >> is caused by some corruption of the database backend.
>>> >>
>>> >> Any backend trouble-shooting tips will be appreciated,
>>> >>
>>> >> Chris
>>> >>
>>> >> On Thu, Jun 9, 2011 at 10:34 AM, XRZ1138 <xrz1...@gmail.com> wrote:
>>> >> >
>>> >> > Hello all,
>>> >> >
>>> >> > I am very new to RB and am just hoping to get a pointer into the
>>> >> > docs.
>>> >> >
>>> >> > I am seeing this error when trying to submit a review:
>>> >> > =========================================
>>> >> > Django Version: 1.2.3
>>> >> > Exception Type: IntegrityError
>>> >> > Exception Value: (1062, "Duplicate entry 'NULL-1' for key 2")
>>> >> > Exception Location: /var/lib/python-support/python2.6/MySQLdb/
>>> >> > connections.py in defaulterrorhandler, line 35
>>> >> > Python Executable: /usr/bin/python
>>> >> > Python Version: 2.6.2
>>> >> > =========================================
>>> >> >
>>> >> > I will continue to look into this but any comments appreciated.
>>> >> >
>>> >> > Chris
>>> >>
>>> >>
>>> >>
>>> >> --
>>> >> Realisant mon espoir, je me lance vers la gloire.
>>> >> Christopher Hahn == xrz1...@gmail.com
>>> >>
>>> >> --
>>> >> Want to help the Review Board project? Donate today at
>>> >> http://www.reviewboard.org/donate/
>>> >> Happy user? Let us know at http://www.reviewboard.org/users/
>>> >> -~----------~----~----~----~------~----~------~--~---
>>> >> To unsubscribe from this group, send email to
>>> >> reviewboard+unsubscr...@googlegroups.com
>>> >> For more options, visit this group at
>>> >> http://groups.google.com/group/reviewboard?hl=en
>>> >
>>> > --
>>> > Want to help the Review Board project? Donate today at
>>> > http://www.reviewboard.org/donate/
>>> > Happy user? Let us know at http://www.reviewboard.org/users/
>>> > -~----------~----~----~----~------~----~------~--~---
>>> > To unsubscribe from this group, send email to
>>> > reviewboard+unsubscr...@googlegroups.com
>>> > For more options, visit this group at
>>> > http://groups.google.com/group/reviewboard?hl=en
>>>
>>>
>>>
>>> --
>>> Realisant mon espoir, je me lance vers la gloire.
>>> Christopher Hahn == xrz1...@gmail.com
>>>
>>> --
>>> Want to help the Review Board project? Donate today at
>>> http://www.reviewboard.org/donate/
>>> Happy user? Let us know at http://www.reviewboard.org/users/
>>> -~----------~----~----~----~------~----~------~--~---
>>> To unsubscribe from this group, send email to
>>> reviewboard+unsubscr...@googlegroups.com
>>> For more options, visit this group at
>>> http://groups.google.com/group/reviewboard?hl=en
>>
>> --
>> Want to help the Review Board project? Donate today at
>> http://www.reviewboard.org/donate/
>> Happy user? Let us know at http://www.reviewboard.org/users/
>> -~----------~----~----~----~------~----~------~--~---
>> To unsubscribe from this group, send email to
>> reviewboard+unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/reviewboard?hl=en
>
>
>
> --
> Realisant mon espoir, je me lance vers la gloire.
> Christopher Hahn == xrz1...@gmail.com
>



-- 
Realisant mon espoir, je me lance vers la gloire.
Christopher Hahn == xrz1...@gmail.com

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~----------~----~----~----~------~----~------~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en

Reply via email to