OCI-21500: internal error code, arguments: [knclprcols:chrlen1], [18446744073709551615], [351], [], [], [], [], []

370 views

Skip to first unread message

Marcell Rózsás

unread,

Jun 13, 2022, 3:20:14 AM6/13/22

to debezium

Hi All,

We are using Debezium Oracle connector with XStream and we are struggling with the following problem.

After the creation of the outbound server and the connector everything worked right. But almost every day it stops. Unfortunately, we don’t what is the cause of this problem.

Connector restart doesn’t help. If we want to solve this problem, we have to recreate the outbound server, but this is a temporary solution with data loss. We tried to use different intant client but got the same error.

Do you have any idea what could be the root cause? Or how can we debug this problem?

Error message:

OCI-21500: internal error code, arguments: [knclprcols:chrlen1], [18446744073709551615], [351], [], [], [], [], []

Environment:

Debezium version: 1.9.0.Final
Oracle version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Oracle Intant client version: v19.14

Tables:

CREATE TABLE "ABC_WF"."WF_SURVEY_COMPL"

( "ID" NUMBER(19,0),

"SURVEY_ID" NUMBER(19,0),

"SUBMITTED" TIMESTAMP (6) NOT NULL ENABLE,

"IPADDRESS" VARCHAR2(100 CHAR),

"SUBMITTED_BY" VARCHAR2(100 CHAR),

"CORRECT_ANSWER_COUNT" NUMBER(5,0),

"CLIENT_OPINION_ID" NUMBER(19,0),

"ENCRYPTED_AES_KEY" VARCHAR2(500 CHAR),

"SUBMITTED_BY_NAME" VARCHAR2(200 BYTE),

"SEARCHABLE_FULL_NAME" VARCHAR2(200 BYTE),

"RESPONSIBLE" VARCHAR2(40 BYTE),

"STATE_ID" NUMBER(19,0),

"COMMENTS" VARCHAR2(1000 CHAR),

"RESPONSIBLE_FULL_NAME" VARCHAR2(100 CHAR),

"RESULT_DOCUMENT_ID" VARCHAR2(250 BYTE),

"COMPL_GENERATED_ID" VARCHAR2(250 BYTE),

"ABC_CLIENT_ID" VARCHAR2(10 BYTE),

"IS_CLIENT_ID_VALID" CHAR(1 BYTE),

"IS_DELETED" CHAR(1 BYTE) DEFAULT 0,

"IS_ANONYMIZED" CHAR(1 BYTE) DEFAULT 0,

"SAP_ID" VARCHAR2(10 CHAR),

"TAXNUMBER" VARCHAR2(20 CHAR),

"CALLBACK_URL" VARCHAR2(255 CHAR),

"EXTERNAL_ID" NUMBER(19,0),

PRIMARY KEY ("ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE,

SUPPLEMENTAL LOG GROUP "GGS_237188" ("ID") ALWAYS,

SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,

SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,

SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,

SUPPLEMENTAL LOG DATA (ALL) COLUMNS,

CONSTRAINT "FK_SURVEY_COMPL" FOREIGN KEY ("SURVEY_ID")

REFERENCES "ABC_WF"."WF_SURVEY" ("ID") ENABLE,

CONSTRAINT "FK_CL_OP" FOREIGN KEY ("CLIENT_OPINION_ID")

REFERENCES "ABC_WF"."WF_CLIENT_OPINION" ("ID") ENABLE,

CONSTRAINT "FK_COMPL_STATE" FOREIGN KEY ("STATE_ID")

REFERENCES "ABC_WF"."WF_SF_STATE" ("ID") ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

CREATE TABLE "ABC_WF"."WF_SURVEY_QUESTION"

( "ID" NUMBER(19,0),

"SURVEY_ID" NUMBER(19,0),

"IDX" NUMBER(5,0),

"TYPE" VARCHAR2(50 CHAR) NOT NULL ENABLE,

"LABEL" VARCHAR2(4000 BYTE) NOT NULL ENABLE,

"DISTRIBUTABLE_SCORE" NUMBER(5,0),

"MAX_LENGTH" NUMBER(5,0),

"IS_REQUIRED" CHAR(1 BYTE) DEFAULT '0' NOT NULL ENABLE,

"PAGE_ID" NUMBER(19,0),

"WEIGHT" NUMBER(*,0) DEFAULT 0,

"CALC_MODE" VARCHAR2(50 BYTE),

"QUESTION_GROUP" NUMBER(38,0),

"SHOW_ORDER" NUMBER(38,0),

"IS_ACTIVE" CHAR(1 BYTE) DEFAULT '1' NOT NULL ENABLE,

"MODIFY_DATE" TIMESTAMP (6) DEFAULT SYSDATE NOT NULL ENABLE,

"MODIFY_USER" VARCHAR2(250 BYTE) NOT NULL ENABLE,

"IS_MULTISELECT" CHAR(1 BYTE) DEFAULT '0',

"PARENT_QUESTION_ID" NUMBER(19,0),

"PARENT_QUESTION_ANSWER_IDS" VARCHAR2(100 CHAR),

"OPTEN_FIELD" VARCHAR2(50 CHAR),

PRIMARY KEY ("ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE,

SUPPLEMENTAL LOG GROUP "GGS_237184" ("ID") ALWAYS,

SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,

SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,

SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,

SUPPLEMENTAL LOG DATA (ALL) COLUMNS,

CONSTRAINT "FK_SURVEY_QUEST" FOREIGN KEY ("SURVEY_ID")

REFERENCES "ABC_WF"."WF_SURVEY" ("ID") ENABLE,

CONSTRAINT "FK_QUESTION_PAGE" FOREIGN KEY ("PAGE_ID")

REFERENCES "ABC_WF"."WF_SURVEY_PAGE" ("ID") ENABLE,

CONSTRAINT "FK_QUESTION_Q_TYPE" FOREIGN KEY ("TYPE")

REFERENCES "ABC_WF"."WF_QUESTION_TYPE" ("CODE") ENABLE,

CONSTRAINT "FK_GROUP_TO_QUESTION" FOREIGN KEY ("QUESTION_GROUP")

REFERENCES "ABC_WF"."WF_QUESTION_GROUP" ("ID") ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

CREATE TABLE "ABC_WF"."WF_SURVEY_RESPONSE"

( "ID" NUMBER(19,0),

"COMPL_ID" NUMBER(19,0),

"IDX" NUMBER(5,0),

"QUESTION_ID" NUMBER(19,0) NOT NULL ENABLE,

"RESPONSE" VARCHAR2(4000 BYTE),

"PROCESS_RESP" CHAR(1 BYTE) NOT NULL ENABLE,

"ANSWER_ID" NUMBER(19,0),

"CALCED_VALUE" NUMBER(38,0),

PRIMARY KEY ("ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ENABLE,

SUPPLEMENTAL LOG GROUP "GGS_237190" ("ID") ALWAYS,

SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,

SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,

SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,

SUPPLEMENTAL LOG DATA (ALL) COLUMNS,

CONSTRAINT "FK_RESP_COMPL" FOREIGN KEY ("COMPL_ID")

REFERENCES "ABC_WF"."WF_SURVEY_COMPL" ("ID") ENABLE,

CONSTRAINT "FK_RESP_QUEST" FOREIGN KEY ("QUESTION_ID")

REFERENCES "ABC_WF"."WF_SURVEY_QUESTION" ("ID") ENABLE,

CONSTRAINT "FK_RESPONSE_ANSWER" FOREIGN KEY ("ANSWER_ID")

REFERENCES "ABC_WF"."WF_SURVEY_ANSWER" ("ID") ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "USERS" ;

TRC file:

Trace file /kafka/oradiag_kafka/diag/clients/user_kafka/host_794824097_110/trace/ora_1_139784030672448.trc

OCI-21500: internal error code, arguments: [knclprcols:chrlen1], [18446744073709551615], [351], [], [], [], [], []

DDE: Flood control is not active

2022-05-27T07:08:45.917928+00:00

Incident 33 created, dump file: /kafka/oradiag_kafka/diag/clients/user_kafka/host_794824097_110/incident/incdir_33/ora_1_139784030672448_i33.trc

oci-10847 [21500] [] [] [] [] [] [] [] [] [] [] []

Trace file /kafka/oradiag_kafka/diag/clients/user_kafka/host_794824097_110/trace/ora_1_139784030672448.trc

KNJLCRFillExtraAttributes-9

OCI-21500: internal error code, arguments: [knclprcols:chrlen1], [18446744073709551615], [104], [], [], [], [], []

DDE: Flood control is not active

2022-05-31T12:05:36.752585+00:00

Incident 49 created, dump file: /kafka/oradiag_kafka/diag/clients/user_kafka/host_794824097_110/incident/incdir_49/ora_1_139784030672448_i49.trc

oci-10847 [21500] [] [] [] [] [] [] [] [] [] [] []

Trace file /kafka/oradiag_kafka/diag/clients/user_kafka/host_794824097_110/trace/ora_1_139784030672448.trc

Debezium log:

OCI-21500: internal error code, arguments: [knclprcols:chrlen1], [18446744073709551615], [104], [], [], [], [], []\n\n\n----- Call Stack Trace -----\ncalling call entry argument values in hex \nlocation type point (? means dubious value) \n-------------------- -------- -------------------- ----------------------------\nskgudmp()+188 call kgdsdst() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nkgerinv_internal()+ call skgudmp() 000000000 ? 000000000 ?\n115 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nkgerinv()+40 call kgerinv_internal() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nkgeasnmierr()+150 call kgerinv() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknclprcols()+9995 call kgeasnmierr() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknclprrow()+4328 call knclprcols() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknclprlcr()+494 call knclprrow() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutGetNextLCR()+ call knclprlcr() 000000000 ? 000000000 ?\n716 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutGetNextLCR() 000000000 ? 000000000 ?\n44 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRcvOneLCR()+2 call knxoutRcvOneLCR() 000000000 ? 000000000 ?\n493 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n**** At frame 60 recursion pattern of size 1 found, for return address \n knxoutRcvOneLCR()+2493 suppressing printing.\n**** At frame 78 recursion pattern broken, last return was \n knxoutRcvOneLCR()\n00007F3155822A00 call 00007F31558216FD 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nttcdrv()+18483 call knxoutRcvLcrs() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nnioqwa()+73 call ttcdrv() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nupirtrc()+1424 call nioqwa() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nkpurcsc()+102 call upirtrc() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutRPC()+183 call kpurcsc() 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nknxoutReceiveLCR_CB call knxoutRPC() 000000000 ? 000000000 ?\n()+444 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nKNJLCRInvokeOCICall call knxoutReceiveLCR_CB 000000000 ? 000000000 ?\n()+204 () 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\nJava_oracle_streams call KNJLCRInvokeOCICall 000000000 ? 000000000 ?\n_XStreamOut_XStream () 000000000 ? 000000000 ?\nOutReceiveLCRCallba 000000000 ? 000000000 ?\nckNative()+451 \n00007F31E8A5EEC0 call Java_oracle_streams 000000000 ? 000000000 ?\n _XStreamOut_XStream 000000000 ? 000000000 ?\n OutReceiveLCRCallba 000000000 ? 000000000 ?\n ckNative() \n00007F31E8C33098 call 00007F31E8A5EEC0 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n00000000081553E8 call 00007F31E8C33098 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n000000000000007F call 00000000081553E8 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n 000000000 ? 000000000 ?\n\nCall stack signature: 0x219c993653e82cb2\n\n\n\ncall stack performance statistics:\ntotal : 0.060000 sec\nsetup : 0.000000 sec\nstack unwind : 0.010000 sec\nsymbol translation : 0.050000 sec\nprinting the call stack: 0.000000 sec\nprinting frame data : 0.000000 sec\nprinting argument data : 0.000000 sec\n\n\n----- End of Call Stack Trace -----\n\n2022-05-04 16:09:09,707 INFO Oracle|t10_spli-debezium_apl|streaming Connection gracefully closed [io.debezium.jdbc.JdbcConnection]\n2022-05-04 16:09:09,707 ERROR Oracle|t10_spli-debezium_apl|streaming Producer failure [io.debezium.pipeline.ErrorHandler]\noracle.streams.StreamsException: OCI-21500: internal error code, arguments: [knclprcols:chrlen1], [18446744073709551615], [104], [], [], [], [], []\n\n\n\tat oracle.streams.XStreamOut.XStreamOutReceiveLCRCallbackNative(Native Method)\n\tat oracle.streams.XStreamOut.receiveLCRCallback(XStreamOut.java:465)\n\tat io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.execute(XstreamStreamingChangeEventSource.java:108)\n\tat

Thanks,

Marcel

Chris Cranford

unread,

Jun 13, 2022, 1:26:14 PM6/13/22

to debe...@googlegroups.com, Marcell Rózsás

Hi Marcel -

I do not see anything with the DDL that specifically stands out which might cause a problem. When using OCI and XStream, there is a set of shared code that both the server and the client execute at various points. When this shared code fails on the server side, it throws an ORA-00600 error but on the client it throws an OCI-21500, but both error codes mean exactly the same thing, just differs by where the error was thrown (client vs server).

What the error does tell us is that the C function "knclprocols" failed when executing the branch code for "chrlen1".

I found a few references:
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1263524_1.html
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1317572_1.html

I also found several references that seem to indicate that when "knclprocols:chrlen1" is raised, this is often a network connection-related problem that occurs inside the OCI callback.

I would suggest you check out the above links & also verify you don't have any type of network connectivity issues that could cause the in-progress OCI call to fall w/Oracle.

Thanks,
Chris

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/69abdec9-e029-4c04-b975-61d5076b9e50n%40googlegroups.com.

Reply all

Reply to author

Forward

0 new messages