Using update_indexes didn't work... I had to remove all "orderby"s from "selects".
Is it a bug? Thanks! Tito On Sun, Jun 7, 2009 at 11:18 AM, Tito Garrido <titogarr...@gmail.com> wrote: > Thank you folks, > > I'll try appcfg.py update_indexes myapp/ to test... localy it works > perfectly. > > I'll keep you in touch about it! > > Thanks Again > > Tito > > > On Sat, Jun 6, 2009 at 6:53 PM, Robin B <robi...@gmail.com> wrote: > >> >> The easiest way to fix this is to exercise your app on the development >> server, (use the query that needs that missing index) which will add >> the missing index to the generated index.yaml. The next time you >> update/deploy your index.yaml to production, GAE will 'build' the new >> index which takes time. Until the new index is added, any query that >> trys to use it will throw an exception. You can see the index >> building progress if you login to appspot.com. >> >> The safest way to add a new index is to write tests that exercise your >> app in development, so index.yaml is autogenerated. Then deploy your >> indexes with: >> >> appcfg.py update_indexes myapp/ >> >> >> http://code.google.com/appengine/docs/python/tools/uploadinganapp.html#Updating_Indexes >> >> Once you see that the indexes are all 'serving' (built), then deploy >> your app code with: >> >> appcfg.py update myapp/ >> >> >> Robin >> >> >> >> On Jun 6, 1:46 pm, Hans Donner <hans.don...@pobox.com> wrote: >> > running locally works fine? >> > did you check index.yaml? >> > >> > On Sat, Jun 6, 2009 at 8:41 PM, Tito Garrido<titogarr...@gmail.com> >> wrote: >> > > Hi Folks, >> > >> > > I've been receiving Index Errors when I try to run my web2py on gae >> > > application: >> > >> > > 189.115.246.131 - - [06/Jun/2009:11:37:39 -0700] "GET / HTTP/1.1" 500 >> 251 >> > > " >> http://appengine.google.com/deployment?&app_id=tito-garrido&version_i..."; >> > > "Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-BR; rv:1.9.0.10) >> > > Gecko/2009042316 Firefox/3.0.10,gzip(gfe)" >> > > "1.latest.tito-garrido.appspot.com" >> > >> > > W 06-06 11:37AM 38.505 >> > >> > > no file locking >> > >> > > D 06-06 11:37AM 39.045 >> > >> > > no sqlite3 or mysqlite2.dbapi2 driver >> > >> > > D 06-06 11:37AM 39.047 >> > >> > > no MySQLdb driver >> > >> > > D 06-06 11:37AM 39.049 >> > >> > > no psycopg2 driver >> > >> > > D 06-06 11:37AM 39.051 >> > >> > > no cx_Oracle driver >> > >> > > D 06-06 11:37AM 39.054 >> > >> > > no MSSQL/DB2 driver >> > >> > > D 06-06 11:37AM 39.058 >> > >> > > no kinterbasdb driver >> > >> > > D 06-06 11:37AM 39.062 >> > >> > > no informixdb driver >> > >> > > D 06-06 11:37AM 39.065 >> > >> > > no zxJDBC driver >> > >> > > W 06-06 11:37AM 39.091 >> > >> > > unable to import dbhash >> > >> > > W 06-06 11:37AM 39.181 >> > >> > > unable to import wsgiserver >> > >> > > E 06-06 11:37AM 39.420 >> > >> > > Traceback (most recent call last): >> > > File >> > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/gluon/restricted.py", >> > > line 107, in restricted >> > > exec ccode in environment >> > >> > > File >> > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/applications/init/controllers/default.py:index", >> > > line 144, in <module> >> > > File >> > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/gluon/globals.py", >> > > line 97, in <lambda> >> > >> > > self._caller = lambda f: f() >> > > File >> > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/applications/init/controllers/default.py:index", >> > > line 58, in index >> > > File >> > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/gluon/contrib/gql.py", >> > > line 736, in select >> > >> > > for item in items: >> > > File >> "/base/python_lib/versions/1/google/appengine/ext/db/__init__.py", >> > > line 1372, in __iter__ >> > > return self.run() >> > > File >> "/base/python_lib/versions/1/google/appengine/ext/db/__init__.py", >> > > line 1360, in run >> > >> > > iterator = self._get_query().Run() >> > > File >> "/base/python_lib/versions/1/google/appengine/api/datastore.py", line >> > > 886, in Run >> > > return self._Run() >> > > File >> "/base/python_lib/versions/1/google/appengine/api/datastore.py", line >> > > 913, in _Run >> > >> > > str(exc) + '\nThis query needs this index:\n' + yaml) >> > > NeedIndexError: no matching index found. >> > > This query needs this index: >> > > - kind: product >> > > properties: >> > > - name: featured >> > > - name: name >> > >> > > direction: desc >> > >> > > Anybody has a clue of what should I do to fix it? >> > >> > > Thanks! >> > >> > > Tito >> > >> > > -- >> > >> > > Linux User #387870 >> > > .........____ >> > > .... _/_õ|__| >> > > ..º[ .-.___.-._| . . . . >> > > .__( o)__( o).:_______ >> > > Sent from Salvador, BA, Brazil >> >> >> > > > -- > > Linux User #387870 > .........____ > .... _/_õ|__| > ..º[ .-.___.-._| . . . . > .__( o)__( o).:_______ > -- Linux User #387870 .........____ .... _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:_______ Sent from Salvador, BA, Brazil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
