fix: 问题修复 1.数据统计模块中查看合同出错

luoyb

2024-05-05 44cca7956f99c8960fbdf877f78695221f8bcb17

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
H:2,block:7,blockSize:1000,chunk:14dc,created:1770a3c7564,format:1,version:14dc,fletcher:46d3235c
H:2,block:7,blockSize:1000,chunk:14dc,created:1770a3c7564,format:1,version:14dc,fletcher:46d3235c
chunk:14d9,block:2,len:1,map:28,max:300,next:4,pages:1,root:5364000003092,time:198ddb5d6,version:14d9,pinCount:0                                                                                 
ÑÊ
chunk.14d7
chunk.14d8map.1map.28map.3map.4map.5map.6map.8map.9name.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3
chunk:14d7,block:3,len:1,liveMax:800,livePages:1,map:28,max:b00,next:4,pages:2,root:535c00001d492,time:198ddb5bf,unusedAtVersion:14d7,version:14d7,pinCount:0¥
chunk:14d8,block:5,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5360000003094,time:198ddb5d5,unused:198ddb5d6,unusedAtVersion:14d8,version:14d8,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 535c000003098Transactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 535c000003098k:14d3,block:6,len:1,liveMax:0,livePages:0,map:28,max:600,pages:1,root:534c000003096,time:198dc55f4,unused:198dc55f5,unusedAtVersion:14d3,version:14d3,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 533c000003098:14ca,pinCount:0
chunk:14cb,block:8,len:1,liveMax:800,livePages:1,map:27,max:e00,next:9,pages:2,root:532c00001d496,time:13c26f9e4,unusedAtVersion:14cb,version:14cb,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 532c000003098chunk:14d9,block:2,version:14d9,fletcher:83812c44                                                                              
chunk:14d7,block:3,len:1,map:28,max:b00,next:4,pages:2,root:535c00001d492,time:198ddb5bf,version:14d7,pinCount:0                                                                                 
…
1234567    
! &XSET CREATE_BUILD 200" " 2CREATE USER IF NOT EXISTS "" SALT '' HASH '' ADMIN#   ¥CREATE CACHED TABLE "PUBLIC"."TXC_UNDO_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_D39145A3_D1D7_4A99_A184_4A8C700750BC" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_D39145A3_D1D7_4A99_A184_4A8C700750BC",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "SQL_TYPE" INT NOT NULL,
    "ROLLBACK_INFO" BLOB NOT NULL,
    "CREATE_TIME" CHAR(23) NOT NULL
)$ # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_D39145A3_D1D7_4A99_A184_4A8C700750BC" START WITH 1 BELONGS_TO_TABLE% ! LCREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_B" ON "PUBLIC"."TXC_UNDO_LOG"("ID")& % {ALTER TABLE "PUBLIC"."TXC_UNDO_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_B" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_B"'   åCREATE CACHED TABLE "PUBLIC"."TXLCN_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_3D794728_8454_47A2_B907_FCE81F4FFDAA" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_3D794728_8454_47A2_B907_FCE81F4FFDAA",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "METHOD_STR" VARCHAR(512) NOT NULL,
    "BYTES" BLOB NOT NULL,
    "GROUP_ID_HASH" BIGINT NOT NULL,
    "UNIT_ID_HASH" BIGINT NOT NULL,
    "TIME" BIGINT NOT NULL
)( # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_3D794728_8454_47A2_B907_FCE81F4FFDAA" START WITH 1 BELONGS_TO_TABLE) ! ICREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8" ON "PUBLIC"."TXLCN_LOG"("ID")* % xALTER TABLE "PUBLIC"."TXLCN_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_8"çb
chunk.14d5
chunk.14d6map.1map.28map.3map.4map.5map.6map.8map.9name.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3¬
chunk:14d5,block:2,len:1,liveMax:0,livePages:0,map:28,max:c00,next:4,pages:2,root:535400001d494,time:198dd05bf,unused:198ddb5bf,unusedAtVersion:14d6,version:14d5,pinCount:0¬
chunk:14d6,block:5,len:1,liveMax:0,livePages:0,map:28,max:400,next:6,pages:1,root:5358000003094,time:198dd05c1,unused:198ddb5bf,unusedAtVersion:14d6,version:14d6,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 535c000003098chunk:14d7,block:3,version:14d7,fletcher:81712a43                                                                              
chunk:14d8,block:4,len:1,map:28,max:400,pages:1,root:5360000003094,time:198ddb5d5,version:14d8,pinCount:0                                                                                        
Š
chunk.14d5
chunk.14d6
chunk.14d7map.1map.28map.3map.4map.5map.6map.8map.9name.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3¬
chunk:14d5,block:2,len:1,liveMax:0,livePages:0,map:28,max:c00,next:4,pages:2,root:535400001d494,time:198dd05bf,unused:198ddb5bf,unusedAtVersion:14d6,version:14d5,pinCount:0¥
chunk:14d6,block:4,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5358000003094,time:198dd05c1,unused:198ddb5bf,unusedAtVersion:14d6,version:14d6,pinCount:0
chunk:14d7,block:3,len:1,liveMax:800,livePages:1,map:28,max:b00,next:4,pages:2,root:535c00001d492,time:198ddb5bf,unusedAtVersion:14d7,version:14d7,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 535c000003098k:14d3,block:6,len:1,liveMax:0,livePages:0,map:28,max:600,pages:1,root:534c000003096,time:198dc55f4,unused:198dc55f5,unusedAtVersion:14d3,version:14d3,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 533c000003098:14ca,pinCount:0
chunk:14cb,block:8,len:1,liveMax:800,livePages:1,map:27,max:e00,next:9,pages:2,root:532c00001d496,time:13c26f9e4,unusedAtVersion:14cb,version:14cb,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 532c000003098chunk:14d8,block:4,version:14d8,fletcher:82852b45                                                                              
chunk:14da,block:5,len:1,map:28,max:400,pages:1,root:5368000003094,time:198ddb5d7,version:14da,pinCount:0                                                                                        
Š’
chunk.14d7
chunk.14d8
chunk.14d9map.1map.28map.3map.4map.5map.6map.8map.9name.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3
chunk:14d7,block:3,len:1,liveMax:800,livePages:1,map:28,max:b00,next:4,pages:2,root:535c00001d492,time:198ddb5bf,unusedAtVersion:14d7,version:14d7,pinCount:0¥
chunk:14d8,block:4,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5360000003094,time:198ddb5d5,unused:198ddb5d6,unusedAtVersion:14d8,version:14d8,pinCount:0¬
chunk:14d9,block:2,len:1,liveMax:0,livePages:0,map:28,max:300,next:4,pages:1,root:5364000003092,time:198ddb5d6,unused:198ddb5d7,unusedAtVersion:14d9,version:14d9,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 535c000003098k:14d3,block:6,len:1,liveMax:0,livePages:0,map:28,max:600,pages:1,root:534c000003096,time:198dc55f4,unused:198dc55f5,unusedAtVersion:14d3,version:14d3,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 533c000003098:14ca,pinCount:0
chunk:14cb,block:8,len:1,liveMax:800,livePages:1,map:27,max:e00,next:9,pages:2,root:532c00001d496,time:13c26f9e4,unusedAtVersion:14cb,version:14cb,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 532c000003098chunk:14da,block:5,version:14da,fletcher:ad79546f                                                                              
chunk:14db,block:6,len:1,map:28,max:600,pages:1,root:536c000003096,time:198ddb5d8,version:14db,pinCount:0                                                                                        
<%
chunk.14d7
chunk.14d8
chunk.14d9
chunk.14damap.1map.28map.3map.4map.5map.6map.8map.9name.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3
chunk:14d7,block:3,len:1,liveMax:800,livePages:1,map:28,max:b00,next:4,pages:2,root:535c00001d492,time:198ddb5bf,unusedAtVersion:14d7,version:14d7,pinCount:0¥
chunk:14d8,block:4,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5360000003094,time:198ddb5d5,unused:198ddb5d6,unusedAtVersion:14d8,version:14d8,pinCount:0¬
chunk:14d9,block:2,len:1,liveMax:0,livePages:0,map:28,max:300,next:4,pages:1,root:5364000003092,time:198ddb5d6,unused:198ddb5d7,unusedAtVersion:14d9,version:14d9,pinCount:0¥
chunk:14da,block:5,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5368000003094,time:198ddb5d7,unused:198ddb5d8,unusedAtVersion:14da,version:14da,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 535c000003098tions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 533c000003098:14ca,pinCount:0
chunk:14cb,block:8,len:1,liveMax:800,livePages:1,map:27,max:e00,next:9,pages:2,root:532c00001d496,time:13c26f9e4,unusedAtVersion:14cb,version:14cb,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 532c000003098chunk:14db,block:6,version:14db,fletcher:ae8d5571                                                                              
chunk:14dc,block:7,len:1,map:28,max:600,next:8,pages:1,root:5370000003096,time:198ddb5d9,version:14dc,pinCount:0                                                                                 
îð
chunk.14d7
chunk.14d8
chunk.14d9
chunk.14da
chunk.14dbmap.1map.28map.3map.4map.5map.6map.8map.9name.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3
chunk:14d7,block:3,len:1,liveMax:800,livePages:1,map:28,max:b00,next:4,pages:2,root:535c00001d492,time:198ddb5bf,unusedAtVersion:14d7,version:14d7,pinCount:0¥
chunk:14d8,block:4,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5360000003094,time:198ddb5d5,unused:198ddb5d6,unusedAtVersion:14d8,version:14d8,pinCount:0¬
chunk:14d9,block:2,len:1,liveMax:0,livePages:0,map:28,max:300,next:4,pages:1,root:5364000003092,time:198ddb5d6,unused:198ddb5d7,unusedAtVersion:14d9,version:14d9,pinCount:0¥
chunk:14da,block:5,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5368000003094,time:198ddb5d7,unused:198ddb5d8,unusedAtVersion:14da,version:14da,pinCount:0¥
chunk:14db,block:6,len:1,liveMax:0,livePages:0,map:28,max:600,pages:1,root:536c000003096,time:198ddb5d8,unused:198ddb5d9,unusedAtVersion:14db,version:14db,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 535c000003098:14ca,pinCount:0
chunk:14cb,block:8,len:1,liveMax:800,livePages:1,map:27,max:e00,next:9,pages:2,root:532c00001d496,time:13c26f9e4,unusedAtVersion:14cb,version:14cb,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 532c000003098chunk:14dc,block:7,version:14dc,fletcher:afa15673                                                                              
chunk:14dd,block:8,len:1,map:28,max:e00,next:9,pages:2,root:537400001d496,time:198de6598,version:14dd,pinCount:0                                                                                 

1234567    
! &XSET CREATE_BUILD 200" " 2CREATE USER IF NOT EXISTS "" SALT '' HASH '' ADMIN#   ¥CREATE CACHED TABLE "PUBLIC"."TXC_UNDO_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_D39145A3_D1D7_4A99_A184_4A8C700750BC" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_D39145A3_D1D7_4A99_A184_4A8C700750BC",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "SQL_TYPE" INT NOT NULL,
    "ROLLBACK_INFO" BLOB NOT NULL,
    "CREATE_TIME" CHAR(23) NOT NULL
)$ # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_D39145A3_D1D7_4A99_A184_4A8C700750BC" START WITH 1 BELONGS_TO_TABLE% ! LCREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_B" ON "PUBLIC"."TXC_UNDO_LOG"("ID")& % {ALTER TABLE "PUBLIC"."TXC_UNDO_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_B" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_B"'   åCREATE CACHED TABLE "PUBLIC"."TXLCN_LOG"(
    "ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUENCE_3D794728_8454_47A2_B907_FCE81F4FFDAA" NOT NULL NULL_TO_DEFAULT SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_3D794728_8454_47A2_B907_FCE81F4FFDAA",
    "UNIT_ID" VARCHAR(32) NOT NULL,
    "GROUP_ID" VARCHAR(64) NOT NULL,
    "METHOD_STR" VARCHAR(512) NOT NULL,
    "BYTES" BLOB NOT NULL,
    "GROUP_ID_HASH" BIGINT NOT NULL,
    "UNIT_ID_HASH" BIGINT NOT NULL,
    "TIME" BIGINT NOT NULL
)( # mCREATE SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_3D794728_8454_47A2_B907_FCE81F4FFDAA" START WITH 1 BELONGS_TO_TABLE) ! ICREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8" ON "PUBLIC"."TXLCN_LOG"("ID")* % xALTER TABLE "PUBLIC"."TXLCN_LOG" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8" PRIMARY KEY("ID") INDEX "PUBLIC"."PRIMARY_KEY_8"¶9
chunk.14d7
chunk.14d8
chunk.14d9
chunk.14da
chunk.14db
chunk.14dcmap.1map.28map.3map.4map.5map.6map.8map.9name.lobDataname.lobMapname.lobRefname.openTransactionsname.table.0name.table.3name.table.7name.undoLog.1root.3¬
chunk:14d7,block:3,len:1,liveMax:0,livePages:0,map:28,max:b00,next:4,pages:2,root:535c00001d492,time:198ddb5bf,unused:198de6598,unusedAtVersion:14dc,version:14d7,pinCount:0¥
chunk:14d8,block:4,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5360000003094,time:198ddb5d5,unused:198ddb5d6,unusedAtVersion:14d8,version:14d8,pinCount:0¬
chunk:14d9,block:2,len:1,liveMax:0,livePages:0,map:28,max:300,next:4,pages:1,root:5364000003092,time:198ddb5d6,unused:198ddb5d7,unusedAtVersion:14d9,version:14d9,pinCount:0¥
chunk:14da,block:5,len:1,liveMax:0,livePages:0,map:28,max:400,pages:1,root:5368000003094,time:198ddb5d7,unused:198ddb5d8,unusedAtVersion:14da,version:14da,pinCount:0¥
chunk:14db,block:6,len:1,liveMax:0,livePages:0,map:28,max:600,pages:1,root:536c000003096,time:198ddb5d8,unused:198ddb5d9,unusedAtVersion:14db,version:14db,pinCount:0¬
chunk:14dc,block:7,len:1,liveMax:0,livePages:0,map:28,max:600,next:8,pages:1,root:5370000003096,time:198ddb5d9,unused:198de6598,unusedAtVersion:14dc,version:14dc,pinCount:0name:openTransactions!name:undoLog.1,createVersion:14cbname:table.0name:lobMapname:lobRefname:lobDataname:table.3,createVersion:4name:table.7,createVersion:5
6
4
5
1
3
8
928 5374000003098chunk:14dd,block:8,version:14dd,fletcher:b0b55775