Taras Ledkov created IGNITE-17001:
-------------------------------------
Summary: 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
Fix For: 2.14
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)
