You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Taras Ledkov (Jira)" <ji...@apache.org> on 2022/05/18 12:27:00 UTC
[jira] [Updated] (IGNITE-17001) Useless ERROR in server logs like Duplicate key during INSERT
[ https://issues.apache.org/jira/browse/IGNITE-17001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Taras Ledkov updated IGNITE-17001:
----------------------------------
Ignite Flags: (was: Docs Required,Release Notes Required)
> 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)