I'm really enjoying working with web2py but I'm having some problems
with local GAE.
I imported a CSV file with 37500 rows into my local app running on
GAE. This import works fine in web2py without GAE (took a few
minutes). After about 2 hours I stopped my GAE app, thinking it was
stuck somewhere and then got an error when I tried looking at the
table through appadmin on the local GAE.
----------------------------------
Traceback (most recent call last):
File "C:\webdev\web2py\gluon\restricted.py", line 188, in restricted
exec ccode in environment
File "C:/webdev/web2py/applications/ArticleSpin/views/
appadmin.html", line 160, in <module>
<strong>{{="%02d" % ram['oldest'][0]}}</strong> hours
File "C:\webdev\web2py\gluon\globals.py", line 105, in write
self.body.write(xmlescape(data))
File "C:\webdev\web2py\gluon\html.py", line 108, in xmlescape
return data.xml()
File "C:\webdev\web2py\gluon\html.py", line 625, in xml
(fa, co) = self._xml()
File "C:\webdev\web2py\gluon\html.py", line 616, in _xml
self.components])
File "C:\webdev\web2py\gluon\html.py", line 108, in xmlescape
return data.xml()
File "C:\webdev\web2py\gluon\html.py", line 625, in xml
(fa, co) = self._xml()
File "C:\webdev\web2py\gluon\html.py", line 616, in _xml
self.components])
File "C:\webdev\web2py\gluon\html.py", line 108, in xmlescape
return data.xml()
File "C:\webdev\web2py\gluon\html.py", line 625, in xml
(fa, co) = self._xml()
File "C:\webdev\web2py\gluon\html.py", line 616, in _xml
self.components])
File "C:\webdev\web2py\gluon\html.py", line 108, in xmlescape
return data.xml()
File "C:\webdev\web2py\gluon\html.py", line 625, in xml
(fa, co) = self._xml()
File "C:\webdev\web2py\gluon\html.py", line 616, in _xml
self.components])
File "C:\webdev\web2py\gluon\html.py", line 108, in xmlescape
return data.xml()
File "C:\webdev\web2py\gluon\sql.py", line 1522, in __getattr__
self.__allocate()
File "C:\webdev\web2py\gluon\sql.py", line 1517, in __allocate
raise RuntimeError, "Using a recursive select but encountered a
broken reference"
RuntimeError: Using a recursive select but encountered a broken
reference
In file: C:\webdev\web2py\applications\ArticleSpin/views\appadmin.html
<code object <module> at 313B0698, file "C:\webdev\web2py\applications
\ArticleSpin/views\appadmin.html", line 1>
--------------------------------------------------
I removed my app from the local GAE and added it back again, same
error. Then I un-installed GAE, re-installed it, and added my app
back
to it. Much to my surprise, the database tables were not empty, the
table in question still had many rows and I still couldn't open it in
appadmin.
Is there any way to empty the database on the local GAE and start
over
again? Removing the app from GAE and adding it back doesn't affect
the
database. Even un-installing and re-installing GAE and then adding
the
app back doesn't work, the database persists. Right now I'm stuck
because I can't empty this table on the local GAE.
Chuck Paulson
