ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Taras Ledkov <tled...@gridgain.com>
Subject Re: Index not getting created
Date Mon, 04 Dec 2017 10:40:25 GMT
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 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".CUSTOMER (ACCOUNT_ID_LIST),
> args=[], stmtType=ANY_STATEMENT_TYPE]]
>
> class org.apache.ignite.internal.processors.query.IgniteSQLException:
> Cache doesn't exist: Customer
>
>          at org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor.convert(DdlStatementsProcessor.java:343)
>
>          at org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor.runDdlStatement(DdlStatementsProcessor.java:287)
>
>          at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1466)
>
>          at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1966)
>
>          at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1962)
>
>          at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
>
>          at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2445)
>
>          at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1971)
>
>          at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:305)
>
>          at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164)
>
>          at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137)
>
>          at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39)
>
>          at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
>
>          at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
>
>          at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
>
>          at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>
>          at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
>
>          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>
>          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>
>          at java.lang.Thread.run(Thread.java:748)
>
>
>
> Select query works fine
>
> 0: jdbc:ignite:thin://127.0.0.1> select ACCOUNT_ID_LIST from
> "Customer".CUSTOMER where ACCOUNT_ID_LIST ='A100000001';
>
> +--------------------------------+
>
> |        ACCOUNT_ID_LIST         |
>
> +--------------------------------+
>
> | A100000001                     |
>
> +--------------------------------+
>
> 1 row selected (1.342 seconds)
>
>
> Create index query failed with the below error
>
> 0: jdbc:ignite:thin://127.0.0.1> CREATE INDEX idx_customer_accountId
> ON "Customer".CUSTOMER (ACCOUNT_ID_LIST);
>
> Error: Cache doesn't exist: Customer (state=50000,code=0)
>
> java.sql.SQLException: Cache doesn't exist: Customer
>
>          at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:671)
>
>          at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
>
>          at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
>
>          at sqlline.Commands.execute(Commands.java:823)
>
>          at sqlline.Commands.sql(Commands.java:733)
>
>          at sqlline.SqlLine.dispatch(SqlLine.java:795)
>
>          at sqlline.SqlLine.begin(SqlLine.java:668)
>
>          at sqlline.SqlLine.start(SqlLine.java:373)
>
>          at sqlline.SqlLine.main(SqlLine.java:265)
>
>
> selectc query works fine even after issuing the create index query
> which is failed
>
> 0: jdbc:ignite:thin://127.0.0.1> select ACCOUNT_ID_LIST from
> "Customer".CUSTOMER where ACCOUNT_ID_LIST ='A100000001';
>
> +--------------------------------+
>
> |        ACCOUNT_ID_LIST         |
>
> +--------------------------------+
>
> | A100000001                     |
>
> +--------------------------------+
>
> 1 row selected (1.641 seconds)
>
> 0: jdbc:ignite:thin://127.0.0.1>
>
> On Thu, Nov 30, 2017 at 9:04 PM, Taras Ledkov <tledkov@gridgain.com> wrote:
>> 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
>>> 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 ='A100000001';
>>> +--------------------------------+
>>> |        ACCOUNT_ID_LIST         |
>>> +--------------------------------+
>>> | A100000001                     |
>>> +--------------------------------+
>>> 1 row selected (2.078 seconds)
>>>
>>> **0: jdbc:ignite:thin://127.0.0.1> CREATE INDEX idx_customer_accountId ON
>>> "Customer".CUSTOMER (ACCOUNT_ID_LIST);*
>>> *Error: Cache doesn't exist: Customer (state=50000,code=0)
>>> java.sql.SQLException: Cache doesn't exist: Customer
>>>           at
>>>
>>> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:671)
>>>           at
>>>
>>> org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
>>>           at
>>>
>>> org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
>>>           at sqlline.Commands.execute(Commands.java:823)
>>>           at sqlline.Commands.sql(Commands.java:733)
>>>           at sqlline.SqlLine.dispatch(SqlLine.java:795)
>>>           at sqlline.SqlLine.begin(SqlLine.java:668)
>>>           at sqlline.SqlLine.start(SqlLine.java:373)
>>>           at sqlline.SqlLine.main(SqlLine.java:265)
>>> 0: jdbc:ignite:thin://127.0.0.1>
>>>
>>>
>>>
>>>
>>> --
>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>> --
>> Taras Ledkov
>> Mail-To: tledkov@gridgain.com
>>
>
>

-- 
Taras Ledkov
Mail-To: tledkov@gridgain.com


Mime
View raw message