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

Useless ERROR in server logs like Duplicate key during INSERT

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.14
    • sql
    • None

    Description

      During execute SQL we have exceptions which looks like do not require any actions from administrator. So it’s looks like we don’t need this one in logs. As example:

      [2022-03-22T14:16:09,423][ERROR][client-connector-#187%nebula-node%][JdbcRequestHandler] Failed to execute SQL query [reqId=5411, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=I
      NSERT INTO ref_bid_prd_crew_dtl VALUES ('201904','U174148','Initload','2019-07-03 07:48:10',NULL,NULL), args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true, partResReq=false, explicitTimeout=false, sup
      er=JdbcRequest [type=2, reqId=5411]]]
      org.apache.ignite.transactions.TransactionDuplicateKeyException: Duplicate key during INSERT [key=SQL_PUBLIC_REF_BID_PRD_CREW_DTL_e46b9a63d00b9bb81931d447fdf13491_KEY [idHash=1167531818, hash=2095161702, BID_PRD=
      201904, FILE_NBR=U174148]]
              at org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.dmlDoInsert(DmlUtils.java:206) ~[ignite-indexing-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.processSelectResult(DmlUtils.java:169) ~[ignite-indexing-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdateNonTransactional(IgniteH2Indexing.java:3199) ~[ignite-indexing-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdate(IgniteH2Indexing.java:3043) ~[ignite-indexing-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdateDistributed(IgniteH2Indexing.java:2970) ~[ignite-indexing-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeDml(IgniteH2Indexing.java:1319) ~[ignite-indexing-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1240) ~[ignite-indexing-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.GridQueryProcessor$2.applyx(GridQueryProcessor.java:2887) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.GridQueryProcessor$2.applyx(GridQueryProcessor.java:2883) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:35) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:3435) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.GridQueryProcessor.lambda$querySqlFields$3(GridQueryProcessor.java:2903) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuerySafe(GridQueryProcessor.java:2941) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2877) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2835) ~[ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:656) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:321) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:258) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:210) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:58) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:278) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:108) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:135) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119) [ignite-core-8.8.16.jar:8.8.16]
              at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:69) [ignite-core-8.8.16.jar:8.8.16]
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
      

      Attachments

        Issue Links

          Activity

            People

              tledkov-gridgain Taras Ledkov
              tledkov-gridgain Taras Ledkov
              Yury Gerzhedovich Yury Gerzhedovich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m