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.
--------------------------------
Error traceback
1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.
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
--------------------------------------
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
