Re: Index not getting created

2017-12-28 Thread Dmitriy Setrakyan
Hi Naveen, Affinity mapping is a critical portion of Ignite data distribution and cannot be changed. For more information, please refer to this documentation: https://apacheignite.readme.io/docs/affinity-collocation D. On Wed, Dec 6, 2017 at 9:20 PM, Naveen wrote: > This issue got fixed after

Re: Index not getting created

2017-12-06 Thread Naveen
This issue got fixed after clean restart of the cluster and creating the caches again. I could create the index. Do we have any option to set the affinity mapping for the cache which is already created and holding data. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.co

Re: Index not getting created

2017-12-04 Thread Taras Ledkov
Hi, I see only that "cache not found" at the server.log. Something is wrong. Is it possible to provide a test as the standalone java class or standalone GitHub project so that I can run it and reproduce the problem? On 30.11.2017 20:34, Naveen Kumar wrote: Hi Here is the node logs captured w

Re: Index not getting created

2017-11-30 Thread Naveen Kumar
Hi Here is the node logs captured with -v option. [22:56:41,291][SEVERE][client-connector-#618%IgnitePOC%][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=CREATE INDEX idx_customer_accountId ON "Customer"

Re: Index not getting created

2017-11-30 Thread Taras Ledkov
Hi, I cannot reproduce the issue with described steps. Please check that the cache wasn't destroyed on the server. i.e. please execute SELECT query again after failed CREATE INDEX. On 30.11.2017 11:45, Naveen wrote: Has anyone got a chance to look into into this issue where I am trying to cre

Re: Index not getting created

2017-11-30 Thread Alexey Kukushkin
Naveen, Your "CREATE INDEX" syntax seems valid to me. Can you start server nodes with debugging enabled, reproduce the problem and share the debug log output from the servers?

Re: Index not getting created

2017-11-30 Thread Naveen
Has anyone got a chance to look into into this issue where I am trying to create an index, but its throwing an error saying cache does not exist 0: jdbc:ignite:thin://127.0.0.1> select ACCOUNT_ID_LIST from "Customer".CUSTOMER where ACCOUNT_ID_LIST ='A10001'; ++

Index not getting created

2017-11-29 Thread Naveen Kumar
AM using 2.3 What could be the issue with below create index command. : jdbc:ignite:thin://127.0.0.1> select * from "Customer".CUSTOMER where ACCOUNT_ID_LIST ='A10001'; ++++---