Thank you for your answer! I am not sure about the cache name. Where would I have created this cache? The ‘first ignite sql application does not mention it either. Wouldn’t the table creation suffice? I have also looked at the logs of the kubernetes node and saw this: ignite-node <> 2018-02-16T00:40:38.517434195Z ... 17 more ignite-node <> 2018-02-16T00:40:38.517431019Z at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1365) ignite-node <> 2018-02-16T00:40:38.517427905Z at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:402) ignite-node <> 2018-02-16T00:40:38.517424810Z at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288) ignite-node <> 2018-02-16T00:40:38.517421498Z at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73) ignite-node <> 2018-02-16T00:40:38.517418414Z at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204) ignite-node <> 2018-02-16T00:40:38.517415060Z at org.h2.engine.Session.prepareCommand(Session.java:514) ignite-node <> 2018-02-16T00:40:38.517402169Z at org.h2.engine.Session.prepareLocal(Session.java:573) ignite-node <> 2018-02-16T00:40:38.517399163Z at org.h2.command.Parser.prepareCommand(Parser.java:257) ignite-node <> 2018-02-16T00:40:38.517396219Z at org.h2.command.Parser.parse(Parser.java:292) ignite-node <> 2018-02-16T00:40:38.517393254Z at org.h2.command.Parser.parse(Parser.java:320) ignite-node <> 2018-02-16T00:40:38.517390293Z at org.h2.command.Parser.parsePrepared(Parser.java:416) ignite-node <> 2018-02-16T00:40:38.517387238Z at org.h2.command.Parser.parseInsert(Parser.java:1056) ignite-node <> 2018-02-16T00:40:38.517384274Z at org.h2.command.Parser.readTableOrView(Parser.java:5483) ignite-node <> 2018-02-16T00:40:38.517381319Z at org.h2.command.Parser.readTableOrView(Parser.java:5506) ignite-node <> 2018-02-16T00:40:38.517378364Z at org.h2.message.DbException.get(DbException.java:155) ignite-node <> 2018-02-16T00:40:38.517375329Z at org.h2.message.DbException.get(DbException.java:179) ignite-node <> 2018-02-16T00:40:38.517372275Z at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ignite-node <> 2018-02-16T00:40:38.517369377Z [42102-195] ignite-node <> 2018-02-16T00:40:38.517366492Z values (?, ?, ?, ?) ignite-node <> 2018-02-16T00:40:38.517363527Z insert into device(id, secret, updated_at, created_at) ignite-node <> 2018-02-16T00:40:38.517360301Z Caused by: org.h2.jdbc.JdbcSQLException: Table "DEVICE" not found; SQL statement: ignite-node <> 2018-02-16T00:40:38.517357290Z at java.lang.Thread.run(Thread.java:748) ignite-node <> 2018-02-16T00:40:38.517354246Z at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ignite-node <> 2018-02-16T00:40:38.517351147Z at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ignite-node <> 2018-02-16T00:40:38.517347126Z at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) ignite-node <> 2018-02-16T00:40:38.517324823Z at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) ignite-node <> 2018-02-16T00:40:38.517321429Z at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) ignite-node <> 2018-02-16T00:40:38.517316840Z at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) ignite-node <> 2018-02-16T00:40:38.517313572Z at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) ignite-node <> 2018-02-16T00:40:38.517310241Z at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39) ignite-node <> 2018-02-16T00:40:38.517306998Z at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137) ignite-node <> 2018-02-16T00:40:38.517303719Z at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164) ignite-node <> 2018-02-16T00:40:38.517300511Z at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:305) ignite-node <> 2018-02-16T00:40:38.517297178Z at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1971) ignite-node <> 2018-02-16T00:40:38.517293915Z at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2445) ignite-node <> 2018-02-16T00:40:38.517290601Z at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) ignite-node <> 2018-02-16T00:40:38.517287374Z at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1962) ignite-node <> 2018-02-16T00:40:38.517283952Z at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1966) ignite-node <> 2018-02-16T00:40:38.517280022Z at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1385) ignite-node <> 2018-02-16T00:40:38.517276485Z ignite-node <> 2018-02-16T00:40:38.517273303Z values (?, ?, ?, ?) ignite-node <> 2018-02-16T00:40:38.517269666Z class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query: insert into device(id, secret, updated_at, created_at) ignite-node <> 2018-02-16T00:40:38.517265972Z , args=[YmMzZWYxZjUtNzY2OS00YjQ2LWI0NjMtY2M0YjljYTBiNjk4, OGNiOWE4NTktMTZkNS00ZDdhLWExYzYtNDdhOTg4OGM4NmFjZTkyY2E0YzItYjY5OS00NjhiLTk5MTgtYzYzOGMxM2ZiZGFk, 2018-02-16 00:40:38.267, 2018-02-16 00:40:38.267], stmtType=ANY_STATEMENT_TYPE]] ignite-node <> 2018-02-16T00:40:38.517260958Z values (?, ?, ?, ?) ignite-node <> 2018-02-16T00:40:38.517190054Z [00:40:38,516][SEVERE][client-connector-#48][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=insert into device(id, secret, updated_at, created_at) ignite-node <> 2018-02-16T00:25:55.543898181Z [00:25:55] Topology snapshot [ver=3, servers=3, clients=0, CPUs=3, heap=3.0GB] ignite-node <> 2018-02-16T00:25:55.542032331Z [00:25:55] Ignite node started OK (id=25f7f37d)
I think it does not provide any more information in my case. Best regards, Stéphane > On Feb 15, 2018, at 20:42, Mikhail <[email protected]> wrote: > > Hi Stéphane, > > I believe a good description of the error you will find in server node log. > > You need to specify a schema for your query, like this: > > insert into "cache_name".device(id, secret, updated_at, created_at) > > there's the existent ticket for error message improvement, I added this > thread as an example: > https://issues.apache.org/jira/browse/IGNITE-7666 > > Thanks, > Mike. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
