<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span>Hi</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span><br>
</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span>every now and then I stumble over syncing problems like this, which seem to be caused by bad data in the db:</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span><br>
</span></div>
<blockquote style="margin: 0px 0px 0px 40px; border: none; padding: 0px;">
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span style="font-family: Consolas, Courier, monospace;">pdb@pdb2:~$ peeringdb sync</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Syncing to https://www.peeringdb.com/api</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Updating resources: org fac net ix ixfac ixlan ixpfx netfac netixlan poc</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Fetching & updating all: org</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Updates to be processed: 4</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Fetching & updating all: fac</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Updates to be processed: 1</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Fetching & updating all: net</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Updates to be processed: 18903</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">Traceback (most recent call last):</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/usr/local/bin/peeringdb", line 11, in <module></span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> sys.exit(main())</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/cli.py", line 62, in main</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> return handler(config=cfg, **vars(options))</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/commands.py", line 20, in _wrapped</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> r = func(*a, **k)</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/commands.py", line 219, in handle</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> client.update_all(rs)</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/_update.py", line 66, in update_all</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> self._atomic_update(lambda: ctx.sync_resource(r, since=since))</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/_update.py", line 78, in _atomic_update</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> sync_func()</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/_update.py", line 66, in <lambda></span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> self._atomic_update(lambda: ctx.sync_resource(r, since=since))</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/_tasks_sequential.py", line 77, in _wrapped</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> return _consume_task(gen)</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/_tasks_sequential.py", line 55, in _consume_task</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> item = gen.send(r)</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/_tasks_sequential.py", line 38, in gather</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> for r in job:</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/peeringdb/_update.py", line 287, in sync_row</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> B.clean(obj)</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/django_peeringdb/client_adaptor/backend.py", line 145, in clean</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> obj.full_clean()</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> File "/home/pdb/.local/lib/python2.7/site-packages/django/db/models/base.py", line 1250, in full_clean</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;"> raise ValidationError(errors)</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<div><span style="font-family: Consolas, Courier, monospace;">django.core.exceptions.ValidationError:
</span><span style="font-family: Consolas, Courier, monospace; background-color: rgb(255, 255, 0);">{'route_server': [u'Enter a valid URL.']</span><span style="font-family: Consolas, Courier, monospace;">}</span></div>
</div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span style="font-family: Consolas, Courier, monospace;">pdb@pdb2:~$</span></div>
</blockquote>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span><br>
</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span>Normally it fixes itself after some time (the bad data has been fixed in the db?)</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span><br>
</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span>Is there any possibility skip this bad data?</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span><br>
</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span>Best regards</span></div>
<div style="font-family: "Trebuchet MS", Trebuchet, sans-serif; font-size: 10pt; color: rgb(0, 36, 81);">
<span>Jan</span></div>
</body>
</html>