oracle事务经常查到的数据是旧数据(新数据已经提交很久了)，或者已经插入的数据报找不到

我来答

很

2024-11-15

## 环境信息
1. DB信息
```
Oracle Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
```
2. client信息
```
gorm.io/gorm v1.25.12
github.com/sijms/go-ora/v2 v2.8.21
```

## 表的DDL如下：
```sql

CREATE TABLE "APC20_DEV_OTHER"."apc_t_dispatching_key"
( "id" NUMBER(19,0) GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"tenant_id" VARCHAR2(64 CHAR) DEFAULT NULL,
"app_id" VARCHAR2(64 CHAR) DEFAULT NULL,
"dispatching_key" VARCHAR2(64 CHAR) DEFAULT NULL,
"weights" VARCHAR2(4000) DEFAULT NULL,
"bpm_no" VARCHAR2(64 CHAR) DEFAULT NULL,
"approve_status" NUMBER(3,0) DEFAULT '0',
"approve_time" TIMESTAMP (6) DEFAULT SYSTIMESTAMP,
"comment" VARCHAR2(512 CHAR) DEFAULT NULL,
"create_user_id" VARCHAR2(32 CHAR) DEFAULT NULL,
"create_user_name" VARCHAR2(128 CHAR) DEFAULT NULL,
"modify_user_id" VARCHAR2(32 CHAR) DEFAULT NULL,
"modify_user_name" VARCHAR2(128 CHAR) DEFAULT NULL,
"create_time" TIMESTAMP (0) DEFAULT SYSTIMESTAMP NOT NULL ENABLE,
"update_time" TIMESTAMP (0) DEFAULT SYSTIMESTAMP NOT NULL ENABLE,
"modify_time" TIMESTAMP (0) DEFAULT SYSTIMESTAMP NOT NULL ENABLE,
"delete_time" TIMESTAMP (6) DEFAULT SYSTIMESTAMP,
"delete_flag" NUMBER(3,0) DEFAULT '0' NOT NULL ENABLE,
"status" NUMBER(3,0) DEFAULT 0 NOT NULL ENABLE,
"new_weights" VARCHAR2(4000),
"description" VARCHAR2(512),
"previous_key" VARCHAR2(100),
"next_key" VARCHAR2(100),
"modify_previous_key" VARCHAR2(100),
"modify_next_key" VARCHAR2(100),
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 "APC" 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 "APC" ;

CREATE UNIQUE INDEX "APC20_DEV_OTHER"."SYS_C0013450" ON "APC20_DEV_OTHER"."apc_t_dispatching_key" ("id")
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 "APC" ;
CREATE INDEX "APC20_DEV_OTHER"."APC_T_DISPATCHING_KEY_TENANT_ID_IDX" ON "APC20_DEV_OTHER"."apc_t_dispatching_key" ("tenant_id", "app_id", "dispatching_key", "bpm_no", "approve_status", "status", "modify_time", "delete_flag")
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 "APC" ;
CREATE UNIQUE INDEX "APC20_DEV_OTHER"."IDX_UNIQUE_DISPATCHING_KEY" ON "APC20_DEV_OTHER"."apc_t_dispatching_key" ("tenant_id", "app_id", "dispatching_key", "delete_flag", "delete_time")
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 "APC" ;

```

## trace.log问题出现时当时的时序

1. `L1`：发起了一次查询，这次非事务查询，`L15~42`是oracle数据库返回的报文，解析出来的TCP报文，可以结合看`L74`以及`L89`，我们知道dispatching_key为module这一行的status为2
2. `L306`：Begin 新的事务
3. `L416`：3的事务内发起了一次查询，`L464`和`L479`可以看到module这一行的status为0，这就是我们本次疑惑的点？为什么后发起的查询查出来的数据是0，这个0是很久之前刷进去的值
- 我们为了定位问题，每次事务结束都会将conn关闭，可以看`L294~303`关闭连接报文
4. `L579~597`：这个事务commit并关闭了连接
5. `L598`:发起了一次查询，这次非事务查询,结合`L673`和`L688`，module这一行的status查出来又变为2了

## 我们当前已经排查的item
1. 缓存
- Oracle查询缓存设置的Mode为：Manual，SQL也未加cache hint
- gorm为打开任何缓存，因为sql确实发射到Oracle服务端了
2. 事务悬挂
- 发生问题时我们查询了v$transcation,没有任何ACTIVE的transcation
3. undo表空间，当时的undo表空间状态
```
ACTIVEBLKS|UNEXPIREDBLKS|EXPIREDBLKS|TUNED_UNDORETENTION|CON_ID|
----------+-------------+-----------+-------------------+------+
0| 0| 0| 1992882| 4|
```

## 我们想要的
1. 导致查询结果不一致的可能性有哪些？
2. 针对这些可能性我们该如何排查

我来答

添加附件

问题补充

6条回答

默认

最新

很

很好的Oracle使我疯狂加班

2024-11-14T07:24:25.5890: Query With Context:SELECT * FROM "apc_t_dispatching_key" WHERE "app_id" = :1 AND "tenant_id" = :2 AND "delete_flag" = :3 ORDER BY "create_time" desc
2024-11-14T07:24:25.5891: 0:
{ 1 2}
2024-11-14T07:24:25.5891: 1:
{ 2 tenant}
2024-11-14T07:24:25.5891: 2:
{ 3 0}
2024-11-14T07:24:25.5891:
Write packet:
00000000 00 00 00 21 06 00 00 00 00 00 03 4e 00 01 03 01 |...!.......N....|
00000010 19 01 20 01 01 07 01 32 06 74 65 6e 61 6e 74 01 |.. ....2.tenant.|
00000020 80 |.|
2024-11-14T07:24:25.5898:
Read packet:
00000000 00 00 01 bb 06 00 00 00 00 00 06 22 01 19 00 01 |..........."....|
00000010 19 00 00 00 07 03 c2 06 4f 06 74 65 6e 61 6e 74 |........O.tenant|
00000020 01 32 0a 72 6f 75 74 65 67 72 6f 75 70 0d 7b 22 |.2.routegroup.{"|
00000030 31 22 3a 35 2c 22 32 22 3a 33 7d 00 02 c1 02 0b |1":5,"2":3}.....|
00000040 78 7c 0b 0e 08 18 05 2a f5 83 48 06 66 64 73 61 |x|.....*..H.fdsa|
00000050 66 73 11 45 30 30 31 33 32 33 35 40 63 64 74 70 |fs.E0013235@cdtp|
00000060 2e 63 6f 6d 09 44 61 76 69 64 20 52 65 6e 11 45 |.com.David Ren.E|
00000070 30 30 31 33 32 33 35 40 63 64 74 70 2e 63 6f 6d |0013235@cdtp.com|
00000080 09 44 61 76 69 64 20 52 65 6e 07 78 7c 0b 0e 08 |.David Ren.x|...|
00000090 14 0d 07 78 7c 0b 0e 08 17 3a 07 78 7c 0b 0e 08 |...x|....:.x|...|
000000a0 17 3a 00 01 80 02 c1 03 00 00 00 00 00 00 07 03 |.:..............|
000000b0 c2 06 4e 06 74 65 6e 61 6e 74 01 32 06 6d 6f 64 |..N.tenant.2.mod|
000000c0 75 6c 65 0d 7b 22 31 22 3a 33 2c 22 32 22 3a 32 |ule.{"1":3,"2":2|
000000d0 7d 00 02 c1 02 0b 78 7c 0b 0e 08 18 05 2a f5 83 |}.....x|.....*..|
000000e0 48 06 66 64 73 61 66 73 11 45 30 30 31 33 32 33 |H.fdsafs.E001323|
000000f0 35 40 63 64 74 70 2e 63 6f 6d 09 44 61 76 69 64 |5@cdtp.com.David|
00000100 20 52 65 6e 11 45 30 30 31 33 32 33 35 40 63 64 | Ren.E0013235@cd|
00000110 74 70 2e 63 6f 6d 09 44 61 76 69 64 20 52 65 6e |tp.com.David Ren|
00000120 07 78 7c 0b 0e 08 13 3c 07 78 7c 0b 0e 08 17 3a |.x|....<.x|....:|
00000130 07 78 7c 0b 0e 08 17 3a 00 01 80 02 c1 03 00 06 |.x|....:........|
00000140 66 64 73 61 66 73 00 00 00 00 15 01 04 19 20 00 |fdsafs........ .|
00000150 00 07 03 c2 06 4d 04 74 79 70 65 0d 7b 22 31 22 |.....M.type.{"1"|
00000160 3a 31 2c 22 32 22 3a 31 7d 07 78 7c 0b 0e 08 13 |:1,"2":1}.x|....|
00000170 2f 04 01 05 02 5b 78 01 03 02 05 7b 00 00 01 03 |/....[x....{....|
00000180 00 03 00 00 00 00 00 03 01 29 49 01 1b 00 02 12 |.........)I.....|
00000190 06 00 00 00 00 00 01 01 00 00 00 00 02 05 7b 01 |..............{.|
000001a0 03 19 4f 52 41 2d 30 31 34 30 33 3a 20 6e 6f 20 |..ORA-01403: no |
000001b0 64 61 74 61 20 66 6f 75 6e 64 0a |data found.|
2024-11-14T07:24:25.5899: Summary: RetCode:1403, Error Message:"ORA-01403: no data found\n"
2024-11-14T07:24:25.5899: Row 0
2024-11-14T07:24:25.5899: id : 578
2024-11-14T07:24:25.5899: tenant_id : tenant
2024-11-14T07:24:25.5899: app_id : 2
2024-11-14T07:24:25.5899: dispatching_key : routegroup
2024-11-14T07:24:25.5899: weights : {"1":5,"2":3}
2024-11-14T07:24:25.5900: bpm_no : <nil>
2024-11-14T07:24:25.5900: approve_status : 1
2024-11-14T07:24:25.5900: approve_time : 2024-11-14 07:23:04.720733 +0800 +08:00
2024-11-14T07:24:25.5900: comment : fdsafs
2024-11-14T07:24:25.5900: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:25.5900: create_user_name : David Ren
2024-11-14T07:24:25.5900: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:25.5900: modify_user_name : David Ren
2024-11-14T07:24:25.5900: create_time : 2024-11-14 07:19:12 +0800 +08:00
2024-11-14T07:24:25.5901: update_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:25.5901: modify_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:25.5901: delete_time : <nil>
2024-11-14T07:24:25.5901: delete_flag : 0
2024-11-14T07:24:25.5901: status : 2
2024-11-14T07:24:25.5901: new_weights : <nil>
2024-11-14T07:24:25.5901: description : <nil>
2024-11-14T07:24:25.5901: previous_key : <nil>
2024-11-14T07:24:25.5901: next_key : <nil>
2024-11-14T07:24:25.5901: modify_previous_key : <nil>
2024-11-14T07:24:25.5901: modify_next_key : <nil>
2024-11-14T07:24:25.5902: Row 1
2024-11-14T07:24:25.5902: id : 577
2024-11-14T07:24:25.5902: tenant_id : tenant
2024-11-14T07:24:25.5902: app_id : 2
2024-11-14T07:24:25.5902: dispatching_key : module
2024-11-14T07:24:25.5902: weights : {"1":3,"2":2}
2024-11-14T07:24:25.5902: bpm_no : <nil>
2024-11-14T07:24:25.5902: approve_status : 1
2024-11-14T07:24:25.5902: approve_time : 2024-11-14 07:23:04.720733 +0800 +08:00
2024-11-14T07:24:25.5902: comment : fdsafs
2024-11-14T07:24:25.5902: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:25.5902: create_user_name : David Ren
2024-11-14T07:24:25.5902: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:25.5903: modify_user_name : David Ren
2024-11-14T07:24:25.5903: create_time : 2024-11-14 07:18:59 +0800 +08:00
2024-11-14T07:24:25.5903: update_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:25.5903: modify_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:25.5903: delete_time : <nil>
2024-11-14T07:24:25.5903: delete_flag : 0
2024-11-14T07:24:25.5903: status : 2
2024-11-14T07:24:25.5903: new_weights : <nil>
2024-11-14T07:24:25.5903: description : fdsafs
2024-11-14T07:24:25.5903: previous_key : <nil>
2024-11-14T07:24:25.5903: next_key : <nil>
2024-11-14T07:24:25.5904: modify_previous_key : <nil>
2024-11-14T07:24:25.5904: modify_next_key : <nil>
2024-11-14T07:24:25.5904: Row 2
2024-11-14T07:24:25.5904: id : 576
2024-11-14T07:24:25.5904: tenant_id : tenant
2024-11-14T07:24:25.5904: app_id : 2
2024-11-14T07:24:25.5904: dispatching_key : type
2024-11-14T07:24:25.5904: weights : {"1":1,"2":1}
2024-11-14T07:24:25.5904: bpm_no : <nil>
2024-11-14T07:24:25.5904: approve_status : 1
2024-11-14T07:24:25.5904: approve_time : 2024-11-14 07:23:04.720733 +0800 +08:00
2024-11-14T07:24:25.5904: comment : fdsafs
2024-11-14T07:24:25.5905: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:25.5905: create_user_name : David Ren
2024-11-14T07:24:25.5905: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:25.5905: modify_user_name : David Ren
2024-11-14T07:24:25.5905: create_time : 2024-11-14 07:18:46 +0800 +08:00
2024-11-14T07:24:25.5905: update_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:25.5905: modify_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:25.5905: delete_time : <nil>
2024-11-14T07:24:25.5905: delete_flag : 0
2024-11-14T07:24:25.5905: status : 2
2024-11-14T07:24:25.5905: new_weights : <nil>
2024-11-14T07:24:25.5905: description : fdsafs
2024-11-14T07:24:25.5905: previous_key : <nil>
2024-11-14T07:24:25.5906: next_key : <nil>
2024-11-14T07:24:25.5906: modify_previous_key : <nil>
2024-11-14T07:24:25.5906: modify_next_key : <nil>
2024-11-14T07:24:52.2077: Begin transaction with context
2024-11-14T07:24:52.2081: Prepare With Context
SELECT * FROM "apc_t_dispatching_key" WHERE "tenant_id" = :1 AND "app_id" = :2 AND "delete_flag" = :3 AND "status" in (:4,:5)
2024-11-14T07:24:52.2082: Query With Context:SELECT * FROM "apc_t_dispatching_key" WHERE "tenant_id" = :1 AND "app_id" = :2 AND "delete_flag" = :3 AND "status" in (:4,:5)
2024-11-14T07:24:52.2083: 0:
{ 1 tenant}
2024-11-14T07:24:52.2083: 1:
{ 2 2}
2024-11-14T07:24:52.2083: 2:
{ 3 0}
2024-11-14T07:24:52.2083: 3:
{ 4 1}
2024-11-14T07:24:52.2083: 4:
{ 5 3}
2024-11-14T07:24:52.2083:
Write packet:
00000000 00 00 01 2d 06 00 00 00 00 00 03 5e 00 02 80 29 |...-.......^...)|
00000010 00 01 01 7d 01 01 0d 00 00 00 01 19 04 7f ff ff |...}............|
00000020 ff 01 01 05 00 00 00 00 00 00 00 00 00 01 00 00 |................|
00000030 00 00 00 00 00 00 00 00 00 00 00 00 00 7d 53 45 |.............}SE|
00000040 4c 45 43 54 20 2a 20 46 52 4f 4d 20 22 61 70 63 |LECT * FROM "apc|
00000050 5f 74 5f 64 69 73 70 61 74 63 68 69 6e 67 5f 6b |_t_dispatching_k|
00000060 65 79 22 20 57 48 45 52 45 20 22 74 65 6e 61 6e |ey" WHERE "tenan|
00000070 74 5f 69 64 22 20 3d 20 3a 31 20 41 4e 44 20 22 |t_id" = :1 AND "|
00000080 61 70 70 5f 69 64 22 20 3d 20 3a 32 20 41 4e 44 |app_id" = :2 AND|
00000090 20 22 64 65 6c 65 74 65 5f 66 6c 61 67 22 20 3d | "delete_flag" =|
000000a0 20 3a 33 20 41 4e 44 20 22 73 74 61 74 75 73 22 | :3 AND "status"|
000000b0 20 69 6e 20 28 3a 34 2c 3a 35 29 01 01 01 19 00 | in (:4,:5).....|
000000c0 00 00 00 00 01 01 00 02 80 00 00 00 00 01 03 00 |................|
000000d0 00 01 06 00 01 10 00 00 02 03 69 01 01 06 00 01 |..........i.....|
000000e0 03 00 00 01 01 00 01 10 00 00 02 03 69 01 01 01 |............i...|
000000f0 00 02 03 00 00 01 16 00 00 00 00 00 00 00 00 02 |................|
00000100 03 00 00 01 16 00 00 00 00 00 00 00 00 02 03 00 |................|
00000110 00 01 16 00 00 00 00 00 00 00 00 07 06 74 65 6e |.............ten|
00000120 61 6e 74 01 32 01 80 02 c1 02 02 c1 04 |ant.2........|
2024-11-14T07:24:52.2090:
Read packet:
00000000 00 00 04 72 06 00 00 00 00 00 10 17 ae 14 9b df |...r............|
00000010 08 79 d8 b4 f7 3f 66 5d 3a 96 51 fd 78 7c 0b 0e |.y...?f]:.Q.x|..|
00000020 0a 25 37 02 34 53 01 19 5c 02 00 13 00 01 16 00 |.%7.4S..\.......|
00000030 00 00 00 00 00 00 00 00 02 01 02 02 69 64 00 00 |............id..|
00000040 00 01 10 01 80 00 00 02 01 00 00 02 10 00 00 00 |................|
00000050 02 03 69 01 01 40 02 3f fe 01 09 01 09 09 74 65 |..i..@.?......te|
00000060 6e 61 6e 74 5f 69 64 00 00 01 01 00 01 80 00 00 |nant_id.........|
00000070 02 01 00 00 02 10 00 00 00 02 03 69 01 01 40 02 |...........i..@.|
00000080 3f fe 01 06 01 06 06 61 70 70 5f 69 64 00 00 01 |?......app_id...|
00000090 02 00 01 80 00 00 02 01 00 00 02 10 00 00 00 02 |................|
000000a0 03 69 01 01 40 02 3f fe 01 0f 01 0f 0f 64 69 73 |.i..@.?......dis|
000000b0 70 61 74 63 68 69 6e 67 5f 6b 65 79 00 00 01 03 |patching_key....|
000000c0 00 01 80 00 00 02 0f a0 00 00 00 00 02 03 69 01 |..............i.|
000000d0 02 0f a0 02 3f fe 01 07 01 07 07 77 65 69 67 68 |....?......weigh|
000000e0 74 73 00 00 01 04 00 01 80 00 00 02 01 00 00 02 |ts..............|
000000f0 10 00 00 00 02 03 69 01 01 40 02 3f fe 01 06 01 |......i..@.?....|
00000100 06 06 62 70 6d 5f 6e 6f 00 00 01 05 00 02 00 03 |..bpm_no........|
00000110 00 01 16 00 00 00 00 00 00 00 00 01 0e 01 0e 0e |................|
00000120 61 70 70 72 6f 76 65 5f 73 74 61 74 75 73 00 00 |approve_status..|
00000130 01 06 00 b4 00 00 01 06 01 0b 00 00 00 00 00 00 |................|
00000140 00 00 01 0c 01 0c 0c 61 70 70 72 6f 76 65 5f 74 |.......approve_t|
00000150 69 6d 65 00 00 01 07 00 01 80 00 00 02 08 00 00 |ime.............|
00000160 02 10 00 00 00 02 03 69 01 02 02 00 02 3f fe 01 |.......i.....?..|
00000170 07 01 07 07 63 6f 6d 6d 65 6e 74 00 00 01 08 00 |....comment.....|
00000180 01 80 00 00 01 80 00 02 10 00 00 00 02 03 69 01 |..............i.|
00000190 01 20 02 3f fe 01 0e 01 0e 0e 63 72 65 61 74 65 |. .?......create|
000001a0 5f 75 73 65 72 5f 69 64 00 00 01 09 00 01 80 00 |_user_id........|
000001b0 00 02 02 00 00 02 10 00 00 00 02 03 69 01 01 80 |............i...|
000001c0 02 3f fe 01 10 01 10 10 63 72 65 61 74 65 5f 75 |.?......create_u|
000001d0 73 65 72 5f 6e 61 6d 65 00 00 01 0a 00 01 80 00 |ser_name........|
000001e0 00 01 80 00 02 10 00 00 00 02 03 69 01 01 20 02 |...........i.. .|
000001f0 3f fe 01 0e 01 0e 0e 6d 6f 64 69 66 79 5f 75 73 |?......modify_us|
00000200 65 72 5f 69 64 00 00 01 0b 00 01 80 00 00 02 02 |er_id...........|
00000210 00 00 02 10 00 00 00 02 03 69 01 01 80 02 3f fe |.........i....?.|
00000220 01 10 01 10 10 6d 6f 64 69 66 79 5f 75 73 65 72 |.....modify_user|
00000230 5f 6e 61 6d 65 00 00 01 0c 00 b4 00 00 00 01 07 |_name...........|
00000240 00 00 00 00 00 00 00 00 00 0b 01 0b 0b 63 72 65 |.............cre|
00000250 61 74 65 5f 74 69 6d 65 00 00 01 0d 00 b4 00 00 |ate_time........|
00000260 00 01 07 00 00 00 00 00 00 00 00 00 0b 01 0b 0b |................|
00000270 75 70 64 61 74 65 5f 74 69 6d 65 00 00 01 0e 00 |update_time.....|
00000280 b4 00 00 00 01 07 00 00 00 00 00 00 00 00 00 0b |................|
00000290 01 0b 0b 6d 6f 64 69 66 79 5f 74 69 6d 65 00 00 |...modify_time..|
000002a0 01 0f 00 b4 00 00 01 06 01 0b 00 00 00 00 00 00 |................|
000002b0 00 00 01 0b 01 0b 0b 64 65 6c 65 74 65 5f 74 69 |.......delete_ti|
000002c0 6d 65 00 00 01 10 00 02 00 03 00 01 16 00 00 00 |me..............|
000002d0 00 00 00 00 00 00 0b 01 0b 0b 64 65 6c 65 74 65 |..........delete|
000002e0 5f 66 6c 61 67 00 00 01 11 00 02 00 03 00 01 16 |_flag...........|
000002f0 00 00 00 00 00 00 00 00 00 06 01 06 06 73 74 61 |.............sta|
00000300 74 75 73 00 00 01 12 00 01 80 00 00 02 0f a0 00 |tus.............|
00000310 00 00 00 02 03 69 01 02 0f a0 02 3f fe 01 0b 01 |.....i.....?....|
00000320 0b 0b 6e 65 77 5f 77 65 69 67 68 74 73 00 00 01 |..new_weights...|
00000330 13 00 01 80 00 00 02 02 00 00 00 00 00 02 03 69 |...............i|
00000340 01 02 02 00 02 3f fe 01 0b 01 0b 0b 64 65 73 63 |.....?......desc|
00000350 72 69 70 74 69 6f 6e 00 00 01 14 00 01 80 00 00 |ription.........|
00000360 01 64 00 00 00 00 02 03 69 01 01 64 02 3f fe 01 |.d......i..d.?..|
00000370 0c 01 0c 0c 70 72 65 76 69 6f 75 73 5f 6b 65 79 |....previous_key|
00000380 00 00 01 15 00 01 80 00 00 01 64 00 00 00 00 02 |..........d.....|
00000390 03 69 01 01 64 02 3f fe 01 08 01 08 08 6e 65 78 |.i..d.?......nex|
000003a0 74 5f 6b 65 79 00 00 01 16 00 01 80 00 00 01 64 |t_key..........d|
000003b0 00 00 00 00 02 03 69 01 01 64 02 3f fe 01 13 01 |......i..d.?....|
000003c0 13 13 6d 6f 64 69 66 79 5f 70 72 65 76 69 6f 75 |..modify_previou|
000003d0 73 5f 6b 65 79 00 00 01 17 00 01 80 00 00 01 64 |s_key..........d|
000003e0 00 00 00 00 02 03 69 01 01 64 02 3f fe 01 0f 01 |......i..d.?....|
000003f0 0f 0f 6d 6f 64 69 66 79 5f 6e 65 78 74 5f 6b 65 |..modify_next_ke|
00000400 79 00 00 01 18 00 01 07 07 78 7c 0b 0e 10 19 35 |y........x|....5|
00000410 00 02 1f e8 01 0a 01 0a 00 08 01 06 04 b8 8d df |................|
00000420 de 00 01 17 00 00 00 00 00 00 04 01 01 02 5b 79 |..............[y|
00000430 00 02 05 7b 00 00 01 17 00 03 00 00 00 00 00 03 |...{............|
00000440 01 29 49 01 1b 00 02 12 06 00 00 00 00 00 01 01 |.)I.............|
00000450 00 00 00 00 02 05 7b 00 19 4f 52 41 2d 30 31 34 |......{..ORA-014|
00000460 30 33 3a 20 6e 6f 20 64 61 74 61 20 66 6f 75 6e |03: no data foun|
00000470 64 0a |d.|
2024-11-14T07:24:52.2091: Summary: RetCode:1403, Error Message:"ORA-01403: no data found\n"
2024-11-14T07:24:52.2095: Query With Context:SELECT * FROM "apc_t_dispatching_key" WHERE "tenant_id" = :1 AND "app_id" = :2 AND "dispatching_key" = :3 AND "delete_flag" = :4 ORDER BY "apc_t_dispatching_key"."id" FETCH NEXT :5 ROWS ONLY
2024-11-14T07:24:52.2095: 0:
{ 1 tenant}
2024-11-14T07:24:52.2095: 1:
{ 2 2}
2024-11-14T07:24:52.2096: 2:
{ 3 type}
2024-11-14T07:24:52.2096: 3:
{ 4 0}
2024-11-14T07:24:52.2096: 4:
{ 5 1}
2024-11-14T07:24:52.2096:
Write packet:
00000000 00 00 00 28 06 00 00 00 00 00 03 4e 00 01 09 01 |...(.......N....|
00000010 19 01 20 00 07 06 74 65 6e 61 6e 74 01 32 04 74 |.. ...tenant.2.t|
00000020 79 70 65 01 80 02 c1 02 |ype.....|
2024-11-14T07:24:52.2099:
Read packet:
00000000 00 00 00 f8 06 00 00 00 00 00 06 22 01 19 00 01 |..........."....|
00000010 19 00 00 00 07 03 c2 06 4d 06 74 65 6e 61 6e 74 |........M.tenant|
00000020 01 32 04 74 79 70 65 0d 7b 22 31 22 3a 31 2c 22 |.2.type.{"1":1,"|
00000030 32 22 3a 31 7d 00 02 c1 02 0b 78 7c 0b 0e 08 18 |2":1}.....x|....|
00000040 05 2a f5 83 48 06 66 64 73 61 66 73 11 45 30 30 |.*..H.fdsafs.E00|
00000050 31 33 32 33 35 40 63 64 74 70 2e 63 6f 6d 09 44 |13235@cdtp.com.D|
00000060 61 76 69 64 20 52 65 6e 11 45 30 30 31 33 32 33 |avid Ren.E001323|
00000070 35 40 63 64 74 70 2e 63 6f 6d 09 44 61 76 69 64 |5@cdtp.com.David|
00000080 20 52 65 6e 07 78 7c 0b 0e 08 13 2f 07 78 7c 0b | Ren.x|..../.x|.|
00000090 0e 08 17 3a 07 78 7c 0b 0e 08 17 3a 00 01 80 02 |...:.x|....:....|
000000a0 c1 03 00 06 66 64 73 61 66 73 00 00 00 00 04 01 |....fdsafs......|
000000b0 01 02 5b 7a 01 01 02 05 7b 00 00 01 09 00 03 00 |..[z....{.......|
000000c0 00 00 00 00 03 01 29 49 01 1b 00 02 12 06 00 00 |......)I........|
000000d0 00 00 00 01 01 00 00 00 00 02 05 7b 01 01 19 4f |...........{...O|
000000e0 52 41 2d 30 31 34 30 33 3a 20 6e 6f 20 64 61 74 |RA-01403: no dat|
000000f0 61 20 66 6f 75 6e 64 0a |a found.|
2024-11-14T07:24:52.2099: Summary: RetCode:1403, Error Message:"ORA-01403: no data found\n"
2024-11-14T07:24:52.2100: Row 0
2024-11-14T07:24:52.2100: id : 576
2024-11-14T07:24:52.2100: tenant_id : tenant
2024-11-14T07:24:52.2100: app_id : 2
2024-11-14T07:24:52.2100: dispatching_key : type
2024-11-14T07:24:52.2100: weights : {"1":1,"2":1}
2024-11-14T07:24:52.2100: bpm_no : <nil>
2024-11-14T07:24:52.2100: approve_status : 1
2024-11-14T07:24:52.2100: approve_time : 2024-11-14 07:23:04.720733 +0800 +08:00
2024-11-14T07:24:52.2100: comment : fdsafs
2024-11-14T07:24:52.2100: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:52.2100: create_user_name : David Ren
2024-11-14T07:24:52.2101: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:52.2101: modify_user_name : David Ren
2024-11-14T07:24:52.2101: create_time : 2024-11-14 07:18:46 +0800 +08:00
2024-11-14T07:24:52.2101: update_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:52.2101: modify_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:52.2101: delete_time : <nil>
2024-11-14T07:24:52.2101: delete_flag : 0
2024-11-14T07:24:52.2101: status : 2
2024-11-14T07:24:52.2101: new_weights : <nil>
2024-11-14T07:24:52.2101: description : fdsafs
2024-11-14T07:24:52.2101: previous_key : <nil>
2024-11-14T07:24:52.2101: next_key : <nil>
2024-11-14T07:24:52.2102: modify_previous_key : <nil>
2024-11-14T07:24:52.2102: modify_next_key : <nil>
2024-11-14T07:24:52.2106:
Write packet:
00000000 00 00 00 0d 06 00 00 00 00 00 03 0f 00 |.............|
2024-11-14T07:24:52.2108:
Read packet:
00000000 00 00 00 10 06 00 00 00 00 00 09 01 05 02 5b 7b |..............[{|
2024-11-14T07:24:52.2109:
Write packet:
00000000 00 00 00 15 06 00 00 00 00 00 11 69 00 01 01 01 |...........i....|
00000010 01 17 03 93 00 |.....|
2024-11-14T07:24:52.2110:
Read packet:
00000000 00 00 00 10 06 00 00 00 00 00 09 01 05 02 5b 7d |..............[}|
2024-11-14T07:24:58.5144: Begin transaction with context
2024-11-14T07:24:58.5147: Prepare With Context
SELECT * FROM "apc_t_dispatching_key" WHERE "tenant_id" = :1 AND "app_id" = :2 AND "delete_flag" = :3 AND "status" in (:4,:5)
2024-11-14T07:24:58.5148: Query With Context:SELECT * FROM "apc_t_dispatching_key" WHERE "tenant_id" = :1 AND "app_id" = :2 AND "delete_flag" = :3 AND "status" in (:4,:5)
2024-11-14T07:24:58.5149: 0:
{ 1 tenant}
2024-11-14T07:24:58.5149: 1:
{ 2 2}
2024-11-14T07:24:58.5149: 2:
{ 3 0}
2024-11-14T07:24:58.5149: 3:
{ 4 1}
2024-11-14T07:24:58.5149: 4:
{ 5 3}
2024-11-14T07:24:58.5149:
Write packet:
00000000 00 00 01 2d 06 00 00 00 00 00 03 5e 00 02 80 29 |...-.......^...)|
00000010 00 01 01 7d 01 01 0d 00 00 00 01 19 04 7f ff ff |...}............|
00000020 ff 01 01 05 00 00 00 00 00 00 00 00 00 01 00 00 |................|
00000030 00 00 00 00 00 00 00 00 00 00 00 00 00 7d 53 45 |.............}SE|
00000040 4c 45 43 54 20 2a 20 46 52 4f 4d 20 22 61 70 63 |LECT * FROM "apc|
00000050 5f 74 5f 64 69 73 70 61 74 63 68 69 6e 67 5f 6b |_t_dispatching_k|
00000060 65 79 22 20 57 48 45 52 45 20 22 74 65 6e 61 6e |ey" WHERE "tenan|
00000070 74 5f 69 64 22 20 3d 20 3a 31 20 41 4e 44 20 22 |t_id" = :1 AND "|
00000080 61 70 70 5f 69 64 22 20 3d 20 3a 32 20 41 4e 44 |app_id" = :2 AND|
00000090 20 22 64 65 6c 65 74 65 5f 66 6c 61 67 22 20 3d | "delete_flag" =|
000000a0 20 3a 33 20 41 4e 44 20 22 73 74 61 74 75 73 22 | :3 AND "status"|
000000b0 20 69 6e 20 28 3a 34 2c 3a 35 29 01 01 01 19 00 | in (:4,:5).....|
000000c0 00 00 00 00 01 01 00 02 80 00 00 00 00 01 03 00 |................|
000000d0 00 01 06 00 01 10 00 00 02 03 69 01 01 06 00 01 |..........i.....|
000000e0 03 00 00 01 01 00 01 10 00 00 02 03 69 01 01 01 |............i...|
000000f0 00 02 03 00 00 01 16 00 00 00 00 00 00 00 00 02 |................|
00000100 03 00 00 01 16 00 00 00 00 00 00 00 00 02 03 00 |................|
00000110 00 01 16 00 00 00 00 00 00 00 00 07 06 74 65 6e |.............ten|
00000120 61 6e 74 01 32 01 80 02 c1 02 02 c1 04 |ant.2........|
2024-11-14T07:24:58.5156:
Read packet:
00000000 00 00 04 72 06 00 00 00 00 00 10 17 ae 14 9b df |...r............|
00000010 08 79 d8 b4 f7 3f 66 5d 3a 96 51 fd 78 7c 0b 0e |.y...?f]:.Q.x|..|
00000020 0a 25 37 02 34 53 01 19 5c 02 00 13 00 01 16 00 |.%7.4S..\.......|
00000030 00 00 00 00 00 00 00 00 02 01 02 02 69 64 00 00 |............id..|
00000040 00 01 10 01 80 00 00 02 01 00 00 02 10 00 00 00 |................|
00000050 02 03 69 01 01 40 02 3f fe 01 09 01 09 09 74 65 |..i..@.?......te|
00000060 6e 61 6e 74 5f 69 64 00 00 01 01 00 01 80 00 00 |nant_id.........|
00000070 02 01 00 00 02 10 00 00 00 02 03 69 01 01 40 02 |...........i..@.|
00000080 3f fe 01 06 01 06 06 61 70 70 5f 69 64 00 00 01 |?......app_id...|
00000090 02 00 01 80 00 00 02 01 00 00 02 10 00 00 00 02 |................|
000000a0 03 69 01 01 40 02 3f fe 01 0f 01 0f 0f 64 69 73 |.i..@.?......dis|
000000b0 70 61 74 63 68 69 6e 67 5f 6b 65 79 00 00 01 03 |patching_key....|
000000c0 00 01 80 00 00 02 0f a0 00 00 00 00 02 03 69 01 |..............i.|
000000d0 02 0f a0 02 3f fe 01 07 01 07 07 77 65 69 67 68 |....?......weigh|
000000e0 74 73 00 00 01 04 00 01 80 00 00 02 01 00 00 02 |ts..............|
000000f0 10 00 00 00 02 03 69 01 01 40 02 3f fe 01 06 01 |......i..@.?....|
00000100 06 06 62 70 6d 5f 6e 6f 00 00 01 05 00 02 00 03 |..bpm_no........|
00000110 00 01 16 00 00 00 00 00 00 00 00 01 0e 01 0e 0e |................|
00000120 61 70 70 72 6f 76 65 5f 73 74 61 74 75 73 00 00 |approve_status..|
00000130 01 06 00 b4 00 00 01 06 01 0b 00 00 00 00 00 00 |................|
00000140 00 00 01 0c 01 0c 0c 61 70 70 72 6f 76 65 5f 74 |.......approve_t|
00000150 69 6d 65 00 00 01 07 00 01 80 00 00 02 08 00 00 |ime.............|
00000160 02 10 00 00 00 02 03 69 01 02 02 00 02 3f fe 01 |.......i.....?..|
00000170 07 01 07 07 63 6f 6d 6d 65 6e 74 00 00 01 08 00 |....comment.....|
00000180 01 80 00 00 01 80 00 02 10 00 00 00 02 03 69 01 |..............i.|
00000190 01 20 02 3f fe 01 0e 01 0e 0e 63 72 65 61 74 65 |. .?......create|
000001a0 5f 75 73 65 72 5f 69 64 00 00 01 09 00 01 80 00 |_user_id........|
000001b0 00 02 02 00 00 02 10 00 00 00 02 03 69 01 01 80 |............i...|
000001c0 02 3f fe 01 10 01 10 10 63 72 65 61 74 65 5f 75 |.?......create_u|
000001d0 73 65 72 5f 6e 61 6d 65 00 00 01 0a 00 01 80 00 |ser_name........|
000001e0 00 01 80 00 02 10 00 00 00 02 03 69 01 01 20 02 |...........i.. .|
000001f0 3f fe 01 0e 01 0e 0e 6d 6f 64 69 66 79 5f 75 73 |?......modify_us|
00000200 65 72 5f 69 64 00 00 01 0b 00 01 80 00 00 02 02 |er_id...........|
00000210 00 00 02 10 00 00 00 02 03 69 01 01 80 02 3f fe |.........i....?.|
00000220 01 10 01 10 10 6d 6f 64 69 66 79 5f 75 73 65 72 |.....modify_user|
00000230 5f 6e 61 6d 65 00 00 01 0c 00 b4 00 00 00 01 07 |_name...........|
00000240 00 00 00 00 00 00 00 00 00 0b 01 0b 0b 63 72 65 |.............cre|
00000250 61 74 65 5f 74 69 6d 65 00 00 01 0d 00 b4 00 00 |ate_time........|
00000260 00 01 07 00 00 00 00 00 00 00 00 00 0b 01 0b 0b |................|
00000270 75 70 64 61 74 65 5f 74 69 6d 65 00 00 01 0e 00 |update_time.....|
00000280 b4 00 00 00 01 07 00 00 00 00 00 00 00 00 00 0b |................|
00000290 01 0b 0b 6d 6f 64 69 66 79 5f 74 69 6d 65 00 00 |...modify_time..|
000002a0 01 0f 00 b4 00 00 01 06 01 0b 00 00 00 00 00 00 |................|
000002b0 00 00 01 0b 01 0b 0b 64 65 6c 65 74 65 5f 74 69 |.......delete_ti|
000002c0 6d 65 00 00 01 10 00 02 00 03 00 01 16 00 00 00 |me..............|
000002d0 00 00 00 00 00 00 0b 01 0b 0b 64 65 6c 65 74 65 |..........delete|
000002e0 5f 66 6c 61 67 00 00 01 11 00 02 00 03 00 01 16 |_flag...........|
000002f0 00 00 00 00 00 00 00 00 00 06 01 06 06 73 74 61 |.............sta|
00000300 74 75 73 00 00 01 12 00 01 80 00 00 02 0f a0 00 |tus.............|
00000310 00 00 00 02 03 69 01 02 0f a0 02 3f fe 01 0b 01 |.....i.....?....|
00000320 0b 0b 6e 65 77 5f 77 65 69 67 68 74 73 00 00 01 |..new_weights...|
00000330 13 00 01 80 00 00 02 02 00 00 00 00 00 02 03 69 |...............i|
00000340 01 02 02 00 02 3f fe 01 0b 01 0b 0b 64 65 73 63 |.....?......desc|
00000350 72 69 70 74 69 6f 6e 00 00 01 14 00 01 80 00 00 |ription.........|
00000360 01 64 00 00 00 00 02 03 69 01 01 64 02 3f fe 01 |.d......i..d.?..|
00000370 0c 01 0c 0c 70 72 65 76 69 6f 75 73 5f 6b 65 79 |....previous_key|
00000380 00 00 01 15 00 01 80 00 00 01 64 00 00 00 00 02 |..........d.....|
00000390 03 69 01 01 64 02 3f fe 01 08 01 08 08 6e 65 78 |.i..d.?......nex|
000003a0 74 5f 6b 65 79 00 00 01 16 00 01 80 00 00 01 64 |t_key..........d|
000003b0 00 00 00 00 02 03 69 01 01 64 02 3f fe 01 13 01 |......i..d.?....|
000003c0 13 13 6d 6f 64 69 66 79 5f 70 72 65 76 69 6f 75 |..modify_previou|
000003d0 73 5f 6b 65 79 00 00 01 17 00 01 80 00 00 01 64 |s_key..........d|
000003e0 00 00 00 00 02 03 69 01 01 64 02 3f fe 01 0f 01 |......i..d.?....|
000003f0 0f 0f 6d 6f 64 69 66 79 5f 6e 65 78 74 5f 6b 65 |..modify_next_ke|
00000400 79 00 00 01 18 00 01 07 07 78 7c 0b 0e 10 19 3b |y........x|....;|
00000410 00 02 1f e8 01 0a 01 0a 00 08 01 06 04 b8 8d e0 |................|
00000420 2a 00 01 18 00 00 00 00 00 00 04 01 01 02 5b 7e |*.............[~|
00000430 00 02 05 7b 00 00 01 18 00 03 00 00 00 00 00 03 |...{............|
00000440 01 29 49 01 1b 00 02 12 06 00 00 00 00 00 01 01 |.)I.............|
00000450 00 00 00 00 02 05 7b 00 19 4f 52 41 2d 30 31 34 |......{..ORA-014|
00000460 30 33 3a 20 6e 6f 20 64 61 74 61 20 66 6f 75 6e |03: no data foun|
00000470 64 0a |d.|
2024-11-14T07:24:58.5157: Summary: RetCode:1403, Error Message:"ORA-01403: no data found\n"
2024-11-14T07:24:58.5160: Query With Context:SELECT * FROM "apc_t_dispatching_key" WHERE "tenant_id" = :1 AND "app_id" = :2 AND "dispatching_key" = :3 AND "delete_flag" = :4 ORDER BY "apc_t_dispatching_key"."id" FETCH NEXT :5 ROWS ONLY
2024-11-14T07:24:58.5160: 0:
{ 1 tenant}
2024-11-14T07:24:58.5160: 1:
{ 2 2}
2024-11-14T07:24:58.5160: 2:
{ 3 module}
2024-11-14T07:24:58.5161: 3:
{ 4 0}
2024-11-14T07:24:58.5161: 4:
{ 5 1}
2024-11-14T07:24:58.5161:
Write packet:
00000000 00 00 00 b9 06 00 00 00 00 00 03 5e 00 02 80 28 |...........^...(|
00000010 01 09 00 00 01 01 0d 00 00 00 00 04 7f ff ff ff |................|
00000020 01 01 05 00 00 00 00 00 00 00 00 00 01 00 00 00 |................|
00000030 00 00 00 00 00 00 00 00 00 00 00 00 00 01 19 00 |................|
00000040 00 00 04 b8 8d cc c9 00 01 01 00 02 80 00 00 00 |................|
00000050 00 01 03 00 00 01 06 00 01 10 00 00 02 03 69 01 |..............i.|
00000060 01 06 00 01 03 00 00 01 01 00 01 10 00 00 02 03 |................|
00000070 69 01 01 01 00 01 03 00 00 01 06 00 01 10 00 00 |i...............|
00000080 02 03 69 01 01 06 00 02 03 00 00 01 16 00 00 00 |..i.............|
00000090 00 00 00 00 00 02 03 00 00 01 16 00 00 00 00 00 |................|
000000a0 00 00 00 07 06 74 65 6e 61 6e 74 01 32 06 6d 6f |.....tenant.2.mo|
000000b0 64 75 6c 65 01 80 02 c1 02 |dule.....|
2024-11-14T07:24:58.5165:
Read packet:
00000000 00 00 00 fe 06 00 00 00 00 00 06 22 01 19 00 01 |..........."....|
00000010 19 00 00 00 07 03 c2 06 4e 06 74 65 6e 61 6e 74 |........N.tenant|
00000020 01 32 06 6d 6f 64 75 6c 65 0d 7b 22 31 22 3a 33 |.2.module.{"1":3|
00000030 2c 22 32 22 3a 32 7d 00 00 00 00 11 45 30 30 31 |,"2":2}.....E001|
00000040 33 32 33 35 40 63 64 74 70 2e 63 6f 6d 09 44 61 |3235@cdtp.com.Da|
00000050 76 69 64 20 52 65 6e 11 45 30 30 31 33 32 33 35 |vid Ren.E0013235|
00000060 40 63 64 74 70 2e 63 6f 6d 09 44 61 76 69 64 20 |@cdtp.com.David |
00000070 52 65 6e 07 78 7c 0b 0e 08 13 3c 07 78 7c 0b 0e |Ren.x|....<.x|..|
00000080 08 13 3c 07 78 7c 0b 0e 08 13 3c 00 01 80 01 80 |..<.x|....<.....|
00000090 0d 7b 22 31 22 3a 31 2c 22 32 22 3a 31 7d 00 00 |.{"1":1,"2":1}..|
000000a0 00 00 00 08 01 06 04 b8 8d e0 2a 00 01 09 00 00 |..........*.....|
000000b0 00 00 00 00 04 01 01 02 5b 7f 01 01 02 05 7b 00 |........[.....{.|
000000c0 00 01 09 00 03 00 00 00 00 00 03 01 29 49 01 1b |............)I..|
000000d0 00 02 12 06 00 00 00 00 00 01 01 00 00 00 00 02 |................|
000000e0 05 7b 01 01 19 4f 52 41 2d 30 31 34 30 33 3a 20 |.{...ORA-01403: |
000000f0 6e 6f 20 64 61 74 61 20 66 6f 75 6e 64 0a |no data found.|
2024-11-14T07:24:58.5166: Summary: RetCode:1403, Error Message:"ORA-01403: no data found\n"
2024-11-14T07:24:58.5166: Row 0
2024-11-14T07:24:58.5166: id : 577
2024-11-14T07:24:58.5166: tenant_id : tenant
2024-11-14T07:24:58.5166: app_id : 2
2024-11-14T07:24:58.5166: dispatching_key : module
2024-11-14T07:24:58.5166: weights : {"1":3,"2":2}
2024-11-14T07:24:58.5166: bpm_no : <nil>
2024-11-14T07:24:58.5167: approve_status : <nil>
2024-11-14T07:24:58.5167: approve_time : <nil>
2024-11-14T07:24:58.5167: comment : <nil>
2024-11-14T07:24:58.5167: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.5167: create_user_name : David Ren
2024-11-14T07:24:58.5167: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.5167: modify_user_name : David Ren
2024-11-14T07:24:58.5167: create_time : 2024-11-14 07:18:59 +0800 +08:00
2024-11-14T07:24:58.5167: update_time : 2024-11-14 07:18:59 +0800 +08:00
2024-11-14T07:24:58.5167: modify_time : 2024-11-14 07:18:59 +0800 +08:00
2024-11-14T07:24:58.5167: delete_time : <nil>
2024-11-14T07:24:58.5167: delete_flag : 0
2024-11-14T07:24:58.5167: status : 0
2024-11-14T07:24:58.5168: new_weights : {"1":1,"2":1}
2024-11-14T07:24:58.5168: description : <nil>
2024-11-14T07:24:58.5168: previous_key : <nil>
2024-11-14T07:24:58.5168: next_key : <nil>
2024-11-14T07:24:58.5168: modify_previous_key : <nil>
2024-11-14T07:24:58.5168: modify_next_key : <nil>
2024-11-14T07:24:58.5171: Prepare With Context
UPDATE "apc_t_dispatching_key" SET "tenant_id"=:1,"app_id"=:2,"dispatching_key"=:3,"weights"=:4,"new_weights"=:5,"description"=:6,"create_user_id"=:7,"create_user_name"=:8,"create_time"=:9,"update_time"=:10,"modify_user_id"=:11,"modify_user_name"=:12,"modify_time"=:13 WHERE "id" = :14
2024-11-14T07:24:58.5172: Exec With Context:
2024-11-14T07:24:58.5172: Exec:
UPDATE "apc_t_dispatching_key" SET "tenant_id"=:1,"app_id"=:2,"dispatching_key"=:3,"weights"=:4,"new_weights"=:5,"description"=:6,"create_user_id"=:7,"create_user_name"=:8,"create_time"=:9,"update_time"=:10,"modify_user_id"=:11,"modify_user_name"=:12,"modify_time"=:13 WHERE "id" = :14
2024-11-14T07:24:58.5172: 0:
{ 1 tenant}
2024-11-14T07:24:58.5172: 1:
{ 2 2}
2024-11-14T07:24:58.5172: 2:
{ 3 module}
2024-11-14T07:24:58.5173: 3:
{ 4 map[1:3 2:2]}
2024-11-14T07:24:58.5173: 4:
{ 5 map[1:1 2:1]}
2024-11-14T07:24:58.5173: 5:
{ 6 fdsafs}
2024-11-14T07:24:58.5173: 6:
{ 7 E0013235@cdtp.com}
2024-11-14T07:24:58.5173: 7:
{ 8 David Ren}
2024-11-14T07:24:58.5174: 8:
{ 9 2024-11-14 07:18:59 +0800 +08:00}
2024-11-14T07:24:58.5174: 9:
{ 10 2024-11-14 07:18:59 +0800 +08:00}
2024-11-14T07:24:58.5174: 10:
{ 11 E0013235@cdtp.com}
2024-11-14T07:24:58.5174: 11:
{ 12 David Ren}
2024-11-14T07:24:58.5175: 12:
{ 13 2024-11-14 07:18:59 +0800 +08:00}
2024-11-14T07:24:58.5175: 13:
{ 14 577}
2024-11-14T07:24:58.5175:
Write packet:
00000000 00 00 02 f6 06 00 00 00 00 00 03 5e 00 02 80 29 |...........^...)|
00000010 00 01 02 01 1d 01 01 0d 00 00 00 00 04 7f ff ff |................|
00000020 ff 01 01 0e 00 00 00 00 00 00 00 00 00 01 00 00 |................|
00000030 00 00 00 00 00 00 00 00 00 00 00 00 00 fe 02 01 |................|
00000040 1d 55 50 44 41 54 45 20 22 61 70 63 5f 74 5f 64 |.UPDATE "apc_t_d|
00000050 69 73 70 61 74 63 68 69 6e 67 5f 6b 65 79 22 20 |ispatching_key" |
00000060 53 45 54 20 22 74 65 6e 61 6e 74 5f 69 64 22 3d |SET "tenant_id"=|
00000070 3a 31 2c 22 61 70 70 5f 69 64 22 3d 3a 32 2c 22 |:1,"app_id"=:2,"|
00000080 64 69 73 70 61 74 63 68 69 6e 67 5f 6b 65 79 22 |dispatching_key"|
00000090 3d 3a 33 2c 22 77 65 69 67 68 74 73 22 3d 3a 34 |=:3,"weights"=:4|
000000a0 2c 22 6e 65 77 5f 77 65 69 67 68 74 73 22 3d 3a |,"new_weights"=:|
000000b0 35 2c 22 64 65 73 63 72 69 70 74 69 6f 6e 22 3d |5,"description"=|
000000c0 3a 36 2c 22 63 72 65 61 74 65 5f 75 73 65 72 5f |:6,"create_user_|
000000d0 69 64 22 3d 3a 37 2c 22 63 72 65 61 74 65 5f 75 |id"=:7,"create_u|
000000e0 73 65 72 5f 6e 61 6d 65 22 3d 3a 38 2c 22 63 72 |ser_name"=:8,"cr|
000000f0 65 61 74 65 5f 74 69 6d 65 22 3d 3a 39 2c 22 75 |eate_time"=:9,"u|
00000100 70 64 61 74 65 5f 74 69 6d 65 22 3d 3a 31 30 2c |pdate_time"=:10,|
00000110 22 6d 6f 64 69 66 79 5f 75 73 65 72 5f 69 64 22 |"modify_user_id"|
00000120 3d 3a 31 31 2c 22 6d 6f 64 69 66 79 5f 75 73 65 |=:11,"modify_use|
00000130 72 5f 6e 61 6d 65 22 3d 3a 31 32 2c 22 6d 6f 64 |r_name"=:12,"mod|
00000140 69 66 79 5f 74 69 6d 65 22 3d 3a 31 33 20 57 48 |ify_time"=:13 WH|
00000150 45 52 45 20 22 69 64 22 20 3d 20 3a 31 34 00 01 |ERE "id" = :14..|
00000160 01 01 01 00 00 00 00 00 00 00 02 80 00 00 00 00 |................|
00000170 01 03 00 00 01 06 00 01 10 00 00 02 03 69 01 01 |.............i..|
00000180 06 00 01 03 00 00 01 01 00 01 10 00 00 02 03 69 |...............i|
00000190 01 01 01 00 01 03 00 00 01 06 00 01 10 00 00 02 |................|
000001a0 03 69 01 01 06 00 01 03 00 00 01 0d 00 01 10 00 |.i..............|
000001b0 00 02 03 69 01 01 0d 00 01 03 00 00 01 0d 00 01 |...i............|
000001c0 10 00 00 02 03 69 01 01 0d 00 01 03 00 00 01 06 |.....i..........|
000001d0 00 01 10 00 00 02 03 69 01 01 06 00 01 03 00 00 |.......i........|
000001e0 01 11 00 01 10 00 00 02 03 69 01 01 11 00 01 03 |.........i......|
000001f0 00 00 01 09 00 01 10 00 00 02 03 69 01 01 09 00 |...........i....|
00000200 b5 03 00 00 01 0d 00 00 00 00 00 00 00 00 b5 03 |................|
00000210 00 00 01 0d 00 00 00 00 00 00 00 00 01 03 00 00 |................|
00000220 01 11 00 01 10 00 00 02 03 69 01 01 11 00 01 03 |.........i......|
00000230 00 00 01 09 00 01 10 00 00 02 03 69 01 01 09 00 |...........i....|
00000240 b5 03 00 00 01 0d 00 00 00 00 00 00 00 00 02 03 |................|
00000250 00 00 01 16 00 00 00 00 00 00 00 00 07 06 74 65 |..............te|
00000260 6e 61 6e 74 01 32 06 6d 6f 64 75 6c 65 0d 7b 22 |nant.2.module.{"|
00000270 31 22 3a 33 2c 22 32 22 3a 32 7d 0d 7b 22 31 22 |1":3,"2":2}.{"1"|
00000280 3a 31 2c 22 32 22 3a 31 7d 06 66 64 73 61 66 73 |:1,"2":1}.fdsafs|
00000290 11 45 30 30 31 33 32 33 35 40 63 64 74 70 2e 63 |.E0013235@cdtp.c|
000002a0 6f 6d 09 44 61 76 69 64 20 52 65 6e 0d 78 7c 0b |om.David Ren.x|.|
000002b0 0d 18 13 3c 00 00 00 00 1c 3c 0d 78 7c 0b 0d 18 |...<.....<.x|...|
000002c0 13 3c 00 00 00 00 1c 3c 11 45 30 30 31 33 32 33 |.<.....<.E001323|
000002d0 35 40 63 64 74 70 2e 63 6f 6d 09 44 61 76 69 64 |5@cdtp.com.David|
000002e0 20 52 65 6e 0d 78 7c 0b 0d 18 13 3c 00 00 00 00 | Ren.x|....<....|
000002f0 1c 3c 03 c2 06 4e |.<...N|
2024-11-14T07:24:58.5181:
Read packet:
00000000 00 00 00 59 06 00 00 00 00 00 08 01 06 04 b8 8d |...Y............|
00000010 e0 2a 00 01 19 01 01 00 00 00 00 00 04 01 02 02 |.*..............|
00000020 5b 80 01 01 00 00 00 01 19 01 07 06 00 00 00 00 |[...............|
00000030 00 03 01 29 49 01 1b 00 02 12 06 01 01 00 00 00 |...)I...........|
00000040 00 01 01 01 0d 0d 01 00 01 29 49 00 1b 00 00 12 |.........)I.....|
00000050 06 00 01 00 00 00 00 01 01 |.........|
2024-11-14T07:24:58.5181: Summary: RetCode:0, Error Message:""
2024-11-14T07:24:58.5183:
Write packet:
00000000 00 00 00 0d 06 00 00 00 00 00 03 0e 00 |.............|
2024-11-14T07:24:58.5193:
Read packet:
00000000 00 00 00 10 06 00 00 00 00 00 09 01 05 02 5b 81 |..............[.|
2024-11-14T07:24:58.5193:
Write packet:
00000000 00 00 00 15 06 00 00 00 00 00 11 69 00 01 01 01 |...........i....|
00000010 01 18 03 93 00 |.....|
2024-11-14T07:24:58.5195:
Read packet:
00000000 00 00 00 10 06 00 00 00 00 00 09 01 05 02 5b 83 |..............[.|
2024-11-14T07:24:58.5196:
Write packet:
00000000 00 00 00 15 06 00 00 00 00 00 11 69 00 01 01 01 |...........i....|
00000010 01 19 03 93 00 |.....|
2024-11-14T07:24:58.5197:
Read packet:
00000000 00 00 00 10 06 00 00 00 00 00 09 01 05 02 5b 85 |..............[.|
2024-11-14T07:24:58.6370: Query With Context:SELECT * FROM "apc_t_dispatching_key" WHERE "app_id" = :1 AND "tenant_id" = :2 AND "delete_flag" = :3 ORDER BY "create_time" desc
2024-11-14T07:24:58.6370: 0:
{ 1 2}
2024-11-14T07:24:58.6370: 1:
{ 2 tenant}
2024-11-14T07:24:58.6371: 2:
{ 3 0}
2024-11-14T07:24:58.6371:
Write packet:
00000000 00 00 00 21 06 00 00 00 00 00 03 4e 00 01 03 01 |...!.......N....|
00000010 19 01 20 01 01 07 01 32 06 74 65 6e 61 6e 74 01 |.. ....2.tenant.|
00000020 80 |.|
2024-11-14T07:24:58.6378:
Read packet:
00000000 00 00 01 da 06 00 00 00 00 00 06 22 01 19 00 01 |..........."....|
00000010 19 00 00 00 07 03 c2 06 4f 06 74 65 6e 61 6e 74 |........O.tenant|
00000020 01 32 0a 72 6f 75 74 65 67 72 6f 75 70 0d 7b 22 |.2.routegroup.{"|
00000030 31 22 3a 35 2c 22 32 22 3a 33 7d 00 02 c1 02 0b |1":5,"2":3}.....|
00000040 78 7c 0b 0e 08 18 05 2a f5 83 48 06 66 64 73 61 |x|.....*..H.fdsa|
00000050 66 73 11 45 30 30 31 33 32 33 35 40 63 64 74 70 |fs.E0013235@cdtp|
00000060 2e 63 6f 6d 09 44 61 76 69 64 20 52 65 6e 11 45 |.com.David Ren.E|
00000070 30 30 31 33 32 33 35 40 63 64 74 70 2e 63 6f 6d |0013235@cdtp.com|
00000080 09 44 61 76 69 64 20 52 65 6e 07 78 7c 0b 0e 08 |.David Ren.x|...|
00000090 14 0d 07 78 7c 0b 0e 08 17 3a 07 78 7c 0b 0e 08 |...x|....:.x|...|
000000a0 17 3a 00 01 80 02 c1 03 00 00 00 00 00 00 07 03 |.:..............|
000000b0 c2 06 4e 06 74 65 6e 61 6e 74 01 32 06 6d 6f 64 |..N.tenant.2.mod|
000000c0 75 6c 65 0d 7b 22 31 22 3a 33 2c 22 32 22 3a 32 |ule.{"1":3,"2":2|
000000d0 7d 00 02 c1 02 0b 78 7c 0b 0e 08 18 05 2a f5 83 |}.....x|.....*..|
000000e0 48 06 66 64 73 61 66 73 11 45 30 30 31 33 32 33 |H.fdsafs.E001323|
000000f0 35 40 63 64 74 70 2e 63 6f 6d 09 44 61 76 69 64 |5@cdtp.com.David|
00000100 20 52 65 6e 11 45 30 30 31 33 32 33 35 40 63 64 | Ren.E0013235@cd|
00000110 74 70 2e 63 6f 6d 09 44 61 76 69 64 20 52 65 6e |tp.com.David Ren|
00000120 07 78 7c 0b 0e 08 13 3c 07 78 7c 0b 0e 08 13 3c |.x|....<.x|....<|
00000130 07 78 7c 0b 0e 08 13 3c 00 01 80 02 c1 03 0d 7b |.x|....<.......{|
00000140 22 31 22 3a 31 2c 22 32 22 3a 31 7d 06 66 64 73 |"1":1,"2":1}.fds|
00000150 61 66 73 00 00 00 00 15 01 07 19 e0 08 00 07 03 |afs.............|
00000160 c2 06 4d 04 74 79 70 65 0d 7b 22 31 22 3a 31 2c |..M.type.{"1":1,|
00000170 22 32 22 3a 31 7d 07 78 7c 0b 0e 08 13 2f 07 78 |"2":1}.x|..../.x|
00000180 7c 0b 0e 08 17 3a 07 78 7c 0b 0e 08 17 3a 00 04 ||....:.x|....:..|
00000190 01 05 02 5b 86 01 03 02 05 7b 00 00 01 03 00 03 |...[.....{......|
000001a0 00 00 00 00 00 03 01 29 49 01 1b 00 02 12 06 01 |.......)I.......|
000001b0 01 00 00 00 00 01 01 00 00 00 00 02 05 7b 01 03 |.............{..|
000001c0 19 4f 52 41 2d 30 31 34 30 33 3a 20 6e 6f 20 64 |.ORA-01403: no d|
000001d0 61 74 61 20 66 6f 75 6e 64 0a |ata found.|
2024-11-14T07:24:58.6379: Summary: RetCode:1403, Error Message:"ORA-01403: no data found\n"
2024-11-14T07:24:58.6379: Row 0
2024-11-14T07:24:58.6379: id : 578
2024-11-14T07:24:58.6379: tenant_id : tenant
2024-11-14T07:24:58.6379: app_id : 2
2024-11-14T07:24:58.6380: dispatching_key : routegroup
2024-11-14T07:24:58.6380: weights : {"1":5,"2":3}
2024-11-14T07:24:58.6380: bpm_no : <nil>
2024-11-14T07:24:58.6380: approve_status : 1
2024-11-14T07:24:58.6380: approve_time : 2024-11-14 07:23:04.720733 +0800 +08:00
2024-11-14T07:24:58.6380: comment : fdsafs
2024-11-14T07:24:58.6380: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.6380: create_user_name : David Ren
2024-11-14T07:24:58.6380: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.6380: modify_user_name : David Ren
2024-11-14T07:24:58.6380: create_time : 2024-11-14 07:19:12 +0800 +08:00
2024-11-14T07:24:58.6380: update_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:58.6380: modify_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:58.6381: delete_time : <nil>
2024-11-14T07:24:58.6381: delete_flag : 0
2024-11-14T07:24:58.6381: status : 2
2024-11-14T07:24:58.6381: new_weights : <nil>
2024-11-14T07:24:58.6381: description : <nil>
2024-11-14T07:24:58.6381: previous_key : <nil>
2024-11-14T07:24:58.6381: next_key : <nil>
2024-11-14T07:24:58.6381: modify_previous_key : <nil>
2024-11-14T07:24:58.6381: modify_next_key : <nil>
2024-11-14T07:24:58.6381: Row 1
2024-11-14T07:24:58.6381: id : 577
2024-11-14T07:24:58.6382: tenant_id : tenant
2024-11-14T07:24:58.6382: app_id : 2
2024-11-14T07:24:58.6382: dispatching_key : module
2024-11-14T07:24:58.6382: weights : {"1":3,"2":2}
2024-11-14T07:24:58.6382: bpm_no : <nil>
2024-11-14T07:24:58.6382: approve_status : 1
2024-11-14T07:24:58.6382: approve_time : 2024-11-14 07:23:04.720733 +0800 +08:00
2024-11-14T07:24:58.6382: comment : fdsafs
2024-11-14T07:24:58.6382: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.6382: create_user_name : David Ren
2024-11-14T07:24:58.6382: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.6382: modify_user_name : David Ren
2024-11-14T07:24:58.6382: create_time : 2024-11-14 07:18:59 +0800 +08:00
2024-11-14T07:24:58.6382: update_time : 2024-11-14 07:18:59 +0800 +08:00
2024-11-14T07:24:58.6383: modify_time : 2024-11-14 07:18:59 +0800 +08:00
2024-11-14T07:24:58.6383: delete_time : <nil>
2024-11-14T07:24:58.6383: delete_flag : 0
2024-11-14T07:24:58.6383: status : 2
2024-11-14T07:24:58.6383: new_weights : {"1":1,"2":1}
2024-11-14T07:24:58.6383: description : fdsafs
2024-11-14T07:24:58.6383: previous_key : <nil>
2024-11-14T07:24:58.6383: next_key : <nil>
2024-11-14T07:24:58.6383: modify_previous_key : <nil>
2024-11-14T07:24:58.6383: modify_next_key : <nil>
2024-11-14T07:24:58.6383: Row 2
2024-11-14T07:24:58.6383: id : 576
2024-11-14T07:24:58.6384: tenant_id : tenant
2024-11-14T07:24:58.6384: app_id : 2
2024-11-14T07:24:58.6384: dispatching_key : type
2024-11-14T07:24:58.6384: weights : {"1":1,"2":1}
2024-11-14T07:24:58.6384: bpm_no : <nil>
2024-11-14T07:24:58.6384: approve_status : 1
2024-11-14T07:24:58.6384: approve_time : 2024-11-14 07:23:04.720733 +0800 +08:00
2024-11-14T07:24:58.6384: comment : fdsafs
2024-11-14T07:24:58.6384: create_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.6384: create_user_name : David Ren
2024-11-14T07:24:58.6384: modify_user_id : E0013235@cdtp.com
2024-11-14T07:24:58.6384: modify_user_name : David Ren
2024-11-14T07:24:58.6384: create_time : 2024-11-14 07:18:46 +0800 +08:00
2024-11-14T07:24:58.6384: update_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:58.6385: modify_time : 2024-11-14 07:22:57 +0800 +08:00
2024-11-14T07:24:58.6385: delete_time : <nil>
2024-11-14T07:24:58.6385: delete_flag : 0
2024-11-14T07:24:58.6385: status : 2
2024-11-14T07:24:58.6385: new_weights : <nil>
2024-11-14T07:24:58.6385: description : fdsafs
2024-11-14T07:24:58.6385: previous_key : <nil>
2024-11-14T07:24:58.6385: next_key : <nil>
2024-11-14T07:24:58.6385: modify_previous_key : <nil>
2024-11-14T07:24:58.6385: modify_next_key : <nil>

有用 0

打赏 0

Thomas

请教下，是如何将TRACE文件转成这种可读的形式的呢？另外，你这里的日志，是记录的关于该DB这段时间的全部DML么？如果是多节点RAC的话，尽管当前节点出现了一头一尾STATUS=2, 但中间STATUS=0的情况，但有无可能其它节点在这期间，更新了STATUS呢？

有用 1

打赏 0

很好的Oracle使我疯狂加班

题主

2024-11-18

TRACE文件可读其实就是抓包, 以plain text格式解析，所以可以看到协议部分是乱码

是全部DML，因为只有一个人操作，这个环境是单节点, 不是多节点RAC。所以我就怀疑人生了

小草

事务未提交导致的数据不可见
可能原因：如果数据是在一个未提交的事务中插入或更新的，而查询是通过一个不同的会话或连接发起的，Oracle 会根据事务隔离级别的规则，导致查询到的数据与其他会话中的提交数据不一致。特别是未提交的事务产生的脏数据或更新，可能不会对其他会话可见。

排查步骤：

确保对数据进行插入/更新的事务在查询之前已经提交。
查看 v$transaction 中的事务状态，确保没有悬挂事务。
检查是否存在 Commit 或 Rollback 的延迟问题，或者事务操作异常中断的情形。
2. Oracle Undo 空间管理问题
可能原因：在 Oracle 中，撤销（Undo）表空间用于管理事务期间的数据修改。如果撤销表空间的管理不当（例如过期的撤销段未释放或撤销表空间不足），可能导致查询获取到的不是最新的数据，而是基于旧的撤销日志的数据（比如您查询时看到的 0 值可能是撤销操作留下的旧数据）。

排查步骤：

检查 vundostat 和 vtransaction 表中撤销空间的使用情况和活跃事务数。
确认 undo_retention 参数是否合理（可以通过 show parameter undo_retention 查看），并确保撤销空间的大小足够。
通过 DBA_FREE_SPACE 查看撤销表空间的可用空间，确保没有出现空间不足的情况。
如果 UNDO_RETENTION 设置不够高，撤销数据可能会被过早地回收，导致查询返回旧数据。

有用 0

打赏 0