__PostgreSQL中文社区: 世界上功能最强大的开源数据库....

PG中文社区 /

mdi-home

首页

社区新闻

中文文档

加入ACE

mdi-home

首页

mdi-chat-processing

社区新闻

mdi-book-open-variant

中文文档

mdi-account-multiple-check

加入ACE

mdi-file-multiple-outline

相关资料

mdi-blank

mdi-exit-to-app

退出账号

qill722	PG9.65版本，创建C-function时，出现coredump ... ... 2018-10-21 14:50:07+08...1楼
	PG9.65版本，创建C-function时，出现coredump 详细过程如下： pg965@SIA1000103209:~> psql psql (9.6.5) Type "help" for help. postgres=# CREATE OR REPLACE FUNCTION sys_eval(TEXT) RETURNS TEXT postgres-# AS '/home/pg965/tmp/tmp/testeval.so','sys_eval' LANGUAGE C STRICT IMMUTABLE; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: LOG: server process (PID 63417) was terminated by signal 11: Segmentation fault DETAIL: Failed process was running: CREATE OR REPLACE FUNCTION sys_eval(TEXT) RETURNS TEXT AS '/home/pg965/tmp/tmp/testeval.so','sys_eval' LANGUAGE C STRICT IMMUTABLE; LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: 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. HINT: In a moment you should be able to reconnect to the database and repeat your command. Failed. !> LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2018-10-21 14:39:26 CST LOG: database system was not properly shut down; automatic recovery in progress LOG: invalid record length at 0/8F5BA48: wanted 24, got 0 LOG: redo is not required LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: autovacuum launcher started coredump信息如下： Thread 1 (Thread 0x7f85da97c700 (LWP 72860)): #0 0x00007f85da7a00fe in _dl_relocate_object () from /lib64/ld-linux-x86-64.so.2 #1 0x00007f85da7a7500 in dl_open_worker () from /lib64/ld-linux-x86-64.so.2 #2 0x00007f85da7a2e46 in _dl_catch_error () from /lib64/ld-linux-x86-64.so.2 #3 0x00007f85da7a6dfb in _dl_open () from /lib64/ld-linux-x86-64.so.2 #4 0x00007f85da182f9b in dlopen_doit () from /lib64/libdl.so.2 #5 0x00007f85da7a2e46 in _dl_catch_error () from /lib64/ld-linux-x86-64.so.2 #6 0x00007f85da18333c in _dlerror_run () from /lib64/libdl.so.2 #7 0x00007f85da182f01 in dlopen@@GLIBC_2.2.5 () from /lib64/libdl.so.2 #8 0x00000000007dcd0a in internal_load_library () #9 0x00000000007dd7d1 in load_external_function () #10 0x00000000005203ac in fmgr_c_validator () #11 0x00000000007e0c1a in OidFunctionCall1Coll () #12 0x00000000005218a7 in ProcedureCreate () #13 0x000000000058f76a in CreateFunction () #14 0x00000000006e95b2 in ProcessUtilitySlow () #15 0x00000000006ea1c2 in standard_ProcessUtility () #16 0x00000000006e64b4 in PortalRunUtility () #17 0x00000000006e74a4 in PortalRunMulti () #18 0x00000000006e7be4 in PortalRun () #19 0x00000000006e42ce in exec_simple_query () #20 0x00000000006e5af8 in PostgresMain () #21 0x000000000068366e in ServerLoop () #22 0x0000000000684cae in PostmasterMain () #23 0x000000000060aec3 in main () 通过分析发现，在加载C-function依赖的.so文件时出错： Missing separate debuginfo for /home/pg965/tmp/tmp/testeval.so Try: zypper install -C "debuginfo(build-id)=6d79dbd0be5e5904fa90dfd2110b54477407402b" Error while mapping shared library sections: `/home/pg965/tmp/tmp/testeval.so': not in executable format: File format not recognized C-function的创建，真的这么脆弱吗？在处理外部.so文件时，需要进行文件解析异常判断吧 ~
	我的签名：
qill722	回复： ... ... 2018-10-21 15:01:50+08...2楼
	PG9.65版本，创建C-function时，出现coredump 详细过程如下： pg965@SIA1000103209:~> psql psql (9.6.5) Type "help" for help. postgres=# CREATE OR REPLACE FUNCTION sys_eval(TEXT) RETURNS TEXT postgres-# AS '/home/pg965/tmp/tmp/testeval.so','sys_eval' LANGUAGE C STRICT IMMUTABLE; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: LOG: server process (PID 72860) was terminated by signal 11: Segmentation fault DETAIL: Failed process was running: CREATE OR REPLACE FUNCTION sys_eval(TEXT) RETURNS TEXT AS '/home/pg965/tmp/tmp/testeval.so','sys_eval' LANGUAGE C STRICT IMMUTABLE; LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: 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. HINT: In a moment you should be able to reconnect to the database and repeat your command. FATAL: the database system is in recovery mode Failed. !> !> LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2018-10-21 14:40:04 CST LOG: database system was not properly shut down; automatic recovery in progress LOG: invalid record length at 0/8F5BAB8: wanted 24, got 0 LOG: redo is not required LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: autovacuum launcher started ======================= coredump信息如下： Thread 1 (Thread 0x7f85da97c700 (LWP 72860)): Thread 1 (Thread 0x7f85da97c700 (LWP 72860)): 0 0x00007f85da7a00fe in _dl_relocate_object () from /lib64/ld-linux-x86-64.so.2 1 0x00007f85da7a7500 in dl_open_worker () from /lib64/ld-linux-x86-64.so.2 2 0x00007f85da7a2e46 in _dl_catch_error () from /lib64/ld-linux-x86-64.so.2 3 0x00007f85da7a6dfb in _dl_open () from /lib64/ld-linux-x86-64.so.2 4 0x00007f85da182f9b in dlopen_doit () from /lib64/libdl.so.2 5 0x00007f85da7a2e46 in _dl_catch_error () from /lib64/ld-linux-x86-64.so.2 6 0x00007f85da18333c in _dlerror_run () from /lib64/libdl.so.2 7 0x00007f85da182f01 in dlopen@@GLIBC_2.2.5 () from /lib64/libdl.so.2 8 0x00000000007dcd0a in internal_load_library () 9 0x00000000007dd7d1 in load_external_function () 10 0x00000000005203ac in fmgr_c_validator () 11 0x00000000007e0c1a in OidFunctionCall1Coll () 12 0x00000000005218a7 in ProcedureCreate () 13 0x000000000058f76a in CreateFunction () 14 0x00000000006e95b2 in ProcessUtilitySlow () 15 0x00000000006ea1c2 in standard_ProcessUtility () 16 0x00000000006e64b4 in PortalRunUtility () 17 0x00000000006e74a4 in PortalRunMulti () 18 0x00000000006e7be4 in PortalRun () 19 0x00000000006e42ce in exec_simple_query () 20 0x00000000006e5af8 in PostgresMain () 21 0x000000000068366e in ServerLoop () 22 0x0000000000684cae in PostmasterMain () 23 0x000000000060aec3 in main () =============>>>>>>>>>>>>> 通过分析发现，在加载C-function依赖的.so文件时出错： Missing separate debuginfo for /home/pg965/tmp/tmp/testeval.so Try: zypper install -C "debuginfo(build-id)=6d79dbd0be5e5904fa90dfd2110b54477407402b" Error while mapping shared library sections: `/home/pg965/tmp/tmp/testeval.so': not in executable format: File forma
	我的签名：
kmblack1	回复： ... ... 2018-12-03 12:37:20+08...3楼
	给你参考,我写的C function没遇到过类似的问题.要遵循规则 https://blog.csdn.net/kmblack1/article/details/80096021
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-20 12:27:08+08...4楼
	https://www.tiancebbs.cn/store/1602/ https://cd.tiancebbs.cn/news/39480.html https://www.tiancebbs.cn/store/4141/contactus.html https://su.tiancebbs.cn/hjzl/463449.html https://jn.tiancebbs.cn/hzwf/519579.html https://ys.tiancebbs.cn/qths/495644.html https://zulin.tiancebbs.cn/sh/6991.html https://qa.tiancebbs.cn/qths/501767.html https://su.tiancebbs.cn/b2bjxsb/524861.html https://www.tiancebbs.cn/store/2011/info.html https://suining.tiancebbs.cn/qths/504972.html https://wh.tiancebbs.cn/cgxxyl/524092.html https://su.tiancebbs.cn/hjzl/457957.html https://www.tiancebbs.cn/news/42610.html https://zz.tiancebbs.cn/b2bjxsb/57584.html https://cd.tiancebbs.cn/news/40908.html https://cd.tiancebbs.cn/news/37040.html
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-20 14:19:57+08...5楼
	http://wukong.sytcxxw.cn/sell/202502/17/678.html https://hd.tiancebbs.cn/b2byqyb/57290.html https://su.tiancebbs.cn/hjzl/456425.html https://su.tiancebbs.cn/hjzl/460866.html https://www.tiancebbs.cn/store/4527/qt/ https://zulin.tiancebbs.cn/sh/7047.html https://zb.tiancebbs.cn/qths/496893.html https://taicang.tiancebbs.cn/hjzl/459789.html https://www.tiancebbs.cn/news/37186.html https://www.tiancebbs.cn/store/1534/goods.html https://zulin.tiancebbs.cn/sh/5065.html https://www.tiancebbs.cn/store/2246/about.html https://taicang.tiancebbs.cn/hjzl/462610.html https://www.tiancebbs.cn/store/1345/comment.html https://www.tiancebbs.cn/store/4412/document-typeid-1.html https://zulin.tiancebbs.cn/sh/4649.html https://www.tiancebbs.cn/store/1204/contactus.html
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-20 17:29:14+08...6楼
	https://sh.tiancebbs.cn/hjzl/473118.html https://www.tiancebbs.cn/store/1888/ https://www.tiancebbs.cn/store/2839/document-typeid-2.html https://zulin.tiancebbs.cn/sh/4026.html https://www.tiancebbs.cn/store/4943/comment.html https://ptqbj.tiancebbs.cn/pzhhs/484704.html https://zulin.tiancebbs.cn/sh/4141.html https://sh.tiancebbs.cn/hjzl/455296.html https://zulin.tiancebbs.cn/sh/7773.html https://bj.tiancebbs.cn/xieziloucz/524898.html http://wukong.sytcxxw.cn/news/13218/202503/492.html https://cd.tiancebbs.cn/news/39462.html https://www.tiancebbs.cn/news/35062.html https://sh.tiancebbs.cn/hjzl/469463.html https://taicang.tiancebbs.cn/hjzl/458347.html https://cd.tiancebbs.cn/news/37261.html https://su.tiancebbs.cn/hjzl/467149.html
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-20 23:15:19+08...7楼
	https://zulin.tiancebbs.cn/sh/2966.html https://www.tiancebbs.cn/store/759/about.html https://qujiangqu.tiancebbs.cn/qths/494682.html https://km.tiancebbs.cn/qitazhuanyejinen/54176.html https://huhehaote.tiancebbs.cn/qths/502817.html https://www.tiancebbs.cn/news/44349.html https://nj.tiancebbs.cn/gaodengjiaoyu/54724.html https://su.tiancebbs.cn/hjzl/468122.html https://www.tiancebbs.cn/news/43498.html https://www.tiancebbs.cn/b2bhg/57117.html https://zulin.tiancebbs.cn/sh/7355.html https://www.tiancebbs.cn/news/43250.html https://www.tiancebbs.cn/store/4782/document-typeid-2.html https://www.tiancebbs.cn/store/2752/ https://cd.tiancebbs.cn/news/39727.html https://taicang.tiancebbs.cn/hjzl/463691.html https://www.tiancebbs.cn/store/4815/album.html
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-20 23:29:24+08...8楼
	https://km.tiancebbs.cn/hfcql/525227.html https://www.tiancebbs.cn/store/1965/album.html https://www.tiancebbs.cn/store/3944/goods.html https://zulin.tiancebbs.cn/sh/4010.html http://shangzhihui.cqtcxxw.cn/sell/202502/18/676.html https://www.tiancebbs.cn/store/2275/document-typeid-2.html https://cd.tiancebbs.cn/news/44476.html https://www.tiancebbs.cn/news/40193.html https://su.tiancebbs.cn/hjzl/471076.html https://www.tiancebbs.cn/news/35069.html https://zulin.tiancebbs.cn/sh/5609.html https://zulin.tiancebbs.cn/sh/7545.html https://taicang.tiancebbs.cn/hjzl/458336.html https://www.tiancebbs.cn/news/45489.html https://www.tiancebbs.cn/news/44355.html https://cd.tiancebbs.cn/news/37506.html https://cd.tiancebbs.cn/news/41056.html
	我的签名：