Skip to content

NeedIndexError on a single property (Google AppEngine + Firestore) #5427

Description

@RohanTalip

I'm cross-posting this from https://stackoverflow.com/questions/50634212/needindexerror-on-a-single-property-google-appengine-firestore

If you can provide us with as much of the following information as possible it
will help us identify the cause of your issue more quickly.

  1. Specify the API at the beginning of the title (for example, "BigQuery: ...")
    General, Core, and Other are also allowed as types

Not sure.

  1. OS type and version
$ sw_vers
ProductName:	Mac OS X
ProductVersion:	10.13.4
BuildVersion:	17E202
  1. Python version and virtual environment information python --version
$ python --version
Python 2.7.12
  1. google-cloud-python version pip show google-cloud, pip show google-<service> or pip freeze

pip show google-cloud shows no results.

$ gcloud version
Google Cloud SDK 203.0.0
alpha 2018.05.25
app-engine-python 1.9.70
beta 2018.05.25
bq 2.0.34
core 2018.05.25
gsutil 4.31
$ dpkg -l "google-cloud-sdk*"
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                               Version                Architecture           Description
+++-==================================-======================-======================-=========================================================================
ii  google-cloud-sdk                   203.0.0-0              all                    Utilities for the Google Cloud Platform
un  google-cloud-sdk-app-engine-java   <none>                 <none>                 (no description available)
ii  google-cloud-sdk-app-engine-python 203.0.0-0              all                    Python runtime for Google App Engine
un  google-cloud-sdk-bigtable-emulator <none>                 <none>                 (no description available)
un  google-cloud-sdk-datastore-emulato <none>                 <none>                 (no description available)
un  google-cloud-sdk-pubsub-emulator   <none>                 <none>                 (no description available)
  1. Stacktrace if available
logMessage:  "An error occurred during a request.
Traceback (most recent call last):
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/lib/flask/app.py", line 1982, in wsgi_app
    response = self.full_dispatch_request()
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/lib/flask/app.py", line 1614, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/lib/flask_cors/extension.py", line 161, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/lib/flask/app.py", line 1517, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/lib/flask/app.py", line 1612, in full_dispatch_request
    rv = self.dispatch_request()
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/lib/flask/app.py", line 1598, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/auth.py", line 42, in wrapper
    return api_function(*args, **kwargs)
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/users.py", line 51, in api_list_users
    users = User.query_users()
  File "/base/data/home/apps/s~events-12275/20180531t165330.410118595690745694/model.py", line 35, in query_users
    db_objects = query.fetch()
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/ext/ndb/utils.py", line 160, in positional_wrapper
    return wrapped(*args, **kwds)
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/ext/ndb/query.py", line 1218, in fetch
    return self.fetch_async(limit, **q_options).get_result()
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/ext/ndb/tasklets.py", line 383, in get_result
    self.check_success()
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/ext/ndb/tasklets.py", line 427, in _help_tasklet_along
    value = gen.throw(exc.__class__, exc, tb)
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/ext/ndb/query.py", line 995, in _run_to_list
    batch = yield rpc
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/ext/ndb/tasklets.py", line 513, in _on_rpc_completion
    result = rpc.get_result()
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/api/apiproxy_stub_map.py", line 613, in get_result
    return self.__get_result_hook(self)
  File "/base/alloc/tmpfs/dynamic_runtimes/python27/277b61042b697c7a_unzipped/python27_lib/versions/1/google/appengine/datastore/datastore_query.py", line 2921, in __query_result_hook
    yaml_index=yaml, xml_index=xml)
NeedIndexError: no matching index found.
The suggested index for this query is:
- kind: User
  properties:
  - name: displayName"     
    severity:  "ERROR"     
  1. Steps to reproduce

Please see the linked stack overflow post above. (Let me know if this is insufficient.)

  1. Code example

Please see the linked stack overflow post above. (Let me know if this is insufficient.)

Any ideas? Should this be possible? i.e. to use GCP on GAE with Firestore indexes?

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions