Couchbase 4.1.1 installed locally and on server giving different output

SQL++
1

New to couchbase:Please help.

object(stdClass)#5 (3) {
  ["rows"]=>
  array(0) {
  }
  ["status"]=>
  string(7) "success"
  ["metrics"]=>
  array(4) {
    ["elapsedTime"]=>
    string(12) "973.568547ms"
    ["executionTime"]=>
    string(12) "973.508414ms"
    ["resultCount"]=>
    int(0)
    ["resultSize"]=>
    int(0)
  }
}

this output is from my local but our servers output is without rows in the above object. can some one help out in fixing this issue. Thanks in advance

2

Hi,

Can you please post the query that gives you different results ?

Thanks

3

The query is same on both the machines:
SELECT language.* FROM nosql where language.type=‘language’

Output in my cloud server(Ubuntu server 14.0.4):

2016-09-13 22:02:38 - Array
(
    [0] => stdClass Object
        (
            [code] => en
            [created_date] => 11-02-2016 05:56:23
            [directory] => english
            [image] => gb.png
            [language_id] => 1cf0544179dcd27e5de70df2f54b8dbb
            [locale] => en_US.UTF-8,en_US,en-gb,english
            [modified_date] => 11-02-2016 05:56:23
            [name] => English
            [sort_order] => 1
            [status] => 1
            [type] => language
        )

)

Output from my local machine(Ubuntu desktop 14.0.4):

2016-09-13 16:41:57 - stdClass Object
(
    [rows] => Array
        (
            [0] => stdClass Object
                (
                    [code] => en
                    [created_date] => 11-02-2016 05:56:23
                    [directory] => english
                    [image] => gb.png
                    [language_id] => 1cf0544179dcd27e5de70df2f54b8dbb
                    [locale] => en_US.UTF-8,en_US,en-gb,english
                    [modified_date] => 11-02-2016 05:56:23
                    [name] => English
                    [sort_order] => 1
                    [status] => 1
                    [type] => language
                )

        )

    [status] => success
    [metrics] => Array
        (
            [elapsedTime] => 1.003046379s
            [executionTime] => 1.002993935s
            [resultCount] => 1
            [resultSize] => 447
        )

)

Please help me, this getting delayed from going live.

Thanks in advance,
Goutham

4

We don’t know enough from your descriptions. Can you run your query directly from cbq shell in both environments. Do they contain the same data? Are they running the same version of Couchbase server? Please post the cbq shell response from both environments here.

5

Output is same in both the environments when using cbq.

When using in code the output is different as above.

cbq> SELECT language.* FROM nosql where language.type='language'
   > ;
{
    "requestID": "aaa22a92-7360-4b79-b921-4f638d65316d",
    "signature": {
        "*": "*"
    },
    "results": [
        {
            "code": "en",
            "created_date": "11-02-2016 05:56:23",
            "directory": "english",
            "image": "gb.png",
            "language_id": "1cf0544179dcd27e5de70df2f54b8dbb",
            "locale": "en_US.UTF-8,en_US,en-gb,english",
            "modified_date": "11-02-2016 05:56:23",
            "name": "English",
            "sort_order": "1",
            "status": "1",
            "type": "language"
        }
    ],
    "status": "success",
    "metrics": {
        "elapsedTime": "18.617835ms",
        "executionTime": "17.047478ms",
        "resultCount": 1,
        "resultSize": 447
    }
}
6

Ok. In that case, you should post a new issue under the client API that you are using (e.g. Ruby / Python / Node.js ).

7

Thank you. Can you please tell how to get the client API details.

Thanks,
Goutham

8

Which programming language are you using. You should post under that language.

9

This question has been posted under Php SDK

10

This is the link to the new post