Cannot show Summary and Flavor Info under custom created bucket

n1ql

#1

I have create a bucket;
create primary index;
create some GSI index;

In the Query Workbench ,I can see the bucket under Fully Queryable Buckets, but when I click the bucket, I can not show any Summary and Flavor Info.
At the same time,For demo bucket(beer-sample and travel-sample), I can see the Summary and Flavor Info.


#2

Can you tell me which version of Couchbase are you using? Also, which version of the Query Workbench?

How many documents are there in your bucket?

What happens if you run the query "describe " for the problematic bucket?

Thank you.


#3

I am using :
Couchbase Version: 4.1.0-5005 Enterprise Edition (build-5005) on MAC 10.10.5 (14F27);
Query Workbench Developer Preview 1.0.0 on MAC 10.10.5 (14F27);
and in my bucket I have 3153 documents.
I can run the describe query, the result looks like this:

Status	Elapsed Time	Execution Time	Result Count	Result Size
success	321.217713ms	321.217713ms	1	256561B

#4

when i rerun describe I got the following error:

  [
    "json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: unsupported value: NaN",
    {
      "#docs": 12,
      "Flavor": "",
      "fields": []
    },
    "json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: unsupported value: NaN",
    "json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: error calling MarshalJSON for type *main.Schema: json: error calling MarshalJSON for type main.Field: json: unsupported value: NaN",

btw,the document is import by cbrestore, and I am using sync gateway 1.1.0.


#5

maybe the json error because of added attachments by sync gateway?


#6

Any update? I guess this might cause by attachments?


#7

Hello,

I apologize for the slow update, I had trouble with my forums account and wasn’t getting notifications.

You appear to have run into a bug in the schema inferencing code. That bug may be fixed in the most recent version of the Query Workbench DP, v1.0.2, which you can download it from the Tools tab on the downloads page:

http://www.couchbase.com/nosql-databases/downloads

Let me know if it hasn’t been fixed, and I’ll look into it more.

Regards,

-Eben


#8

I am using Query Workbench Developer Preview 1.0.2
and when I click my bucket, the refresh icon before Metadata is also show refreshing (at least 1h until now).

and when I run

describe mybucket;

some errors shows as following:

  [
    "json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: unsupported value: NaN",
    "json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: unsupported value: NaN",
    "json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: error calling MarshalJSON for type inferencer.fieldMap: json: unsupported value: NaN",

#9

Hi, you’ve definitely found a bug in my code. It’s complaining about “NaN”, do you have any number fields whose value is NaN or null? Can you send me a sample of documents so I can figure out where my code is going wrong?

Thank you.

-Eben


#10

yes, I have null value in doc,This null value are set by Sync Gateway, Following is a sample doc:

{
  "_sync": {
    "rev": "1-f8274e371ded251dcdb1bb0f6f0a3738",
    "sequence": 3939,
    "recent_sequences": [
      3939
    ],
    "history": {
      "revs": [
        "1-f8274e371ded251dcdb1bb0f6f0a3738"
      ],
      "parents": [
        -1
      ],
      "bodies": [
        ""
      ],
      "channels": [
        [
          "u-USR-test1",
          "u-USR-test2",
          "u-USR-test3",
          "u-USR-test4",
          "u-USR-test5"
        ]
      ]
    },
    "channels": {
      "u-USR-test1": null,
      "u-USR-test2": null,
      "u-USR-test3": null,
      "u-USR-test4": null,
      "u-USR-test5": null
    },
    "time_saved": "2015-12-21T10:35:53.47924475+08:00"
  },
  "comment_id": "CMT:52BF837B-97E5-4BD3-9D19-A99727CF198F",
  "id": "ATK:0D9C3133-A6B1-4C93-880B-929F6944FB0E",
  "type": "ATK",
  "usr_list": [
    "USR:test1",
    "USR:test2",
    "USR:test3",
    "USR:test4",
    "USR:test5"
  ]
}

#11

How big is your bucket? Could I have a larger sample to try and debug my code? You could either attach here, or e-mail directly to me (eben at couchbase.com).

Thank you,

-Eben


#12

Only 2971 docs.
I will email you the sample data.