[PDB Tech] peeringdb sync error

[Stefan Pratter]

Hi,

Cannot reproduce the issue on my local sync - hadn't run it since Jul 
31st and updated without errors just now.

I'd appreciate if you could answer these questions to help us identify 
the cause:

1. which version of py-peeringdb are you running
2. "org last update 1470142503 0 changed" indicates that you ran the 
script earlier today, did that produce any errors? particularly with the 
org sync? if so which error?
3. Does the problem persist if you do it on a fresh db (eg. after 
running the drop_tables command, WARNING: this will delete all existing 
data)


thanks,
Stefan

On 02/08/16 18:38, Paul Vlaar wrote:
> Something's not going right here:
>
> $ /usr/local/bin/peeringdb sync
> Operations to perform:
>   Synchronize unmigrated apps: django_peeringdb
>   Apply all migrations: admin, contenttypes, auth, sessions
> Synchronizing apps without migrations:
>   Creating tables...
>     Running deferred SQL...
>   Installing custom SQL...
> Running migrations:
>   No migrations to apply.
> Starting new HTTPS connection (1): www.peeringdb.com
> "GET /api/org?since=1470142503 HTTP/1.1" 200 None
> org last update 1470142503 0 changed
> data to be processed 0
> Starting new HTTPS connection (1): www.peeringdb.com
> "GET /api/fac?since=1470088505 HTTP/1.1" 200 None
> fac last update 1470088505 0 changed
> data to be processed 0
> Starting new HTTPS connection (1): www.peeringdb.com
> "GET /api/net?since=1469642106 HTTP/1.1" 200 None
> net last update 1469642106 110 changed
> data to be processed 110
> Traceback (most recent call last):
>   File "/usr/local/bin/peeringdb", line 9, in <module>
>     load_entry_point('peeringdb==0.4.3.2', 'console_scripts', 'peeringdb')()
>   File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 716,
> in __call__
>     return self.main(*args, **kwargs)
>   File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 696,
> in main
>     rv = self.invoke(ctx)
>   File "/usr/local/lib/python2.7/dist-packages/click/core.py", line
> 1060, in invoke
>     return _process_result(sub_ctx.command.invoke(sub_ctx))
>   File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 889,
> in invoke
>     return ctx.invoke(self.callback, **ctx.params)
>   File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 534,
> in invoke
>     return callback(*args, **kwargs)
>   File "/usr/local/lib/python2.7/dist-packages/peeringdb/cli.py", line
> 169, in sync
>     db.sync()
>   File "/usr/local/lib/python2.7/dist-packages/peeringdb/localdb.py",
> line 140, in sync
>     call_command('pdb_sync', interactive=False)
>   File
> "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
> line 120, in call_command
>     return command.execute(*args, **defaults)
>   File
> "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py",
> line 445, in execute
>     output = self.handle(*args, **options)
>   File
> "/usr/local/lib/python2.7/dist-packages/django_peeringdb/management/commands/pdb_sync.py",
> line 85, in handle
>     self.sync(tables)
>   File
> "/usr/local/lib/python2.7/dist-packages/django_peeringdb/management/commands/pdb_sync.py",
> line 92, in sync
>     self.update_db(cls, self.get_objs(cls))
>   File
> "/usr/local/lib/python2.7/dist-packages/django_peeringdb/management/commands/pdb_sync.py",
> line 127, in update_db
>     sync.sync_obj(cls, row)
>   File
> "/usr/local/lib/python2.7/dist-packages/django_peeringdb/sync.py", line
> 25, in sync_obj
>     obj.full_clean()
>   File
> "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line
> 1171, in full_clean
>     raise ValidationError(errors)
> django.core.exceptions.ValidationError: {'org': [u'organization instance
> with id 14675 does not exist.']}
>
> 	~paul
> _______________________________________________
> Pdb-tech mailing list
> Pdb-tech at lists.peeringdb.com
> http://lists.peeringdb.com/cgi-bin/mailman/listinfo/pdb-tech
>