Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-7710

copy from csv fails to find existing table (intermittently)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • sql
    • None

    Description

      1) create table via new SqlFieldsQuery()
      2) run ignite node in FULL_SYNC mode
      3) perform sql via thin driver

      COPY FROM "/tmp/mydata.csv" INTO test_update FORMAT CSV;
      

      driver throws:

      java.sql.SQLException: Table does not exist: TEST_UPLOAD
             at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:653)
             at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:136)
             at org.apache.ignite.internal.jdbc.thin.JdbcThinPreparedStatement.executeWithArguments(JdbcThinPreparedStatement.java:252)
             at org.apache.ignite.internal.jdbc.thin.JdbcThinPreparedStatement.executeUpdate(JdbcThinPreparedStatement.java:96)
             at org.apache.ignite.yardstick.upload.CopyBenchmark.warmup(CopyBenchmark.java:67)
             at org.apache.ignite.yardstick.upload.AbstractUploadBenchmark.setUp(AbstractUploadBenchmark.java:50)
             at org.yardstickframework.BenchmarkDriverStartUp.main(BenchmarkDriverStartUp.java:130)
      

      server gets

      [2018-02-14 19:57:47,840][ERROR][client-connector-#47][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=COPY FROM "/tmp/warmup1971356426935
      538953.csv" INTO TEST_UPLOAD (id, val_1, val_2, val_3, val_4, val_5, val_6, val_7, val_8, val_9, val_10) FORMAT CSV;, args=[], stmtType=UPDATE_STMT_TYPE]]
      class org.apache.ignite.internal.processors.query.IgniteSQLException: Table does not exist: TEST_UPLOAD
             at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.processBulkLoadCommand(DmlStatementsProcessor.java:1020)
             at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.runNativeDmlStatement(DmlStatementsProcessor.java:992)
             at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1482)
             at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1518)
             at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2037)
             at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2032)
             at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
             at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2553)
             at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2046)
             at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:1977)
             at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:374)
             at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:179)
             at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:156)
             at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:41)
             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)
      

      Making "test_upload" -> "TEST_UPLOAD" does not help

      sql insert work fine

      Attachments

        Issue Links

          Activity

            People

              kirill.shirokov Kirill Shirokov
              pkouznet Pavel Kuznetsov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: