: 世界上功能最强大的开源数据库...

x86	pg异常重启 ... ... 2020-05-08 18:03:15+08...1楼
	配置文件设置：postgres.conf:shared_preload_libraries = 'pg_stat_statements' 程序通过java的war包方式调用pg的一个存储过程（过程中有异常，致使代代码进入异常捕获代码） EXCEPTION WHEN OTHERS THEN P_RET_CODE :=SQLSTATE; P_RET_STR :=SUBSTR(SQLERRM, 1, 400); ROLLBACK; 数据库主进程直接重启了，具休日志如下：数据库日志： The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 系统日志：kernel: postgres[5901]: segfault at 4f83460 ip 00007fc990bd1641 sp 00007ffd5c4b5548 error 4 in libc-2.17.so[7fc990a62000+1c3000] 经过测试发现：pg_stat_statements和ROLLBACK同时出再的时候会出现些问题，(postgres.conf:shared_preload_libraries = '')取消加载项后恢复正常，前台返回异常错误。
	我的签名：