[Systems] Double entry in pootle database [SOLVED]

[Sebastian Silva]

Hi,
I wanted to let you know that Julen already helped me out on IRC #pootle
channel, and post the solution.

There were in fact two entries in the pootle_app_directory table.
Going into the django shell and using the api to delete the second,
duplicate entry, fixed it.

The commands I used where:

    select * from pootle_app_directory where pootle_path='/agr/Write/'

to find the ID of the double entry.

With this id I did:

        (took a database backup first)

    from pootle_app.models import Directory

    Directory.objects.filter(id=<conflictive_dir_id>).delete()

in accordance to Julen's friendly advice on IRC, and then it started
working again.

Thanks a lot to Julen. He did mention a constraint in the database
schema could have prevented this issue, and hopefully newer pootle might
include such a constraint.

Your timely help was very much appreciated as we have a session with
translators later today.

Regards from Peru!
Sebastian


On 26/05/15 01:43, Sebastian Silva wrote:
> Hello pootle developers! (cc: Sugar Labs infrastructure team)
>
> This is your friendly sugar labs pootle instance co-maintainer.
>
> I've run into an issue I can't seem to fix.
> You will be able to see the error at this URL:
> http://translate.sugarlabs.org/agr/Write/
> Here i've pasted it for you:
>
>
>     Server Error
>
> An error has occurred. Thank you for your patience.
>
> get() returned more than one Directory -- it returned 2! Lookup
> parameters were {'pootle_path': u'/agr/Write/'}
>
>
> This error started appearing as we were adding languages to an
> existing project. Perhaps we did it twice.
>
> I've gone into the database shell and inspected the records but did
> not find where the issue seems to be. I don't know where to look
> because I can't find a more detailed error log anywhere. Please help!
>
> Regards,
> Sebastian
> -- 
> I+D SomosAzucar.Org
> "icarito" #somosazucar en Freenode IRC
> "Nadie libera a nadie, nadie se libera solo. Los seres humanos se liberan en comunión" - P. Freire

-- 
I+D SomosAzucar.Org
"icarito" #somosazucar en Freenode IRC
"Nadie libera a nadie, nadie se libera solo. Los seres humanos se liberan en comunión" - P. Freire

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sugarlabs.org/private/systems/attachments/20150526/25cbf0c5/attachment.html>