<div dir="ltr"><div dir="ltr"><br></div><div class="gmail_quote"><div class="gmail_attr"><br></div>Arnold Nipper said to send to this list.<br><br>(This is kind of urgent for me, my goal is to get a snapshot of the data, so any alternative workaround would be helpful in the meantime.)<br><br>I'm in the process of setting up a local copy, and have run into a problem after getting the peeringdb-py stuff set up.<br><br>When I do peeringdb sync (with the correct mysql database UTF8 stuff and everything,), I am currently getting a persistent error which aborts the sync with no data in the tables:<br><br>(Apologies in advance for the long error output text.)<br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Syncing to </span><a href="https://www.peeringdb.com/api" target="_blank" style="font-variant-ligatures:no-common-ligatures;font-family:Menlo;font-size:17px">https://www.peeringdb.com/api</a><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Updating resources: org fac net ix ixfac ixlan ixpfx netfac netixlan poc</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Fetching & updating all: org</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Updates to be processed: 5</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (org-26015)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (org-26052)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (org-17918)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (org-26053)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Fetching & updating all: fac</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Updates to be processed: 0</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Fetching & updating all: net</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Updates to be processed: 18800</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (net-1356)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (net-3684)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (net-7924)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (net-10733)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (net-13084)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (net-14581)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Ignoring object updated after sync began: (net-15702)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Traceback (most recent call last):</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/backends/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">utils.py", line 84, in _execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return self.cursor.execute(sql, params)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/backends/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">mysql/base.py", line 71, in execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return self.cursor.execute(query, args)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/MySQLdb/cursors.py", line 209, in execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    res = self._query(query)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/MySQLdb/cursors.py", line 315, in _query</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    db.query(q)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/MySQLdb/connections.</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">py", line 226, in query</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    _mysql.connection.query(</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">self, query)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">MySQLdb._exceptions.</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`peeringdb`.`peeringdb_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">network`, CONSTRAINT `peeringdb_network_org_id_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">404d6106_fk_peeringdb_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">organization_id` FOREIGN KEY (`org_id`) REFERENCES `peeringdb_organization` (`id`))')</span><br><font color="#000000" face="Menlo"><span style="font-size:17px"><br></span></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:17px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:20px"><span style="font-variant-ligatures:no-common-ligatures"></span></p></div></blockquote><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">The above exception was the direct cause of the following exception:</span><br><font color="#000000" face="Menlo"><span style="font-size:17px"><br></span></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:17px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:20px"><span style="font-variant-ligatures:no-common-ligatures"></span></p></div></blockquote><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Traceback (most recent call last):</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/bin/peeringdb", line 8, in <module></span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    sys.exit(main())</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/cli.py", line 62, in main</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return handler(config=cfg, **vars(options))</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/commands.</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">py", line 20, in _wrapped</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    r = func(*a, **k)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/commands.</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">py", line 219, in handle</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    client.update_all(rs)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/_update.py"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">, line 66, in update_all</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    self._atomic_update(lambda: ctx.sync_resource(r, since=since))</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/_update.py"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">, line 78, in _atomic_update</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    sync_func()</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/_update.py"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">, line 66, in <lambda></span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    self._atomic_update(lambda: ctx.sync_resource(r, since=since))</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/_tasks_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">async.py", line 65, in _wrapped</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return loop.run_until_complete(func(*</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">a, **k))</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/opt/local/Library/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Frameworks/Python.framework/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">Versions/3.6/lib/python3.6/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">asyncio/base_events.py", line 488, in run_until_complete</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return future.result()</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/_tasks_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">async.py", line 41, in _wrapped</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    item = gen.send(r)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/peeringdb/_update.py"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">, line 274, in sync_row</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    B.save(obj)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django_peeringdb/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">client_adaptor/backend.py", line 148, in save</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    obj.save()</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/models/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">base.py", line 741, in save</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    force_update=force_update, update_fields=update_fields)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/models/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">base.py", line 779, in save_base</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    force_update, using, update_fields,</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/models/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">base.py", line 870, in _save_table</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    result = self._do_insert(cls._base_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">manager, using, fields, update_pk, raw)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/models/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">base.py", line 908, in _do_insert</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    using=using, raw=raw)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/models/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">manager.py", line 82, in manager_method</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return getattr(self.get_queryset(), name)(*args, **kwargs)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/models/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">query.py", line 1186, in _insert</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return query.get_compiler(using=</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">using).execute_sql(return_id)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/models/sql/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">compiler.py", line 1375, in execute_sql</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    cursor.execute(sql, params)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/backends/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">utils.py", line 67, in execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return self._execute_with_wrappers(</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">sql, params, many=False, executor=self._execute)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/backends/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">utils.py", line 76, in _execute_with_wrappers</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return executor(sql, params, many, context)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/backends/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">utils.py", line 84, in _execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return self.cursor.execute(sql, params)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/utils.py", line 89, in __exit__</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    raise dj_exc_value.with_traceback(</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">traceback) from exc_value</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/backends/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">utils.py", line 84, in _execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return self.cursor.execute(sql, params)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/django/db/backends/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">mysql/base.py", line 71, in execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    return self.cursor.execute(query, args)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/MySQLdb/cursors.py", line 209, in execute</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    res = self._query(query)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/MySQLdb/cursors.py", line 315, in _query</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    db.query(q)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">  File "/Users/bdickson1/Documents/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">projects/site-selection/</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">pdbvenv/lib/python3.6/site-</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">packages/MySQLdb/connections.</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">py", line 226, in query</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">    _mysql.connection.query(</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">self, query)</span><br><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">django.db.utils.</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`peeringdb`.`peeringdb_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">network`, CONSTRAINT `peeringdb_network_org_id_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">404d6106_fk_peeringdb_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0);font-family:Menlo;font-size:17px">organization_id` FOREIGN KEY (`org_id`) REFERENCES `peeringdb_organization` (`id`))')</span><br><font color="#000000" face="Menlo"><span style="font-size:17px;font-variant-ligatures:no-common-ligatures"><br></span></font><span style="font-variant-ligatures:no-common-ligatures;font-family:"times new roman",serif;color:rgb(0,0,0);font-size:17px">Please let me know if this is a problem on my end, or a problem with the data in the master db itself...</span><br><font color="#000000" face="times new roman, serif"><span style="font-size:17px;font-variant-ligatures:no-common-ligatures"><br></span></font><span style="font-variant-ligatures:no-common-ligatures;font-family:"times new roman",serif;color:rgb(0,0,0);font-size:17px">If there is something I should do to fix this on my end, any advice would be greatly appreciated.</span><br><span style="font-variant-ligatures:no-common-ligatures;font-family:"times new roman",serif;color:rgb(0,0,0);font-size:17px">(If there is any other way to grab a copy of the tables in mysql format, that's all I'm really trying to get, just a snapshot of the current peeringdb database to process with some perl scripts I have.)</span><br><font color="#000000" face="times new roman, serif"><span style="font-size:17px;font-variant-ligatures:no-common-ligatures"><br></span></font><span style="font-variant-ligatures:no-common-ligatures;font-family:"times new roman",serif;color:rgb(0,0,0);font-size:17px">Thanks in advance,</span><br><div><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:17px;line-height:normal;color:rgb(0,0,0)"><font face="times new roman, serif"><span style="font-variant-ligatures:no-common-ligatures">Brian Dickson</span></font></p></div>
</div></div>