When I try to implement my N1Ql query which uses GSI in the log it says
GSI instantiation failed: Post /_metakv: missing port in address
I have tried gooling it, but the basic result that I get is issue: MB-15001
For Example:
When I fire the Query:
CREATE INDEX ko ON beer-sample(name);
Result is:
{
“requestID”: “63ba3eae-528c-4042-a8ba-807a7096144d”,
“signature”: null,
“results”: [
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “6.092730473s”,
“executionTime”: “6.092483222s”,
“resultCount”: 0,
“resultSize”: 0
}
}
But when I fire the same Query Using GSI i.e.
In the Logger:
time=2015-07-22T12:07:18+05:30 _level=ERROR _msg=GSIC[default; beer-sample] GSI instantiation failed: Post /_metakv: missing port in address
_time=2015-07-22T12:07:18+05:30 _level=WARN _msg=Error loading GSI indexes for keyspace beer-sample. Error GSI client instantiation failed - cause: Post /_metakv: missing port in address
Hi @shiv4nsh,
I have just run both queries you describe against a local instance of CB 4.0 and both of them return successfully.
Could you give more details of your current setup, CB version, cluster size and OS?
Also just to be sure, did you enable indexing and query during initial setup?
CB version: CB 4.0
cluster size: Single node
and OS: Ubuntu 15.04
And I have enabled indexing, querying and datastoring on this server while installing.
Does the version of libssl effects…??
And I have checked the Issue given above it says that you have outdated ns_server code.
I didn’t get that, so please provide me a detailed solution.
@shiv4nsh, looks like there was a hiccup during install. few questions;
Can you confirm you are using build 2213 (BETA)?
Did you get any errors doing installation?
can you check if your indexer process is running right now?
thanks
-cihan
./cbq-engine -datastore http://Administrator:123456@127.0.0.1:8091
_time=2015-07-23T10:17:19+05:30 _level=INFO _msg=Setting log level to INFO
_time=2015-07-23T10:17:19+05:30 _level=ERROR _msg= Unable to initialize cbauth. Error Unable to initialize cbauth's revrpc: cbauth environment variable CBAUTH_REVRPC_URL is not set
_time=2015-07-23T10:17:19+05:30 _level=INFO _msg= Trying to init cbauth with credentials 127.0.0.1:8091 Administrator 123456
_time=2015-07-23T10:17:19+05:30 _level=INFO _msg= Initialization of cbauth succeeded
_time=2015-07-23T10:17:19+05:30 _level=INFO _msg=New site created with url http://Administrator:123456@127.0.0.1:8091
_time=2015-07-23T10:17:19+05:30 _level=INFO _msg=Request Size Cap bytes=67108864
_time=2015-07-23T10:17:19+05:30 _level=INFO _msg=cbq-engine started version=0.8.1 datastore=http://Administrator:123456@127.0.0.1:8091 threads=4
_time=2015-07-23T10:17:19+05:30 _level=INFO _msg=HttpEndpoint: Listen Address=[::]:8093
cbauth refers to the auth module. is your bucket sasl password protected? looks like cbq is having trouble authenticating. I assume this isn’t a production env. so if you have a bucket password set up and if the data isn’t sensitive, could you remove the bucket password and try again?
thanks
-cihan
The bucket is not password protected.
And I think its an Issue that we cannot fire a Nickel query on a password protected bucket. Thats why I have removed it.
without that you won’t be able to create a GSI index. could you check the setting page and index ram quota and make sure you have set that to 256 MB. if you set this value too large, it could cause the initialization to fail.
thanks
-cihan
apologies for the delayed response. I think you need to enable the index service at the initial setup and I don’t believe you have that given the log files present in this directory.
