如下是一个简单的测试的例子（这种测试也就玩玩，不能在生产环境进行模拟):
--dd 破坏表
dd if=/dev/zero of=/opt/gauss/gaussdata/user1 bs=8192 skip=28288 count=3 conv=notrunc
--insert
SQL> conn roger/Roger007@127.0.0.1:1611
connected.
SQL> drop table test;
Succeed.
SQL> create table test(a number);
Succeed.
SQL> declare
2 i number;
3 begin
4 for i in 1..100 loop
5 insert into test SELECT DBMS_RANDOM.VALUE(0,100000) FROM sys.SYS_DUMMY CONNECT BY LEVEL < 256;
6 commit;
7 end loop;
8 end;
9 /
GS-00304, tcp connection is closed
SQL>
SQL> exit
[1]+ Aborted (core dumped) zengine open -D /opt/gauss/gaussdata
[roger@mysqldb tmp]$
复制此时有相关堆栈的错误：
================= exception info ================= Exception Date = 2020-03-02 15:22:14.181 Exception Number = 11 Exception Code = 1 Exception Name = Segmentation fault Exception Process = 0x000000000001eb50 Exception Thread = 0x00007f53311e4700 Exception Process name = /opt/gauss/gauss100/bin/zengine Version = GaussDB_100_1.0.1.SPC2.B003 Release 3ae9d6c Platform = Oracle Linux Server release 7.3 Register Contents: reg: RAX 0x0000000000000007 reg: RBX 0x00007f5376f92430 reg: RCX 0x00007f53402fb000 reg: RDX 0x00007f5376f88a90 reg: RSI 0x0000000000000001 reg: RDI 0x0000000000000000 reg: RBP 0x00007f53311e5010 reg: RSP 0x00007f53311d9d50 reg: R8 0x0000000000000001 reg: R9 0x0000000000000008 reg: R10 0x00007f53402fb000 reg: R11 0x0000000000000004 reg: R12 0x00007f53520c5180 reg: R13 0x0000000000000001 reg: R14 0x0000000000000004 reg: R15 0x0000000000000000 reg: RIP 0x000055c7f56f4df8 reg: EFLAGS 0x0000000000010202 reg: CS 0x0000000000000033 reg: ERR 0x0000000000000006 reg: TRAPNO 0x000000000000000e reg: OM 0x0000000000000000 reg: CR2 0x0000000000000000 Stack information when exception zengine(buf_leave_page+0x2bb) [0x55c7f56f4df8] zengine(spc_alloc_extent_normal+0x30c) [0x55c7f584f039] zengine(heap_create_segment+0x73) [0x55c7f57ae0a3] zengine(heap_create_entry+0x3e5) [0x55c7f57ae62d] zengine(pcrh_insert+0x411) [0x55c7f57bd58e] zengine(knl_internal_insert+0xb2) [0x55c7f56cca45] zengine(+0x16081f) [0x55c7f550681f] zengine(sql_execute_insert_plan+0x1b4) [0x55c7f55070ed] zengine(sql_execute_insert_with_ctx+0x6d) [0x55c7f55074cb] zengine(sql_execute_insert+0x3e) [0x55c7f55075e0] zengine(sql_execute_single_dml+0x92) [0x55c7f54d674e] zengine(sql_try_execute_dml+0x360) [0x55c7f54d6b74] zengine(sql_execute+0x775) [0x55c7f54b173a] zengine(ple_exec_sql+0x25a) [0x55c7f564c752] zengine(ple_lines+0x8c4) [0x55c7f5652402] zengine(ple_exec_anonymous_block+0x19c) [0x55c7f5653046] zengine(sql_execute+0xacd) [0x55c7f54b1a92] zengine(sql_process_execute+0x394) [0x55c7f549b524] zengine(srv_process_command+0x480) [0x55c7f54408f3] zengine(srv_process_single_session+0xa4) [0x55c7f5484768] zengine(srv_agent_entry+0x19b) [0x55c7f5486811] /opt/gauss/gauss100/lib/libzecommon.so(+0xdd261) [0x7f537afca261] /lib64/libpthread.so.0(+0x7e25) [0x7f5379d9ae25] /lib64/libc.so.6(clone+0x6d) [0x7f5379ac834d] Dump stack(total 1536Bytes, 16Bytes/line: [DUMP] dump_addr 0x7f53311d9b50, dump_len 1536 0x7f53311d9b50: 53 58 50 46 44 3 0 0 7 0 0 0 0 0 0 0 SXPFD 0x7f53311d9b60: 40 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @ 0x7f53311d9b70: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9b80: 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9b90: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9ba0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9bb0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9bc0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9bd0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9be0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9bf0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c00: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c10: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c20: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c30: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c40: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c50: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c60: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c70: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c80: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9c90: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9ca0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9cb0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311d9cc0: 45 58 50 46 53 7f 0 0 60 9f 1d 31 53 7f 0 0 EXPFS 0x7f53311d9cd0: 90 31 b6 f5 c7 55 0 0 40 5e 12 0 0 0 0 0 0x7f53311d9ce0: 0 0 0 0 0 0 0 0 41 84 5d f5 c7 55 0 0 A 0x7f53311d9cf0: 1 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0x7f53311d9d00: 40 9d 1d 31 53 7f 0 0 60 9f 1d 31 53 7f 0 0 @ 0x7f53311d9d10: 0 0 0 0 0 0 0 0 40 5e 12 0 0 0 0 0 @^ 0x7f53311d9d20: 68 a8 7d 58 53 7f 0 0 0 1 5 e2 92 b6 78 b h 0x7f53311d9d30: 0 0 0 0 0 0 0 0 95 bb 1 7b 53 7f 0 0 0x7f53311d9d40: 0 0 0 0 0 0 0 0 0 1 5 e2 92 b6 78 b 0x7f53311d9d50: 0 0 0 0 0 0 0 0 0 1 5 e2 92 b6 78 b 0x7f53311d9d60: 0 0 0 0 0 0 0 0 30 24 f9 76 53 7f 0 0 0$ 0x7f53311d9d70: 0 0 0 0 0 0 0 0 10 50 1e 31 53 7f 0 0 0x7f53311d9d80: 1 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0x7f53311d9d90: 0 0 0 0 0 0 0 0 39 f0 84 f5 c7 55 0 0 9 0x7f53311d9da0: 0 0 0 0 0 0 0 0 0 1 5 e2 92 b6 78 b 0x7f53311d9db0: 0 0 0 0 0 0 0 0 78 29 c2 5a 53 7f 0 0 x) 0x7f53311d9dc0: 98 9e 1d 31 53 7f 0 0 0 0 0 0 c7 55 0 0 0x7f53311d9dd0: 8 0 0 0 1e 0 0 0 0 1 5 e2 0 0 0 0 0x7f53311d9de0: 10 50 1e 31 53 7f 0 0 90 8a f8 76 53 7f 0 0 0x7f53311d9df0: 58 24 c2 5a 53 7f 0 0 11 50 7f f5 c7 55 0 0 X$ 0x7f53311d9e00: 20 d4 7d 58 53 7f 0 0 f0 9e 1d 31 53 7f 0 0 0x7f53311d9e10: 40 5e 12 0 0 0 0 0 e0 9f 1d 31 53 7f 0 0 @^ 0x7f53311d9e20: 2f 1 0 0 0 0 0 0 0 1 5 e2 92 b6 78 b / 0x7f53311d9e30: 2 0 0 0 0 0 0 0 10 50 1e 31 53 7f 0 0 0x7f53311d9e40: 8 8b f8 76 53 7f 0 0 58 24 c2 5a 53 7f 0 0 0x7f53311d9e50: 30 24 f9 76 53 7f 0 0 0 0 0 0 0 0 0 0 0$ 0x7f53311d9e60: 60 28 c2 5a 53 7f 0 0 a3 e0 7a f5 c7 55 0 0 `( 0x7f53311d9e70: 88 14 18 f6 c7 55 0 0 d0 a0 1d 31 53 7f 0 0 0x7f53311d9e80: 68 a8 7d 58 53 7f 0 0 17 5d 4c f5 c7 55 0 0 h 0x7f53311d9e90: a0 c6 7d 58 53 7f 0 0 0 0 0 0 4 0 0 0 0x7f53311d9ea0: 88 b1 7d 58 53 7f 0 0 60 9f 1d 31 53 7f 0 0 0x7f53311d9eb0: 68 a8 7d 58 53 7f 0 0 0 1 5 e2 92 b6 78 b h 0x7f53311d9ec0: 64 28 c2 5a 53 7f 0 0 f8 72 1e 31 53 7f 0 0 d( 0x7f53311d9ed0: 1 0 0 0 0 0 0 0 10 50 1e 31 53 7f 0 0 0x7f53311d9ee0: 0 0 0 0 0 0 0 0 2d e6 7a f5 c7 55 0 0 - 0x7f53311d9ef0: 88 14 18 f6 c7 55 0 0 88 b1 7d 58 53 7f 0 0 0x7f53311d9f00: d0 a0 1d 31 53 7f 0 0 9b eb 85 f5 c7 55 0 0 0x7f53311d9f10: 20 31 35 3a 32 31 3a 35 60 9f 1d 31 53 7f 0 0 15:21:5` 0x7f53311d9f20: 40 9f 1d 31 53 7f 0 0 18 73 1e 31 53 7f 0 0 @ 0x7f53311d9f30: 58 24 c2 5a 53 7f 0 0 35 0 0 0 0 0 0 0 X$ 0x7f53311d9f40: 0 0 0 0 0 0 0 0 d0 b2 e1 34 53 7f 0 0 0x7f53311d9f50: 45 52 3a 5b 35 5d 20 22 0 1 5 e2 92 b6 78 b ER:[5] " 0x7f53311d9f60: 0 3 0 0 10 73 1 0 20 4 1f 31 53 7f 0 0 0x7f53311d9f70: 10 50 1e 31 53 7f 0 0 60 28 c2 5a 53 7f 0 0 0x7f53311d9f80: 68 1a 17 f6 c7 55 0 0 28 24 c2 5a 53 7f 0 0 h 0x7f53311d9f90: 20 4 1f 31 53 7f 0 0 8e d5 7b f5 c7 55 0 0 0x7f53311d9fa0: 18 f0 4c 41 53 7f 0 0 0 0 0 0 0 0 0 0 0x7f53311d9fb0: 88 14 18 f6 c7 55 1 0 20 4 1f 31 53 7f 0 0 0x7f53311d9fc0: 30 db dd 34 53 7f 0 0 88 b1 7d 58 53 7f 0 0 0 0x7f53311d9fd0: 0 0 0 0 0 0 0 0 0 1 5 e2 92 b6 78 b 0x7f53311d9fe0: 10 50 1e 31 53 7f 0 0 1 0 0 0 0 0 0 0 0x7f53311d9ff0: 0 0 0 0 0 0 0 0 28 24 c2 5a 53 7f 0 0 ($ 0x7f53311da000: 58 24 c2 5a 53 7f 0 0 45 ca 6c f5 c7 55 0 0 X$ 0x7f53311da010: 0 c7 df 34 53 7f 0 0 68 a8 7d 58 53 7f 0 0 0x7f53311da020: d0 b2 e1 34 53 7f 0 0 0 0 0 0 0 0 0 0 0x7f53311da030: 0 0 0 0 0 0 0 0 30 a2 1d 31 53 7f 0 0 0 0x7f53311da040: 38 a2 1d 31 53 7f 0 0 60 28 c2 5a 53 7f 0 0 8 0x7f53311da050: b0 a0 1d 31 53 7f 0 ff 90 a0 1d 31 53 7f 0 0 0x7f53311da060: dc 0 0 0 0 0 0 0 f 0 0 0 0 0 0 0 0x7f53311da070: 1f 0 0 0 0 0 0 0 0 0 0 0 53 7f 0 0 0x7f53311da080: d0 b2 e1 34 53 7f 0 0 a8 a0 1d 31 53 7f 0 0 0x7f53311da090: a4 a0 1d 31 53 7f 0 0 40 5e 12 0 0 0 0 0 0x7f53311da0a0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311da0b0: 1 0 0 fa 0 0 0 0 68 1a 17 f6 c7 55 0 0 0x7f53311da0c0: 68 1a 17 f6 c7 55 0 0 70 cb df 34 53 7f 0 0 h 0x7f53311da0d0: ff 3 0 0 ff ff 0 0 ff 3 0 0 ff ff 0 0 0x7f53311da0e0: 8e 73 94 0 0 0 0 0 c 0 46 2 e 0 0 0 0x7f53311da0f0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0x7f53311da100: 0 0 0 0 0 0 0 0 8 0 0 0 6 0 0 0 0x7f53311da110: 13 0 0 0 0 0 0 0 ff ff ff ff ff ff ff ff 0x7f53311da120: 6 0 0 0 5 0 0 0 2 0 0 0 12 0 0 0 0x7f53311da130: 0 0 0 0 ff ff ff ff ff ff ff ff 2 0 0 0 0x7f53311da140: 5 0 0 0 1 0 0 0 11 0 0 0 0 0 0 0 Proc maps information: 55c7f53a6000-55c7f593c000 r-xp 00000000 fb:00 40475280 /opt/gauss/gauss100/bin/zengine 55c7f5b3c000-55c7f5b40000 r--p 00596000 fb:00 40475280 /opt/gauss/gauss100/bin/zengine 55c7f5b40000-55c7f5b6f000 rw-p 0059a000 fb:00 40475280 /opt/gauss/gauss100/bin/zengine 55c7f5b6f000-55c7f5b92000 rw-p 00000000 00:00 0 55c7f600a000-55c7f6358000 rw-p 00000000 00:00 0 [heap] 7f5330faf000-7f5331164000 rw-p 00000000 00:00 0 7f5331164000-7f5331165000 ---p 00000000 00:00 0 7f5331165000-7f533139a000 rw-p 00000000 00:00 0 [stack:126294] 7f533149c000-7f533149d000 ---p 00000000 00:00 0 7f533149d000-7f533151d000 rw-p 00000000 00:00 0 7f533151d000-7f533151e000 ---p 00000000 00:00 0 7f533151e000-7f533155e000 rw-p 00000000 00:00 0 [stack:125825] 7f533155e000-7f533155f000 ---p 00000000 00:00 0 7f533155f000-7f53337a2000 rw-p 00000000 00:00 0 [stack:125824] 7f53337a2000-7f53337a3000 ---p 00000000 00:00 0 7f53337a3000-7f53337e3000 rw-p 00000000 00:00 0 [stack:125801] 7f53337e3000-7f53337e4000 ---p 00000000 00:00 0 7f53337e4000-7f53338a5000 rw-p 00000000 00:00 0 [stack:125800] 7f53338a5000-7f53338a6000 ---p 00000000 00:00 0 7f53338a6000-7f5339521000 rw-p 00000000 00:00 0 [stack:125799] 7f5339521000-7f5339522000 ---p 00000000 00:00 0 7f5339522000-7f5339562000 rw-p 00000000 00:00 0 [stack:125796] 7f5339562000-7f5339563000 ---p 00000000 00:00 0 7f5339563000-7f53395a3000 rw-p 00000000 00:00 0 7f53395a3000-7f53395a4000 ---p 00000000 00:00 0 7f53395a4000-7f53395e4000 rw-p 00000000 00:00 0 7f53395e4000-7f53395e5000 ---p 00000000 00:00 0 7f53395e5000-7f5339625000 rw-p 00000000 00:00 0 [stack:125793] 7f5339625000-7f5339626000 ---p 00000000 00:00 0 7f5339626000-7f5339666000 rw-p 00000000 00:00 0 [stack:125792] 7f5339666000-7f5339667000 ---p 00000000 00:00 0 7f5339667000-7f53396a7000 rw-p 00000000 00:00 0 [stack:125791] 7f53396a7000-7f53396a8000 ---p 00000000 00:00 0 7f53396a8000-7f53396e8000 rw-p 00000000 00:00 0 [stack:125790] 7f53396e8000-7f53396e9000 ---p 00000000 00:00 0 7f53396e9000-7f5339729000 rw-p 00000000 00:00 0 [stack:125789] 7f5339729000-7f533972a000 ---p 00000000 00:00 0 7f533972a000-7f533976a000 rw-p 00000000 00:00 0 [stack:125788] 7f533976a000-7f533976b000 ---p 00000000 00:00 0 7f533976b000-7f5370a5f000 rw-p 00000000 00:00 0 [stack:125787] 7f5370a5f000-7f5376f88000 r--p 00000000 fb:00 1427425 /usr/lib/locale/locale-archive 7f5376f88000-7f5378e56000 rw-p 00000000 00:00 0 7f5378e56000-7f5378e62000 r-xp 00000000 fb:00 33907802 /usr/lib64/libnss_files-2.17.so 7f5378e62000-7f5379061000 ---p 0000c000 fb:00 33907802 /usr/lib64/libnss_files-2.17.so 7f5379061000-7f5379062000 r--p 0000b000 fb:00 33907802 /usr/lib64/libnss_files-2.17.so 7f5379062000-7f5379063000 rw-p 0000c000 fb:00 33907802 /usr/lib64/libnss_files-2.17.so 7f5379063000-7f5379069000 rw-p 00000000 00:00 0 7f5379069000-7f537906d000 r-xp 00000000 fb:00 34003449 /usr/lib64/libuuid.so.1.3.0 7f537906d000-7f537926c000 ---p 00004000 fb:00 34003449 /usr/lib64/libuuid.so.1.3.0 7f537926c000-7f537926d000 r--p 00003000 fb:00 34003449 /usr/lib64/libuuid.so.1.3.0 7f537926d000-7f537926e000 rw-p 00004000 fb:00 34003449 /usr/lib64/libuuid.so.1.3.0 7f537926e000-7f53792b2000 r-xp 00000000 fb:00 3505363 /opt/gauss/gauss100/add-ons/libpcre.so.1.2.10 7f53792b2000-7f53794b1000 ---p 00044000 fb:00 3505363 /opt/gauss/gauss100/add-ons/libpcre.so.1.2.10 7f53794b1000-7f53794b2000 r--p 00043000 fb:00 3505363 /opt/gauss/gauss100/add-ons/libpcre.so.1.2.10 7f53794b2000-7f53794b3000 rw-p 00044000 fb:00 3505363 /opt/gauss/gauss100/add-ons/libpcre.so.1.2.10 7f53794b3000-7f53794c8000 r-xp 00000000 fb:00 40475278 /usr/lib64/libgcc_s-4.8.5-20150702.so.1 7f53794c8000-7f53796c7000 ---p 00015000 fb:00 40475278 /usr/lib64/libgcc_s-4.8.5-20150702.so.1 7f53796c7000-7f53796c8000 r--p 00014000 fb:00 40475278 /usr/lib64/libgcc_s-4.8.5-20150702.so.1 7f53796c8000-7f53796c9000 rw-p 00015000 fb:00 40475278 /usr/lib64/libgcc_s-4.8.5-20150702.so.1 7f53796c9000-7f53797b2000 r-xp 00000000 fb:00 33908156 /usr/lib64/libstdc++.so.6.0.19 7f53797b2000-7f53799b1000 ---p 000e9000 fb:00 33908156 /usr/lib64/libstdc++.so.6.0.19 7f53799b1000-7f53799b9000 r--p 000e8000 fb:00 33908156 /usr/lib64/libstdc++.so.6.0.19 7f53799b9000-7f53799bb000 rw-p 000f0000 fb:00 33908156 /usr/lib64/libstdc++.so.6.0.19 7f53799bb000-7f53799d0000 rw-p 00000000 00:00 0 7f53799d0000-7f5379b88000 r-xp 00000000 fb:00 33601528 /usr/lib64/libc-2.17.so 7f5379b88000-7f5379d88000 ---p 001b8000 fb:00 33601528 /usr/lib64/libc-2.17.so 7f5379d88000-7f5379d8c000 r--p 001b8000 fb:00 33601528 /usr/lib64/libc-2.17.so 7f5379d8c000-7f5379d8e000 rw-p 001bc000 fb:00 33601528 /usr/lib64/libc-2.17.so 7f5379d8e000-7f5379d93000 rw-p 00000000 00:00 0 7f5379d93000-7f5379daa000 r-xp 00000000 fb:00 33907820 /usr/lib64/libpthread-2.17.so 7f5379daa000-7f5379fa9000 ---p 00017000 fb:00 33907820 /usr/lib64/libpthread-2.17.so 7f5379fa9000-7f5379faa000 r--p 00016000 fb:00 33907820 /usr/lib64/libpthread-2.17.so 7f5379faa000-7f5379fab000 rw-p 00017000 fb:00 33907820 /usr/lib64/libpthread-2.17.so 7f5379fab000-7f5379faf000 rw-p 00000000 00:00 0 7f5379faf000-7f5379fc3000 r-xp 00000000 fb:00 3505369 /opt/gauss/gauss100/add-ons/liblz4.so.1.8.3 7f5379fc3000-7f537a1c3000 ---p 00014000 fb:00 3505369 /opt/gauss/gauss100/add-ons/liblz4.so.1.8.3 7f537a1c3000-7f537a1c4000 r--p 00014000 fb:00 3505369 /opt/gauss/gauss100/add-ons/liblz4.so.1.8.3 7f537a1c4000-7f537a1c5000 rw-p 00000000 00:00 0 7f537a1c5000-7f537a295000 r-xp 00000000 fb:00 3505376 /opt/gauss/gauss100/add-ons/libzstd.so.1.3.8 7f537a295000-7f537a494000 ---p 000d0000 fb:00 3505376 /opt/gauss/gauss100/add-ons/libzstd.so.1.3.8 7f537a494000-7f537a495000 r--p 000cf000 fb:00 3505376 /opt/gauss/gauss100/add-ons/libzstd.so.1.3.8 7f537a495000-7f537a496000 rw-p 000d0000 fb:00 3505376 /opt/gauss/gauss100/add-ons/libzstd.so.1.3.8 7f537a496000-7f537a4ad000 r-xp 00000000 fb:00 3505367 /opt/gauss/gauss100/add-ons/libz.so.1.2.11 7f537a4ad000-7f537a6ac000 ---p 00017000 fb:00 3505367 /opt/gauss/gauss100/add-ons/libz.so.1.2.11 7f537a6ac000-7f537a6ad000 r--p 00016000 fb:00 3505367 /opt/gauss/gauss100/add-ons/libz.so.1.2.11 7f537a6ad000-7f537a6ae000 rw-p 00017000 fb:00 3505367 /opt/gauss/gauss100/add-ons/libz.so.1.2.11 7f537a6ae000-7f537a6b5000 r-xp 00000000 fb:00 33907828 /usr/lib64/librt-2.17.so 7f537a6b5000-7f537a8b4000 ---p 00007000 fb:00 33907828 /usr/lib64/librt-2.17.so 7f537a8b4000-7f537a8b5000 r--p 00006000 fb:00 33907828 /usr/lib64/librt-2.17.so 7f537a8b5000-7f537a8b6000 rw-p 00007000 fb:00 33907828 /usr/lib64/librt-2.17.so 7f537a8b6000-7f537ac98000 r-xp 00000000 fb:00 110439565 /opt/gauss/gauss100/lib/libzeclient.so 7f537ac98000-7f537ae98000 ---p 003e2000 fb:00 110439565 /opt/gauss/gauss100/lib/libzeclient.so 7f537ae98000-7f537aed7000 r--p 003e2000 fb:00 110439565 /opt/gauss/gauss100/lib/libzeclient.so 7f537aed7000-7f537aee7000 rw-p 00421000 fb:00 110439565 /opt/gauss/gauss100/lib/libzeclient.so 7f537aee7000-7f537aeed000 rw-p 00000000 00:00 0 7f537aeed000-7f537b346000 r-xp 00000000 fb:00 110439562 /opt/gauss/gauss100/lib/libzecommon.so 7f537b346000-7f537b545000 ---p 00459000 fb:00 110439562 /opt/gauss/gauss100/lib/libzecommon.so 7f537b545000-7f537b58d000 r--p 00458000 fb:00 110439562 /opt/gauss/gauss100/lib/libzecommon.so 7f537b58d000-7f537b59e000 rw-p 004a0000 fb:00 110439562 /opt/gauss/gauss100/lib/libzecommon.so 7f537b59e000-7f537b5a4000 rw-p 00000000 00:00 0 7f537b5a4000-7f537b5b5000 r-xp 00000000 fb:00 110439564 /opt/gauss/gauss100/lib/libzeprotocol.so 7f537b5b5000-7f537b7b5000 ---p 00011000 fb:00 110439564 /opt/gauss/gauss100/lib/libzeprotocol.so 7f537b7b5000-7f537b7b6000 r--p 00011000 fb:00 110439564 /opt/gauss/gauss100/lib/libzeprotocol.so 7f537b7b6000-7f537b7b7000 rw-p 00012000 fb:00 110439564 /opt/gauss/gauss100/lib/libzeprotocol.so 7f537b7b7000-7f537b7b9000 r-xp 00000000 fb:00 33601667 /usr/lib64/libdl-2.17.so 7f537b7b9000-7f537b9b9000 ---p 00002000 fb:00 33601667 /usr/lib64/libdl-2.17.so 7f537b9b9000-7f537b9ba000 r--p 00002000 fb:00 33601667 /usr/lib64/libdl-2.17.so 7f537b9ba000-7f537b9bb000 rw-p 00003000 fb:00 33601667 /usr/lib64/libdl-2.17.so 7f537b9bb000-7f537babc000 r-xp 00000000 fb:00 33601679 /usr/lib64/libm-2.17.so 7f537babc000-7f537bcbb000 ---p 00101000 fb:00 33601679 /usr/lib64/libm-2.17.so 7f537bcbb000-7f537bcbc000 r--p 00100000 fb:00 33601679 /usr/lib64/libm-2.17.so 7f537bcbc000-7f537bcbd000 rw-p 00101000 fb:00 33601679 /usr/lib64/libm-2.17.so 7f537bcbd000-7f537bcde000 r-xp 00000000 fb:00 33582142 /usr/lib64/ld-2.17.so 7f537bce3000-7f537be76000 rw-p 00000000 00:00 0 7f537be76000-7f537be77000 ---p 00000000 00:00 0 7f537be77000-7f537becb000 rw-p 00000000 00:00 0 [stack:125777] 7f537bed5000-7f537bedc000 r--s 00000000 fb:00 33908121 /usr/lib64/gconv/gconv-modules.cache 7f537bedc000-7f537bede000 rw-p 00000000 00:00 0 7f537bede000-7f537bedf000 r--p 00021000 fb:00 33582142 /usr/lib64/ld-2.17.so 7f537bedf000-7f537bee0000 rw-p 00022000 fb:00 33582142 /usr/lib64/ld-2.17.so 7f537bee0000-7f537bee1000 rw-p 00000000 00:00 0 7ffc6a2ba000-7ffc6a2db000 rw-p 00000000 00:00 0 [stack] 7ffc6a393000-7ffc6a395000 r--p 00000000 00:00 0 [vvar] 7ffc6a395000-7ffc6a397000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] start to process exception num 11, sql hook ================= session info ================= session id 53 session serial# 4 session type 2 session user ROGER session schema ROGER session osuser roger session machine 127.0.0.1 session program [126292]/opt/gauss/gauss100/bin/zsql session module 3 session client version 11 session call version 11 session status ACTIVE session client ip 127.0.0.1 session client port 47392 session server ip 127.0.0.1 session server port 1611 ================= sql info ================= current sql insert into test select DBMS_RANDOM.VALUE(0,100000) from sys.SYS_DUMMY CONNECT BY LEVEL<256复制
此时写数据看上去是ok的，其实没有任何数据返回；
[roger@mysqldb tmp]$ zsql / as sysdba -q
connected.
SQL> conn roger/Roger007@127.0.0.1:1611
connected.
SQL> select * from test;
A B
---------------------------------------- --------------------
0 rows fetched.
SQL> insert into roger.test values(1,'www.enmotech.com');
1 rows affected.
SQL> commit;
Succeed.
SQL> select * from test;
A B
---------------------------------------- --------------------
0 rows fetched.
复制经猜测可能是page损坏的问题；于是重建一个新表空间进行操作，则没有这个问题。
[roger@mysqldb tmp]$ zsql / as sysdba -q
connected.
SQL> create tablespace test datafile '/opt/gauss/gaussdata/test01' size 100m;
Succeed.
SQL> alter user roger default tablespace test;
Succeed.
SQL> conn roger/Roger007@127.0.0.1:1611
connected.
SQL> select * from test;
A
----------------------------------------
0 rows fetched.
SQL> drop table test;
Succeed.
SQL> create table test(a number);
Succeed.
SQL> declare
2 i number;
3 begin
4 for i in 1..100 loop
5 insert into test SELECT DBMS_RANDOM.VALUE(0,100000) FROM sys.SYS_DUMMY CONNECT BY LEVEL < 256;
6 commit;
7 end loop;
8 end;
9 /
PL/SQL procedure successfully completed.
SQL> select count(1) from test;
COUNT(1)
--------------------
25500
1 rows fetched.
复制不知道这个算不算bug。 我猜测page出现损坏后，及时重建对象，gauss这里也不会去重新对损坏的page进行format格式化。这一点跟Oracle还是有所区别的。
最后修改时间：2020-03-02 16:23:58
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
相关阅读
2025年4月中国数据库流行度排行榜：OB高分复登顶，崖山稳驭撼十强
墨天轮编辑部
1823次阅读
2025-04-09 15:33:27
2025年3月国产数据库中标情况一览：TDSQL大单622万、GaussDB大单581万……
通讯员
594次阅读
2025-04-10 15:35:48
北京市公安局数据库大单：华为云GaussDB 1427万、金仓数据库 510万！
通讯员
274次阅读
2025-04-11 12:33:24
新疆维吾尔自治区行政事业单位数据库2025年框架协议采购（二次）入围结果公布
通讯员
136次阅读
2025-04-14 12:21:01
2687万！上海浦东发展银行采购GaussDB软件许可和服务
通讯员
119次阅读
2025-04-23 11:36:39
GaussDB 嵌入式SQL：OPEN命令深度解析与实战指南
Gauss松鼠会
47次阅读
2025-03-28 16:35:13
GaussDB嵌入式SQL命令EXECUTE IMMEDIATE
Gauss松鼠会
42次阅读
2025-03-28 16:35:39
GaussDB执行SQL语句
Gauss松鼠会
39次阅读
2025-03-27 15:30:48
GaussDB 数据库连接技术全解析：从基础连接到高性能集群
Gauss松鼠会
37次阅读
2025-03-27 15:30:04
GaussDB 嵌入式SQL：DEALLOCATE DESCRIPTOR深度解析与实战指南
Gauss松鼠会
36次阅读
2025-03-28 16:34:12
TA的专栏
Roger's Database Notes
收录77篇内容
