Description
Setup the 2 sample buckets beer-sample and travel-sample into a couchbase node.
I execute this query ..
select * from system:indexes
|
When I look into the logs for all the indexers setup, N1QL doesn't seem to have setup indexers over `_default` scope and `_default` collection for either of the buckets ..
[17:33:32] AD: ~/Documents/couchbase/ns_server $ grep "NewFTSIndexer" logs/n_0/query.log |
|
|
_time=2021-05-25T17:33:30.328-06:00 _level=INFO _msg=n1fty: NewFTSIndexer, server: http://127.0.0.1:9000, namespace: default, keyspace: beer-sample |
_time=2021-05-25T17:33:30.410-06:00 _level=INFO _msg=n1fty: NewFTSIndexer, server: http://127.0.0.1:9000, namespace: default, keyspace: travel-sample |
_time=2021-05-25T17:33:30.440-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_03, keyspace: users |
_time=2021-05-25T17:33:30.456-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_03, keyspace: bookings |
_time=2021-05-25T17:33:30.471-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_02, keyspace: users |
_time=2021-05-25T17:33:30.486-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_02, keyspace: bookings |
_time=2021-05-25T17:33:30.502-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_01, keyspace: users |
_time=2021-05-25T17:33:30.520-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_01, keyspace: bookings |
_time=2021-05-25T17:33:30.537-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_00, keyspace: bookings |
_time=2021-05-25T17:33:30.554-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_00, keyspace: users |
_time=2021-05-25T17:33:30.569-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: inventory, keyspace: landmark |
_time=2021-05-25T17:33:30.583-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: inventory, keyspace: hotel |
_time=2021-05-25T17:33:30.601-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: inventory, keyspace: airport |
_time=2021-05-25T17:33:30.616-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: inventory, keyspace: airline |
_time=2021-05-25T17:33:30.632-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: inventory, keyspace: route |
_time=2021-05-25T17:33:30.647-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_04, keyspace: users |
_time=2021-05-25T17:33:30.663-06:00 _level=INFO _msg=n1fty: NewFTSIndexer2, server: http://127.0.0.1:9000, namespace: default, bucket: travel-sample, scope: tenant_agent_04, keyspace: bookings |
So now, if we set up FTS indexes over the `_default._default` scope.collection, there's no results.
Attachments
Issue Links
- relates to
-
MB-46821 [FTS] ~50x increase in latency for QF2 , QF3 N1FTY tests
-
- Closed
-