No bucket named ______

SQL++
1

Started using N1QL today with existing buckets. I’ve followed the advice of the documentation and tried creating a PRIMARY INDEX on each bucket (same as namespace?) with different results. For one bucket it returns this:

{
“results”: []
}

But for another bucket it returns this:
{
“code”: 5000,
“msg”: “Keyspace users name not found - cause: Bucket users not found. - cause: No bucket named users”
}

I know in fact the the bucket does exist. Any idea as to why this might be happening?

Thanks in advance.

-Tony

2

Hi,

Please post the results of the following:

select * from system:namespaces;

select * from system:keyspaces;

select * from system:indexes;

3

Gerald,

Here are the results of those queries:

select * from system:namespaces;

{
  "results": [
    {
      "namespaces": {
        "id": "default",
        "name": "default",
        "store_id": "http://localhost:8091/"
      }
    }
  ]
}

select * from system:keyspaces;

{
  "results": [
    {
      "keyspaces": {
        "id": "couchmusic",
        "name": "couchmusic",
        "namespace_id": "default",
        "store_id": "http://localhost:8091/"
      }
    },
    {
      "keyspaces": {
        "id": "default",
        "name": "default",
        "namespace_id": "default",
        "store_id": "http://localhost:8091/"
      }
    },
    {
      "keyspaces": {
        "id": "playlists",
        "name": "playlists",
        "namespace_id": "default",
        "store_id": "http://localhost:8091/"
      }
    },
    {
      "keyspaces": {
        "id": "tracks",
        "name": "tracks",
        "namespace_id": "default",
        "store_id": "http://localhost:8091/"
      }
    }
  ]
}

select * from system:indexes;

{
  "results": [
    {
      "indexes": {
        "id": "#primary",
        "index_key": [
          "(meta(`couchmusic`).`id`)"
        ],
        "index_type": "view",
        "keyspace_id": "couchmusic",
        "name": "#primary",
        "namespace_id": "default",
        "store_id": "http://localhost:8091/"
      }
    },
    {
      "indexes": {
        "id": "#primary",
        "index_key": [
          "(meta(`playlists`).`id`)"
        ],
        "index_type": "view",
        "keyspace_id": "playlists",
        "name": "#primary",
        "namespace_id": "default",
        "store_id": "http://localhost:8091/"
      }
    }
  ]
}

Thanks,

-Tony

4

Ok. You can see that the users bucket is not showing up in the list of keyspaces. Is it password-protected?

-Gerald

5

Yes, that bucket is password-protected. Is that a problem?

-Tony

6

Yes, password-protected buckets are not supported for DP4. They will be supported going forward.

-Gerald

7

Gerald,

Any idea when a build will be available that supports password-protected buckets? I need that capability in the app I am building for that Java developer course.

Thanks!

-Tony

8

The next DP release will support password-protected buckets; this release will include full support for using Couchbase key-value as a back-end (not just a file store). Coming soon! ETA mid-April.

Thanks,
Colm.