[ https://issues.apache.org/jira/browse/IGNITE-17001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539971#comment-17539971 ]
Ignite TC Bot commented on IGNITE-17001: ---------------------------------------- {panel:title=Branch: [pull/10026/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel} {panel:title=Branch: [pull/10026/head] Base: [master] : No new tests found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}{panel} [TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6578073&buildTypeId=IgniteTests24Java8_RunAll] > Useless ERROR in server logs like Duplicate key during INSERT > ------------------------------------------------------------- > > Key: IGNITE-17001 > URL: https://issues.apache.org/jira/browse/IGNITE-17001 > Project: Ignite > Issue Type: Bug > Components: sql > Reporter: Taras Ledkov > Assignee: Taras Ledkov > Priority: Major > Fix For: 2.14 > > Time Spent: 10m > Remaining Estimate: 0h > > 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: > {code} > [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) > [?:?] > {code} -- This message was sent by Atlassian Jira (v8.20.7#820007)