虚机测试环境跑了个存储过程，向表中写入400000条记录，每1000条记录提交一次。开始执行几秒钟后实例异常，这种问题该怎么排查。
版本：
omm@postgres#select version() ;
±----------------------------------------------------------------------------------------------------------------------------------------------------------+
| version |
±----------------------------------------------------------------------------------------------------------------------------------------------------------+
| (openGauss 6.0.2 build 6285c0ef) compiled at 2025-07-15 15:13:08 commit 0 last mr 8059 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.0, 64-bit |
±----------------------------------------------------------------------------------------------------------------------------------------------------------+
(1 row)
存储过程
CREATE OR REPLACE PROCEDURE initdata(total_count int=500)
AS
DECLARE
i INT := 1;
batch_size INT := 1000;
–total_count INT := 500;
BEGIN
WHILE i <= total_count LOOP
insert into tab_test1(value1,value2,value3,value4,value5,value6,value7) values(test_seq.nextval,substring(md5(random()::text), 1,10),substring(md5(random()::text), 1,10),substring(md5(random()::text), 1,10),round(random()*10000,2),now(),current_time);
IF MOD(i, batch_size) = 0 THEN
COMMIT;
–RAISE NOTICE ‘’ ;
END IF;
i := i + 1;
END LOOP;
COMMIT;
RAISE NOTICE ‘数据insert完成，共写入 % 条记录’, total_count;
END;
/