<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>If you are situated West of UTC you might be running into the timezone issue I reported. The work around I had was to change this <a href="https://github.com/peeringdb/peeringdb-py/blob/289524928c62115da114a0a05e591c940b03ac4f/peeringdb/_update.py#L97" class="OWAAutoLink">line</a>
in peeringdb/_update.py</p>
<p></p>
<p><br>
</p>
<p>from</p>
<p><span> self.start_time = datetime.now()</span><br>
</p>
<p><span><br>
</span></p>
<p><span>to</span></p>
<p><span><br>
</span></p>
<p><span></p>
<p style="font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
self.start_time = datetime.utcnow()</p>
</span>
<p></p>
<p><br>
</p>
<p><br>
</p>
<br>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Pdb-tech <pdb-tech-bounces@lists.peeringdb.com> on behalf of Brian Dickson <brian.peter.dickson@gmail.com><br>
<b>Sent:</b> Friday, May 15, 2020 10:43:44 AM<br>
<b>To:</b> pdb-tech@lists.peeringdb.com<br>
<b>Subject:</b> Re: [PDB Tech] Problem doing initial 'peeringdb sync', foreign key constraint fails?</font>
<div> </div>
</div>
<div>
<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>
</div>
</body>
</html>